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: 4 / 5
Total 142 questions

The stores table has a column START_DATE of data type DATE, containing the date the row was inserted. You only want to display details of rows where START_DATE is within the last 25 months. Which where clause can be used?

A.

WHERE MON'THS_BETWEEN (SYSDATE, start_date) <= 25

B.

WHERE ADD_MONTHS

C.

WHERE TO_XUMBER(start_date - SYSDATE) <= 25

D.

WHERE MON'THS_BETWEEN (start_date, SYSDATE) <= 25

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

A.

COLUMN STORE COMPRESS BASIC

B.

COLUMN STORE COMPRESS ADVANCED

C.

RON STORE COMPRESS BASIC

D.

ROW STORE COMPRESS ADVANCED

Which three statements are true about table data storage in an Oracle Database? (Choose three.)

A.

Data block headers contain their own Data Block Address (DBA)

B.

A table row piece can be chained across several database blocks

C.

Multiple row pieces from the same row may be stored in different database blocks

D.

Multiple row pieces from the same row may be stored in the same block

E.

Data block free space is always contiguous in the middle of the block

F.

Index block free space is always contiguous in the middle of the block

You execute this command:

CREATE SMALLFILE TABLESPACE sales

DATAFILE ‘/u01/app/oracle/sales01.dbf

SIZE 5G

SEGMENT SPACE MANAGEMENT AUTO;

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

A.

It must be smaller than the smallest BIGFILE tablespace

B.

Free space is managed using freelists

C.

Any data files added to the tablespace must have a size of 5 gigabytes

D.

It uses the database default blocksize

E.

It is a locally managed tablespace

Which two statements are true regarding a SAVEPOINT? (Choose two.)

A.

Rolling back to a SAVEPOINT can undo a CREATE INDEX statement

B.

Rolling back to a SAVEPOINT can undo a TRUNCATE statement

C.

Only one SAVEPOINT may be issued in a transaction

D.

A SAVEPOINT does not issue a COMMIT

E.

Rolling back to a SAVEPOINT can undo a DELETE statement

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

Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

A.

The data type group of each column returned by the second query must match the data type of the corresponding column returned by the first query.

B.

The number, but not names, of columns must be identical for all SELECT statements in the query.

C.

The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.

D.

The names and number of columns must be identical for all SELECT statements in the query.

E.

The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.

Which two statements are true about undo and undo tablespaces?

A.

There can be only one undo tablespace created in a database.

B.

An instance will crash if the active undo tablespace is lost.

C.

An undo tablespace may be owned by only one instance.

D.

undo segments are owned by SYSTEM.

E.

undo segments are owned by SYSBACKUP.

Which two statements are true about space-saving features in an Oracle Database? (Choose two.)

A.

Private Temporary Tables (PTTS) store metadata in memory only

B.

An index created with the UNUSABLE attribute has no segment

C.

If they exist for a session, Private Temporary Tables (PTTs) are always dropped at the next COMMIT OR ROLLBACK statement

D.

An index that is altered to be UNUSABLE will retain its segment

E.

A table that is truncated will always have its segment removed

Which two statements are true about Enterprise Manager Database Express? (Choose two.)

A.

It is available only when the database is open

B.

It can be used to perform database recovery

C.

The same port number can be used for Database Express configurations for databases on different hosts

D.

It can be used to switch a database into ARCHIVELOGMODE

E.

The same port number can be used for multiple Database Express configurations for multiple databases on the same host