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
241. What are the tasks which database administrators may be called upon to specifically perform?
- To enter and/or delete data in the database
- Performance monitoring and maintenance
- Deciding the Graphical User Interface (GUI) necessary for data entry
- Enhancing the SQL queries
242. Which of the following is an/are incorrect statement(s)?
- Seek-time = The time taken to extend/retract the read/write head.
- Rotational delay is also called Latency.
- Block transfer time is the time to locate and transfer an arbitrary block, given its address.
- The seek time and rotational delay when added is equal to Block transfer time.
243. A data processing system is
- a system that uniquely identifies a record in a file.
- an automated system, which organizes data to produce information.
- information on organized or summarized data.
- an automated system for processing the data of an organization.
244. Which of the following is an/are incorrect statement(s)? a. Pointer
- a,b and d
- a,b and c
- a,b,c and e
- a,b,c,d and e
245. Data transfer time refers to the
- amount of time required in transferring data from/to the disk to/from primary memory.
- expected time to access a disk address and transfer a block of data.
- time required activating a read/write head.
- time required for the disk to rotate the sought-for record under the read-write head.
246. The functions of a database administrator include(s): a. Defining database schema. b. Defining backup and recovery procedures. c. Granting authorization for data access. d. Managing storage structures and access methods.
- a,b
- b and c
- a,b,c and d
- a,b,c,
247. Which of the following statement(s) is/are true related to data, information and databases? a. A database is designed, built and populated with data or information for a specific purpose. b. A list of students who have scored more than fifty can be recognised as a set of data. c. Meta data allow database designers and users to understand what data exist, what the data mean, and their limitations. d. A sales person may include in his database, photographic images of customers and video clip
- a,b
- a,b and c
- c, d
- a,c and d
248. A database management software (DBMS) includes:
- Automated tools (CASE) used to design databases and application programs
- A software application that is used to define, create, maintain and provide controlled access to user databases.
- Application programs that are used to provide information to users.
- Database that contains occurrences of logically organised data or information.
249. Which of the following closely describe the limitations of traditional file processing systems? a. File descriptions of files are stored within each application program that accesses those files. b. A duplication of certain columns of a file used by one department may appear in another file used by another department of the organisation. c. Different application programs used in different departments can easily have inter- program communication to share data. d. Addition of a new attribut
- a,b and d
- a,b and c
- c, d
- b,d
250. In addition to the database management software, the other possible types of software a database system will have are a. languages used for coding user interfaces and application programs. b. presentation software for documenting the design of the database. c. computer-aided software engineering tools (CASE). d. a fourth generation language such as Embedded Structured Query Language.
- .) a,c and d
- a,b and c
- c, d
- b,d