Database Management System Quiz

Question 1

Who created the first DBMS

Answer 1

Charles Bachman

Question 2

database is collection of ________

Answer 2

Columns

Question 3

Most popular commercial DBMS

Answer 3

Oracle

Question 4

DBMS is what type of software ?

Answer 4

It is a type of system software

Question 5

What is data about data

Answer 5

Meta data

Question 6

Relational Calculus is what type of language

Answer 6

Non -procedural language

Question 7

Which of the following is procedural language

Answer 7

Relational Algebra

Question 8

cardinality is termed as

Answer 8

number of tuples

Question 9

In a relation database, every tuples divided into fields are known as ________

Answer 9

Domains

Question 10

What are different views to represent a Table

Answer 10

Design View, Datasheet View, Pivot Table View

Question 12

What are types of database

Answer 12

Relational, Object Database, NoSql, Hierarchical, Centralized, Operational, Cloud, Network, Distributed

Question 13

Which command is used to remove a relation from SQL

Answer 13

Drop Table

Question 14

Report Generators are used to

Answer 14

Retrieve information from files, Answer queries

Question 15

Tell types of SQL commands and all commands that come under it

Answer 15

1. DDL : Create, Alter, Drop, Truncate, Rename
2. DML : Select, Insert, Update, Delete
3. DCL : Grand, Revoke
4. TCL: Commit, Rollback, Saveprint

Question 16

External Database is

Answer 16

Database Created using DBMS package

Question 17

Which command creates and initializes one or more memory variables ?

Answer 17

STORE

Question 18

What are types of Intigrity constraint

Answer 18

1. Domain Constraint (Attributes are of same considered datatype)
2. Entity Integrity Constraint (Not null like primary key)
3. Referential Integrity Constrain (related to foreign key)
4. Key Constraint (Unique like id, addhar no.)

Question 19

Steps of transaction Processing Cycle

Answer 19

1. Data Entry
2. Transaction Processing
3. Database Management
4. Transaction Validation
5. Commit or Rollback
6. Output Generation
7. Transaction End

Question 20

What does data dictionary Identify

Answer 20

field types, field names, field formats, field constraints, field descriptions, field

Question 21

Minimum size that is supported by FAT

Answer 21

4 GB

Question 22

Maximum size that is supported by NTFS ?

Answer 22

4 GB

Question 23

Which command is used to save any transaction permanently into database

Answer 23

Commit

Question 24

Which field has width of 8 bytes

Answer 24

Data/Time

Question 25

Properties of Transaction, meaning of each property

Answer 25

Atomicity : Either all commands are performed or none
Consistency : Data is in consistent state when transaction starts and ends
Isolation : Transactions that run concurrently appear to be serialized
Durability : Once change is done in db it should be permanent