1Z0-082 Online Practice Questions and Answers

Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER.

Examine these SQL statements:

Statement 1:

SELECT MAX(unit_price * quantity) "Maximum Order"

FROM order_items;

Statement 2:

SELECT MAX(unit_price * quantity) "Maximum Order"

FROM order_items

GROUP BY order_id;

Which two statements are true?

A. Statement 1 returns only one row of output.

B. Statement 2 returns only one row of output.

C. Both statements will return NULL if either UNIT_PRICE or QUANTITY contains NULL.

D. Both the statements give the same output.

E. Statement 2 may return multiple rows of output.

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

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 sales table has columns prod_id and quantity_sold of data type number In two queries execute successfully? x

A. SELECT prod_id FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id HAVING COUNT(-) > 10;

B. SELECT prod_id FROM sales WHERE quantity_sold > 5S000 AND COUNT(-) > 10 GROUP BY prod_id HAVING COUNT(-) > 10;

C. SELECT COUNT|prod_id> FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id;

D. SELECT COUNTlprod_id> FROM sales GROUP BY prod_id WHERE quantity_Sold > 55000;

E. SELECT prod_id FROM sales WHERE quantity_scld > 55000 AND COUNT(-) > 10 GROUP BY COUNT(-) > 10;

Which three files are used by conventional path SQL*Loader when the TABLE option is not specified? (Choose three.)

A. dump files

B. control files

C. password files

D. bad files

E. input files

Which two statements are true about UNDO and REDO? (Choose two.)

A. The generation of UNDO generates REDO

B. DML modifies Oracle database objects and only generates UNDO

C. The generation of REDO generates UNDO

D. DML modifies Oracle database objects and only generates REDO

E. DML modifies Oracle database objects and generates UNDO and REDO

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

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 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 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