Which two statements are true regarding subqueries? (Choose two.)

• A.The columns in a subquery must always be qualified with the name or alias of the table used.
• B.Only two subqueries can be placed at one level.
• C.A subquery can be used to access data from one or more tables or views.
• D.A subquery in the WHERE clause of a SELECT statement can be nested up to three levels only.
• E.If the subquery returns 0 rows, then the value returned by the subquery expression is NULL.

Comment: *

Name: *

Email: *

Verification: *

Examine the commands used to create DEPARTMENT_DETAILSand COURSE_DETAILS:
SQL>CREATE TABLE DEPARTMENT_DETAILS
( DEPARTMENT_ID NUMBER PRIMARY KEY,
DEPARTMENT_NAME VARCHAR2(50),
HOD VARCHAR2(50));
SQL>CREATE TABLE COURSE_DETAILS
(COURSE_ID NUMBER PRIMARY KEY,
COURSE_NAME VARCHAR2(50),
DEPARTMENT_ID VARCHAR2(50));
You want to generate a list of all department IDs along with any course IDs that may have been assigned to them.
Which SQL statement must you use?

• A.SELECT d.department_id, c.course_id FROM department_details d LEFT OUTER JOIN course_details c ON (d.department_id=c. department_id);
• B.SELECT d.department_id, c.course_id FROM department_details d RIGHT OUTER JOIN course_details c ON (d.department_id=c. department_id);
• C.SELECT d.department_id, c.course_id FROM course_details c LEFT OUTER JOIN department_details d ON (c.department_id=d. department_id);
• D.SELECT d.department_id, c.course_id FROM department_details d RIGHT OUTER JOIN course_details c ON (c.department_id=d. department_id);

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the EMP_DETAILS table given below:

Which two statements are true regarding SQL statements that can be executed on the EMP_DETAIL TABLE?

• A.You cannot add a new column to the table with LONG as the data type.
• B.An EMP_IMAGE column can be included in the GROUP BY clause.
• C.You can alter the table to include the NOT NULL constraint on the EMP_IMAGE column.
• D.An EMP_IMAGE column cannot be included in the ORDER BY clause.

Comment: *

Name: *

Email: *

Verification: *

Examine this query:
SELECT TRUNC (ROUND(156.00,-2),-1) FROM DUAL; What is the result?

• A.150
• B.16
• C.160
• D.100
• E.200

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true regarding the COUNT function? (Choose two.)

• A.COUNT(DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULL values in the INV_AMT column
• B.The COUNT function can be used only for CHAR, VARCHAR2 and NUMBER data types
• C.A SELECT statement using COUNT function with a DISTINCT keyword cannot have a WHERE clause
• D.COUNT(*) returns the number of rows including duplicate rows and rows containing NULL value in any of the columns
• E.COUNT(cust_id) returns the number of rows including rows with duplicate customer IDs and NULL value in the CUST_ID column

Comment: *

Name: *

Email: *

Verification: *