MCQs > IT & Programming > Oracle Database MCQs > Basic Oracle Database MCQs

Basic Oracle Database MCQ

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

Answer

Correct Answer: Control files

Note: This Question is unanswered, help us to find answer for this one

2. To truncate table changes, use DATA_OBJECT_ID.

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

3. Users that can see any changed data are:

Answer

Correct Answer: Only the ones making the changes

Note: This Question is unanswered, help us to find answer for this one

4. The default value of SHARED_POOL_SIZE is:

Answer

Correct Answer: 3500000 bytes

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Allocating the SGA

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: A writer of data is blocked only when a reader of data has already locked the row it was going after.

Note: This Question is unanswered, help us to find answer for this one

7. Rowid on oracle stores:

Answer

Correct Answer: Physical position of the data

Note: This Question is unanswered, help us to find answer for this one

8. Does "Not in" use an index?

Answer

Correct Answer: No

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Hash values

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: 12

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: The data block is read, loading it into a memory structure called a buffer cache

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: SYS and INTERNAL

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Ctrl + K

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Logical blocks

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: srvctl add database

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: REMOTE_LOGIN_PASSWORDFILE

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: B-Tree

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: CREATE SPFILE FROM PFILE;

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: For each open session, a new dedicated server will be created separately from the instance in a one-to-one mapping

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Database buffer cache

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: V$SGA, V$INSTANCE, V$PROCESS

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: It is created on multiple columns in a table.

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: The statement is executed using "normal" user

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: INT

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Library cache

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: SQL statements

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Oracle will deallocate all unused space above the high water mark

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: BACKGROUND_DUMP_DEST

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: It is portable

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: ORA-01555

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: SMON

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: By using CREATE TABLE AS SELECT

Note: This Question is unanswered, help us to find answer for this one

33. Oracle default optimization follows:

Answer

Correct Answer: Cost based optimiztion

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Avoid setting MAXEXTENT to UNLIMITED

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: DataLoad

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: PING AILYN LESLIE

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: In a folder pointed by USER_DUMP_DEST

Note: This Question is unanswered, help us to find answer for this one

38. Which function is not in DBMS_OUTPUT?

Answer

Correct Answer: PREV_LINE

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: DUAL

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Latch

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Transcation will commit automatically

Note: This Question is unanswered, help us to find answer for this one

42. Implicit Cursor works when:

Answer

Correct Answer: DML operation is done

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Oracle Questions

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Oracle will assume that it is the column that is being referenced

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Returns the output of top query minus the output of the query below the MINUS operator.

Note: This Question is unanswered, help us to find answer for this one

46. The "materialized view" in Oracle stores:

Answer

Correct Answer: Output in different physical space

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: EXISTS

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: USER_COL_PRIVS

Note: This Question is unanswered, help us to find answer for this one

49. Which of these statement is NOT true?

Answer

Correct Answer: A datafile can be associated with one or more database

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Substitution variables

Note: This Question is unanswered, help us to find answer for this one

51. In Oracle "view" consists of:

Answer

Correct Answer: The definition only

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Use the IN operator

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: PMON

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Data blocks, extents, segments, table spaces

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: flashback table <tablename> to before drop

Note: This Question is unanswered, help us to find answer for this one

56. "Select for Update" performs:

Answer

Correct Answer: Lock the record on result set

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: You obtain the results retrieved from the HR table that belongs to your schema.

Note: This Question is unanswered, help us to find answer for this one

58. What is the definition of data buffer cache?

Answer

Correct Answer: An area in SGA that is used to store the most recently used data block

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Oracle Certified Developer (OCD)

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Data Encryption Standard

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: CHUCHKOO AND CHARLIE

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Update

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: DB_BLOCK_SIZE

Note: This Question is unanswered, help us to find answer for this one

64. SQL stands for:

Answer

Correct Answer: Structured Query Language

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Enterprise Resource Planning

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: distinct

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Oracle Enterprise Manager

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Having

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: LIKE

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Role

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: All of these

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: BETWEEN ... AND

Note: This Question is unanswered, help us to find answer for this one

74. Define Index:

Answer

Correct Answer: Ordered form of data

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Customer Relationship Management

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: IS NULL

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Oracle Customer Service Suite

Note: This Question is unanswered, help us to find answer for this one

78. Which of the following are system privileges?

Answer

Correct Answer: CREATE TABLE and DROP TABLE

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: All of these

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: 0

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: 1

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: All of these

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: ALTER INDEX index_name REBUILD

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: DBA_DATA_FILES

Note: This Question is unanswered, help us to find answer for this one

85. Remote access of database can be made by:

Answer

Correct Answer: Database Link

Note: This Question is unanswered, help us to find answer for this one

86. In a sequence, Curval returns:

Answer

Correct Answer: Present Value

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: All of these

Note: This Question is unanswered, help us to find answer for this one

88. Which naming rules are applied to tables?

Answer

Correct Answer: All of these

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Execute Query

Note: This Question is unanswered, help us to find answer for this one

90. Which statement about views are true?

Answer

Correct Answer: A view can be created as a join on two or more tables.

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: lock

Note: This Question is unanswered, help us to find answer for this one

92. What are the parts of a Package?

Answer

Correct Answer: Spec and Body

Note: This Question is unanswered, help us to find answer for this one

93. What does the acronym RDBMS mean?

Answer

Correct Answer: Relational Database Management System

Note: This Question is unanswered, help us to find answer for this one