Explore topic-wise MCQs in Database.

This section includes 95 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.

1.

Which of the following projects illustrates a database being designed from existing data?

A. A database using the Production Department's spreadsheets
B. A database designed to produce production reports for a new Production Department manufacturing process
C. A database that will combine two databases currently used by the Production Department
D. None of the above is correct.
Answer» B. A database designed to produce production reports for a new Production Department manufacturing process
Discussion
2.

You have run an SQL statement that asked the DBMS to display data in a table named USER_TABLES. The results include columns of data labeled "TableName," "NumberOfColumns" and "PrimaryKey." You are looking at ________.
A. user data
B. metadata
C. A report
D. indexes
Answer» C. A report
Discussion
3.

In E-R diagram generalization is represented by
A. Ellipse
B. Dashed ellipse
C. Rectangle
D. Triangle
Answer» E.
Discussion
4.

Hierarchical model is also called
A. Tree structure
B. Plex Structure
C. Normalize Structure
D. Table Structure
Answer» B. Plex Structure
Discussion
5.

In E-R Diagram relationship type is represented by
A. Ellipse
B. Dashed ellipse
C. Rectangle
D. Diamond
Answer» E.
Discussion
6.

__________________ is collection of interrelated data and set of program to access them.
A. Data Structure
B. Programming language
C. Database Management System
D. Database
Answer» D. Database
Discussion
7.

Database is collection of ____.
A. Modules
B. Data
C. None of these
D. Programs
Answer» C. None of these
Discussion
8.

Related fields in a database are grouped to form a
A. Data file
B. Data record.
C. Menu.
D. Bank.
Answer» C. Menu.
Discussion
9.

In __________ data can be stored in structured manner.
A. None of these
B. CPU
C. Database
D. ALU
Answer» D. ALU
Discussion
10.

Long form of DBA is ______________.
A. Database Application
B. None of these
C. Database Admin
D. Database Administrator
Answer» E.
Discussion
11.

DBMS stands for __________.
A. None of these
B. Database Administrator System
C. Database Basic Management System
D. Database Management System
Answer» E.
Discussion
12.

A database is a complex type of ______.
A. None of these
B. Application
C. Data Structure
D. Manager
Answer» D. Manager
Discussion
13.

The DBMS acts as an interface between what two components of an database system ?
A. Data and Database
B. Database and User
C. Database and SQL
D. Database Application and Database
Answer» E.
Discussion
14.

Before use of DBMS information was stored using __________.
A. Cloud Storage
B. None of these
C. File Management System
D. Data System
Answer» D. Data System
Discussion
15.

Which of the following is considered as DBMS ?
A. Oracle
B. Foxpro
C. All of these
D. Access
Answer» D. Access
Discussion
16.

DBMS should provide following feature(s) ______.
A. Protect data from system crash
B. All of these
C. Safety of the information stored
D. Authorized access
Answer» C. Safety of the information stored
Discussion
17.

The method in which records are physically stored in a specified order according to a key field in each record is
A. Hash
B. Direct.
C. Sequential
D. All of the above.
Answer» B. Direct.
Discussion
18.

Which one of the following statements is false?
A. The data dictionary is normally maintained by the database administrator.
B. Data elements in the database can be modified by changing the data dictionary.
C. The data dictionary contains the name and description of each data element.
D. The data dictionary is a tool used exclusively by the database administrator.
Answer» C. The data dictionary contains the name and description of each data element.
Discussion
19.

A subschema expresses
A. The logical view
B. The physical view.
C. The external view.
D. All of the above.
Answer» D. All of the above.
Discussion
20.

Conceptual design
A. Is a documentation technique.
B. Needs data volume and processing frequencies to determine the size of the database.
C. Involves modelling independent of the DBMS
D. Is designing the relational model.
Answer» D. Is designing the relational model.
Discussion
21.

The relational model feature is that there
A. Is no need for primary key data
B. Is much more data independence than some other database models
C. Are explicit relationships among records
D. Are tables with many dimensions
Answer» C. Are explicit relationships among records
Discussion
22.

The way a particular application views the data from the database that the application uses is a
A. Module.
B. Relational model.
C. Schema.
D. Sub schema.
Answer» E.
Discussion
23.

The property / properties of a database is / are :
A. It is an integrated collection of logically related records.
B. It consolidates separate files into a common pool of data records.
C. Data stored in a database is independent of the application programs using it
D. All of the above
Answer» E.
Discussion
24.

The database environment has all of the following components except:
A. Users.
B. Separate files
C. Database.
D. Database administrator
Answer» C. Database.
Discussion
25.

