Answered step by step
Verified Expert Solution
Link Copied!

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

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 (2NF)
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
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems Introduction To Databases And Data Warehouses

Authors: Nenad Jukic, Susan Vrbsky, Svetlozar Nestorov

1st Edition

1943153191, 978-1943153190

More Books

Students also viewed these Databases questions