Database Management System Quiz Questions and Answers Pdf - 1

Question: 1

The structure representing the organizational view of entire database is known as in MySQL database.

(A) Schema

(B) View

(C) Table

(D) Instance

Question: 2

MySQL is freely available and is open source.

(A) True

(B) False

Question: 3

Communication is established with MySQL using

(A) SQL

(B) Network calls

(C) API's

(D) Java

Question: 4

______ represents a tuple in a relational database?

(A) Row

(B) Table

(C) Column

(D) Object

Question: 5

______ command is used to delete a database.

(A) Drop database name

(B) Drop database database name

(C) Delete database_name

(D) Delete database databasename

Question: 6

Which language is used to request information from a Database?

(A) Query

(B) Compiler

(C) Relational

(D) Structural

Question: 7

Which type of below DBMS is MySQL?

(A) Relational

(B) Network

(C) Object Oriented

(D) Hierarchical

Question: 8

An entity set that does not have enough attributes to form primary key is known as

(A) Strong entity set

(B) Weak entity set

(C) Identity set

(D) Owner set

Question: 9

______ ensures that the changes in data value to be constant at any given instance.

(A) Consistency

(B) Atomicity

(C) Durability

(D) Isolation

Question: 10

The collection of records in Hierarchical models are called as ______

(A) Record types

(B) ACID

(C) Tubles

(D) Field types