DBI_1to50

QN=1 (6803) A ____ is a logically coherent collection of data with some inherent meaning, representing some aspect

• 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)

• a. AB
• b. AC
• c. AD
• d. BD