Free Access to Oracle.1Z1-082.v2023-05-27.q116 with Valid Practice Test (Page 20)

Question 91

Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.
Only the EMPLOYEE_ID column is indexed.
Rows exist for employees 100 and 200.
Examine this statement:

Which two statements are true? (Choose two.)

A.Employees 100 and 200 will have the same SALARY as before the update command
B.Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100
C.Employee 100 will have SALARY set to the same value as the SALARY of employee 200
D.Employee 200 will have SALARY set to the same value as the SALARY of employee 100
E.Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200
F.Employees 100 and 200 will have the same JOB_ID as before the update command

Question 92

Which three statements are true about data block storage in an Oracle Database?

A.A table block must always contain row data.
B.A block header contains a row directory pointing to all rows in the block.
C.Row data is stored starting at the end of the block.
D.A data block header is of a fixed length.
E.An index block can contain row data.

Question 93

Which three statements are true about a self-join? (Choose three.)

A.The ON clause can be used
B.The ON clause must be used
C.The query must use two different aliases for the table
D.It must be an equi join
E.It can be an outer join
F.It must be an inner join

Question 94

Examine this description of the TRANSACTIONS table:

Which two SQL statements execute successfully? (Choose two.)

A.SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100 "DUES AMOUNT" FROM transactions;
B.SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100 DUES FROM transactions;
C.SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100 "DUES" FROM transactions;
D.SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;
E.SELECT customer_id AS 'CUSTOMER-ID', transaction_date AS DATE, amount + 100 'DUES AMOUNT' FROM transactions;

Question 95

Which two statements are true about interval data types?

A.The value in an interval day to SECOND column can be copied into an interval year to month column.
B.The year field in an interval year to month column must be a positive value.
C.INTERVAL year to month columns only support monthly Intervals within a single year.
D.INTERVAL year to month columns only support monthly intervals within a range of years.
E.INTERVAL day to second columns support fractions of seconds.
F.INTERVAL year TO month columns support yearly intervals.

Question 91

Question 92

Question 93

Question 94

Question 95

Download PDF File