Oracle Database Questions and Answers – Storing and Guarding the Data

This set of Oracle Database Multiple Choice Questions & Answers (MCQs) focuses on “Storing and Guarding the Data”.

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

4. How we can force a log switch?
a) By using ALTER SYSTEM LOG
b) By using ALTER SYSTEM SWITCH LOGFILE
c) By using ALTER SYSTEM SWITCH LOGS
d) By using ALTER SYS LOGFILES
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. 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.
Note: Join free Sanfoundry classes at Telegram or Youtube

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

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

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.

Sanfoundry Global Education & Learning Series – Oracle Database.

To practice all areas of Oracle Database, here is complete set of 1000+ Multiple Choice Questions and Answers.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]

advertisement
advertisement
Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.