最新的Oracle Database SQL - 1z0-071免費考試真題

A. The first column in the first select of the compound query with the union operator is used by default to sort output in the absence of an order by clause.

B. only column names from the first select statement in the compound query are recognized.

C. Each select statement in the compound query must have its own order by clause.

D. column positions must be used in the order by clause.

E. Each select statement in the compound query can have its own order by clause.

A. Data Manipulation Language (DML) statements always start a new transaction.

B. A Data Definition Language (DDL) statement does a commit automatically only for the data dictionary updates caused by the DDL

C. An uncommitted transaction commits automatically if the user exits SQL*Plus

D. A session can always see uncommitted updates made by itself.

E. A user can always see uncommitted updates made by the same user in a different session.

F. If a session has an uncommitted transaction, then a DDL statement issue a COMMIT before starting a new transaction.

A. Reversing the order of the intersected tables can sometimes affect the output.

B. INTERSECT ignores NULLs

C. INTERSECT returns rows common to both sides of the compound query.

D. Column names in each SELECT in the compound query can be different.

E. The number of columns in each SELECT in the compound query can be different.

A. SELECT * FROM customers WHERE city ='D_%';

B. SELECT * FROM customers WHERE city ='%D_';

C. SELECT * FROM customers WHERE city LIKE'D_';

D. SELECT * FROM customers WHERE city LIKE'D %';

A. An ORDER BY clause always sorts NULL values last.

B. An ORDR BY clause will always precede a HAVI NG clause if both are used in the same top-level

C. An ORDER BY clause can perform a linguistic sort

D. By default an ORDERBY clause sorts rows in ascending order

E. An ORDER BY clause can perform a binary sort

A. It will return rows both select statements including duplicate rows.

B. It will return rows from both select statements after eliminating duplicate rows.

C. It will return rows that are not common to both select statements.

D. It will return rows common to both select statements.

A. SELECT NVL(cust_credit_limit * .15,'Not Available') FROM customers;

B. SLECT NVL(TO_CHAR(cust_credit_limit * .15),'Not available') from customers;

C. SELECT NVL2(cust_credit_limit * .15,'Not Available') FROM customers;

D. SELECT NVL2(cust_credit_limit,TO_CHAR(cust_credit_limit * .15),'NOT Available') FROM customers;

E. True - This query uses NVL2 correctly by checking if cust_credit_limit is not NULL, then applying TO_CHAR to compute 15% of it and converting it to string, or returning 'NOT Available' if it is NULL. The syntax and function usage are correct.

F. SELECT TO_CHAR(NVL(cust_credit_limit * .15,'Not Available')) FROM customers;

A. SELECT prod_id FROM sales WHERE quantity_sold> 55000 AND COUNT(*)> 10 GROUP BY prod_id HAVING COUNT(*)> 10;

B. SELECT COUNT(prod_id) FROM sales GROUP BY prod_id WHERE quantity_sold> 55000;

C. SELECT prod_id FROM sales WHERE quantity_sold> 55000 AND COUNT(*)> 10 GROUP BY COUNT(*)> 10;

D. SELECT prod_id FROM sales WHERE quantity_sold> 55000 GROUP BY prod_id HAVING COUNT(*)> 10;

E. SELECT COUNT(prod_id) FROM sales WHERE quantity_sold>55000 GROUP BY prod_id;

A. It must be an equijoin.

B. The ON clause can be used.

C. The query must use two different aliases for the table.

D. It must be an inner join.

E. It can be an outer join.

F. The ON clause must be used.

A. They can return at most one row.

B. .You must enclose them in parentheses.

C. You cannot correlate them with a table in the parent statement

D. You can use them as a default value for a column.

E. They can return two columns.

A. Tables in the defining query of a view must always exist in order to create the view.

B. Views can be updated without the need to re-grant privileges on the view.

C. Views can be indexed.

D. Theethi CHEcK clause prevents certalin rows from being updated or inserted in the underying table through the view.

E. The wITH CHECK clause prevents certain rows from being displayed when querying the view.

A. It can be accessed by any user who has the SELECT privilege in any schema

B. It consists of a single row and single column of VARCHAR2 data type.

C. It can be accessed only by the SYS user.

D. It can display multiple rows and columns.

E. It can be used to display only constants or pseudo columns.

F. It can display multiple rows but only a single column.

A. SELECT.
FROM bricks b
RIGHT JOIN colors c
ON b. color _rgb_ hex_ value = c. rgb hex_ value;

B. SELECT
EROM colors C
LEFT JOIN bricks on
USING (rgb _ hex_ value) ;

C. SELECT
FROM bricks b
FULL JOIN colors C
ON b. color rgb _ hex_ value = c. rgb _hex_ value;

D. SELECT *
EROM bricks | b
JOIN colors C
ON b. color_ rgb_ hex_ value =c. rgb _hex value;

E. SELECT
EROM colors C
LEET JOIN bricks b
ON b. color_ rgb_ hex value = c. rgb. hex.

A. It returns only unmatched rows from both tables being joined.

B. The Oracle join operator (+) must be used on both sides of the join condition in the WHERE clause.

C. It returns matched and unmatched rows from both tables being joined.

D. It includes rows that are returned by an inner join.

E. It includes rows that are returned by a Cartesian product.