Most Important Database Mcqs

Database is a data structure that stores organized information. Most databases contain multiple tables, which may each include several different fields. For example, a company database may include tables for products, employees, and financial record.

Database Mcqs Set 1

1. DBMS is a collection of ………….. that enables user to create and maintain a database.
A) Keys
B) Translators
C) Program
D) Language Activity

2. In a relational schema, each tuple is divided into fields called 
A) Relations
B) Domains
C) Queries
D) All of the above

3. In an ER model, ……………. is described in the database by storing its data.
A) Entity
B) Attribute
C) Relationship
D) Notation

4. DFD stands for
A) Data Flow Document
B) Data File Diagram
C) Data Flow Diagram
D) Non of the above

5. A top-to-bottom relationship among the items in a database is established by a 
A) Hierarchical schema
B) Network schema
C) Relational Schema
D) All of the above

6. ……………… table store information about database or about the system.
A) SQL
B) Nested
C) System
D) None of these

7. …………..defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
A) Instance 
B) Schema
C) Program
D) Super Key

8. ……………… clause is an additional filter that is applied to the result.
A) Select
B) Group-by
C) Having
D) Order by

9. A logical schema 
A) is the entire database
B) is a standard way of organizing information into accessible parts.

C) Describes how data is actually stored on disk.
D) All of the above

10. ………………… is a full form of SQL.
A) Standard query language
B) Sequential query language
C) Structured query language
D) Server side query language

Next

Leave a Reply

Your email address will not be published. Required fields are marked *