1. The data file in an oracle database
a) Can be associated with only one table space
b) Can be associated with more than one database
c) Can be associated with more than one table space
d) Has no relationship with table space
2. Redo log files have at least _ groups
a) 1
b) 2
c) 3
d) 4
3. Which data dictionary view contain the description information of user’s data objects
Including tables, procedures and packages etc?
a) User_objects
b) User_tables
c) User_source
d) User_procedures
4. DROP PACKAGE package_1;
The above statement will drop the body of package_1 and the package
specification will remain
a) TRUE
b) FALSE
c) NONE
5. What will be output of the following PL/SQL block?
Declare
Inner_exception exception;
Outer_exception exception;
Begin
Begin
Raise inner_exception;
Dbms_output.put_line(‘inner block’);
Exception
When inner_exception then
Dbms_output.put_line(‘Exception in inner block’);
End
Raise outer_exception;
Exception
When outer_exception then
Dbms_output.put_line(‘Exception in outer block’);
End;
a) Exception in inner block
Exception in outer block
1
评论1