Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

A.

A TRUNCATE command issued in a session causes all rows in a GLOBAL
TEMPORARY TABLE for the issuing session to be deleted.

B.

GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.

C.

GLOBAL TEMPORARY TABLE space allocation occurs at session start.

D.

Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.

E.

A GLOBAL TEMPORARY TABLE’S definition is available to multiple sessions.

F.

A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back

Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)

A.

Column positions must be used in the ORDER BY clause

B.

Only column names from the first SELECT statement in the compound query are recognized

C.

The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause

D.

Each SELECT statement in the compound query must have its own ORDER BY clause

E.

Each SELECT statement in the compound query can have its own ORDER BY clause

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

Which three statements are true about views in an Oracle database? (Choose three.)

A.

Views can be updated without the need to re-grant privileges on the view

B.

Tables in the defining query of a view must always exist in order to create the view

C.

The WITH CHECK clause prevents certain rows from being displayed when querying the view

D.

Data Manipulation Language (DML) can always be used on views

E.

Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error

F.

Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error

G.

The WITH CHECK clause prevents certain rows from being updated or inserted

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;

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

A.

The ON clause must be used

B.

The query must use two different aliases for the table

C.

It must be an equi join

D.

It must be an inner join

E.

The ON clause can be used

F.

It can be an outer join

Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:
ALTER DATABASE MOUNT; Which two actions are performed? (Choose two.)

A.

The online redo logs are opened

B.

The online data files are opened

C.

The alert log records the execution details

D.

The Oracle background processes are started

E.

The initialization parameter file is read

F.

The control file is read

The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two
different locations.
Each database has a tnsnames.ora file defining DALLAS_DB as a service name.
Examine this command:
CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING
‘dallas_db’; How do you execute the command so that only SCOTT in BOSTON_DB can access the
SCOTT schema in DALLAS_DB?

A.

as SCOTT in DALLAS_DB

B.

as SCOTT in BOSTON_DB

C.

as SCOTT in BOSTON_DB and SYS in DALLAS_DB

D.

as SYS in both the databases

E.

as SCOTT in both the databases

You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
Be stored in a format supporting date arithmetic without using conversion functions
Store a loan period of up to 10 years
Be used for calculating interest for the number of days the loan remains unpaid
Which data type should you use?

A.

INTERVAL YEAR TO MONTH

B.

INTERVAL DAY TO SECOND

C.

TIMESTAMP WITH LOCAL TIMEZONE

D.

TIMESTAMP

E.

TIMESTAMP WITH TIMEZONE

Examine this command:

Which two statements are true? (Choose two.)

A.

DML may be performed on tables with one or more extents in this data file during the execution of this command.

B.

The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.

C.

The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.

D.

If Oracle Managed Files (OMF) is used, then the file is renamed but moved to
DB_CREATE_FILE_DEST.

E.

The file is renamed and stored in the same location

In one of your databases, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which three actions can HR perform? (Choose three.)

A.

Revoke the CREATE SESSION privilege from other users

B.

Revoke the CREATE SESSION privilege from user HR

C.

Log in to the database instance

D.

Grant the CREATE SESSION privilege with ADMIN OPTION to other users

E.

Execute DDL statements in the HR schema

F.

Execute DML statements in the HR schema

Which two statements are true about single row functions? (Choose two.)

A.

MOD : returns the quotient of a division operation

B.

FLOOR : returns the smallest integer greater than or equal to a specified number

C.

TRUNC : can be used to combine any number of values

D.

CONCAT : can be used to combine any number of values

E.

CEIL : can be used for positive and negative numbers