NEW
Font size
WorksheetsLNCTE -DBMS-QUIZ-2
Total questions: 11
Worksheet time: 5mins
The relationship between two entity types is known as
Two-way relationship
Double relationship
Binary relationship
Multiple relationship
A foreign key must
Be numeric.
Match the field value of a primary key in a related table
Be defined in all tables in the database
Be unique.
The constraint that can be applied only at column level is_______
Primary key constraint
Foreign key constraint
Unique constraint
Not Null constraint
Which of the following relational algebra operations require two tables as input with exactly the
same attributes?
Join, cartesian product (multiplication), division
Project, restriction, union
Union, intersection, minus
Update, insert, delete
Which of these keywords is used to eliminate duplicate tuples from the resultant relation?
COUNT
DISTINCT
NONDUPLICATE
UNIQUE
Which of these is the correct command for inserting values in the Employee relation?
INSERT VALUES (‘John’, 2000) INTO Employee;
INSERT (‘John’, 2000) INTO Employee;
INSERT INTO Employee VALUES (‘John’, 2000);
INSERT (John , 2000) INTO Employee;
Which of these is the correct command to change “Jon” into “John” in the Name attribute of the
Employee relation?
UPDATE Employee SET Name =‘ John’ WHERE Name =‘ Jon’;
ALTER Employee SET Name =‘ Jon’ INTO Name =‘ John’;
UPDATE Employee SET Name =‘ Jon’ INTO Name =‘ John’;
ALTER Employee SET Name=‘John’ WHERE Name=‘Jon’;
Consider the following SQL statements:
(I) DELETE FROM Customer; (II) DROP TABLE Customer;
Only statement (I) permanently removes the relation Customer
Only statement (II) permanently removes the relation Customer
Both statements (I) and (II) permanently remove the relation Customer
None of these
Which of the following clauses is used to restrict groups returned by the GROUP BY clause?
DISTINCT
WHERE
EXISTS
HAVING
Given a relation R having three attributes X, Y and Z. Which of the following statements is true
according to augmentation rule?
If both X→Y and Y→Z hold, then X→Z holds.
If X→Y holds, then XZ→YZ holds.
If X→YZ holds, then both X→Y and X→Z hold.
If both X→Y and X→Z hold , then X→YZ holds.
Once the transaction executes its final operation, it enters into state.
Committed
Terminated
Partially committed
Failed
