Free NR0-013 Braindumps


  • Exam Number: NR0-013
  • Provider: TeraData
  • Questions: 0
  • Updated On: 9-Nov-2018


QUESTION: 5
The employee table contains emp_no, emp_name and dept_no . The department table
contains dept_no and dept_name . Which query returns the employees who work in the
Finance Department?

A. SELECT emp_name FROM employee WHERE dept_name LIKE '%Finance%';
B. SELECT emp_name FROM employee WHERE dept_no IN (SELECT
e.dept_no FROM employee e WHERE dept_name LIKE '%Finance%');
C. SELECT emp_name FROM department WHERE dept_name LIKE
'%Finance%' and dept_no IN (SELECT e.dept_no FROM employee e);
D. SELECT emp_name FROM employee WHERE dept_no IN (SELECT
d.dept_no FROM department d WHERE dept_name LIKE '%Finance%');

Answer(s): D

QUESTION: 6
Which two statements about correlated subqueries are true? (Choose two.)

A. They require temporary table space.
B. They require special access rights to create.
C. They always join a table to a subset of the same table.
D. They allow the user to process data from the same table twice within the query.
E. They are one method for locating a maximum or minimum occurrence withingroups.

Answer(s): D, E

QUESTION: 7
The employee table contains only empno and name columns. The department table contains
only deptno and mgrno columns. Which query produces the names of all employees who are
department managers?

A. SELECT name FROM employee WHERE mgrno IN (SELECT mgrno FROMdepartment);
B. SELECT name FROM employee WHERE empno IN (SELECT mgrno FROM
department);
C. SELECT name FROM employee WHERE name IN (SELECT mgrno FROM
department);
D. SELECT name FROM employee WHERE empno NOT IN (SELECT mgrnoFROM
department);

Answer(s): B

QUESTION: 8
2

Get The Premium Version

Allbraindumps.com
 Test Questions PDF from Myitguides.com

 Test Questions PDF from Myitguides.com