1z0-071 Oracle Database SQL Certified Practice Exam

Sample Questions

Q) Which three statements are true regarding sub-query? (Choose three.)

a) multiple columns or expressions can be compared between the main query and the subquery.

b) Subqueries can contain ORDER BY, but not the GROUP BY clause.

c) the main query and subquery can get data from different tables.

d) Subqueries can contain GROUP BY and ORDER BY the main query and subquery must obtain data from the same tables.

e) Only one column or expression can be compared between the main query and subquery.

Q) Which statement is true of an inner join specified in a clause QUERYAs Where?

a) It applies only for equijoin conditions.

b) It applies to equijoin and nonequijoin conditions.

c) It requires the column names to be the same in all tables to be joined.

d) Must have primary key and foreign key constraints defined on join columns.

Q) Which task can be performed using economic language (DML) single data manipulation?

a) adding a column constraint during the insertion of a row in a table

b) adding a column with a default value during the insertion of a row in a table

c) remove all data from only a single column on which a unique constraint is defined

d) remove all data from only a single column on which is defined a primary key constraint

Q) Consider the following SQL: SELECT product_name || 'It is not available for order' FROM WHERE product_information product_status = 'obsolete'; You have received the following error when running the previous query: ORA-01756 error: quoted string not properly terminated What would you do to run the query successfully?

a) Remove the single quotation marks that enclose the literal string of characters in the SELECT clause

b) Use the escape character to deny the single quotation mark within the string literal characters in the SELECT clause

c) Enclose the literal character string in the SELECT clause in double quotes

d) Use the (q) and Oracle delimiter operator to allow the use of a single quote within the literal character string in the SELECT clause

Q) Which three tasks can be performed using embedded SQL functions in Oracle Database?

a) displaying a date in a non-default format

b) find the number of characters in an expression

c) replacing a character string in a text expression with a specified string

d) combine more than two columns or expressions in a single column in the output