Database Management System Set 33
Computer Science Engineering (CSE),
Bachelor of Science in Computer Science FY (BSc CS),
Bachelor of Science in Computer Science SY (BSc CS),
Bachelor of Science in Information Technology SY (BSc IT),
Bachelor of Computer Applications (BCA),
Bachelor of Business Administration in Computer Applications (BBA [CA]),
Bachelor of Science in Information Technology (BSc IT),
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
- 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