Oracle Database Interview Questions - 2

1. Which is the smallest unit of storage in an Oracle database?

A. Data Block

B. Segment

C. Extent

D. Data File

Correct Answer is : Data Block

2. Collection of information stored in database at particular instance of time is called as ____________

A. Instance of Database

B. Objects in Databases

C. Data structure

D. Database Schema

Correct Answer is : Instance of Database

3. Oracle database’s design is also called as_____________

A. Database Abstraction

B. Database Instance

C. Database Schema

D. None of the Mentioned

Correct Answer is : Database Schema

4. What are the valid Oracle database schemas?

A. Logical Schema

B. Physical Schema

C. Logical and Physical Schema

D. None of the Mentioned

Correct Answer is : Logical and Physical Schema

5. What do the schema objects comprise of?

A. Table

B. Index

C. Cluster

D. All of the Mentioned

Correct Answer is : All of the Mentioned

6. Map entities, attributes and relations in Oracle is represented by___________

A. Conceptual Schema

B. Logical Schema

C. Physical Schema

D. All of the Mentioned

Correct Answer is : Logical Schema

7. Modification schema of oracle database in one level without affecting the schema in high level is called as _______

A. Data Migration

B. Data Isolation

C. Data Independence

D. Data Abstraction

Correct Answer is : Data Independence

8. A _______________ is used to logically group data together

A. Database

B. Tablespace

C. Datafiles

D. Object

Correct Answer is : Tablespace

9. A _____________ is a set of tables physically stored together as one table that shares a common column

A. Index

B. Object

C. Datafiles

D. Cluster

Correct Answer is : Cluster

10. What is the use of Library cache?

A. Contains User information, such as user privileges

B. Used to store shared SQL

C. Log of changes made to the database

D. All of the Mentioned

Correct Answer is : Used to store shared SQL

11. Which processes is an instance made of Oracle?

A. Oracle background processes

B. Memory processes

C. Data processes

D. All of the Mentioned

Correct Answer is : Oracle background processes

12. Which of the following segment is destroyed when the SQL statement is finished?

A. Data Segment

B. Object Segment

C. Temporary Segment

D. All of the Mentioned

Correct Answer is : Temporary Segment

13. What is the use of an index?

A. Retrieve data more quickly and efficiently

B. Related data requires much less I/O overhead if accessed simultaneously

C. Simplify the user’s perception of data access

D. All of the Mentioned

Correct Answer is : Retrieve data more quickly and efficiently

14. Which of the following components comprise an Oracle architecture?

A. Database related background processes

B. Tablespaces

C. Datafiles

D. All of the Mentioned

Correct Answer is : All of the Mentioned

15. What is the use of extent in Oracle?

A. Stores user data within the database

B. Stores rollback information used when data must be rolled back

C. Minimize the amount of wasted (empty) storage

D. None of the Mentioned

Correct Answer is : Minimize the amount of wasted (empty) storage

16. Which area of PGA stores binding variables and run-time buffers information?

A. SQL area

B. Private SQL area

C. Stack space

D. Session area

Correct Answer is : Private SQL area

17. The ____________ contains a set of tables and views that Oracle uses as a reference to the database.

A. PGA

B. Library cache

C. Data dictionary

D. SGA

Correct Answer is : Data dictionary

18. In Oracle, which of below are types of segments?

A. Permanent Segment

B. Object Segment

C. Data Segment

D. All of the Mentioned

Correct Answer is : Data Segment

19. The redo log buffer and Shared pool are elements of?

A. PGA

B. Buffer cache

C. PGA and Buffer cache

D. SGA

Correct Answer is : SGA

20. What does DLL stand for ?

A. Dynamic Link Library

B. Dynamic Language Library

C. Dynamic Load Library

D. None of the Mentioned

Correct Answer is : Dynamic Link Library

Oracle Database interview questions part 2

Oracle Database interview questions part 2

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?

2. Collection of information stored in database at particular instance of time is called as ____________

3. Oracle database’s design is also called as_____________

4. What are the valid Oracle database schemas?

5. What do the schema objects comprise of?

6. Map entities, attributes and relations in Oracle is represented by___________

7. Modification schema of oracle database in one level without affecting the schema in high level is called as _______

8. A _______________ is used to logically group data together

9. A _____________ is a set of tables physically stored together as one table that shares a common column

10. What is the use of Library cache?

11. Which processes is an instance made of Oracle?

12. Which of the following segment is destroyed when the SQL statement is finished?

13. What is the use of an index?

14. Which of the following components comprise an Oracle architecture?

15. What is the use of extent in Oracle?

16. Which area of PGA stores binding variables and run-time buffers information?

17. The ____________ contains a set of tables and views that Oracle uses as a reference to the database.

18. In Oracle, which of below are types of segments?

19. The redo log buffer and Shared pool are elements of?

20. What does DLL stand for ?

Similar Interview Questions

Search for latest jobs

For Employers

For Partner

For Jobseekers

Help

Follow Us

snaprecruit

Download mobile appsJust Swipe to apply for jobs. Try it out !