Q. The clause used in CREATE TABLE statement in SQL to specify secondary keys is called

View solution

Q. The possible actions of altering the tables in Standard Query Language includes

View solution

Q. The type of bit strings which is preceded by 'B' and is placed between single quotes is classified as

View solution

Q. In CREATE TABLE SQL command, each table must have atleast column/s

View solution

Q. Which of the following information does an SQL DDL not specify?

View solution

Q. Which of the following data types does the SQL standard not support?

View solution

Q. Which command is used to create a new relation in SQL

View solution

Q. If a1, a2, a3 are attributes in a relation and S is another relation, which of the following is an incorrect specification of an integrity constraint?

View solution

Q. What is the syntax to load data into the database? (Consider D as the database and a, b, c as data)

View solution

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