Q. Which of the following commands do we use to delete a relation (R) from a database?

View solution

Q. Which of the following commands do we use to delete all the tuples from a relation (R)?

View solution

Q. Choose the correct command to delete an attribute A from a relation R

View solution

Q. create table apartment(ownerID varchar (5), ownername varchar(25), floor numeric(4,0), primary key (ownerID));
Choose the correct option regarding the above statement

View solution

Q. What does the notnull integrity constraint do?

View solution

Q. Which of the following keywords is used beside the select clause to explicitly specify that duplicates are not removed?

View solution

Q. Which of the following logical connectives is not included in SQL?

View solution

Q. The where clause is a predicate involving attributes of the relation in the ______ clause.

View solution

Q. select distinct dept_name
from institute;

What does the above query do?

View solution

Q. What does the following query do?
select name, ID, branch

from student, department

where student.branch = department.branch;

View solution

Q. The ________ clause is used to list the attributes desired in the result of a query

View solution

Q. If we specify multiple relations in the from clause and do not specify any conditions in the where clause, what will the result be?

View solution

Q. State true or false: Multiple conditions in the where clause are separated by a “,”

View solution

Q. What does the natural join operation do?

View solution

Q. Observe the following query and choose the correct option.
select name, ID

from student natural join department natural join section

View solution

Q. Which keyword is used to rename a relation in a query?

View solution

Q. While operating with strings, what does “_ _ _%” match with?

View solution

Q. What is the function of the union operation?

View solution

Q. What is the function of the intersect operation?

View solution

Q. What is the function of the except operation?

View solution