Set - 10

Question 51 :

How many rows will the following SQL return :

Answer :

Select * from emp Where rownum < 10;
9 rows


Question 52 :

How many rows will the following SQL return :

Answer :

Select * from emp Where rownum = 10;
No rows


Question 53 :

Which symbol preceeds the path to the table in the remote database ?

Answer :

@


Question 54 :

Are views automatically updated when base tables are updated ?

Answer :

Yes


Question 55 :

Can a trigger written for a view ?

Answer :

No