Solved MCQ of Oracle and Distributed Database set-4

1. ………………….. is the collection of memory structures and Oracle background processes that operates against an Oracle database.

A) Database

B) Instance

C) Tablespace

D) Segment

2. A ………………………… is a logical grouping of database objects, usually to facilitate security, performance, or the availability of database objects such as tables and indexes.

A) tablespace

B) segments

C) extents

D) blocks


3. A tablespace is further broken down into …………………

A) tablespace

B) segments

C) extents

D) blocks

4. ……………………….. is a contiguous group of blocks allocated for use as part of a table, index, and so forth.

A) tablespace

B) segment

C) extent

D) block


5. ……………… is the smallest unit of allocation in an Oracle database.

A) Database

B) Instance

C) Tablespace

D) Database Block


6. An Oracle ………………………..is a set of tables and views that are used as a read-only reference about the database.

A) Database dictionary

B) Dictionary table

C) Data dictionary

D) Dictionary


7. A data dictionary is created when a …………………. created.

A) Instance

B) Segment

C) Database

D) Dictionary


8. An Oracle object type has two parts the …………………. and …………………….

A) Instance and body

B) Segment and blocks

C) Specification and body

D) Body and segment


9. By, default, Oracle object types are ………………………

A) INSTANTIABLE

B) NOT INSTANTIABLE

C) FINAL

D) OVERRIDING


10. A method modifier tells Oracle that new subtypes may not override a method is called …………….

A) INSTANTIABLE

B) NOT INSTANTIABLE

C) FINAL

D) OVERRIDING

Answers:

1. B) Instance

2. A) tablespace

3. B) segments

4. C) extent

5.  D) Database Block

6.  C) Data dictionary

7.  C) Database

8.  C) Specification and body

9.  A) INSTANTIABLE

10. C) FINAL

You Might also view the following Related Posts

• Solved MCQ of PL/SQL and Oracle set-1
• MCQ of PL/SQL and Oracle With Answer set -2
• Solved MCQ of SQL Server set-1
• Solved MCQ of Internet and HTML set-1
• Solved MCQ of Data Structure Set-2  
• Solved MCQ of Data Structure Set-1
• Solved MCQ of Oracle and Distributed Databases set-3
• MCQ of Structured Query Language(SQL) With Answer Set -2
• Solved MCQ of Database Management System (DBMS) Set - 3

You can view the following other posts

• Solved MCQ of System Analysis and Design Set-3
• Solved MCQ of Data Structure Set - 2
• Solved MCQ of Java for Java Proficiency test set-3
• MCQ of C++ with answer Set-2
• Solved MCQ of C set-1
• MCQ of Computer Networking with answer set-4
• Solved MCQ of Database Management System (DBMS) Set - 8

For other more Multiple Choice Questions (MCQs): Click Here