Which of the following are the properties of entities?
A. Groups
B. Table
C. Attributes
D. Switchboards
Answer» D. Switchboards
Discussion
26.

_______ produces the relation that has attributes of R1 and R2
A. Cartesian product
B. Difference
C. Intersection
D. Product
Answer» B. Difference
Discussion
27.

SET concept is used in :
A. Network Model
B. Hierarchical Model
C. Relational Model
D. None of these
Answer» B. Hierarchical Model
Discussion
28.

Data independence means
A. Data is defined separately and not included in programs
B. Programs are not dependent on the physical attributes of data.
C. Programs are not dependent on the logical attributes of data
D. Both (B) and (C).
Answer» E.
Discussion
29.

E-R model uses this symbol to represent weak entity set ?
A. Dotted rectangle
B. Diamond
C. Doubly outlined rectangle
D. None of these
Answer» D. None of these
Discussion
30.

A DBMS query language is designed to
A. Support end users who use English-like commands
B. Support in the development of complex applications software
C. Specify the structure of a database.
D. All of the above.
Answer» E.
Discussion
31.

Which are the two ways in which entities can participate in a relationship?
A. Passive and active
B. Total and partial
C. Simple and Complex
D. All of the above
Answer» C. Simple and Complex
Discussion
32.

Which of the following is an advantage of view?
A. Data security
B. Derived columns
C. Hiding of complex queries
D. All of the above
Answer» E.
Discussion
33.

Which database level is closest to the users?
A. External
B. Internal
C. Physical
D. Conceptual
Answer» B. Internal
Discussion
34.

The users who use easy-to-use menu are called
A. Sophisticated end users
B. Na ve users.
C. Stand-alone users.
D. Casual end user
Answer» C. Stand-alone users.
Discussion
35.

A primary key is combined with a foreign key creates
A. Parent-Child relationship between the tables that connect them
B. Many to many relationship between the tables that connect them.
C. Network model between the tables that connect them.
D. None of the above
Answer» B. Many to many relationship between the tables that connect them.
Discussion
36.

Which of the following is record based logical model?
A. Network Model
B. Object oriented model
C. E-R Model
D. None of these
Answer» B. Object oriented model
Discussion
37.

A file manipulation command that extracts some of the records from a file is called
A. SELECT
B. PROJECT
C. JOIN
D. PRODUCT
Answer» B. PROJECT
Discussion
38.

NULL is
A. The same as 0 for integer
B. The same as blank for character
C. The same as 0 for integer and blank for character
D. Not a value
Answer» E.
Discussion
39.

A data dictionary is a special file that contains:
A. The name of all fields in all files.
B. The width of all fields in all files.
C. The data type of all fields in all file
D. All of the above
Answer» E.
Discussion
40.

Which of the following is another name for weak entity?
A. Child
B. Owner
C. Dominant
D. All of the above
Answer» B. Owner
Discussion
41.

Which of the operations constitute a basic set of operations for manipulating relational data?
A. Predicate calculus
B. Relational calculus
C. Relational algebra
D. None of the above
Answer» D. None of the above
Discussion
42.

A set of possible data values is called
A. Attribute
B. Degree.
C. Tuple.
D. Domain.
Answer» E.
Discussion
43.

The result of the UNION operation between R1 and R2 is a relation that includes
A. All the tuples of R1
B. All the tuples of R2
C. All the tuples of R1 and R2
D. All the tuples of R1 and R2 which have common columns
Answer» D. All the tuples of R1 and R2 which have common columns
Discussion
44.

Which of the following database object does not physically exist?
A. Base table
B. Index
C. View
D. None of the above
Answer» D. None of the above
Discussion
45.

The conceptual model is
A. Dependent on hardware
B. Dependent on software.
C. Dependent on both hardware and software
D. Independent of both hardware and software
Answer» E.
Discussion
46.

The RDBMS terminology for a row is
A. Tuple.
B. Relation.
C. Attribute.
D. Degree.
Answer» B. Relation.
Discussion
47.

What is a relationship called when it is maintained between two entities?
A. Unary
B. Binary
C. Ternary
D. Quaternary
Answer» C. Ternary
Discussion
48.

It is better to use files than a DBMS when there are
A. Stringent real-time requirements
B. Multiple users wish to access the data
C. Complex relationships among data
D. All of the above.
Answer» C. Complex relationships among data
Discussion
49.

In a relation
A. Ordering of rows is immaterial
B. No two rows are identical
C. (A) and (B) both are true
D. None of these
Answer» D. None of these
Discussion
50.

Which of the following operation is used if we are interested in only certain columns of a table?
A. PROJECTION
B. SELECTION
C. UNION
D. JOIN
Answer» B. SELECTION
Discussion