Oracle Cert IZ0-061 questions

Oracle Cert IZ0-061 questions

memorize.aimemorize.ai (lvl 286)
Section 1

Preview this deck

Primary Key

Front

Star 0%
Star 0%
Star 0%
Star 0%
Star 0%

0.0

0 reviews

5
0
4
0
3
0
2
0
1
0

Active users

0

All-time users

0

Favorites

0

Last updated

4 years ago

Date created

Mar 1, 2020

Cards (110)

Section 1

(50 cards)

Primary Key

Front

The PRIMARY KEY constraint uniquely identifies each record in a database table. Primary keys must contain UNIQUE values. A primary key column cannot contain NULL values. Most tables should have a primary key, and each table can have only ONE primary key.

Back

DDL

Front

Data Definition Language; - CREATE - ALTER - DROP - RENAME - TRUNCATE - COMMENT

Back

Attributes

Front

Back

Oracle Database

Front

A set of files on a disk

Back

Database Dictionary

Front

The Oracle server stores information about all tables in a special set of relational tables called the data dictionary, in order to manage them. It stores definitions of database objects in a centralized, ordered, and structured format.

Back

Instance

Front

The instance is a set of processes and memory structures: it exists on the CPU(s) and in the memory of the server node, and this existence is temporary.

Back

1NF

Front

1st normal form - deals with the issue of eliminating unnecessary repeating groups of data.

Back

Joining

Front

Joining, as a relational concept, refers to the interaction of tables with each other in a query. Third normal form, as discussed in Chapter 1, presented the notion of separating different types of data into autonomous tables to avoid duplication and maintenance anomalies and to associate related data using primary and foreign key relationships.

Back

Where may the demonstration schemas be created? (Choose the best answer.)

Front

The demonstration schemas can be created in any database.

Back

TCL

Front

Transaction Control Language; - COMMIT - ROLLBACK - SAVEPOINT

Back

A database schema

Front

A database schema is all the objects in the database owned by one user. Collection of objects.

Back

Which of these statements regarding SQL Developer are correct? (Choose two answers.)

Front

SQL Developer can be installed outside an Oracle Home SQL Developer can store passwords.

Back

Which of the following are requirements for using SQL Developer? (Choose two correct answers.)

Front

A Java Runtime Environment A graphical terminal

Back

Which of these constructs is not part of the SQL language? (Choose all that apply.)

Front

Iteration, based on WHILE.. Iteration, based on FOR..DO Branching, based on IF..THEN..ELSE

Back

Choose the WHERE clause that extracts the DEPARTMENT_NAME values containing the character literal "er" from the DEPARTMENTS table. The SELECT and FROM clauses are SELECT DEPARTMENT_NAME FROM DEPARTMENTS:

Front

WHERE DEPARTMENT_NAME LIKE '%er%';

Back

Selection

Front

Selection refers to the restriction of the tuples or rows selected from a relation (table). It is often not desirable to retrieve every row from a table

Back

Which two of the following conditions are equivalent to each other?

Front

WHERE COMMISSION_PCT IS NULL, and WHERE NOT(COMMISSION_PCT IS NOT NULL)

Back

column aliasing

Front

An alias is an alternate name for a column or an expression.

Back

DWH

Front

Data ware house

Back

3NF

Front

3rd Normal form

Back

Which two clauses of the SELECT statement facilitate selection and projection?

Front

SELECT, WHERE

Back

Foreign Keys

Front

Back

Oracle Home

Front

Oracle software installation: the set of files and directories containing the executable code and some of the configuration files.

Back

Web application

Front

A web application can be defined as any application with which users communicate with HTTP. Web applications usually run in at least three tiers: a database tier manages access to the data, the client tier (often implemented as a web browser) handles the local window management for communications with the users, and an application tier in the middle executes the program logic that generates the user interface and the SQL calls to the database.

Back

Which of the following WHERE clauses contains an error? The SELECT and FROM clauses are SELECT * FROM EMPLOYEES:

Front

WHERE JOB_ID IN (SA_REP,MK_MAN);

Back

DML

Front

Data Manipulation Language; - SELECT - INSERT - UPDATE - DELETE - MERGE

Back

concatenation operator

Front

This operator is used to join character expressions or columns together to create a larger character expression.

Back

2NF

Front

second normal form

Back

Crows Foot notation

Front

