11. The NOWAIT optional Keyword works for
Answer : Implicit cursors only.
12. __________puts piece of information in package buffer followed by an end of line marker
Answer : PUT_LINE.
13. type of data in database
Answer : all.
14. Which statement most accurately describes the result of not creating an exception handler for a raised
Answer : Control will pass to the PL/SQL block caller’s exception handler.
15. The default parameter type in stored procedures is
Answer : IN.
16. When both the Oracle name server as well as tnsnames.ora file is used simultaneously, the priority between
the two is resolved by
Answer : sqlnet.ora.
17. Consider a table OLD with few rows. The statement
CREATE TABLE new AS SELECT * FROM OLD
Answer : creates an empty NEW table with column definitions same as OLD.
18. Choose the Incorrect option related to DBMS
Answer : satisfy more than 8 rule of Dr. E.F. Codd .
19. The Maximum size of Raw Datatype is
Answer : 2000 bytes.
20. Choose correct one
Answer : rollup and cube are grouping type of statements for sql query.