최신 1Z1-082 무료덤프 - Oracle Database Administration I

A. It processes NULLs in the selected columns

B. INTERSECT is of lower precedence than UNION or UNION ALL

C. It ignores NULLs

D. Multiple INTERSECT operators are not possible in the same SQL statement

A. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

B. SELECT DISTINCT promo_category || ' has ' || promo_cost AS COSTS FROM promotions ORDER BY 1;

C. SELECT promo_cost, promo_category FROM promotions ORDER BY by 1;

D. SELECT DISTINCT promo_cost || ' in ' || DISTINCT promo_category FROM promotions ORDER BY 1;

E. SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;

A. A full outer join returns matched and unmatched rows

B. An inner join returns matched rows

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

D. Outer joins can only be used between two tables per query

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

F. A full outer join must use Oracle syntax

A. WHERE city = =%AN%'

B. ORDER BY 1, LNAME DESC

C. WHERE city LIKE *%AN%*

D. WHERE city IN (*%AN%')

E. ORDER BY last_narae DESC, city ASC

F. ORDER BY 1, 2

A. Primary key and foreign key constraints can be defined at both the column and table level

B. The foreign key columns and parent table primary key columns must have the same names

C. A table can have only one primary key but multiple foreign keys

D. A table can have only one primary key and one foreign key

E. It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted

F. Only the primary key can be defined at the column and table level

G. It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted

A. It can be used only in SQL*Plus

B. It displays values for variables created by the DEFINE command

C. It can be used in SQL Developer and SQL*Plus

D. It displays values for variables used only in the WHERE clause of a query

E. It displays values for variables prefixed with &&

A. It must be smaller than the smallest BIGFILE tablespace

B. It is a locally managed tablespace

C. It uses the database default blocksize

D. Free space is managed using freelists

E. Any data files added to the tablespace must have a size of 5 gigabytes

A. CONCAT : can be used to combine any number of values

B. TRUNC : can be used with NUMBER and DATE values

C. FLOOR : returns the smallest integer greater than or equal to a specified number

D. MOD : returns the quotient of a division operation

E. CEIL : can be used for positive and negative numbers

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

B. It can display multiple rows and columns

C. It can be accessed only by the SYS user

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

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

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

A. SELECT COUNTlprod_id> FROM sales GROUP BY prod_id WHERE quantity_Sold > 55000;

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

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

D. SELECT COUNT|prod_id> FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id;

E. SELECT prod_id FROM sales WHERE quantity_sold > 5S000 AND COUNT(-) > 10 GROUP BY prod_id HAVING COUNT(-) > 10;