DBMS MCQ Question and Answer
DBMS MCQ Question and Answer
1. What does the abbreviation DBMS stand for?
- Database Manipulation Software.
- Database Management System.
- Data Borrowing and Movement Software.
- Digital Base Mapping System.
2. ORACLE database is comprised of
- Data files
- Redo Log files
- Control files
- All the above
3. The components of Physical database structure of Oracle Database is
- Data files
- Redo Log files
- Control files
- Table Space
4. The components of logical database structure of Oracle Database is
- Data files
- Data base Schema Objects
- Control files
- Table Space
5. A database is divided into Logical Storage Unit called
- Data files
- Redo Log files
- Control files
- tablespaces
6. SYSTEM TABLESPASCE is
- Which is automatically created when the database is created
- Which is installed with oracle
- There is no SYSTEM TABLESPASCE
- None of the above
7. SYSTEM tablespace always contains
- The data dictionary tables for the entire database.
- The programs
- All the redolog and control files
- None of the above
8. The relationship among Database, Tablespace
- Both are related to physical database
- Both are related to logical database
- There is no relation ship at all
- Each databases logically divided into one or more tablespaces
9. The relationship among Tablespace and datafile
- Both are related to physical database
- Both are related to logical database
- There is no relation ship at all
- One or more data files are explicitly created for each tablespace.
10. what is schema
- A schema is collection of database objects of a User.
- Collection of files
- Collection databases
- All the above