1) Here which of the following displays the unique values value of the column SELECT ------dep_name from instructor.

1) Here which of the following displays the unique values value of the column SELECT dep_name from instructor..

2)which command is used to remove the table’CUSTOMER’? a)Delete the structure only b)Truncate c)Drop table customer d)Remove table customer (ANS C).

3)The DROP TABLE Statement a)Delete the table structure only b)Delete the table structure along with the table data c)Works whether or not referential integrity constraints would be violated d)Is not an SQL statement. (ANS B).

nd. 4) which is valid create TABLE statement? a)create table customer add(id number(3)); b)create table customer(id number(3)); c)create table customer modified (id number(3)); (ANS B).

5)which of the following are some common RDBMS in use? a)Oracle b)My Sql c)HeidiSql d)all of the above (ANS D).

6)what command is used to create a newtable in sql? a)CREATE TABLE b)BUILD TABLE c)GENERATE TABLE d)none of the above (ANS A).

7)what does the following statement in sql do? a)Deletes a table called student b)Creates a table called student c)Check if these is a table called student d)None of the above (ANS A).

8)which of the following are type of unicode character string types in sql? a)nchar b)ntext c)both a and b d)none of these (ANS C).

9) It is mandatory to define constraint for each attribute of a table? a)True b)False (ANS B).

10) which of the following datatype is most appropriate for storing a string of up to255? a)TEXT b)TINY TEXT c)BLOB d)BINARY (ANS B).

11)what happens when no values is inserted in an ENUM list? a)Nothing happens b)The code will crash c)A blank value is inserted in that case d)None of the above (ANS C).

12)Which of the following command is used to delete all rows and freeup space from table? a)TRUNCATE b)DROPS c)DELETE d)ALTER (ANS A).

alue. 13) which sql constraint do we use to set some values to a field whose value has not been added explicity? a)unique b)NotNil c)Default d)Check (ANS C).

14)During transaction before commit which of the following statement is done automatically incase of shutdown? a)Rollback b)Commit c)View d)Flashback (ANS A).

15)which of the following allows you to unique key indentify a tuple? a)schema b)attribute c)superkey d)domain (ANS C).

16)Each table can contain more than one primary key? a)True b)False (ANS B).

17)To select some particular columns which of the following commands is used? a)PROJECTION b)SELECTION c)JOIN d)UNION (ANS A).

18)primary key can be? a)NULL b)NOTNULL c)Both a and b d)Depends on the sutivation (ANS B).

19)unique constraints ensure that all the values in a column are distinct/unique? a)true b)false (ANS A).

20)select the valid SQL type? a)Numeric b)Character c)Float d)All of the above (ANS D).

21)NATURAL join can also be termed as? a)combination of union and cartesion product b)combination of intersection and cartesian product c)combination of projection and cartesian product d)none of the above (ANS C).

22)How can view all the trigger currently in the database? a)Show b)view c)read d)none of the above (ANS A).

23)Select the correct foreign key constraint? a)Referential integrity b)Entity integrity c)Domain integrity d)None of these (ANS A).

24)A Null value is treated as a blank or zero? a)true b)false (ANS B).

25)Sql view also known as? a)schema b)virtual table c)instance d)none of the above (ANS B).