On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Database Management System Set 33

Q1 | The relational model is based on the concept that data is organized and stored in two-dimensionaltables called ……………………….
  • Fields
  • Records
  • Relations
  • Keys
Q2 | ……………….. contains information that defines valid values that are stored in a column or datatype.
  • View
  • Rule
  • Index
  • Default
Q3 | Which of the syntax is correct for insert statement?i) insert into values ii) insert into (column list) values
  • i-only
  • ii-only
  • Both of them
  • None of them
Q4 | ………………. first proposed the process of normalization.
  • Edgar. W
  • Edgar F. Codd
  • Edward Stephen
  • Edward Codd
Q5 | For using a specific database …………… command is used.
  • Use database
  • use
  • Both A &B
  • None of them
Q6 | Which of the following is not comparison operator?
  • <>
  • <
  • 0
  • >=
Q7 | An outstanding functionality of SQL is its support for automatic ………… to the target data.
  • Programming
  • Functioning
  • Navigation
  • Notification
Q8 | ………………… is a special type of integrity constraint that relates two relations & maintainsconsistency across the relations.
  • Entity Integrity Constraints
  • Referential Integrity Constraints
  • Domain Integrity Constraints
  • Key Constraints
Q9 | ……………..specifies a search condition for a group or an aggregate.
  • GROUP BY Clause
  • HAVING Clause
  • FROM Clause
  • WHERE Clause
Q10 | Drop Table cannot be used to drop a table referenced by a …………… constraint.
  • Local Key
  • Primary Key
  • Composite Key
  • Foreign Key
Q11 | Which are the not features of a DBMS which provide a number of advantages for data management:
  • DML
  • DDL
  • SDL
  • None of these
Q12 | Minimal data redundancy means improved _________:
  • Data independence
  • Data consistency
  • Data integration
  • Data sharing
Q13 | Who access the database occasionally and have different needs each time:
  • Naïve users
  • Casual users
  • Sophisticated user
  • All of these
Q14 | System analyst and application programmers are commonly referred to as …………………….
  • Naïve users
  • Casual users
  • Software engineers
  • Programmers
Q15 | Who interact with the system without writing a program:
  • Naïve users
  • Casual users
  • Sophisticated user
  • All of these
Q16 | Who interact with the system by invoking one of the permanent application program:
  • Naïve users
  • Casual users
  • Sophisticated user
  • All of these
Q17 | The main interface that a naive user uses is a form interface using___:
  • DDL
  • GUI
  • OLAP
  • DML
Q18 | The provision of _______ is a major objective for database system:
  • Data independence
  • Data consistency
  • Data integration
  • Data sharing
Q19 | ____ is a translates into low-level instruction that a query processor understands:
  • DBA
  • DBMS
  • DBS
  • DDL compiler
Q20 | Retrieval of data is done by using a ____:
  • Stack
  • Query
  • Linked list
  • All of these
Q21 | DML is a language by which user accesses or manipulates the ________:
  • Data model
  • Data consistency
  • Data integration
  • Data sharing
Q22 | Which is the central component of the DBMS software that can also be termed as the database controlsystem?
  • Data consistency
  • Data integration
  • Data sharing
  • Data manager
Q23 | Which is stored information about description of data in the database:
  • Data files
  • Data dictionary
  • Database
  • Data administrator
Q24 | After conversion of high level queries into low level commands for file access and is calledcompiled_____:
  • DDL
  • DML
  • SDL
  • VDL
Q25 | Which is installs, configures, troubleshoots and maintains a database system:
  • DBA
  • DDL
  • DML
  • SDL