Most Frequently asked Oracle DBA Multiple Choice Questions and Answers for Freshers pdf
1. SNAPSHOT is used for_____ .
2. We can create SNAPSHOTLOG for[DBA]
3. Transactions per rollback segment is derived from[DBA]
4. ENQUEUE resources parameter information is derived from[DBA]
5. LGWR process writes information into
6. SET TRANSACTION USE ROLLBACK SEGMENT is used to create user objects in a particular Tablespace
7. Databases overall structure is maintained in a file called
8. These following parameters are optional in init.ora parameter file DB_BLOCK_SIZE, PROCESSES
9. What is a trigger?
10. Constraints cannot be exported through EXPORT command
11. It is very difficult to grant and manage common privileges needed by different groups of database users using the roles
12. What is difference between a DIALOG WINDOW and a DOCUMENT WINDOW regarding moving the window with respect to the application window
13. What is the difference between a MESSAGE BOX and an ALERT
14. Which of the following is not an reason for the fact that most of the processing is done at the server ?
15. Can a DIALOG WINDOW have scroll bar attached to it ?
16. Which of the following is not an advantage of GUI systems ?
17. What is the difference between a LIST BOX and a COMBO BOX ?
18. When do you get a .PLL extension ?
19. In a CLIENT/SERVER environment , which of the following would not be done at the client ?
20. Why is it better to use an INTEGRITY CONSTRAINT to validate data in a table than to use a STORED PROCEDURE ?
21. Which of the following is not an advantage of a client/server model ?
22. What does DLL stands for ?
23. POST-BLOCK trigger is a
24. 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
25. Which of the following is TRUE for the ENFORCE KEY field
26. What is the maximum size of the page ?
27. A FORM is madeup of which of the following objects
28. For the following statements which is true
29. The packaged procedure that makes data in form permanent in the Database is
30. Which of the following is TRUE for the SYSTEM VARIABLE $$date$$
31. Which of the following packaged procedure is UNRESTRICTED ?
32. Identify the RESTRICTED packaged procedure from the following
32. What is SQL*FORMS
33. Name the two files that are created when you generate a form using Forms 3.0
34. Which of the folowing is TRUE for a ERASE packaged procedure
35. All datafiles related to a Tablespace are removed when the Table space is dropped
36. Size of Tablespace can be increased by
37. Multiple Tablespaces can share a single datafile
38. A set of Dictionary tables are created
39. Datadictionary can span across multiple Tablespaces
40. What is a DATABLOCK
41. Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint
42. A column defined as PRIMARY KEY can have NULL’s
43. A Transaction ends
44. A Database Procedure is stored in the Database
45. A database trigger doesn't apply to data loaded before the definition of the trigger
46. Dedicated server configuration is
47. Which of the following does not affect the size of the SGA
48. What does a COMMIT statement do to a CURSOR
49. Which of the following is TRUE
50. Which of the following is NOT VALID is PL/SQL
51. GET_BLOCK property is a
52. What will be the value of scar after the execution ?
53. Which of the following is not correct about an Exception ?
54. Which of the following is not correct about User_Defined Exceptions ?
55. A Stored Procedure is a
56. Which of the following statement is false
57. Is it possible to open a cursor which is in a Package in another procedure ?
58. Is it possible to use Transactional control statements in Database Triggers?
59. Is it possible to Enable or Disable a Database trigger ?
60. PL/SQL supports datatype(s)
61. Find the ODD datatype out
62. Which of the following is not correct about the “TABLE” datatype ?
63. Find the ODD one out of the following
64. Which of the following is not correct about Cursor ?
65. Which of the following is NOT VALID in PL/SQL ?
67. What is the Result of the following ‘VIK’NULL’RAM’ ?
68. A CONTROL BLOCK can sometimes refer to a BASETABLE ?
69. Is it possible to modify a Datatype of a column when column contains data ?
70. Which of the following is not correct about a View ?
71. Which is not part of the Data Definition Language ?
72. List of Values (LOV) supports
73. If an UNIQUE KEY constraint on DATE column is created, will it accept the rows that are inserted with sysdate?
74. What are the different events in Triggers ?
75. What built-in subprogram is used to manipulate images in image items ?
76. Can we pass RECORD GROUP between FORMS ?
77. SHOW_ALERT function returns
78. What SYSTEM VARIABLE is used to refer DATABASE TIME ?
79. SYSTEM.EFFECTIVE.DATE varaible is
80. How can you CALL Reports from Forms4.0 ?
1. SNAPSHOT is used for_____ .
2. We can create SNAPSHOTLOG for[DBA]
3. Transactions per rollback segment is derived from[DBA]
4. ENQUEUE resources parameter information is derived from[DBA]
5. LGWR process writes information into
6. SET TRANSACTION USE ROLLBACK SEGMENT is used to create user objects in a particular Tablespace
7. Databases overall structure is maintained in a file called
8. These following parameters are optional in init.ora parameter file DB_BLOCK_SIZE, PROCESSES
9. What is a trigger?
10. Constraints cannot be exported through EXPORT command
11. It is very difficult to grant and manage common privileges needed by different groups of database users using the roles
12. What is difference between a DIALOG WINDOW and a DOCUMENT WINDOW regarding moving the window with respect to the application window
13. What is the difference between a MESSAGE BOX and an ALERT
14. Which of the following is not an reason for the fact that most of the processing is done at the server ?
15. Can a DIALOG WINDOW have scroll bar attached to it ?
16. Which of the following is not an advantage of GUI systems ?
17. What is the difference between a LIST BOX and a COMBO BOX ?
18. When do you get a .PLL extension ?
19. In a CLIENT/SERVER environment , which of the following would not be done at the client ?
20. Why is it better to use an INTEGRITY CONSTRAINT to validate data in a table than to use a STORED PROCEDURE ?
21. Which of the following is not an advantage of a client/server model ?
22. What does DLL stands for ?
23. POST-BLOCK trigger is a
24. 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
25. Which of the following is TRUE for the ENFORCE KEY field
26. What is the maximum size of the page ?
27. A FORM is madeup of which of the following objects
28. For the following statements which is true
29. The packaged procedure that makes data in form permanent in the Database is
30. Which of the following is TRUE for the SYSTEM VARIABLE $$date$$
31. Which of the following packaged procedure is UNRESTRICTED ?
32. Identify the RESTRICTED packaged procedure from the following
32. What is SQL*FORMS
33. Name the two files that are created when you generate a form using Forms 3.0
34. Which of the folowing is TRUE for a ERASE packaged procedure
35. All datafiles related to a Tablespace are removed when the Table space is dropped
36. Size of Tablespace can be increased by
37. Multiple Tablespaces can share a single datafile
38. A set of Dictionary tables are created
39. Datadictionary can span across multiple Tablespaces
40. What is a DATABLOCK
41. Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint
42. A column defined as PRIMARY KEY can have NULL’s
43. A Transaction ends
44. A Database Procedure is stored in the Database
45. A database trigger doesn't apply to data loaded before the definition of the trigger
46. Dedicated server configuration is
47. Which of the following does not affect the size of the SGA
48. What does a COMMIT statement do to a CURSOR
49. Which of the following is TRUE
50. Which of the following is NOT VALID is PL/SQL
51. GET_BLOCK property is a
52. What will be the value of scar after the execution ?
53. Which of the following is not correct about an Exception ?
54. Which of the following is not correct about User_Defined Exceptions ?
55. A Stored Procedure is a
56. Which of the following statement is false
57. Is it possible to open a cursor which is in a Package in another procedure ?
58. Is it possible to use Transactional control statements in Database Triggers?
59. Is it possible to Enable or Disable a Database trigger ?
60. PL/SQL supports datatype(s)
61. Find the ODD datatype out
62. Which of the following is not correct about the “TABLE” datatype ?
63. Find the ODD one out of the following
64. Which of the following is not correct about Cursor ?
65. Which of the following is NOT VALID in PL/SQL ?
67. What is the Result of the following ‘VIK’NULL’RAM’ ?
68. A CONTROL BLOCK can sometimes refer to a BASETABLE ?
69. Is it possible to modify a Datatype of a column when column contains data ?
70. Which of the following is not correct about a View ?
71. Which is not part of the Data Definition Language ?
72. List of Values (LOV) supports
73. If an UNIQUE KEY constraint on DATE column is created, will it accept the rows that are inserted with sysdate?
74. What are the different events in Triggers ?
75. What built-in subprogram is used to manipulate images in image items ?
76. Can we pass RECORD GROUP between FORMS ?
77. SHOW_ALERT function returns
78. What SYSTEM VARIABLE is used to refer DATABASE TIME ?
79. SYSTEM.EFFECTIVE.DATE varaible is
80. How can you CALL Reports from Forms4.0 ?
