Question 1

If we have not specified ASC or DESC after a SQL ORDER BY clause, the following is used by default

Accepted Answer

ASC

Answer

DESC

Answer

There is no default value

Answer

None of the mentioned

Question 2

Which operator is used to compare the NULL values in SQL?

Accepted Answer

IS

Answer

Equal

Answer

None of Above

Answer

IN

Question 3

Which statement is used to get all data from the student table whose name starts with p?

Accepted Answer

SELECT * FROM student WHERE name LIKE 'p%';

Answer

SELECT * FROM student WHERE name LIKE '_p%';

Answer

SELECT * FROM student WHERE name LIKE '%p';

Answer

SELECT * FROM student WHERE name LIKE '%p%';

Question 4

Which of the following gives a logical structure of the database graphically?

Accepted Answer

Entity-relationship diagram

Answer

Architectural representation

Answer

Database diagram

Answer

Entity diagram

Question 5

Minimal Superkeys are called

Accepted Answer

Candidate keys

Answer

Domain keys

Answer

Attribute keys

Answer

Schema keys

Question 6

Which of the following in true regarding Referential Integrity?

Accepted Answer

Every foreign-key value must match a primary-key value in an associated table

Answer

Every primary-key value must match a primary-key value in an associated table

Answer

Every foreign-key value must match a foreign-key value in an associated table

Answer

Every primary-key value must match a foreign-key value in an associated table

Question 7

A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.

Accepted Answer

Referential

Answer

Primary

Answer

Specific

Answer

Referencing

Question 8

Which of the following can replace the below query?

SELECT name, course_id FROM instructor, teaches WHERE instructor_ID= teaches_ID;

Accepted Answer

Select name, course_id from instructor natural join teaches;

Answer

Select name,course_id from teaches,instructor where instructor_id=course_id;

Answer

Select name, course_id from instructor;

Answer

Select course_id from instructor join teaches;

Question 9

_______ produces the relation that has attributes of R1 and R2.

Accepted Answer

Cartesian product

Answer

Difference

Answer

Intersection

Answer

Product

Question 10

Consider the join of a relation R with relation S. If R has m tuples and S has n tuples, then the maximum size of join is:

Accepted Answer

mn

Answer

(m+n)/2

Answer

2(m+n

Answer

m+n

Related quizzes

Related quizzes