Oracle Database MCQ Questions Answers

1. What does the acronym RDBMS mean?

2. What are the parts of a Package?

3. The transaction control that prevents more than one user from updating data in a table is which of the following (choose one)?

4. Which statement about views are true?

5. What will the shortcut "Ctrl + F11" do?

6. Which naming rules are applied to tables?

7. Which syntax turns an existing constraint on?

8. The source code of procedure, function and package bodies can be queried from which data dictionary?

9. In a sequence, Curval returns:

10. Remote access of database can be made by:

11. What view would you use to look at the size of a data file?

12. Which of the following statement correctly decribes how to rebuild an index?

13. Which of the following statements is true about rebuilding indexes?

14. How many columns are there in a Dual table?

15. A rollback segment can be specified as either PUBLIC or PRIVATE. The value of PCTINCREASE of a rollback segment is always set to:

16. Which of these is not a language element of SQL?

17. DBMS_SCHEDULER, along with the power of PL/SQL, provides a mechanism for automating some of the daily tasks. Which of the following is an advantage of using DBMS_SCHEDULER?

18. Which of the following are system privileges?

19. Which of these is not a real Oracle suite option?

20. SQL statement operator that tests whether a field value is unavailable, unassigned or unknown is:

21. In business, what is the most common definition for CRM?

22. Define Index:

23. What is the purpose of the Rollback command?

24. Which of the following operators can be used to substitute the 'IN' operator in a SELECT statement?

25. Which of the following is(are) physical storage file(s) of Oracle?

26. Which of the following is not DML (Data Manipulation Language)?

27. True or False: "Select for Update" performs the function "Lock the record on result set."

28. The DBA assigns permission to the user using this command:

29. You need to search for text data in a column, but you only remember part of the string. Which of the following SQL operations allows the use of wildcard comparisons?

30. What clause follows "group by" in SQL?

31. In terms of Oracle, what is the most common meaning of OEM?

32. Which operator will help to filter out all duplicate records?

33. In business, what is the most common definition for ERP?

34. SQL stands for:

35. A block is the smallest unit of logical storage that the Relational Database Management System (RDBMS) can manipulate. Block size is determined by which of the following database parameter?

36. Which one of the following is not a DDL (Data Definition Language) command?

37. REPLACE ('CUCKOO AND CARLIE', 'C', 'CH') will return:

38. Regarding Oracle, what does DES most commonly mean?

39. The Oracle Certification Program contains three levels. Which of these is not one of them?

40. What is the definition of data buffer cache?

41. The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? select * from HR

42. "Select for Update" performs:

43. What command is used to restore an "accidentally" dropped table?

44. Order the following entities from the smallest to the largest:

45. When a user process fails, this background process will clean up after it:

46. What operator would you choose to prevent this Oracle error message? ORA-01427:single -row subquery returns more than one row

47. What is true about this set of statements? CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)); ROLLBACK; DESCRIBE DEPT;

48. In Oracle "view" consists of:

49. You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others. Which statement accomplishes this?

50. Which /SQL*Plus feature can be used to replace values in the WHERE clause?

51. Which of these statement is NOT true?

52. Which data dictionary table should you query to view the object privileges granted to the user on specific columns?

53. The IN operator is used when you are using a subquery which returns more than one record. What is the operator used in a correlated subquery?

54. The "materialized view" in Oracle stores:

55. Which of the following actions are performed by the MINUS operator?

56. How would you display a listing of the sums of employee salaries for those employees not making a commission, for each job type, including only those sums greater than 2500?

57. What will happen if PL/SQL variables occur in SQL statements and have the same name as a table column

58. Which of these is NOT an Oracle "database option?"

59. Implicit Cursor works when:

60. What happends when you execute one transcaction and then truncate another table?

61. You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?

62. This protects the library cache from becoming corrupted by concurrent modifications by two sessions or by one session trying to read information that is being modified by another one.

63. A "virtual" table name to query the current time is:

64. Which function is not in DBMS_OUTPUT?

65. When you issue the command "ALTER DATABASE BACKUP CONTROLFILE TO TRACE", a text script version of backup control file will be created. Where is this file located?

66. Given the following data in the emp table: ENAME SALARY : PING 5000 AILYN 4999 SAM 1000 LESLIE 3000 TOM 2500 RAVI 10000 What will the following select statement produce? SELECT ename FROM emp WHERE salary BETWEEN 3000 AND 5000;

67. Which of these programs is the most popular choice to load data directly into Oracle E-Business Suite?

68. Which of the following is a good suggestion for avoiding unnecessary extension of a rollback segment?

69. Oracle default optimization follows:

70. The most effective way to re-order the columns in a table is:

71. The background process that checks for consistency of the database is called:

72. This type of error can be solved by increasing the undo retention of increasing the size of rollbacks.

73. How does PL/SQL allow programmers to use it on any host environment?

74. The init.ora parameter that controls the location of the Alert log file is:

75. What happens if the command ALTER TABLE <tablename> DEALLOCATE UNUSED is used without the KEEP clause?

76. Which of the following cannot be placed in the declaration part of PL/SQL?

77. Before any SQL statement is parsed, Oracle will check the _______ to see if that same statement already exists there.

78. Which of the following SQL functions can operate on any datatype?

79. One of these datatypes is NOT a base scalar datatype?

80. When executing the command: "show parameter xxxx", ORA-00942: table or view does not exist appears. Which of the following best explains this error?

81. Which one of these statements is true about a concatenated index?

82. The Oracle server provides a number of standard data dictionary views to obtain information on database and instance. These views are:

83. This structure is not included in the Shared Pool contents.

84. Which of the following best describes how to have requests serviced by an Oracle server (using either dedicated or shared server)?

85. How do you switch from an init.ora file to a spfile?

86. There are 2 classifications of an index: by logical design and by physical implementation. From its logical design, indexes can have the following types, except:

87. Which of the following parameters specifies whether Oracle checks for a password file?

88. What is Extended Rowid?

89. In an Oracle RAC environment, a physical standby database will be registered with the clusterware. When creating the clusterware resource for the standby database, which of the following commands do you use to perform this registration?

90. The basic units that make up a PL/SQL are called:

91. In Forms, what keyboard shortcut will access the shortcut menu?

92. The only users recognized by the password file are:

93. Which of the following statements are true about deleting or updating a statement?

94. What is the number of user defined triggers in Oracle?

95. In what value do these 3 statements differ from one another? select * from employees where department_id = 60; SELECT * FROM EMPLOYEES WHERE DEPARTMENT_ID = 60; select /* a_comment */ * from employees where department_id = 60;

96. Does "Not in" use an index?

97. Rowid on oracle stores:

98. Which of the following falsely sums up Oracle’s locking policy?

99. Which of these tasks is NOT performed during the database mounting process?

100. The default value of SHARED_POOL_SIZE is: