a$)$ instructor

b$)$ select

c$)$ view... at

d$)$ all of them

a$)$ create table

b$)$ medify table

g relaction, one can use:

e$)$ none of them

$32.$ Which of the following is not an inceatity calter table

a$)$ not null

b$)$ positive

d$)$ drop table

e$)$ none of them

$33-$ The quety 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 $2000)$;

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$

e$)$ whose salaries are more than average of employees' with "emp$\_$id$"$s between $1000$ and $20$

$5$