Describes relationships between entities in a data model

Back

Literal values

Front

These values refer to numeric, character, or date and time values found in SELECT clauses that do not originate from any database object.

Back

SQL is a set-oriented language. Which of these features is a consequence of this? (Choose the best answer.)

Front

One statement can affect multiple rows

Back

Null

Front

Null refers to an absence of data

Back

How can you move a schema from one user to another?

Front

B. You cannot move a schema from one user to another.

Back

DSS

Front

Data Support system

Back

RAC

Front

The simplest form of the database server is one instance connected to one database, but in a more complex environment one database can be opened by many instances concurrently.

Back

What languages can run within the database? (Choose all that apply.)

Front

SQL and PL/SQL and Java

Back

DCL

Front

Data Control Language; - GRANT - REVOKE

Back

Three concepts from relational theory encompass the capability of the SELECT statement

Front

projection, selection, and joining

Back

3GL's

Front

Back

Data that is modeled into a form suitable for processing in a relational database may be described as being (Choose the best answer.)

Front

Third normal form

Back

Normalize(With Data)

Front

Back

Choose the query that extracts the LAST_NAME, JOB_ID, and SALARY values from the EMPLOYEES table for records having JOB_ID values of either SA_REP or MK_MAN and having SALARY values in the range of $1,000 to $4,000. The SELECT and FROM clauses are SELECT LAST_NAME, JOB_ID, SALARY FROM EMPLOYEES:

Front

WHERE JOB_ID IN ('SA_REP','MK_MAN') AND SALARY BETWEEN 1000 AND 4000;

Back

Choose one false statement about the ORDER BY clause. A. When using the ORDER BY clause, it always appears as the last clause in a SELECT statement. B. The ORDER BY clause may appear in a SELECT statement that does not contain a WHERE clause. C. The ORDER BY clause specifies one or more terms by which the retrieved rows are sorted. These terms can only be column names. D. Positional sorting is accomplished by specifying the numeric position of a column as it appears in the SELECT list, in the ORDER BY clause.

Front

The ORDER BY clause specifies one or more terms by which the retrieved rows are sorted. These terms can only be column names.

Back

What components of the IT environment can Oracle Enterprise Manager Cloud Control manage? (Choose the best answer.)

Front

All of the above

Back

Oracle Registry Key

Front

HKEY_LOCAL_MACHINE SOFTWARE ORACLE KEY_OraDb12c_home1

Back

Relations

Front

Tables

Back

Which other two of the following conditions are equivalent to each other?

Front

WHERE SALARY <=5000 AND SALARY >=2000 and WHERE SALARY BETWEEN 2000 AND 5000

Back

An entity-relationship diagram shows data modeled into (Choose the best answer.)

Front

Two-dimensional tables

Back

OLTP

Front

Online transaction Processing

Back

projection

Front

refers to the restriction of attributes (columns) selected from a relation or table

Back

Section 2

(50 cards)

Which of the following statements are syntactically correct? (Choose all that apply.) A. SELECT E.EMPLOYEE_ID, J.JOB_ID PREVIOUS_JOB, E.JOB_ID CURRENT_JOB FROM JOB_HISTORY J CROSS JOIN EMPLOYEES E ON (J.START_DATE=E.HIRE_DATE); B. SELECT E.EMPLOYEE_ID, J.JOB_ID PREVIOUS_JOB, E.JOB_ID CURRENT_JOB FROM JOB_HISTORY J JOIN EMPLOYEES E ON (J.START_DATE=E.HIRE_DATE); C. SELECT E.EMPLOYEE_ID, J.JOB_ID PREVIOUS_JOB, E.JOB_ID CURRENT_JOB FROM JOB_HISTORY J OUTER JOIN EMPLOYEES E ON (J.START_DATE=E.HIRE_DATE); D. None of the above

Front

SELECT E.EMPLOYEE_ID, J.JOB_ID PREVIOUS_JOB, E.JOB_ID CURRENT_JOB FROM JOB_HISTORY J JOIN EMPLOYEES E ON (J.START_DATE=E.HIRE_DATE);

Back

What value is returned after executing the following statement? SELECT NVL2 (NULLIF('CODA', 'SID'), 'SPANIEL', 'TERRIER') FROM DUAL;

Front

SPANIEL

Back

