Free Oracle 1Z1-082 Practice Test & Real Exam Questions, Page 2

Question #14

The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations.
Each database has a tnsnames.ora file defining DALLAS_DB as a service name.
Examine this command:
CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING
`dallas_db';
How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?

A. as SCOTT in BOSTON_DB

B. as SYS in both the databases

C. as SCOTT in both the databases

D. as SCOTT in DALLAS_DB

E. as SCOTT in BOSTON_DB and SYS in DALLAS_DB

Discussion 0

Correct Answer: B Vote an answer

Question #15

Which two are true about Oracle recovery and data protection solutions? (Choose two.)

A. RMAN can be used to roll back committed transactions.

B. Data Recovery Advisor can be used to validate backup strategies.

C. Data Recovery Advisor can be used to restore a single file from an RMAN backupset.

D. Oracle Data Guard can prevent data loss caused by a site failure.

E. RMAN can be used to FLASHBACK a database.

Discussion 0

Correct Answer: D,E Vote an answer

Question #16

In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties:
1. A size of 100 MB
2. AUTOEXTEND is off
3. UNDO_RETENTION is set to 15 minutes
4. It has RETENTION GUARANTEE
UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens.
What will happen when the next update is attempted by any transaction?

A. It fails and returns the error message "ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'".

B. It succeeds and the generated undo is stored in SYSTEM.

C. It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.

D. It succeeds and the generated undo is stored in SYSAUX.

E. It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.

Discussion 0

Correct Answer: C Vote an answer

Question #17

Examine the description of the SALES1 table:

SALES2 is a table with the same description as SALES1.
Some sales data is duplicated in both tables.
You want to display the rows from the SALES1 table which are not present in the SALES2 table.
Which set operator generates the required output?

A. UNION ALL

B. UNION

C. SUBTRACT

D. INTERSECT

E. MINUS

Discussion 0

Correct Answer: E Vote an answer

Question #18

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

A. All trace files contain error information that require contacting Oracle Support

B. They can be written by background processes

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

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

E. They can be written by server processes

Discussion 0

Correct Answer: B,E Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #19

Examine this command:
SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT
Which two statements are true?

A. The shrink operation causes rows to be moved to empty space starting from the beginning of the orders segment.

B. Only queries are allowed on ORDERS while the shrink is executing.

C. Dependent indexes become UNUSABLE.

D. The high-water mark (HWM) of orders is adjusted.

E. The shrink operation causes rows to be moved to empty space starting toward the end of the orders segment.

F. Queries and DML statements are allowed on ORDERS while the shrink is executing.

Discussion 0

Correct Answer: A,F Vote an answer

Question #20

Which two statements are true about undo and undo tablespaces?

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

B. undo segments are owned by SYSTEM.

C. An undo tablespace may be owned by only one instance.

D. undo segments are owned by SYSBACKUP.

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

Discussion 0

Correct Answer: C,E Vote an answer

Question #21

Examine the description of the BOOKS_TRANSACTIONS table:

A. WHERE borrowed_date = SYSDATE AND transaction_type = 'RM*) OR member_id IN ('A101',
'A102');

B. WHERE borrowed_date = SYSDATE AND {transaction_type = 'RM* AND (raeraber_id =
'A101' OR member_id = 'A102));

C. WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM* OR member_id IN ('A101',
'A102'));
E, WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' OR member_id IN ('A101',
'A102');

D. WHERE borrowed_date = SYSDATE AND (transaction_ype = 'RM' AND .-neraber_id = 'A101' OR member_id = 'A102');

Discussion 0

Correct Answer: A,C Vote an answer

Question #22

Examine this description of the TRANSACTIONS table:

Which two SQL statements execute successfully? (Choose two.)

A. SELECT customer_id AS `CUSTOMER-ID', transaction_date AS DATE, amount + 100 `DUES AMOUNT' FROM transactions;

B. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100 "DUES" FROM transactions;

C. SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100
"DUES AMOUNT" FROM transactions;

D. SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;

E. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100 DUES FROM transactions;

Discussion 0

Correct Answer: D,E Vote an answer

Question #23

Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.
Only the EMPLOYEE_ID column is indexed.
Rows exist for employees 100 and 200.
Examine this statement:

Which two statements are true? (Choose two.)

A. Employees 100 and 200 will have the same SALARY as before the update command

B. Employees 100 and 200 will have the same JOB_ID as before the update command

C. Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200

D. Employee 100 will have SALARY set to the same value as the SALARY of employee 200

E. Employee 200 will have SALARY set to the same value as the SALARY of employee 100

F. Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100

Discussion 0

Correct Answer: D,F Vote an answer

Question #24

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. Drop other U1 objects in DATA

B. Set AUTOEXTEND ON for data files in DATA

C. Set DEFERRED_SEGMENT_CREATION to TRUE

D. Increase U1's quota sufficiently in DATA

E. Grant UNLIMITED TABLESPACE to U1

F. Add a data file to DATA

Discussion 0

Correct Answer: B,C,D Vote an answer

Question #25

Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)

A. The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause

B. Only column names from the first SELECT statement in the compound query are recognized

C. Column positions must be used in the ORDER BY clause

D. Each SELECT statement in the compound query must have its own ORDER BY clause

E. Each SELECT statement in the compound query can have its own ORDER BY clause

Discussion 0

Correct Answer: B,E Vote an answer

Question #26

An Oracle database session has an uncommitted transaction in progress which updated 5000 rows in a table.
Which three situations does the transaction complete thereby committing the updates?

A. when a COMMIT statement is issued by the same user from another session in the same database instance

B. when the session logs out successfully

C. when a CREATE TABLE AS SELECT statement is executed unsuccessfully in the same session

D. when a DBA issues a successful SHUTDOWN IMMEDIATE statement and the user then issues a COMMIT

E. when a CREATE INDEX statement is executed successfully in the same session

F. when a DBA issues a successful SHUTDOWN TRANSACTIONAL statement and the user then issues a COMMIT

Discussion 0

Correct Answer: B,E,F Vote an answer

Free Oracle 1Z1-082 Practice Test & Real Exam Questions

Download Free Oracle 1Z1-082 Demo