1Z0-082 Online Practice Questions and Answers

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

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

Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)

A. Column names in each SELECT in the compound query can be different

B. The number of columns in each SELECT in the compound query can be different

C. Reversing the order of the intersected tables can sometimes affect the output

D. INTERSECT returns rows common to both sides of the compound query

E. INTERSECT ignores NULLs

Which two statements are true about single row functions? (Choose two.)

A. MOD : returns the quotient of a division operation

B. FLOOR : returns the smallest integer greater than or equal to a specified number

C. TRUNC : can be used to combine any number of values

D. CONCAT : can be used to combine any number of values

E. CEIL : can be used for positive and negative numbers

The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION =

FALSE

User U1 has a 1 MB quota in tablespace DATA.

U1 executes this command:

SQL> CREATE TABLE t1 AS

(SELECT object_name, sharing, created

FROM dba_objects);

U1 complains that the command is taking too long to execute.

In the alert log, the database administrator (DBA) finds this:

2017-03-06T12:15:17.183438+05:30

statement in resumable session `User U1(136), Session 1, Instance 1' was suspended due to ORA-01536:

space quota exceeded for tablespace `DATA'

Which are three actions any one of which the DBA could take to resume the session? (Choose three.)

A. Add a data file to DATA

B. Drop other U1 objects in DATA

C. Increase U1's quota sufficiently in DATA

D. Set DEFERRED_SEGMENT_CREATION to TRUE

E. Grant UNLIMITED TABLESPACE to U1

F. Set AUTOEXTEND ON for data files in DATA

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 three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

A. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.

B. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.

C. GLOBAL TEMPORARY TABLE space allocation occurs at session start.

D. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.

E. A GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.

F. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

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;

E. SELECT SYSDATE ?TO_DATE('01-JANUARY-2019') FROM DUAL;

Examine this command and some partial output:

Why does the DB01.abc.com service show unknown status?

A. The service DB01.abc.com is dynamically registered

B. The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1

C. The service DB01.abc.com is statically registered

D. The listener is not listening on the default port 1521

E. The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file

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.

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

The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.

Segment creation is not deferred.

You execute this command:

Which three statements must be true so that the SALES user can create tables in SALES_Q1? (Choose three.)

A. The sales user must have a quota on the TEMP tablespace

B. The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema

C. The sales user must have been granted the CREATE SESSION privilege D. The sales user must have their quota on the users tablespace removed

E. The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema

F. The sales user must have been granted the CREATE TABLE privilege

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

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.