1z0-071 Exam Dumps - Oracle Database 12c SQL

Go to page:

<< First
Prev
4
5
6
7
8
9
10
11
12
13
Next
Last >>

Question # 73

Examine this statement which executes successfully:

CREATE view emp80 AS

SELECT

FROM employees

WHERE department_ id = 80

WITH CHECK OPTION;

Which statement will violate the CHECK constraint?

DELETE FROM emp80

WHERE department_ id = 90;

SELECT

FROM emp80

WHERE department_ id = 90;

SELECT

FROM emp80

WHERE department. id = 80;

UPDATE emp80

SET department. 1d =80;

WHERE department_ id =90;

Full Access

Question # 74

Examine the description of the transactions table:

Which two SQL statements execute successfully?

SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount+100 "DUES" from transactions;

SELECT customer_id AS 'CUSTOMER-ID',transaction_date AS DATE, amount+100 'DUES' from transactions;

SELECT customer_id CUSTID, transaction_date TRANS_DATEï¼Œamount+100 DUES FROM transactions;

SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount+100 DUES FROM transactions;

SELECT customer id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount+100 "DUES AMOUNT" FROM transactions;

Full Access

Question # 75

What is true about non-equijoin statement performance?

The between condition always performs less well than using the >= and <= conditions.

The Oracle join syntax performs better than the SQL: 1999 compliant ANSI join syntax.

The join syntax used makes no difference to performance.

The between condition always performs better than using the >= and <= conditions.

Table aliases can improve performance.

Full Access

Question # 76

You want to write a query that prompts for two column names and the WHERE condition each time It is executed in a session but only prompts for the table name the first time it is executed. The variables used in your

query are never undefined in your session . Which query can be used?

SELECT &col1, &col2

FROM &&table

WHERE &condition;

SELECT &col1, &col2

FROM â€œ&tableâ€

WHERE &condition;

SELECT &&col1,&&col2

FROM &table

WHERE &&condition= &&cond;

SELECT'&co11','&&co12'

FROM &table

WHERE'&&condition' ='&cond';

SELECT&&col1, &&col2

FROM &table

WHERE &&condition;

Full Access

Question # 77

Examine the description or the BOOKS_TRANSACTIONS table:

FOR customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.

Which query should be used?