DBMS MCQ Questions and Answers
DBMS MCQ questions with answers form a vital part of technical exams and campus interviews. This topic explores database concepts, normalization, SQL queries, transaction management, and ER models. Practicing programming questions and answers from this section strengthens your database design and query optimization skills. These questions are frequently asked in GATE, Infosys, TCS, and Wipro assessments, making them essential for students and professionals alike. Detailed solutions and explanations make this section perfect for both beginners and advanced learners aiming to master database management fundamentals.
DBMS MCQ
Showing 10 of
527 questions
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