How many rows of data are returned after executing the following statement? (Choose the best answer.) SELECT DEPT_ID, SUM(SALARY) FROM EMP GROUP BY DEPT_ID HAVING SUM(NVL(SALARY, 100)) > 400; Assume the EMP table has ten rows and each contains a SALARY value of 100, except for one, which has a null value in the SALARY field. The first and second five rows have DEPT_ID values of 10 and 20, respectively.

Front

Two rows

Back

Assuming SYSDATE=30-DEC-2007, what value is returned after executing the following statement? SELECT TRUNC (SYSDATE, 'YEAR') FROM DUAL;

Front

01-JAN-2007

Back

If SYSDATE returns 12-JUL-2009, what is returned by the following statement? SELECT TO_CHAR(SYSDATE, 'fmDDth MONTH') FROM DUAL;

Front

12TH JULY

Back

What value is returned after executing the following statement? (Choose the best answer.) SELECT LENGTH('How_long_is_a_piece_of_string? ') FROM DUAL;

Front

30

Back

What value is returned after executing the following statement? SUBSTR('How_long_is_a_piece_of_string? ','_', ' ') FROM DUAL;

Front

Howlongisapieceofstring

Back

If SYSDATE returns 12-JUL-2009, what is returned by the following statement? (Choose the best answer.) SELECT TO_CHAR(SYSDATE, 'fmMONTH, YEAR') FROM DUAL;

Front

JULY, TWO THOUSAND NINE

Back

If SYSDATE returns 12-JUL-2009, what is returned by the following statement? SELECT TO_CHAR(TO_DATE(TO_CHAR(SYSDATE, 'DD'), 'DD'), 'YEAR') FROM DUAL;

Front

TWO THOUSAND NINE

Back

Consider this generic description of a SELECT statement: Where could subqueries be used? (Choose all correct answers.) SELECT select_list FROM table WHERE condition GROUP BY expression_1 HAVING expression_2 ORDER BY expression_3;

Front

A. select_list B. table C. condition E. expression_2

Back

What value is returned after executing the following statement? (Choose the best answer.) SELECT SUBSTR('How_long_is_a_piece_of_string? ', 5, 4) FROM DUAL;

Front

The SUBSTR functions return a portion of char, beginning at character position, substring_length characters long. SUBSTR calculates lengths using characters as defined by the input character set. SUBSTRB uses bytes instead of characters. SUBSTRC uses Unicode complete characters. SUBSTR2 uses UCS2 code points. SUBSTR4 uses UCS4 code points. So the answer is long(no pun intended).

Back

The EMPLOYEES and DEPARTMENTS tables have two identically named columns: DEPARTMENT_ID and MANAGER_ID. Which statements join these tables based on both column values? (Choose all that apply.)

Front

SELECT * FROM EMPLOYEES E JOIN DEPARTMENTS D ON E.DEPARTMENT_ID=D.DEPARTMENT_ID AND E.MANAGER_ID=D.MANAGER_ID; AND SELECT * FROM EMPLOYEES JOIN DEPARTMENTS USING (DEPARTMENT_ID,MANAGER_ID); AND SELECT * FROM EMPLOYEES NATURAL JOIN DEPARTMENTS;

Back

Which of these are single-row character-case conversion functions? (Choose all that apply.)

Front

LOWER INITCAP

Back

What result is returned by the following statement? (Choose the best answer.) SELECT COUNT(*) FROM DUAL;

Front

1

Back

How many records are returned by the following query? (Choose the best answer.) SELECT SUM(SALARY), DEPARTMENT_ID FROM EMPLOYEES GROUP BY DEPARTMENT_ID; Assume there are 11 non null and 1 null unique DEPARTMENT_ID values. All records have a non null SALARY value.

Front

12

Back

When using ampersand substitution variables in the following query, how many times will you be prompted to input a value for the variable called JOB the first time this query is executed? SELECT FIRST_NAME, '&JOB' FROM EMPLOYEES WHERE JOB_ID LIKE '%'||&JOB||'%' AND '&&JOB' BETWEEN 'A' AND 'Z';

Front

3

Back

Choose any incorrect statements regarding conversion functions. (Choose all that apply.)

Front

TO_CHAR may convert date items to character items. TO_CHAR may convert numbers to character items. TO_DATE may convert date items to character items.

Back

equiloin

Front

A row is associated with one or more rows in another table based on the equality of column values or expressions.

Back

