1Z0-082 Online Practice Questions and Answers
Examine the description of the BOOKS table:
The table has 100 rows.
Examine this sequence of statements issued in a new session:
INSERT INTO books VALUES (`ADV112', `Adventures of Tom Sawyer', NULL, NULL);
SAVEPOINT a;
DELETE FROM books;
ROLLBACK TO SAVEPOINT a;
ROLLBACK;
Which two statements are true? (Choose two.)
A. The second ROLLBACK command does nothing
B. The second ROLLBACK command replays the delete
C. The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed
D. The second ROLLBACK command undoes the insert
E. The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row
Which compression method is recommended for Direct-Path Insert operations?
A. COLUMN STORE COMPRESS BASIC
B. COLUMN STORE COMPRESS ADVANCED
C. ROW STORE COMPRESS BASIC
D. ROW STORE COMPRESS ADVANCED
Which three activities are recorded in the database alert log? (Choose three.)
A. Data Definition Language (DDL) statements
B. non-default database parameters
C. block corruption errors
D. deadlock errors
E. session logins and logouts
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 DIAGNIOSTIC_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.
Examine the description of the employees table:
Which query requires explicit data type conversion?
A. SELECT join_date FROM employees WHERE join_date > '10-02-2018';
B. SELECT join_date + '20' FROM employees;
C. SELECT salary + '120.50' FROM employees;
D. SELECT SUBSTR(join_date, 1, 2) - 10 FROM employees;
E. SELECT join_date || ' ' || salary FROM employees;
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 three statements are true about roles?
A. All roles granted to a user are set on by default when the user logs in,
B. Object privileges may not be granted to roles.
C. The SET ROLE statement can disable one or more roles for a session.
D. Roles must be password protected.
E. Roles may be granted to roles.
F. The SET ROLE statement can enable one or more roles for a session.
The CUSTOMERS table has a CUST_LAST_NAME column of data type VARCHAR2.
The table has two rows whose CUST_LAST_NAME values are Anderson and Ausson.
Which query produces output for CUST_LAST_NAME containing Oder for the first row and Aus for the second?
A. SELECT REPLACE(SUBSTR(cust_last_name, -3), 'An', 'O') FROM customers;
B. SELECT REPLACE(TRIM(TRAILING 'son' FROM cust_last_name), 'An', 'O') FROM customers;
C. SELECT INITCAP(REPLACE(TRIM('son' FROM cust_last_name), 'An', 'O')) FROM customers;
D. SELECT REPLACE(REPLACE(cust_last_name, 'son', ''), 'An', 'O') FROM customers;
Which two statements are true about INTERVAL data types? (Choose two.)
A. INTERVAL DAY TO SECOND columns support fractions of seconds.
B. The YEAR field in an INTERVAL YEAR TO MONTH column must be a positive value.
C. The value in an INTERVAL DAY TO SECOND column can be copied into an INTERVAL YEAR TO MONTH column.
D. INTERVAL YEAR TO MONTH columns only support monthly intervals within a range of years.
E. INTERVAL YEAR TO MONTH columns only support monthly intervals within a single year.
F. INTERVAL YEAR TO MONTH support yearly intervals.
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.