Oracle Database SQL - 1z0-071 Exam Practice Test

A. It can only be used for NUMBER data types.

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

C. COUNT(inv_amt) returns the number of rows in a table including rows with NULL in the INV_AMT column.

D. COUNT(*) returns the number of rows in a table including duplicate rows and rows containing NULLs in any column.

E. COUNT (DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULLs in the INV_AMT column

A. Operators are evaluated before conditions.

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

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

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

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

A. The statement will fail if a row already exists in the SALES table for product 23.

B. The SALES table has five foreign keys.

C. A product can have a different unit price at different times.

D. The statement will execute successfully and a new row will be inserted into the SALES table.

E. The statement will fail because subquery may not be I contained in a values clause.

F. A customer can exist in many countries.

A. SELECT * FROM order_ items WHERE quantity = TRUNC (quantity, -1);

B. SELECT FROM order_ items WHERE quantity / 10 = TRUNC (quantity);

C. SELECT" FROM order_ _items WHERE quantity = ROUND (quantity, 1);

D. SELECT" FROM order_ items WHERE FLOOR (quantity / 10) = TRUNC (quantity / 10);

E. SELECT * FROM order_ items WHERE MOD (quantity, 10) = 0;

A. Multiple parentheses can be used to override the default precedence of operators in an expression.

B. The concatenation operator || is always evaluated before addition and subtraction in an expression.

C. Arithmetic operators with equal precedence are evaluated from left to right within an expression.

D. The + binary operator has the highest precedence in an expression in a SQL statements.

E. NULLS influence the precedence of operators in an expression.

A. an entity

B. a unique identifier

C. a cardinality

D. an attribute

E. label

F. an optionality

A. The NEW_SALES table would not get created because the column names in the CREATE TABLE command and the SELECT clause I do not match.

B. The NEW_SALES table would get created and all the FOREIGN KEY constraints defined on the specified columns would be passed to the new table

C. The NEW_SALES table would get created and all the NOT NULL constraints defined on the specified columns would be passed to the new table.

D. The NEW_SALES table would not get created because the DEFAULT value cannot be specified in the column definition.

A. SELECT promo_cost, | pxomo_category FROM promotions ORDER BY 1;

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

C. SELECT promo_category, DISTINCT promo_cost PROM promotions ORDER BY 2:

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

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

A. INSERT can be granted on tables, views, and sequences.

B. SELECT can be granted only on tables and views.

C. REFERENCES can be granted only on tables and views.

D. UPDATE can be granted only on tables and views.

E. DELETE can be granted on tables, views, and sequences.

F. ALTER can be granted only on tables and sequences.

A. SELECT to_date(' 2019-01-01 ', 'YYYY -MM-DD' ) FROM DUAL;

B. SELECT DATE '2019-01-01' FROM DUAL ;

C. SELECT TO_CHAR('2019-01-01') FROM DUAL; 2019-01-01

D. SELECT '2019-01-01' FROM DUAL ; 2019-01-01

E. SELECT TO_ DATE('2019-01-01') FROM DUAL;

A. A substitution variable prefixed with 6 prompts only once for a value in a session unless is set to undefined in the session.

B. A substitution variable can be used with any clause in a SELECT statement.

C. A substitution variable prefixed with & always prompts only once for a value in a session.

D. A substitution variable can be used only in a SELECT statement.

E. A substitution variable used to prompt for a column name must be endorsed in single quotation marks.

F. A substitution variable used to prompt for a column name must be endorsed in double quotation marks.