Oracle DBA Online model free test3

Thank you very much for taking test

Test your caliber

1. Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint.
Yes	No

2. A column defined as PRIMARY KEY can have NULL’s ______.
TRUE	FALSE

3. A Transaction ends ______.
Only when it is Committed	Only when it is Rolledback
When it is Committed or Rolledback	None of the above

4. A Database Procedure is stored in the Database.
In compiled form	As source code
Both A & B	Not stored

5. A database trigger doesnot apply to data loaded before the definition of the trigger.
TRUE	FALSE

6. Dedicated server configuration is _____ .
One server process – Many user processes	Many server processes – One user process
One server process – One user process	Many server processes – Many user processes

7. Which of the following does not affect the size of the SGA.
Database buffer	Redolog buffer
Stored procedure	Shared pool

8. What does a COMMIT statement do to a CURSOR.
Open the Cursor	Fetch the Cursor
Close the Cursor	None of the above

9. Which of the following is TRUE. 1. Host variables are declared anywhere in the program 2. Host variables are declared in the DECLARE section
Only 1 is TRUE	Only 2 is TRUE
Both 1 & 2are TRUE	Both are FALSE

10. Which of the following is NOT VALID is PL/SQL.
Bool boolean;	NUM1, NUM2 number;
deptname dept.dname%type;	date1 date := sysdate

11. GET_BLOCK property is a ______ .
Restricted procedure	Unrestricted procedure
Library function	None of the above

12. What will be the value of svar after the execution ?
Error	10
5	None of the above

13. Which of the following is not correct about an Exception ?
Raised automatically / Explicitly in response to an ORACLE_ERROR	An exception will be raised when an error occurs in that block
Process terminates after completion of error sequence	A Procedure or Sequence of statements may be processed

14. Which of the following is not correct about User_Defined Exceptions ?
Must be declared	Must be raised explicitly
Raised automatically in response to an Oracle error	None of the above

15. A Stored Procedure is a _____.
Sequence of SQL or PL/SQL statements to perform specific function	Stored in compiled form in the database
Can be called from all client environmets	All of the above

16. Which of the following statement is false.
Any procedure can raise an error and return an user message and error number	Error number ranging from 20000 to 20999 are reserved for user defined messages
Oracle checks Uniqueness of User defined errors	Raise_Application_error is used for raising an user defined error

17. Is it possible to open a cursor which is in a Package in another procedure ?
Yes	No

18. Is it possible to use Transactional control statements in Database Triggers?
Yes	No

19. Is it possible to Enable or Disable a Database trigger ?
Yes	No

20. PL/SQL supports datatype(s).
Scalar datatype	Composite datatype
All of the above	None of the above