Oracle DBA Online Test1

Thank you very much for taking test

Test your caliber

1. SNAPSHOT is used for_____ .
Synonym	Table space
System server	Dynamic data replication

2. We can create SNAPSHOTLOG for[DBA]
Simple snapshots	Complex snapshots
Both A & B	Neither A nor B

3. Transactions per rollback segment is derived from[DBA]
Db_Block_Buffers	Processes
Shared_Pool_Size	None of the above

4. ENQUEUE resources parameter information is derived from[DBA]
Processes or DDL_LOCKS and DML_LOCKS	LOG_BUFFER
DB__BLOCK_SIZE	None

5. LGWR process writes information into____.
Database files	Control files
Redolog files	All the above

6. SET TRANSACTION USE ROLLBACK SEGMENT is used to create user objects in a particular Tablespace.
True	False

7. Databases overall structure is maintained in a file called _____ .
Redolog file	Data file
Control file	All of the above

8. These following parameters are optional in init.ora parameter file DB_BLOCK_SIZE, PROCESSES.
True	False

9. How can you CALL Reports from Forms4.0 ?
Run_Report built_in	Call_Report built_in
Run_Product built_in	Call_Product built_in

10. Constraints cannot be exported through EXPORT command.
True	False

11. It is very difficult to grant and manage common privileges needed by different groups of database users using the roles.
True	False

12. What is difference between a DIALOG WINDOW and a DOCUMENT WINDOW regarding moving the window with respect to the application window.
Both windows behave the same way as far as moving the window is concerned	A document window can be moved outside the application window while a dialog window cannot be moved
A dialog window can be moved outside the application window while a document window cannot be moved	None

13. What is the difference between a MESSAGEBOX and an ALERT.
A messagebox can be used only by the system and cannot be used in user application while an alert can be used in user application also	A alert can be used only by the system and cannot be use din user application while an messagebox can be used in user application also
An alert requires an response from the userwhile a messagebox just flashes a message and only requires an acknowledment from the user	An message box requires an response from the userwhile a alert just flashes a message an only requires an acknowledment from the user

14. Which of the following is not an reason for the fact that most of the processing is done at the server ?
To reduce network traffic	For application sharing
To implement business rules centrally	None of the above

15. Can a DIALOG WINDOW have scroll bar attached to it ?
Yes	No

16. Which of the following is not an advantage of GUI systems ?
Intuitive and easy to use	GUI’s can display multiple applications in multiple windows
GUI’s provide more user interface objects for a developer	None of the above

17. What is the difference between a LIST BOX and a COMBO BOX ?
In the list box, the user is restricted to selecting a value from a list but in a combo box the user can type in value which is not in the list	A list box is a data entry area while a combo box can be used only for control purposes
In a combo box, the user is restricted to selecting a value from a list but in a list box	None of the above

18. When do you get a .PLL extension ?
Save Library file	Generate Library file
Run Library file	None of the above

19. In a CLIENT/SERVER environment , which of the following would not be done at the client ?
User interface part	Data validation at entry line
Responding to user events	None of the above

20. Why is it better to use an INTEGRITY CONSTRAINT to validate data in a table than to use a STORED PROCEDURE ?
Because an integrity constraint is automatically checked while data is inserted into or updated in a table while a stored procedure has to be specifically invoked	Because the stored procedure occupies more space in the database than a integrity constraint definition
Because a stored procedure creates more network traffic than a integrity constraint definition	None of the above