Engineering Questions with Answers - Multiple Choice Questions
Oracle Database MCQs
1 - Question
1. Where is data dictionary kept?
a) SYSTEM Tablespace
b) Stack Space
c) Data File
d) None of the Mentioned
View Answer
Answer: a
Explanation: The Oracle Database user SYS owns all base tables and user-accessible views of the data dictionary.
2 - Question
2. Which schema object instructs Oracle to connect to remotely access an object of a database?
a) Sequence
b) Remote Link
c) Database Link
d) Data Link
View Answer
Answer: d
Explanation: A DATABASE LINK value references a resource outside the underlying data source through a URL.
3 - Question
3. Which of the following object types below cannot be replicated?
a) Data
b) Trigger
c) View
d) Sequence
View Answer
Answer: d
Explanation: Use the CREATE SEQUENCE statement to create a sequence, which is a database object from which multiple users may generate unique integers. You can use sequences to automatically generate primary key values.
4 - Question
Answer: d
Explanation: Use the CREATE SEQUENCE statement to create a sequence, which is a database object from which multiple users may generate unique integers. You can use sequences to automatically generate primary key values.
View Answer
Answer: b
Explanation: To force a log switch, you must have the ALTER SYSTEM privilege. Use the ALTER SYSTEM statement with the SWITCH LOGFILE clause.
5 - Question
5. In the below given query, which expression is evaluated first?
SELECT id_number, (quantity – 100 / 0.15 – 35 * 20) FROM inventory
a) 0.15-35
b) quantity – 100
c) 35*20
d) 100 / 0.15
View Answer
Answer: d
Explanation: According to BODMAS rule that will be getting applied to the expression first brackets should get off but as there is no bracket in expression it will look for the division. As 100/0.15 is a division expression so in this expression will be getting evaluated first.
6 - Question
6. The ORDER BY clause can only be used in ___________
a) SELECT queries
b) INSERT queries
c) GROUP BY queries
d) HAVING queries
View Answer
Answer: a
Explanation: An ORDER BY clause allows you to specify the order in which rows appear in the result set.
7 - Question
7. Which of the following rule below are categories of index?
a) Column and Functional
b) Multiple Column and Functional
c) To create an index in another schema
d) None of the Mentioned
View Answer
Answer: a
Explanation: An index is an optional structure, associated with a table or table cluster, that can sometimes speed data access.
8 - Question
8. What is the purpose of SMON (System Monitor Process) background process?
a) Performs crash recovery when a failed instance starts up again
b) Performs recovery when a user process fails
c) Writes redo log entries to disk
d) All of the Mentioned
View Answer
Answer: a
Explanation: SMON process of one instance can perform instance recovery for a failed CPU or instance.
9 - Question
9. Recycle bin can be turned on or off this. This parameter is stored in which of the below file?
a) PARAMETER FILE
b) PARFILE
c) DATAFILES
d) PFILE
View Answer
Answer: a
Explanation: A parameter file is a file that contains a list of initialization parameters and a value for each parameter.
10 - Question
10. When a transaction modifies the database, Oracle copies the original data before modifying it. The original copy of the modified data is called
a) Undone Data
b) Archive Data
c) Redo Data
d) Undo Data
View Answer
Answer: d
Explanation: Before transaction happen the Oracle kept the files in Undo Data to overcome form any failure.