Oracle 1z0-082 Preparation Labs 2021

NEW QUESTION 1
Which two statements are true about the PMON background process? (Choose two.)

• A. It registers database services with all local and remote listeners known to the database instance
• B. It frees resources held by abnormally terminated processes
• C. It records checkpoint information in the control file
• D. It frees unused temporary segments
• E. It kills sessions that exceed idle time

Answer: AB

NEW QUESTION 2
Your database instance is started with a PFILE.
Examine these parameters:

You want to increase the size of the buffer cache.
Free memory is available to increase the size of the buffer cache. You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
What is the outcome?

• A. The value is changed only in the PFILE and takes effect at the next instance startup
• B. The value is changed for the current instance and in the PFILE
• C. It fails because the SCOPE clause is missing
• D. Change is applied to the current instance, but does not persist after instance restart

Answer: D

NEW QUESTION 3
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

Answer: AC

NEW QUESTION 4
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 succeeds and the generated undo is stored in SYSTEM.
• B. It fails and returns the error message “ORA-30036: unable to extend segment by 8 in undo tablespace ‘UNDOTBS1’ “.
• 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.

Answer: C

NEW QUESTION 5
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. INTERSECT
• B. UNION ALL
• C. UNION
• D. SUBTRACT
• E. MINUS

Answer: E

NEW QUESTION 6
In one of your databases, you create a user, HR, and then execute this command: GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which three actions can HR perform? (Choose three.)

• A. Revoke the CREATE SESSION privilege from other users
• B. Revoke the CREATE SESSION privilege from user HR
• C. Log in to the database instance
• D. Grant the CREATE SESSION privilege with ADMIN OPTION to other users
• E. Execute DDL statements in the HR schema
• F. Execute DML statements in the HR schema

Answer: ADE

NEW QUESTION 7
Which two statements are true about the DUAL table? (Choose two.)

• A. It can be accessed only by the SYS user
• B. It consists of a single row and single column of VARCHAR2 data type
• C. It can display multiple rows but only a single column
• D. It can be used to display only constants or pseudo columns
• E. It can be accessed by any user who has the SELECT privilege in any schema
• F. It can display multiple rows and columns

Answer: AB

NEW QUESTION 8
In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespaces are smallfile tablespaces.
SALES_Q1 is a permanent user-defined tablespace in the SALES database.
Examine this command which is about to be issued by a DBA logged in to the SALES database: ALTER TABLESPACE sales_q1 ADD DATAFILE;
Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)

• A. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least50 Mb of available space.
• B. Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.
• C. Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.
• D. Add the AUTOEXTEND ON clause with NEXT set to 100M.
• E. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.

Answer: BD

NEW QUESTION 9
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

Answer: CE

NEW QUESTION 10
You want to use table compression suitable for OLTP that will:
Compress rows for all DML statements on that table
Minimize the overheads associated with compression
Which compression option is best suited for this?

• A. COLUMN STORE COMPRESS FOR QUERY LOW
• B. ROW STORE COMPRESS BASIC
• C. COLUMN STORE COMPRESS FOR ARCHIVE LOW
• D. COLUMN STORE COMPRESS FOR ARCHIVE HIGH
• E. ROW STORE COMPRESS ADVANCED

Answer: E

NEW QUESTION 11
The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE.
You want to display the date of the first Monday after the completion of six months since hiring.
The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day on the wee.
Which query can be used?

• A. SELECT emp_id, ADD_MONTHS(hire_date, 6), NEXT_DAY(‘MONDAY’) FROM employees;
• B. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), ‘MONDAY’) FROM employees;
• C. SELECT emp_id, NEXT_DAY(MONTHS_BETWEEN(hire_date, SYSDATE), 6) FROM employees;
• D. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM employees;

Answer: B

NEW QUESTION 12
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

Answer: A

NEW QUESTION 13
You have been tasked to create a table for a banking application. One of the columns must meet three requirements:
Be stored in a format supporting date arithmetic without using conversion functions
Store a loan period of up to 10 years
Be used for calculating interest for the number of days the loan remains unpaid Which data type should you use?

• A. INTERVAL YEAR TO MONTH
• B. INTERVAL DAY TO SECOND
• C. TIMESTAMP WITH LOCAL TIMEZONE
• D. TIMESTAMP
• E. TIMESTAMP WITH TIMEZONE

Answer: B

NEW QUESTION 14
In one of your databases, the user HR has the password HRMGR.
You want to connect to a database instance whose listener listens on port 1531 by using this statement: CONNECT HR/HRMGR@orcl
No name server is used.
Which statement is true about ORCL?

• A. It must be the value of the SERVICE_NAMES parameter on the client side
• B. It must resolve to a valid connect descriptor in the server’s tnsnames.ora file
• C. It must resolve to a valid connect descriptor in the client’s tnsnames.ora file
• D. It must be the name of the database to whose instance HR wishes to connect
• E. It must be the name of the server running the database to whose instance HR wishes to connect

Answer: E

NEW QUESTION 15
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 DALLAS_DB
• B. as SCOTT in BOSTON_DB
• C. as SCOTT in BOSTON_DB and SYS in DALLAS_DB
• D. as SYS in both the databases
• E. as SCOTT in both the databases

Answer: D

NEW QUESTION 16
In one of your databases, user KING is:
1. Not a DBA user
2. An operating system (OS) user Examine this command and its output:

What must you do so that KING is authenticated by the OS when connecting to the database instance?

• A. Set OS_AUTHEN_PREFIX to OPS$
• B. Have the OS administrator add KING to the OSDBA group
• C. Grant DBA to KING
• D. Unset REMOTE_LOGIN_PASSWORDFILE
• E. Alter user KING to be IDENTIFIED EXTERNALLY

Answer: D

NEW QUESTION 17
Which four account management capabilities can be configured using Oracle profiles? (Choose four.)

• A. the number of hours for which an account is locked after the configured number of login attempts has been reached
• B. the number of days for which an account may be inactive before it is locked
• C. the maximum amount of CPU time allowed for a user’s sessions before their account is locked
• D. the ability to prevent a password from ever being reused
• E. the number of password changes required within a period of time before a password can be reused
• F. the number of days for which an account is locked after the configured number of login attempts has been reached
• G. the maximum number of sessions permitted for a user before the account is locked

Answer: DEFG

NEW QUESTION 18
Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

• A. The ADR base defaults to $ORACLE_HOME/rdbms/admin ifneither DIAGNOSTIC_DEST nor ORACLE_BASE is set
• B. The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set
• C. It supports diagnostics for Automatic Storage Management (ASM)
• D. It supports diagnostics for Oracle Clusterware
• E. It is held inside an Oracle database schema

Answer: AE

NEW QUESTION 19
Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)

• A. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
• B. SYSDATE can be queried only from the DUAL table
• C. CURRENT_DATE returns the current date and time as per the session time zone
• D. SYSDATE can be used in expressions only if the default date format is DD-MON-RR
• E. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server
• F. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE

Answer: BC

NEW QUESTION 20
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

Answer: DE

NEW QUESTION 21
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

Answer: DE

NEW QUESTION 22
Which three statements are true regarding indexes? (Choose three.)

• A. A UNIQUE index can be altered to be non-unique
• B. A SELECT statement can access one or more indices without accessing any tables
• C. A table belonging to one user can have an index that belongs to a different user
• D. An update to a table can result in updates to any or all of the table’s indexes
• E. When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped
• F. An update to a table can result in no updates to any of the table’s indexes

Answer: ADE

NEW QUESTION 23
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

Answer: B

NEW QUESTION 24
......