1z0-082 Practice Test

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