Database Management System (DBMS) MCQs
Database Management System (DBMS) MCQs
Our experts have gathered these Database Management System (DBMS) MCQs through research, and we hope that you will be able to see how much knowledge base you have for the subject of Database Management System (DBMS) by answering these multiple-choice questions.
Get started now by scrolling down!
1: TRUNCATE statement in SQL is a?
A. DCL statement
B. DML statement
C. DDL statement
D. None of these
2: A condition that led to the development of database was?
A. None of these
B. The poliferation of data files
C. A demand for more data to support information needs
D. An increase in the amount of data handled by organizations
E. All of these
3: A second Normal form does not permit ...... dependency between a non prime attribute and the relation key?
A. Multi
B. Functional
C. Valued
D. Partial
4: Which filter method lets you filter records based on criterion you specify?
A. Filter by selection
B. Advanced filter
C. Auto filter
D. Filter by form
5: What type of relationship exists between a Teacher table and Class table?
A. One to Many
B. One to One
C. Many to many
D. Two to two
6: In a large DBMS?
A. Each sub schema contains every field in the logical schema
B. None of these
C. All of these
D. Each user can see only a small part of the entire database
E. Each user can access every sub schema
7: From which version Microsoft introduced Backstage View for Access Interface?
A. Access 2007
B. Access does not have Backstage View
C. Access 2003
D. Access 2010
8: Circular button with Office icon in it is
A. Control menu box
B. Office box
C. Company box
D. Control box
9: Grant and revoke are ....... statements.
A. DML
B. DDL
C. TCL
D. DCL
10: A locked file can be?
A. Accessed by only one user
B. Modified by users with the correct password
C. None of these
D. Is used to hide sensitive information
E. Modified by users with the correct password and Is used to hide sensitive information
11: Why do you pin an item in list?
A. None of these
B. To mark it to delete from list
C. To move it up and make it always available
D. To make it default database when you open Access
12: Arrange according to the size
A. Bit, field, byte, record
B. Byte, bit, record, field
C. Field, byte, record, bit
D. Record, field, byte, bit
13: The options like Save, Open Database, Print are available in
A. File menu
B. Home tab
C. Database Tools tab
D. Backstage View tab
14: .......... keyword is used to find the number of values in a column.
A. SUM
B. Add
C. COUNT
D. TOTAL
15: DBMS is a collection of ………….. that enables user to create and maintain a database.
A. Language Activity
B. Translators
C. Keys
D. Program
16: What type of relationship exists between a Student table and Fees table?
A. Many to many
B. One to One
C. One to many and many to many
D. One to Many
17: You can filter the display of different Access objects in navigation pane from
A. Drop down menu at the top of navigation pane
B. Sort & Filter group in Home menu
C. Database tab
D. View tab in ribbon
18: A logical schema
A. Is the entire database
B. Describes how data is actually stored on disk.
C. All of these
D. Is a standard way of organizing information into accessible parts.
19: Which filter method lets you filter the records that match the selected field?
A. Advanced filter
B. Filter by selection
C. Filter by form
D. Auto filter
20: Which of the following method can be used to add more tables in a database?
A. Table Wizard
B. By Entering Data
C. Design View
D. All of these
21: Controlled ____ makes a relational database work.
A. Relations
B. Logic
C. Chaos
D. Redundancy
22: Corporate databases are an example of a(n) _________ source of data.
A. Internal
B. Master data
C. A database
D. Data marts
23: Data ________ helps to ensure data integrity by maintaining information in only one place
A. Flexibility
B. Redundancy
C. Mapping
D. Centralization
24: Data elements in a relational database are organized into ____.
A. Tuple
B. False
C. Tables
D. Attribute
25: Data in a multidimensional database is organized in a ________ format.
A. Linear
B. Modular
C. Cube
D. Cellular
26: Data integrity problems are likely to occur when __________.
A. Data is duplicated
B. The data design has a​ N:M relationship
C. Minimum cardinalities are not met
D. Attribute conflicts are not resolved
E. Normal forms are used
27: Database management systems _____.
A. Are used to create, organize, and manage databases
B. Thin clients have no processing power.
C. They use natural language processing.
D. It is an independent program that can spread itself without attaching itself to a host program
28: Databases that not related or linked to other data are called ________ databases.
A. Flat
B. Globe
C. Four
D. Design
List of Database Management Sy...
Available in:
Database Management System (DBMS) MCQs
