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
401. The term refers to a collection of related information
- Database
- List
- Outline
- Record
402. A form that is used to collect data in a structured manner for entry to a database is called a
- Database deign form
- Systems flowchart
- Data capture form
- None of above
403. The folowing command is used for inserting records
- INSERT
- ADD
- Both of the above
- None of the above
404. The Query is a statement requesting for
- Insertion of Information
- Deletion of Information
- Updata of information
- Retrieval of Information
405. The activity of a file
- Is a low percentage of number of records added or deleted from a file
- If high, reduces processing efficiency for sequential and non sequential files
- Is a measure of the percentage of existing records updated during a run
- Refers to how closely the files fit into the allocated
406. The following statement is not valid about indexing
- It stores the index fields
- It stores the corresponding record number
- It maintains the alphabetically order
- it duplicate the database file
407. The following devices can be used to input data into a database
- Keyboard, fax roller ball
- Mouse, keyboard, monitor
- Mouse, keyboard, touch screen
- None of the above
409. List command is used to get
- List of database contents
- List of database contents
- List of variables used in database file
- None of the abvoe
410. A field that uniquely identifies a record is called a
- Main field
- Header
- Key field
- None of above