Free Access Oracle.1z1-071.v2022-04-30.q200 Practice Test (Page 21)

Question 96

Examine the structure of the ORDERS table: (Choose the best answer.)

You want to find the total value of all the orders for each year and issue this command:
SQL> SELECT TO_CHAR(order_date,'rr'), SUM(order_total) FROM orders
GROUP BY TO_CHAR(order_date, 'yyyy');
Which statement is true regarding the result?

A.It return an error because the datatype conversion in the SELECT list does not match the data type conversion in the GROUP BY clause.

B.It executes successfully but gives the correct output.

C.It executes successfully but does not give the correct output.

D.It returns an error because the TO_CHAR function is not valid.

Question 97

In your session, the NLS._DAE_FORMAT is DD- MM- YYYY.There are 86400 seconds in a day.Examine
this result:
DATE
02-JAN-2020
Which statement returns this?

A.SELECT TO_ CHAR(TO_ DATE('29-10-2019') + INTERVAL '3' MONTH + INTERVAL '7' DAY -
INTERVAL '360' SECOND, ' DD-MON-YYYY') AS "date"
FROM DUAL;

B.SELECT-TO_CHAR(TO _DATE('29-10-2019'+ INTERVAL '2' MONTH+INTERVAL '4' DAYINTERVAL
'120' SECOND, 'DD-MON-YY') AS "daTe"
FROM DUAL;

C.SELECT-TO_CHAR(TO _DATE('29-10-2019'+ INTERVAL '2' MONTH+INTERVAL '6' DAYINTERVAL
'120' SECOND, 'DD-MON-YY') AS "daTe"
FROM DUAL;

D.SELECT TO_ CHAR(TO_ DATE('29-10-2019') +INTERVAL '2'; MONTH + INTERVAL '5'; DAY -
INTERVAL '86410' SECOND, ' DD-MON-YYYY') AS "date"
FROM DUAL;

E.SELECT To CHAR(TO _DATE('29-10-2019') + INTERVAL '2' NONTH + INTERVAL '5' DAY
INEERVAL '120' SECOND, ' DD-MON-YYY) AS "date"
FROM DUAL;

Question 98

Which three statements are true? (Choose three.)

A.The data dictionary is created and maintained by the database administrator.

B.Data dictionary views consist of joins of dictionary base tables and user-defined tables.

C.The usernames of all users including database administrators are stored in the data dictionary.

D.The USER_CONS_COLUMNS view should be queried to find the names of columns to which constraints apply.

E.Both USER_OBJECTS and CAT views provide the same information about all objects that are owned by the user.

F.Views with the same name but different prefixes, such as DBA, ALL and USER, reference the same base tables from the data dictionary.

Question 99

Examine the structure of the INVOICEtable.
Name Null? Type
- ----------------- ------------------- -------------
INV_NO NOT NULL NUMBER(3)
INV_DATE DATE
INV_AMT NUMBER(10,2)
Which two SQL statements would execute successfully?

A.SELECT inv_no, NVL2(inv_amt, inv_amt*.25, 'Not Available')
FROM invoice;

B.SELECT inv_no, NVL2(inv_amt, inv_date, 'Not Available')
FROM invoice;

C.SELECT inv_no, NVL2(inv_date, sysdate-inv_date, sysdate)
FROM invoice;

D.SELECT inv_no, NVL2(inv_date, 'Pending', 'Incomplete')
FROM invoice;