$30-$Find the error in the query "create view faculty as select ID$,$ name, dept name from instructor;"

a$)$ instructor

b$)$ select

c$)$ vicw $...$ as

d$)$ all of them

e$)$ none of them

$31-$ To include integrity constraint in an existing relation, one can use :

a$)$ create table

b$)$ modify table

c$)$ alter table

d$)$ drop table

c$)$ none of them

$32-$ Which of the following is not an integrity constraint?

a$)$ not null

b$)$ positive

c$)$ check 'predicate'

d$)$ unique

e$)$ none of them

$33-$ The query below must use to delete entries in the referenced table when a course is deleted. create table course $(...$ foreign key $($dept$\_$name$)$ references department $...)$

a$)$ delete

b$)$ delete cascade

c$)$ set null

d$)$ all of them

e$)$ none of them

$34-$ Tables in second normal form $(2$NF$)$

a$)$ eliminate all hidden dependencies

b$)$ eliminate the possibility of insertion anomalies

c$)$ have a composite key

d$)$ eliminate multiple tuples

e$)$ do not allow foreign keys

$35-$Consider the following query and pick the correct answer below:

select customer$\_$name, sales$\_$quota from customer

where customer.salesman id in $($select

salesman.id where name $=$ 'SMITH'$)$;

a$)$ it will select the name and city of the customers of the salesmen "SMITH"

b$)$ it will select the name of the customers and the quota of the salesmen "SMITH"

c$)$ it will select both name and city of customers and the quota of the salesmen "SMITH"

d$)$ it will produce an error

e$)$ none of the above

$36-$ The clause is used to combine the output from multiple queries into a single result table

a$)$ intersect

b$)$ divide

c$)$ collate

d$)$ using

e$)$ union

$37-$ Embedded SQL consists of:

a$)$ SQL statements included in another language.

b$)$ SQL encapsulated inside of other SQL statements.

c$)$ SQL written into a front$-$end application.

d$)$ SQL translated to a lower$-$level language.

e$)$ none of them

$38-$ The following query returns the name and surname of employees

select name, surname from employee

where salary $>($select avg$($salary$)$ from employee where emp$\_$id between $1000$ and $2$

a$)$ whose salaries are between $1000$ and $2000$

b$)$ whose salaries are greater than $1000$

c$)$ whose salaries are less than $2000$

d$)$ whose average "emp$\_$id$"$s are between $1000$ and $2000$