Oracle Database MCQ Questions Answers

1. Which of the follwing is NOT associated with an instance?

2. Which DATETIME data types cannot be used when specifying column definitions?

3. To truncate table changes, use DATA_OBJECT_ID.

4. Users that can see any changed data are:

5. The default value of SHARED_POOL_SIZE is:

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

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

8. Rowid on oracle stores:

9. Does "Not in" use an index?

10. 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;

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

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

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

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

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

16. 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?

17. What is Extended Rowid?

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

19. 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:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

36. Oracle default optimization follows:

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

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

39. 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;

40. 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?

41. Which function is not in DBMS_OUTPUT?

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

43. 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.

44. 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?

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

46. Implicit Cursor works when:

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

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

49. 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?

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

51. The "materialized view" in Oracle stores:

52. 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?

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

54. Which of these statement is NOT true?

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

56. 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?

57. In Oracle "view" consists of:

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

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

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

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

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

63. "Select for Update" performs:

64. 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

65. What is the definition of data buffer cache?

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

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

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

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

70. 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?

71. SQL stands for:

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

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

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

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

76. 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?

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

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

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

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

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

82. What is the purpose of the Rollback command?

83. Define Index:

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

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

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

87. Which of the following are system privileges?

88. 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?

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

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

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

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

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

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

95. Remote access of database can be made by:

96. In a sequence, Curval returns:

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

98. Which syntax turns an existing constraint on?

99. Which naming rules are applied to tables?

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