Free Access to Oracle.1Z1-082.v2023-12-08.q100 with Valid Practice Test (Page 19)

Question 86

Which statement is true about aggregate functions?

A.Aggregate functions can be nested to any number of levels
B.Aggregate functions can be used in any clause of a SELECT statement
C.The MAX and MIN functions can be used on columns with character data types
D.The AVG function implicitly converts NULLS to zero

Question 87

The orders table has a column ORDER_DATE of data type date.
The default display format for a date Is DD-MON-RR.
Which two where conditions demonstrate the correct usage of conversion functions?

A.WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')
B.WHERE order date > TO DATE('JUL 10 2018', *MON DD YYYY')
C.WHERE order_date IN (TO_DATE ('Oct 21 2018', 'Mon DD YYYY'), TC_CHAR('Nov 21 2018', 'Mon DD YYYY'))
D.WHERE TO_CHAR(order_date, 'MON DD YYYY') = 'JAN 20 2019'
E.WHERE order_date > TO_DATE<ADD_MONTHS(SYSDATE, c) , 'MON DD YYYY')

Question 88

Which compression method is recommended for Direct-Path Insert operations?

A.RON STORE COMPRESS BASIC
B.ROW STORE COMPRESS ADVANCED
C.COLUMN STORE COMPRESS ADVANCED
D.COLUMN STORE COMPRESS BASIC

Question 89

Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

A.The foreign key columns and parent table primary key columns must have the same names
B.Primary key and foreign key constraints can be defined at both the column and table level
C.It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted
D.It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted
E.A table can have only one primary key and foreign key
F.Only the primary key can be defined at the column and table level
G.A table can have only one primary key but multiple foreign keys

Question 90