DBI202_PART1

QN=1 (6803) A ____ is a logically coherent collection of data with some inherent meaning, representing some aspect of real world and being designed, built and populated with data for a specific purpose

• a. Database

• b. Database Instance

• c. Schema

• d. Schema Instance

QN=2 (6801) Choose the most correct statement.

• a. Database is created and maintained by a DMBS

• b. All of the others

• c. Database is a collection of data that is managed by a DBMS

• d. Database is a collection of information that exists over a long period of time

QN=3 (6802) Which of following is never used as a data model?

• a. Hierarchical data model

• b. None of the others

• c. Graph-based data model

• d. Tree-based data model

• e. Relational data model

QN=4 (6817) A ____ is a relation name, together with the attributes of that relation.

• a. schema

• b. database

• c. database instance

• d. schema instance

QN=5 (6824) A ___ is a notation for describing the structure of the data in a database, along with the constraints on that data

• a. data model

• b. database management system

• c. data operation

• d. data manipulation

QN=6 (6827) A _____ is a language for defining data structures

• a. DDL

• b. DML

• c. DCL

• d. None of the others

QN=7 (6834) Which statement is used to remove a relation named R?

• a. DROP TABLE R;

• b. REMOVE TABLE R;

• c. DELETE TABLE R;

• d. TRUNCATE TABLE R;

QN=8 (6829) What is another term for a row in a relational table?

• a. Attribute

• b. Tuple

• c. Field

• d. Relation

QN=9 (7961) Given a relation R(A,B,C,D). Which of the followings is trivial?

• a. A->AB

• b. A->->AB

• c. A->BCD

• d. A->->BCD

QN=10 (7972) Let R(ABCD) be a relation with functional dependencies
{A -> B,
C -> B,
B -> D}
What is the key for R (choose one)

• AB

• AC

• AD

• BD