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
451. Each individual data items of record is caled a
- Field
- Data type
- Comment
- All of the above
452. A large collections of files are called
- Fields
- Records
- Databases
- File system
453. Memo field in database file is used to
- Store lengthy number
- Store images
- Store audio files
- Store long textual information
454. Applications that rely on database are
- Supermarket stock control, theater booking and payroll
- Accounts, online banking, PowerPoint presentations.
- Internet shopping, robotics, computer games
- Noneof above
455. Which of the following is not a Access database object ?
- Table
- form
- Query
- datasheet
456. Data owners must protect their data against corruption or loss. One sensible method to achieving this is to
- Take regular backups
- Keep a hardcopy printout of all data
- Keep fingers crossed at all times
- None of above
457. Facilities offered by databases are
- The ability to store a large amount of data in a structured format, easy update. Sort, query, production of reports
- Easy editing, spell check, perform calculations, replication
- The ability, to rotate images, copy and paste, fill scale
- None of above
458. Users who store data about real people for marketing purposes must register the data ad its potential use with
- The computer misuse controller
- The data protection controller
- HM customs and excise
- None of above
459. When you double click a query object, you open
- The object in design view
- The object in print preview
- The result off the query
- The underlying table on which the query is based
460. Checks that are added to databases to detect unsuitable data on inpt are called
- Validation
- Verification
- Vegetation
- None of above