Assuming SYSDATE=07-JUN-1996 12:05pm, what value is returned after executing the following statement? SELECT ADD_MONTHS (SYSDATE - 1) FROM DUAL;

Front

07-MAY-1996 12:05pm

Back

How many rows of data are returned after executing the following statement? (Choose the best answer.) SELECT DEPT_ID, SUM(NVL(SALARY,100)) FROM EMP GROUP BY DEPT_ID HAVING SUM(SALARY) > 400; Assume the EMP table has ten rows and each contains a SALARY value of 100, except for one, which has a null value in the SALARY field. The first and second five rows have DEPT_ID values of 10 and 20, respectively.

Front

One row

Back

What value is returned after executing the following statement? Take note that 01-JAN-2009 occurs on a Thursday. (Choose the best answer.) SELECT NEXT_DAY('01-JAN-2009', 'wed') FROM DUAL;

Front

07-JAN-2009

Back

What value is returned after executing the following statement? SELECT MOD(14, 3) FROM DUAL;

Front

2

Back

JOIN ON

Front

Back

Join Using

Front

Back

If the REGIONS table, which contains 4 rows, is cross joined to the COUNTRIES table, which contains 25 rows, how many rows appear in the final results set? (Choose the best answer.)

Front

100 rows

Back

The DEFINE command explicitly declares a session-persistent substitution variable with a specific value. How is this variable referenced in an SQL statement? Consider an expression that calculates tax on an employee's SALARY based on the current tax rate. For the following session-persistent substitution variable, which statement correctly references the TAX_RATE variable? DEFINE TAX_RATE=0.14

Front

SELECT SALARY * &TAX_RATE TAX FROM EMPLOYEES;

Back

What value is returned after executing the following statement? SELECT TO_CHAR(1234.49, '999999.9') FROM DUAL;

Front

001234.5

Back

What value is returned after executing the following statement? (Choose the best answer.) SELECT SUM((AVG(LENGTH(NVL(SALARY, 0))))) FROM EMPLOYEES GROUP BY SALARY; Assume there are ten employee records and each contains a SALARY value of 100, except for one, which has a null value in the SALARY field.

Front

4

Back

Choose one correct statement regarding group functions.

Front

Group functions can operate on multiple rows at a time.

Back

What value is returned after executing the following statement? SELECT SUBSTR('How_long_is_a_piece_of_string? ','_', 5, 3) FROM DUAL;

Front

14

Back

What values are returned after executing the following statement? (Choose the best answer.) SELECT JOB_ID, MAX_SALARY FROM JOBS GROUP BY MAX_SALARY; Assume that the JOBS table has ten records with the same JOB_ID value of DBA and the same MAX_SALARY value of 100.

Front

An error is returned

Back

Choose one correct statement regarding the following query: SELECT * FROM EMPLOYEE E JOIN DEPARTMENTS D ON (D.DEPARTMENT_ID=E.DEPARTMENT_ID) JOIN LOCATIONS L ON (L.LOCATION_ID = D.LOCATION_ID);

Front

The JOIN...ON clause may be used for joins between multiple tables.

Back

Three pillars of relational theory,

Front

Selection, projection and joining

Back

If SYSDATE returns 12-JUL-2009, what is returned by the following statement? SELECT DECODE(TO_CHAR(SYSDATE, 'MM'), '02', 'TAX DUE', 'PARTY') FROM DUAL;

Front

PARTY

Back

nonequijoin

Front

In this case, a row is associated with one or more rows in another table if its column values fall into a range determined by inequality operators

Back

What value is returned after executing the following statement? SELECT NVL(SUBSTR('AM I NULL', 10), 'YES I AM') FROM DUAL;

Front

YES I AM

Back

Which of the following statements are syntactically correct? (Choose all that apply.) A. SELECT JH.JOB_ID FROM JOB_HISTORY JH RIGHT OUTER JOIN JOBS J ON JH.JOB_ID=J.JOB_ID; B. SELECT JOB_ID FROM JOB_HISTORY JH RIGHT OUTER JOIN JOBS J ON (JH.JOB_ID=J.JOB_ID); C. SELECT JOB_HISTORY.JOB_ID FROM JOB_HISTORY OUTER JOIN JOBS ON JOB_HISTORY.JOB_ID=JOBS.JOB_ID; D. None of the above

Front

