DBMS QUIZ 2

The restrictions placed on the data.

• Relation

• Attribute

• Parameter

• Constraint

Which of the following isn’t a level of abstraction?

• physical

• logical

• user

• view

A logical structure of the database.

• Schema

• Attribute

• Parameter

• Instance

A level that describes data stored in a database and the relationships among the data.

• physical

• logical

• user

• view

In ER diagram an Entity set is represented by a

• Ellipse

• Rhombus

• Rectangle

• Triangle

An SQL statement which allows changing definition of Table is?

• CREATE

• ALTER

• UPDATE

• SELECT

In RDBMS a row is termed as

• attribute

• tuple

• relation

• degree

The full form of DDL is

• Dynamic data language

• Detailed Data Language

• Data Definition Language

• Data derivation language

Data dictionary is a file that contains:

• The names of all fields in all files

• The size or width of all fields in all files

• The Datatypes of all fields in all files

• All the above

The________ Datatype can store unstructured data

• CHAR

• VARCHAR

• NUMERIC

• RAW