Oracle DBA free online exams test2

Thank you very much for taking test

Test your caliber

1. Which of the following is not an advantage of a client/server model ?
A client/server model allows centralised control of data and centralised implementation of business rules	A client/server model increases developer;s productivity
A client/server model is suitable for all applications	None of the above

2. What does DLL stands for ?
Dynamic Language Library	Dynamic Link Library
Dynamic Load Library	None of the above

3. POST-BLOCK trigger is a _____ .
Navigational trigger	Key trigger
Transactional trigger	None of the above

4.You can prepare for these Oracle employment qualification test multiple choice questions. People usually get similar questions in the regular oracle placement papers. Check out the answers given. The system variable that records the select statement that SQL * FORMS most recently used to populate a block is?
SYSTEM.LAST_RECORD	SYSTEM.CURSOR_RECORD
SYSTEM.CURSOR_FIELD	SYSTEM.LAST_QUERY

5. Which of the following is TRUE for the ENFORCE KEY field 1. ENFORCE KEY field characterstic indicates the source of the value that SQL*FORMS uses to populate the field 2. A field with the ENFORCE KEY characterstic should have the INPUT ALLOWED charaterstic turned off
Only 1 is TRUE	Only 2 is TRUE
Both 1 and 2 are TRUE	Both 1 and 2 are FALSE

6. What is the maximum size of the page ?
Characters wide & 265 characters length	Characters wide & 265 characters length
Characters wide & 80 characters length	None of the above

7. A FORM is madeup of which of the following objects
block, fields only	blocks, fields, pages only
blocks, fields, pages, triggers and form level procedures	Only blocks

8. For the following statements which is true. 1. Page is an object owned by a form 2. Pages are a collection of display information such as constant text and graphics.
Only 1 is TRUE	Only 2 is TRUE
Both 1 & 2 are TRUE	Both are FALSE

9. The packaged procedure that makes data in form permanent in the Database is ____ .
Post	Post form
Commit form	None of the above

10. Which of the following is TRUE for the SYSTEM VARIABLE $$date$$
Can be assigned to a global variable	Can be assigned to any field only during design time
Can be assigned to any variable or field during run time	None of the above

11. Which of the following packaged procedure is UNRESTRICTED ?
CALL_INPUT	CLEAR_BLOCK
EXECUTE_QUERY	USER_EXIT

12. Identify the RESTRICTED packaged procedure from the following ______.
USER_EXIT	MESSAGE
BREAK	EXIT_FORM

13. What is SQL*FORMS
SQL*FORMS is a 4GL tool for developing & executing Oracle based interactive applications	SQL*FORMS is a 3GL tool for connecting to the Database
SQL*FORMS is a reporting tool	None of the above

14. Name the two files that are created when you generate a form using Forms 3.0.
FMB & FMX	FMR & FDX
INP & FRM	None of the above

15. What is a trigger.
A piece of logic written in PL/SQL	Executed at the arrival of a SQL*FORMS event
Both A & B	None of the above

16. Which of the folowing is TRUE for a ERASE packaged procedure 1. ERASE removes an indicated Global variable & releases the memory associated with it 2. ERASE is used to remove a field from a page
Only 1 is TRUE	Only 2 is TRUE
Both 1 & 2 are TRUE	Both 1 & 2 are FALSE

17. All datafiles related to a Tablespace are removed when the Tablespace is dropped.
TRUE	FALSE

18. Size of Tablespace can be increased by _____.
Increasing the size of one of the Datafiles	Adding one or more Datafiles
Cannot be increased	None of the above

19. Multiple Tablespaces can share a single datafile.
TRUE	FALSE

20. A set of Dictionary tables are created _____.
Once for the Entire Database	Every time a user is created
Every time a Tablespace is created	None of the above