11. The NOWAIT optional Keyword works for

A. Implicit cursors only 

B. Explicit cursor only 

C. Both a and b 

D. none of the above 

12. __________puts piece of information in package buffer followed by an end of line marker

A. DBMS_OUTPUT 

B. PUT_LINE 

C. serveroutput 

D. none 

13. type of data in database

A. actual data 

B. system data 

C. overhed data 

D. all 

14. Which statement most accurately describes the result of not creating an exception handler for a raised
exception?

A. The program will continue without raising the exception 

B. There will be a memory leak 

C. Control will pass to the PL/SQL block caller’s exception handler 

D. The program will return a %notfound error 

15. The default parameter type in stored procedures is

A. IN 

B. OUT 

C. INOUT 

D. There is no default type 

16. When both the Oracle name server as well as tnsnames.ora file is used simultaneously, the priority between
the two is resolved by

A. listener.ora 

B. tnsnames.ora 

C. init.ora 

D. sqlnet.ora 

17. Consider a table OLD with few rows. The statement
CREATE TABLE new AS SELECT * FROM OLD
WHERE 1=2

A. copies all the rows from OLD to NEW 

B. creates a dummy NEW table 

C. creates an empty NEW table with column definitions same as OLD 

D. creates a table NEW that acts as a synonym for OLD 

18. Choose the Incorrect option related to DBMS

A. There is no Security of data 

B. Not support distributed database 

C. satisfy more than 8 rule of Dr. E.F. Codd  

D. None 

19. The Maximum size of Raw Datatype is

A. 1000 bytes 

B. 2000 bytes 

C. 4000 bytes 

D. 8000 bytes 

20. Choose correct one

A. rollup and cube are grouping type of statements for sql query 

B. rollup and cube are inbuilt functions for sql query 

C. rollup and cube are not related to oracle 

D. none of the above 

• 1
• 2
• 3
• 4
• 5