Select __________ from instructor where dept name= ’Comp. Sci.’; Which of the following should be used to find the mean of the salary?

Given the following schema: employees(emp-id, first-name, last-name, hire-date, dept-id, salary) departments(dept-id, dept-name, manager-id, location-id) You want to display the last names and hire dates of all latest hires in their respective departments in the location ID 1700. You issue the following query: SQL>SELECT last-name, hire-date FROM employees WHERE (dept-id, hire-date) IN (SELECT dept-id, MAX(hire-date) FROM employees JOIN departments USING(dept-id) WHERE location-id = 1700 GROUP BY dept-id); What is the outcome?

A

It executes but does not give the correct result

B

It executes and gives the correct result.

C

It generates an error because of pairwise comparison

D

It generates an error because the GROUP BY clause cannot be used with table joins in a subquery.

Consider the relation Emp-Dept with SSn as key Ename SSn EAddr Dept. No Dept. Name Dept. Manager SSn Which of the following is (are) invalid operation(s)? a) Inserting an employee without name and address b) Inserting an employee with only SSn c) Inserting a department with no employee d) Inserting an employee without SSn

A

a

B

d

C

c and d

D

b and c

Consider a database that has the relation schemas EMP(EmpId, EmpName, DeptId), and DEPT(DeptName, DeptId) Note that the deptId can be permitted to be NULL in the relation EMP. Consider the following queries on the database expressed in tuple relational calculus. (I) { t |∃u ∈ EMP(tEmpName] = u[EmpName] ∧ ∀ v∈ DEPT(t[DeptId] ≠ v[DeptId]))} (II) {t |∃ u ∈ EMP(t[EmpName] = u[EmpName] ∧ ∃ v ∈ DEPT(t[DeptId] ≠ v[DeptId]))} (III) {t | ∃ u∈ EMP(t[EmpName] = u[EmpName] ∧ ∃ v ∈ DEPT(t[DeptId] = v[DeptId]))} Which of the above queries are safe?

A

(I) and (II) only

B

(I) and (III) only

C

(II) and (III) only

D

(I), (II) and (III)

There are five actors S, T, U, V and W in a play. The salary of S is Rs. 10000 and the salary of T is 25% less than the salary of U whose salary is 50% more than the salary of S. The salary of V is Rs. 20000 which is Rs. 6000 more than the salary of W. Average salary of three lowest paid actors is what percent of the average salary of the three highest paid actors?

A

80.80%

B

71.93%

C

67.45%

D

83.45%

E

83.33%

Monthly salary of six persons A, B, C, D, E and F are 10000, 15000, 20000, 25000, 30000 and 35000 (not necessarily in the same order). Who has the highest salary among all? I. B’s salary is neither 10000 nor 25000. E’s salary is 5000 more than the B’s salary. II. E’s salary is 10000 less than the C’s salary. Salary of C is not 30000.

A

Only I is sufficient

B

Only II is sufficient

C

Data is Insufficient

D

Both the statements are required

P's salary is 40% more than Q’s salary. R's salary is ¾ of Q's salary. Now the salary of P and Q is increased by 5% and salary of R is increased by 8%. After increment, what percent of P’s salary is the salary of R?

A

56.78%

B

53.57%

C

18.66%

D

55.10%

E

50%

Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only functional dependencies are from dept name to the other attributes. This relation is in

A

Fourth NF

B

BCNF

C

Third NF

D

Second NF

Total salary of A, B and C is Rs. 86000. Salary of A is 40% less than salary of B and salary of C is Rs. 5000 less than salary of B. Salary of A is what percent of salary of C?

A

77.77%

B

70%

C

19.99%

D

33%

E

45%

Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary) Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations.

A

Attributes of common

B

Tuple of common

C

Tuple of distinct

D

Attributes of distinct

Select ID, name, dept name, salary * 1.1 where instructor; The query given below will not give an error. Which one of the following has to be replaced to get the desired output?

A

Salary*1.1

B

ID

C

Where

D

Instructor

Select __________ from instructor where dept name= ’Comp. Sci.’; Which of the following should be used to find the mean of the salary?

Related Questions