SELECT JH.JOB_ID FROM JOB_HISTORY JH RIGHT OUTER JOIN JOBS J ON JH.JOB_ID=J.JOB_ID;

Back

What value is returned after executing the following statement? SELECT TO_NUMBER(1234.49, 999999.9) FROM DUAL;

Front

1234.5

Back

What value is returned after executing the following statement? (Choose the best answer.) SELECT AVG(NVL(SALARY, 100)) FROM EMPLOYEES; Assume there are ten employee records and each contains a SALARY value of 100, except for one employee, who has a null value in the SALARY field.

Front

100

Back

Which join is performed by the following query? (Choose the best answer.) SELECT E.JOB_ID,J.JOB_ID FROM EMPLOYEES E JOIN JOBS J ON (E.SALARY < J.MAX_SALARY);

Front

Nonequijoin

Back

The EMPLOYEES and DEPARTMENTS tables have two identically named columns: DEPARTMENT_ID and MANAGER_ID. Which of these statements joins these tables based only on common DEPARTMENT_ID values? (Choose all that apply.)

Front

None of the above

Back

What type of conversion is performed by the following statement? SELECT TO_NUMBER (1234.49, 999999.9) FROM DUAL;

Front

Implicit conversion

Back

Which values are returned after executing the following statement? (Choose all that apply.) SELECT COUNT(*), COUNT(SALARY) FROM EMPLOYEES; Assume there are ten employee records and each contain a SALARY value of 100, except for one, which has a null value in their SALARY field.

Front

10 and 9

Back

Choose one correct statement regarding the following query. SELECT C.COUNTRY_ID FROM LOCATIONS L RIGHT OUTER JOIN COUNTRIES C ON (L.COUNTRY_ID=C.COUNTRY_ID) WHERE L.COUNTRY_ID is NULL;

Front

No rows in the LOCATIONS table have the COUNTRY_ID values returned.

Back

The following query retrieves the LAST_NAME, SALARY, and COMMISSION_PCT values for employees whose LAST_NAME begins with the letter "R". Based on the following query, choose the ORDER BY clause that first sorts the results by the COMMISSION_PCT column, listing highest commission earners first, and then sorts the results in ascending order by the SALARY column. Any records with NULL COMMISSION_PCT must appear last: SELECT LAST_NAME, SALARY, COMMISSION_PCT FROM EMPLOYEES WHERE LAST_NAME LIKE 'R%'

Front

ORDER BY 3 DESC NULLS LAST, 2 ASC;

Back

Which of the following statements are syntactically correct? (Choose all that apply.) A. SELECT * FROM EMPLOYEES E JOIN DEPARTMENTS D USING (DEPARTMENT_ID); B. SELECT * FROM EMPLOYEES JOIN DEPARTMENTS D USING (D.DEPARTMENT_ID); C. SELECT D.DEPARTMENT_ID FROM EMPLOYEES JOIN DEPARTMENTS D USING (DEPARTMENT_ID); D. None of the above

Front

SELECT * FROM EMPLOYEES E JOIN DEPARTMENTS D USING (DEPARTMENT_ID);

Back

Natural Join

Front

Back

What value is returned after executing the following statement? (Choose the best answer.) SELECT SUM(SALARY) FROM EMPLOYEES; Assume there are ten employee records and each contains a SALARY value of 100, except for one, which has a null value in the SALARY field

Front

900

Back

How many rows are returned after executing the following statement? (Choose the best answer.) SELECT * FROM REGIONS R1 JOIN REGIONS R2 ON (R1.REGION_ID=LENGTH(R2.REGION_NAME)/2);

Front

3

Back

Which statements regarding single-row functions are true? (Choose all that apply.)

Front

They execute once for each record processed. They may have zero or more input parameters

Back

Section 3

(10 cards)

PRAGMA

Front

In Oracle PL/SQL, PRAGMA refers to a compiler directive or "hint" it is used to provide an instruction to the compiler. The directive restricts member subprograms to query or modify database tables and packaged variables. Pragma directives are processed at compile time where they pass necessary information to the compiler; they are not processed at runtime.

Back

Which comparison operator cannot be used with multiple-row subqueries? (Choose the best answer.) A. ALL B. ANY C. IN D. NOT IN E. All the above can be used.

Front

E. All the above can be used.

Back

