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 ……………………….
Q2 | ……………….. contains information that defines valid values that are stored in a column or datatype.
Q3 | Which of the syntax is correct for insert statement?i) insert into values ii) insert into (column list) values
Q4 | ………………. first proposed the process of normalization.
Q5 | For using a specific database …………… command is used.
Q6 | Which of the following is not comparison operator?
Q7 | An outstanding functionality of SQL is its support for automatic ………… to the target data.
Q8 | ………………… is a special type of integrity constraint that relates two relations & maintainsconsistency across the relations.
Q9 | ……………..specifies a search condition for a group or an aggregate.
Q10 | Drop Table cannot be used to drop a table referenced by a …………… constraint.
Q11 | Which are the not features of a DBMS which provide a number of advantages for data management:
Q12 | Minimal data redundancy means improved _________:
Q13 | Who access the database occasionally and have different needs each time:
Q14 | System analyst and application programmers are commonly referred to as …………………….
Q15 | Who interact with the system without writing a program:
Q16 | Who interact with the system by invoking one of the permanent application program:
Q17 | The main interface that a naive user uses is a form interface using___:
Q18 | The provision of _______ is a major objective for database system:
Q19 | ____ is a translates into low-level instruction that a query processor understands:
Q20 | Retrieval of data is done by using a ____:
Q21 | DML is a language by which user accesses or manipulates the ________:
Q22 | Which is the central component of the DBMS software that can also be termed as the database controlsystem?
Q23 | Which is stored information about description of data in the database:
Q24 | After conversion of high level queries into low level commands for file access and is calledcompiled_____:
Q25 | Which is installs, configures, troubleshoots and maintains a database system: