Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmas50

Oracle 1z0-082 - Oracle Database Administration I

Oracle 1z0-082 Premium Access     Download Demo    
Page: 2 / 5
Total 142 questions

Which two queries execute successfully?

A.

SELECT NULLIF(NULL, 100) FROM DUAL;

B.

SELECT COALESCE (100, 'AM FROM DUAL;

C.

SELECT 2TOLLIF(100, 'A') FROM DUAL;

D.

SELECT NULLIF(100,100) FROM DUAL;

E.

SELECT COALESCE(100, NULL, 200) FROM DUAL;

Which three statements are true concerning logical and physical database structures? (Choose three.)

A.

All tablespaces may have one or more data files

B.

The extents of a segment must always reside in the same datafile

C.

A smallfile tablespace might be bigger than a bigfile tablespace

D.

A segment can span multiple data files in some tablespaces

E.

A segment’s blocks can be of different sizes

F.

A segment might have only one extent

G.

Segments can span multiple tablespaces

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

A.

A table can have only one primary key but multiple foreign keys

B.

A table can have only one primary key and one foreign key

C.

The foreign key columns and parent table primary key columns must have the same names

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.

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

F.

Only the primary key can be defined at the column and table level

G.

Primary key and foreign key constraints can be defined at both the column and table level

Examine this command:

CREATE UNDO TABLESPACE undotbs01

DATAFILE ‘undotbs_01.dbf’

SIZE 100M

AUTOEXTEND ON;

Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)

A.

Add the SEGMENT SPACE MANAGEMENT AUTO clause

B.

Set UNDO_TABLESPACE to UNDOTBS01

C.

Add the NOLOGGING clause

D.

Make certain that the database operates in automatic undo management mode

E.

Add the ONLINE clause

Which three statements are true about Oracle synonyms? (Choose three.)

A.

A synonym cannot be created for a PL/SQL package

B.

A synonym can be available to all users

C.

A SEQUENCE can have a synonym

D.

A synonym created by one user can refer to an object belonging to another user

E.

Any user can drop a PUBLIC synonym

In one of your databases, the user HR has the password HRMGR.

You want to connect to a database instance whose listener listens on port 1531 by using this statement:

CONNECT HR/HRMGR@orcl

No name server is used.

Which statement is true about ORCL?

A.

It must be the value of the SERVICE_NAMES parameter on the client side

B.

It must resolve to a valid connect descriptor in the server’s tnsnames.ora file

C.

It must resolve to a valid connect descriptor in the client’s tnsnames.ora file

D.

It must be the name of the database to whose instance HR wishes to connect

E.

It must be the name of the server running the database to whose instance HR wishes to connect

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

Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)

A.

They can be written by server processes

B.

Trace files are written to the Fast Recovery Area (FRA)

C.

They can be written by background processes

D.

All trace files contain error information that require contacting Oracle Support

E.

Trace file names are based on the database name concatenated with a sequential number

You execute this command:

During the export operation, you detach from the job by using CTRL+C and then execute this command:

Export> STOP_JOB=immediate

Are you sure you wish to stop the job ([yes]/no): yes

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

A.

You can no longer monitor it

B.

You can reattach to it and monitor it

C.

It is paused and can be resumed

D.

It continues to run in the background

E.

It terminates

A database is configured to use automatic undo management with temporary undo enabled.

An UPDATE is executed on a temporary table.

Where is the UNDO stored?

A.

in the undo tablespace

B.

in the SYSAUX tablespace

C.

in the SGA

D.

in the PGA

E.

in the temporary tablespace