NEW
Font size
WorksheetsQuiz No 1
Total questions: 10
Worksheet time: 2mins
The statement in SQL which allows to change the definition of a table is
(A) Alter
(B) Update.
(C) Create.
(D) select.
The statement in SQL which allows to change the values of a table is
(A) Alter.
(B) Update.
(C) Create.
(D) select.
Key to represent relationship between tables is called
(A) Primary key
(B) Secondary Key
(C) Foreign Key
(D) None of these
_______ produces the relation that has attributes of R1 and R2
(A) Cartesian product
(B) Difference
(C) Intersection
(D) Product
Which of the following operation is used if we are interested in only certain columns of a table?
(A) PROJECTION
(B) SELECTION
(C) UNION
(D) JOIN
Which of the following is a valid SQL type?
(A) CHARACTER
(B) NUMERIC
(C) FLOAT
(D) All of the above
The RDBMS terminology for a row is
(A) degree.
(B) relation.
(C) attribute
D) tuple.
The full form of DDL is
(A Dynamic Data Language
B) Detailed Data Language
(C) Data Definition Language
(D) Data Derivation Language
Which of the following is a legal expression in SQL?
(A) SELECT NULL FROM EMPLOYEE;
(B) SELECT NAME FROM EMPLOYEE;
(C) SELECT NAME FROM EMPLOYEE WHERE SALARY = NULL;
(D) None of the above
A set of possible data values is called
(A) attribute
(B) degree.
(C) tuple.
(D) domain.
