quiz DBI202

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

To create a DEFAULT constraint on the "City" column of the table PERSON which is already created, use the following SQL:

• ALTER TABLE Person

  EDIT COLUMN City SET DEFAULT 'Da Nang'

• ALTER TABLE Person

  ALTER COLUMN City SET DEFAULT 'Da Nang'

• ALTER TABLE Person

  UPDATE COLUMN City SET DEFAULT 'Da Nang'

• ALTER TABLE Person

  MODIFY COLUMN City SET DEFAULT 'Da Nang'

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

• DML

• DDL

• 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

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

• A->AB

• A->->AB

• A->BCD

• A->->BCD

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