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

Which two statements are true about the Oracle Data Dictionary?

A.

It is owned by the sys user.

B.

Data dictionary base tables can be queried directly.

C.

It is owned by the system user.

D.

Data dictionary views are always created with queries that join two or more base tables.

E.

All data dictionary view joins base tables to dynamic performance views.

Which two statements are true about interval data types?

A.

INTERVAL year TO month columns support yearly intervals.

B.

The value in an interval day to SECOND column can be copied into an interval year to month column.

C.

INTERVAL day to second columns support fractions of seconds.

D.

INTERVAL year to month columns only support monthly Intervals within a single year.

E.

INTERVAL year to month columns only support monthly intervals within a range of years.

F.

The year field in an interval year to month column must be a positive value.

Examine the description of the PRODUCT_STATUS table:

The status column contains the values 'in stock' or 'out of stock' for each row.

Which two queries will execute successfully?

A.

SELECT prod_id Il q"'s not available" FROM product_status where status = 'OUT OF STOCK';

B.

SELECT prod_id II q'l's not available)' FROM product_status WHERE status = 'OUT OF STOCK';

C.

SELECT prod_id "CURRENT AVAILABILITY" II q'<'s not available)' FROM product_status WHERE status = 'OUT OF STOCK

D.

SELECT prod_id I I q' (*s not available)' "CURRENT AVAILABILITY" FROM product_status WHERE status = 'OUT OF STOCK

E.

SELECT prod_id I I q' ('s not available) • 'CURRENT AVAILABILITY' FROM product_status WHERE status = 'OUT OF STOCK

F.

SELECT prod_id q's not available" FROM product_status WHERE status = 'OUT OF STOCK*;

Which three statements are true about using SQL*Plus?

A.

It has its own commands that are separate from any SQL statements.

B.

It must be downloaded from the Oracle Technology Network (OTN).

C.

It can run scripts entered at the SQL prompt.

D.

It can run Recovery Manager (RMAN) commands.

E.

It has both command-line and graphical user interfaces (GUI).

F.

It can run scripts passed to it by a shell script.

Examine this command:

Which two statements are true?

A.

Compressed objects in SALES01.DBF will be uncompressed In SALES02.DBF after the move.

B.

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

C.

It overwrites any existing file with the name SALES02.DBF.dbf in /u02 by default.

D.

The "to" clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used.

E.

Tables with one or more extents in this data file may be queried during the execution of this command.

Which three statements are true about the Automatic Diagnostic Repository (ADR)?

A.

It Is held Inside an Oracle database schema.

B.

The ADR base is specified In the diagnostic_dest database parameter.

C.

It is only used for Oracle Database diagnostic information.

D.

It is a file-based repository held outside any database.

E.

It can be used for problem diagnosis of a database when that database's instance is down.

You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed.

The variables used in your query are never undefined in your session.

Which query can be used?

A.

SELECT &&col1, &&col2FROM &tableWHERE &&condition = &&cond;

B.

SELECT &col1, &col2FROM &&tableWHERE &condition;

C.

SELECT &col1, &col2FROM “&table”WHERE &condition;

D.

SELECT ‘&&col1’, ‘&&col2’FROM &tableWHERE ‘&&condition’ = ‘&cond’;

E.

SELECT &&col1, &&col2FROM &tableWHERE &&condition;

Which statement is true about aggregate functions?

A.

Aggregate functions can be nested to any number of levels

B.

The AVG function implicitly converts NULLS to zero

C.

Aggregate functions can be used in any clause of a SELECT statement

D.

The MAX and MIN functions can be used on columns with character data types

A script abc.sql must be executed to perform a job.

A database user HR, who is defined in this database, executes this command:

$ sqlplus hr/hr@orcl @abc.sql

What will happen upon execution?

A.

The command succeeds and HR will be connected to the orcl and abc.sql databases

B.

The command succeeds and HR will be connected to the orcl database instance, and the abc.sql script will be executed

C.

The command fails because the script must refer to the full path name

D.

The command fails and reports an error because @ is used twice

Examine the description of the product_details table:

Which two statements are true?

A.

PRODUCT _ic can be assigned the PRIMARY KEY constraint.

B.

PRODUCT _price contains the value zero by default if no value is assigned to it.

C.

PRODUCT _price can be used in an arithmetic expression even if it has no value stored in it.

D.

EXPIRY_ DATE contains the sysdate by default if no date is assigned to it.

E.

PRODUCT_NAKE cannot contain duplicate values.

F.

EXPIRY_ DATE cannot be used in arithmetic expressions.