Consider the following statement: SELECT last_name FROM employees JOIN departments ON employees.department_id = departments.department_id WHERE department_name = 'Executive'; and this statement: SELECT last_name FROM employees WHERE department_id IN (SELECT department_id FROM departments WHERE department_name = 'Executive'); What can be said about the two statements? (Choose two correct answers.) A. The two statements should generate the same result. B. The two statements could generate different results. C. The first statement will always run successfully; the second statement will error if there are two departments with DEPARTMENT_NAME='Executive'. D. Both statements will always run successfully, even if there are two departments with DEPARTMENT_NAME='Executive'.

Front

A. The two statements should generate the same result. D. Both statements will always run successfully, even if there are two departments with DEPARTMENT_NAME='Executive'.

Back

Consider this statement: SELECT employee_id, last_name FROM employees WHERE salary > (SELECT avg(salay) FROM employees); When will the subquery be executed? (Choose the best answer.) A. It will be executed before the outer query. B. It will be executed after the outer query. C. It will be executed concurrently with the outer query. D. It will be executed once for every row in the EMPLOYEES table.

Front

A. It will be executed before the outer query.

Back

What are the distinguishing characteristics of a scalar subquery? (Choose two correct answers.) A. A scalar subquery returns one row. B. A scalar subquery returns one column. C. A scalar subquery cannot be used in the SELECT LIST of the parent query. D. A scalar subquery cannot be used as a correlated subquery.

Front

A. A scalar subquery returns one row. B. A scalar subquery returns one column.

Back

Consider this statement: SELECT o.employee_id, o.last_name FROM employees o WHERE o.salary > (SELECT avg(i.salaty) FROM employees I WHERE i.department_id=o.department_id); When will the subquery be executed? (Choose the best answer.) A. It will be executed before the outer query. B. It will be executed after the outer query. C. It will be executed concurrently with the outer query. D. It will be executed once for every row in the EMPLOYEES table.

Front

D. It will be executed once for every row in the EMPLOYEES table.

Back

Which of the following statements are equivalent? (Choose two answers.) A. SELECT employee_id FROM employees WHERE salary < ALL (SELECT salary FROM employees WHERE department_id=10); B. SELECT employee_id FROM employees WHERE salary < (SELECT min(salary) FROM employees WHERE department_id=10); C. SELECT employee_id FROM employees WHERE salary NOT >= ANY (SELECT salary FROM employees WHERE department_id=10); D. SELECT employee_id FROM employees e JOIN departments d ON e.department_id=d.department_id WHERE e.salary < (SELECT min(salary) FROM employees) AND d.department_id=10;

Front

A. SELECT employee_id FROM employees WHERE salary < ALL (SELECT salary FROM employees WHERE department_id=10); B. SELECT employee_id FROM employees WHERE salary < (SELECT min(salary) FROM employees WHERE department_id=10);

Back

Consider this statement, which is intended to prompt for an employee's name and then find all employees who have the same job as the first employee: SELECT last_name, employee_id FROM employees WHERE job_id = (SELECT job_id FROM employees WHERE last_name = '&Name'); What would happen if a value were given for &Name that did not match with any row in EMPLOYEES? (Choose the best answer.) A. The statement would fail with an error. B. The statement would return every row in the table. C. The statement would return no rows. D. The statement would return all rows where JOB_ID is NULL.

Front

C. The statement would return no rows.

Back

A query can have a subquery embedded within it. Under what circumstances could there be more than one subquery? (Choose the best answer.) A. The outer query can include an inner query. It is not possible to have another query within the inner query. B. It is possible to embed a single-row subquery inside a multiple-row subquery, but not the other way around. C. The outer query can have multiple inner queries, but they must not be embedded within each other. D. Subqueries can be embedded within each other with no practical limitations on depth.

Front

D. Subqueries can be embedded within each other with no practical limitations on depth.

Back

Consider this statement: SELECT last_name, (SELECT count(*) FROM departments) FROM employees WHERE salary = (SELECT salary FROM employees); What is wrong with it? (Choose the best answer.) A. Nothing is wrong—the statement should run without error. B. The statement will fail because the subquery in the SELECT list references a table that is not listed in the FROM clause. C. The statement will fail if the second query returns more than one row. D. The statement will run but is extremely inefficient because of the need to run the second subquery once for every row in EMPLOYEES.

Front

C. The statement will fail if the second query returns more than one row.

Back