최신Oracle Database SQL - 1z0-071무료샘플문제

A. COUNT(*) returns the number of rows including duplicate rows and rows containing NULL value in any of the columns

B. COUNT(DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULL values in the INV_AMT column

C. The COUNT function can be used only for CHAR, VARCHAR2 and NUMBER data types

D. COUNT(cust_id) returns the number of rows including rows with duplicate customer IDs and NULL value in the CUST_ID column

E. A SELECT statement using COUNT function with a DISTINCT keyword cannot have a WHERE clause

A. + (addition) has a higher order of precedence than * (multiplication).

B. NOT has a higher order of precedence than AND and OR in a condition.

C. Operators are evaluated before conditions.

D. || has a higher order of precedence than + (addition).

E. AND and OR have the same order of precedence in a condition.

A. DELETE can be used to remove rows from multiple tables in one statement.

B. DELETE can be used to remove rows from only one table in one statement.

C. DELETE can be used to remove rows only for tables that are parents for a child table that has a referential integrity constraint referring to the parent.

D. DELETE can be used to remove data from specific columns as well as complete rows.

E. DELETE and TRUNCATE can be used for tables that are parents for a child table that has a referential integrity constraint having an ON DELETE rule.

A. The statement will fail because the VALUES clause is not required with the subquery.

B. The statement will fail because a subquery cannot be used in a VALUES clause.

C. The statement will execute and a new row will be inserted in the SALES table.

D. The statement will fail because the subquery in the VALUES clause is not enclosed within single quotation marks.

A. You can create and configure pluggable databases by using EM express.

B. You can use EM express to manage multiple databases running on the same server.

C. By default, EM express is available for a database after database creation.

D. You cannot start up or shut down a database Instance by using EM express.

E. You can perform basic administrative tasks for pluggable databases by using the EM express interface.

A. It executes successfully and generates the required result.

B. It produces an error because COUNT(*) should be specified in the SELECT clause also.

C. It produces an error because COUNT(*) should be only in the HAVING clause and not in the WHERE clause.

D. It executes successfully but produces no result because COUNT(prod_id) should be used instead of COUNT(*).

A. 200

B. 160

C. 100

D. 150

E. 16

A. A full outer join must use Oracle syntax

B. An inner join returns matched rows

C. Outer joins can be used when there are multiple join conditions on two tables

D. A full outer join returns matched and unmatched rows

E. A left or right outer join returns only unmatched rows

F. Outer joins can only be used between two per query

A. SELECT c.course_id, d.department_id FROM course_details c FULL OUTER JOIN department_details d ON (c.department_id=d. department_id)

B. SELECT c.course_id, d.department_id FROM course_details c RIGHT OUTER JOIN .department_details d ON (c.depatrment_id=d.department_id)

C. SELECT course_id, department_id, FROM department_details d RIGHT OUTER JOIN course_details c USING (department_id)

D. SELECT c.course_id, d.department_id FROM course_details c FULL OUTER JOIN department_details d ON (c.department_id<>d. department_id)