A file manipulation command that extracts some of the records from a file is called
SELECT
PROJECT
JOIN
PRODUCT
How many distinct tuples are there in a relation instance with cardinality 22 ?
22
11
1
none
Related fields in a database are grouped to form a
data file
data record
menu
bank
Which database level is closest to the users?
external
internal
physical
conceptual
The person who interact the database through query language is called
DBA
Application programmers
Sophisticated users
Naive user
Which of the following operations is used if we are interested only in certain columns of a table ?
PROJECTION
SELECTION
UNION
Which of the following operations need the participating relations to be union compatible ?
INTERSECTION
SET DIFFERENCE
All of the above
A set of possible data values is called
attribute
degree
tuple
domain
In the abstraction of a database system the external level is the
physical level
logical level
conceptual level
view level
A relational database developer refers to a record as
criteria
relation