Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exc65

examout.co

Which two statements are true about conditional INSERT ALL?

A.

Each row returned by the subquery can be inserted into only a single target table.

B.

It cannot have an ELSE clause.

C.

The total number of rows inserted is always equal to the number of rows returned by the subquery

D.

A single WHEN condition can be used for multiple INTO clauses.

E.

Each WHEN condition is tested for each row returned by the subquery.

Which statements is true about using functions in WHERE and HAVING?

A.

using single-row functions in the WHERE clause requires a subquery

B.

using single-row functions in the HAVING clause requires a subquery

C.

using aggregate functions in the WHERE clause requires a subquery

D.

using aggregate functions in the HAVING clause requires a subquery

Which two are true about multiple table INSERT statements?

A.

They always use subqueries.

B.

They can transform a row from a source table into multiple rows in a target table.

C.

The conditional INSERT FIRST statement always inserts a row into a single table.

D.

The conditional INSERT ALL statement inserts rows into a single table by aggregating source rows.

E.

The unconditional INSERT ALL statement must have the same number of columns in both the source and target tables.

Which three statements are true about Oracle synonyms?

A.

A synonym cannot be created for a PL /SQL package.

B.

A SEQUENCE can have a synonym.

C.

A synonym can be available to all users .

D.

A synonym created by one user can refer to an object belonging to another user.

E.

Any user can drop a PUBLIC synonym.

In your session NLS_ DATE_ FORMAT is set to DD–MON_RR.

Which two queries display the year as four digits?

A.

SELECT TO_DATE(TO_CHAR(SYSDATE,'MM/DD/YYYY'),'MM/DD/YYYY') FROM DUAL;

B.

SELECT TO_CHAR (ADD_MONTHS (SYSDATE,6)) FROM DUAL;

C.

SELECT TO_DATE (SYSDATE, 'RRRR-MM-DD') FROM DUAL;

D.

SELECT TO_DATE (ADD_MONTHS(SYSDATE,6), 'dd-mon-yyyy') FROM DUAL;

E.

SELECT TO_CHAR (SYSDATE, 'MM/DD/YYYY') FROM DUAL;

F.

SELECT TO_CHAR (ADD_MONTHS (SYSDATE, 6), 'dd-mon-yyyy') FROM DUAL;

Examine this query:

SELECT employee_id,first_name,salary

FROM employees

WHERE hire_date>'&1';

Which two methods should you use to prevent prompting for a hire date value when this query is executed?

A.

Use the DEFINE command before executing the query.

B.

Store the query in a script and pass the substitution value to the script when executing it.

C.

Replace'&1' with'&&1' in the query.

D.

Execute the SET VERIFY OFF command before executing the query.

E.

Use the UNDEFINE command before executing the query.

F.

Execute the SET VERIFY ON command before executing the query.

Which two statements are true about truncate and delete?

A.

the result of a delete can be undone by issuing a rollback

B.

delete can use a where clause to determine which row(s) should be removed.

C.

TRUNCATE can use a where clause to determine which row(s) should be removed.

D.

truncate leavers any indexes on the table in an UNUSABLE STATE.

E.

the result of a truncate can be undone by issuing a ROLLBACK.

Which two statements are true about Oracle synonyms?

A.

A synonym can have a synonym.

B.

A synonym has an object number.

C.

Any user can create a public synonym.

D.

All private synonym names must be unique in the database.

E.

A synonym can be created on an object in a package.

Which three are true about system and object privileges

A.

WITH GRANT OPTION can be used when granting an object privilege to both users and roles

B.

WITH GRANT OPTION cannot be used when granting an object privilege to PUBLIC

C.

Revoking a system privilege that was granted with the WITH ADMIN OPTION has a cascading effect.

D.

Revoking an object privilege that was granted with the WITH GRANT OPTION clause has a cascading effect

E.

Adding a primary key constraint to an existing table in another schema requires a system privilege

F.

Adding a foreign key constraint pointing to a table in another schema requires the REFERENCEs object privilege

Evaluate the following SQL statement

SQL>SELECT promo_id, prom _category FROM promotions

WHERE promo_category=’Internet’ ORDER BY promo_id

UNION

SELECT promo_id, promo_category FROM Pomotions

WHERE promo_category = ‘TV’

UNION

SELECT promoid, promocategory FROM promotions WHERE promo category=’Radio’

Which statement is true regarding the outcome of the above query?

A.

It executes successfully and displays rows in the descend ignore of PROMO CATEGORY.

B.

It produces an error because positional, notation cannot be used in the ORDER BY clause with SBT operators.

C.

It executes successfully but ignores the ORDER BY clause because it is not located at the end of the compound statement.

D.

It produces an error because the ORDER BY clause should appear only at the end of a compound query-that is, with the last SELECT statement.