DBI202 - Review 2

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

• Database

• Database Instance

• Schema

• Schema Instance

Choose the most correct statement.

• Database is created and maintained by a DMBS

• All of the others

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

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

Which of following is never used as a data model?

• Hierarchical data model

• None of the others

• Graph-based data model

• Tree-based data model

• Relational data model

A ____ is a relation name, together with the attributes of that relation.

• schema

• database

• database instance

• schema instance

A ___ is a notation for describing the structure of the data in a database, along with the constraints on that data

• data model

• database management system

• data operation

• data manipulation

A _____ is a language for defining data structures

• DDL

• DML

• DCL

• None of the others

Which statement is used to remove a relation named R?

• DROP TABLE R;

• REMOVE TABLE R;

• DELETE TABLE R;

• TRUNCATE TABLE R;

What is another term for a row in a relational table?

• Attribute

• Tuple

• Field

• Relation

What is the difference between the 2NF and the 3NF?

• 2NF deals with partial functional dependency, while 3NF deals with transitive functional dependency

• 2NF deals with transitive functional dependency, while 3NF deals with partial functional dependency

The key for a weak entity set E is .........

• Zero or more attributes of E

• The set of attributes of supporting relationships for E

• The set of attributes of supporting entity sets

• Zero or more attributes of E and key attributes from supporting entity sets