NEW
Font size
WorksheetsDBMS QUIZ 2
Total questions: 12
Worksheet time: 12mins
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
Data about data is normally termed as?
Directory
Data bank
Meta data
None of the above
A Data model is?
Used to describe the structure of the Database
Set of basic operations on Database
Both A & B
None of the above
