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

examout.co

Which two statements are true about Database Instances and Real Application Clusters (RAC)?

A.

A RAC database can have one Instance.

B.

A RAC database can have instances on separate servers.

C.

Two RAC databases can share their instances.

D.

A RAC database must have three or more Instances.

E.

A RAC database must have two or more instances.

You need to calculate the number of days from 1st January 2019 until today.

Dates are stored in the default format of DD-MON-RR.

Which two queries give the required output? (Choose two.)

A.

SELECT TO_CHAR(SYSDATE,‘DD-MON-YYYY’) – ’01-JAN-2019’ FROM DUAL;

B.

SELECT ROUND(SYSDATE – ’01-JAN-2019’) FROM DUAL;

C.

SELECT ROUND(SYSDATE – TO_DATE(‘01/JANUARY/2019’)) FROM DUAL;

D.

SELECT TO_DATE(SYSDATE, ‘DD/MONTH/YYYY’) – ‘01/JANUARY/2019’ FROM DUAL;

E.

SELECT SYSDATE – TO_DATE(’01-JANUARY-2019’) FROM DUAL;

You want to use table compression suitable for OLTP that will:

Compress rows for all DML statements on that table

Minimize the overheads associated with compression

Which compression option is best suited for this?

A.

COLUMN STORE COMPRESS FOR QUERY LOW

B.

ROW STORE COMPRESS BASIC

C.

COLUMN STORE COMPRESS FOR ARCHIVE LOW

D.

COLUMN STORE COMPRESS FOR ARCHIVE HIGH

E.

ROW STORE COMPRESS ADVANCED

Examine this SQL statement:

SELECT cust_id, cust_last_name “Last Name”

FROM customers

WHERE country_id = 10

UNION

SELECT cust_id CUST_NO, cust_last_name

FROM customers

WHERE country_id = 30

Identify three ORDER BY clauses, any one of which can complete the query successfully. (Choose three.)

A.

ORDER BY “Last Name”

B.

ORDER BY 2, 1

C.

ORDER BY 2, cust_id

D.

ORDER BY CUST_NO

E.

ORDER BY “CUST_NO”

Which three statements are true regarding single row subqueries?

A.

They must be placed on the right side of the comparison operator or condition.

B.

They must be placed on the left side of the comparison operator or condition.

C.

They can be used in the where clause.

D.

A SQL statement may have multiple single row subquery blocks.

E.

They must return a row to prevent errors in the SQL statement.

F.

They can be used in the having clause.

Which three instance situations are possible with the Oracle Database server without multi-tenant? (Choose three.)

A.

two or more instances on separate servers all associated with one database

B.

one instance on one server associated with one database

C.

one instance on one server associated with two or more databases on the same server

D.

one instance on one server not associated with any database

E.

one instance on one server associated with two or more databases on separate servers

You execute this query:

SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), ‘MON’), ‘dd “Monday for” fmMonth rrrr’)

What is the result?

A.

It executes successfully but does not return any result

B.

It returns the date for the first Monday of the next month

C.

It generates an error

D.

It returns the date for the last Monday of the current month

You execute this command:

Sufficient storage is available in filesystem /u01.

Which two statements are true about the BIG_TBS tablespace? (Choose two.)

A.

AUTOEXTEND is possible for the datafile

B.

It must be bigger than the largest SMALLFILE tablespace

C.

Additional data files may not be added

D.

It will be a dictionary-managed tablespace by default

E.

It will always have a 32K blocksize

Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)

A.

Duplicates are eliminated automatically by the UNION ALL operator

B.

The number of columns selected in each SELECT statement must be identical

C.

The names of columns selected in each SELECT statement must be identical

D.

The output is sorted by the UNION ALL operator

E.

NULLS are not ignored during duplicate checking

Which two statements are true about the rules of precedence for operators? (Choose two.)

A.

The concatenation operator | | is always evaluated before addition and subtraction in an expression

B.

NULLS influence the precedence of operators in an expression

C.

The + binary operator has the highest precedence in an expression in a SQL statement

D.

Arithmetic operators with equal precedence are evaluated from left to right within an expression

E.

Multiple parentheses can be used to override the default precedence of operators in an expression