Interview question based on skill :
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. Which is the smallest unit of storage in an Oracle database?
Correct Answer is : Data Block
2. Collection of information stored in database at particular instance of time is called as ____________
Correct Answer is : Instance of Database
3. Oracle database’s design is also called as_____________
Correct Answer is : Database Schema
4. What are the valid Oracle database schemas?
Correct Answer is : Logical and Physical Schema
5. What do the schema objects comprise of?
Correct Answer is : All of the Mentioned
6. Map entities, attributes and relations in Oracle is represented by___________
Correct Answer is : Logical Schema
7. Modification schema of oracle database in one level without affecting the schema in high level is called as _______
Correct Answer is : Data Independence
8. A _______________ is used to logically group data together
Correct Answer is : Tablespace
9. A _____________ is a set of tables physically stored together as one table that shares a common column
Correct Answer is : Cluster
10. What is the use of Library cache?
Correct Answer is : Used to store shared SQL
11. Which processes is an instance made of Oracle?
Correct Answer is : Oracle background processes
12. Which of the following segment is destroyed when the SQL statement is finished?
Correct Answer is : Temporary Segment
13. What is the use of an index?
Correct Answer is : Retrieve data more quickly and efficiently
14. Which of the following components comprise an Oracle architecture?
Correct Answer is : All of the Mentioned
15. What is the use of extent in Oracle?
Correct Answer is : Minimize the amount of wasted (empty) storage
16. Which area of PGA stores binding variables and run-time buffers information?
Correct Answer is : Private SQL area
17. The ____________ contains a set of tables and views that Oracle uses as a reference to the database.
Correct Answer is : Data dictionary
18. In Oracle, which of below are types of segments?
Correct Answer is : Data Segment
19. The redo log buffer and Shared pool are elements of?
Correct Answer is : SGA
20. What does DLL stand for ?
Correct Answer is : Dynamic Link Library
