Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3 0 - Find the error in the query create view faculty as select ID , name, dept name from instructor; a ) instructor b
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
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
Which of the following is not an integrity constraint?
a not null
b positive
c check 'predicate'
d unique
e none of them
The query below must use to delete entries in the referenced table when a course is deleted. create table course foreign key deptname references department
a delete
b delete cascade
c set null
d all of them
e none of them
Tables in second normal form 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
Consider the following query and pick the correct answer below:
select customername, salesquota 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
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
Embedded SQL consists of:
a SQL statements included in another language.
b SQL encapsulated inside of other SQL statements.
c SQL written into a frontend application.
d SQL translated to a lowerlevel language.
e none of them
The following query returns the name and surname of employees
select name, surname from employee
where salary select avgsalary from employee where empid between and
a whose salaries are between and
b whose salaries are greater than
c whose salaries are less than
d whose average "empids are between and
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started