1z0-082 | Abreast Of The Times 1z0-082 Questions 2021

NEW QUESTION 1
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 2
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 3
You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed.
The variables used in your query are never undefined in your session. Which query can be used?

• A. SELECT &&col1, &&col2FROM &tableWHERE &&condition = &&cond;
• B. SELECT &col1, &col2FROM &&tableWHERE &condition;
• C. SELECT &col1, &col2FROM “&table”WHERE &condition;
• D. SELECT ‘&&col1’, ‘&&col2’FROM &tableWHERE ‘&&condition’ = ‘&cond’;
• E. SELECT &&col1, &&col2FROM &tableWHERE &&condition;

Answer: B

NEW QUESTION 4
Which three statements are true about the DESCRIBE command? (Choose three.)

• A. It displays the PRIMARY KEY constraint for any column or columns that have that constraint
• B. It can be used from SQL Developer
• C. It displays the NOT NULL constraint for any columns that have that constraint
• D. It can be used to display the structure of an existing view
• E. It displays all constraints that are defined for each column
• F. It can be used only from SQL *Plus

Answer: CDF

NEW QUESTION 5
Which two statements are true about views used for viewing tablespace and datafile information? (Choose two.)

• A. Tablespace free space can be viewed in VSTABLESPACE
• B. VSTABLESPACE displays information that is contained in the controlfile about tablespaces
• C. VSTABLESPACE displays information about tablespaces contained in the data dictionary
• D. Tablespace free space can be viewed in DBA_TABLESPACES
• E. A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened

Answer: BE

NEW QUESTION 6
Examine these commands:

Which two statements are true about the sqlldr execution? (Choose two.)

• A. It overwrites data in EMP with data in EMP.DAT
• B. It uses the database buffer cache to load data
• C. It generates a log that contains control file entries, which can be used with normal SQL*Loader operations
• D. It generates a sql script that it uses to load data from EMP.DAT to EMP
• E. It appends data from EMP.DAT to EMP

Answer: BD

NEW QUESTION 7
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 8
Examine the description of the EMPLOYEES table:

Which query is valid?

• A. SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;
• B. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;
• C. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;
• D. SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;

Answer: B

NEW QUESTION 9
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 10
Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance? (Choose three.)

• A. An undo segment may be used by multiple transactions simultaneously
• B. Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment
• C. Undo segments have a minimum of three extents
• D. Undo segments can extend when a transaction fills the last extent of the undo segment
• E. A single transaction may use multiple undo segments simultaneously
• F. Undo segments must be stored in a BIGFILE tablespace
• G. Undo segments must be stored in a SMALLFILE tablespace

Answer: ADG

NEW QUESTION 11
Which two statements are true about space-saving features in an Oracle Database? (Choose two.)

• A. Private Temporary Tables (PTTS) store metadata in memory only
• B. An index created with the UNUSABLE attribute has no segment
• C. If they exist for a session, Private Temporary Tables (PTTs) are always dropped at the next COMMIT OR ROLLBACK statement
• D. An index that is altered to be UNUSABLE will retain its segment
• E. A table that is truncated will always have its segment removed

Answer: BC

NEW QUESTION 12
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 13
Which three statements are true about table data storage in an Oracle Database? (Choose three.)

• A. Data block headers contain their own Data Block Address (DBA)
• B. A table row piece can be chained across several database blocks
• C. Multiple row pieces from the same row may be stored in different database blocks
• D. Multiple row pieces from the same row may be stored in the same block
• E. Data block free space is always contiguous in the middle of the block
• F. Index block free space is always contiguous in the middle of the block

Answer: BCE

NEW QUESTION 14
Evaluate these commands which execute successfully:

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)

• A. If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS
• B. Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ
• C. Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO
• D. Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times
• E. Sequence ORD_SEQ is guaranteed not to generate duplicate numbers

Answer: BE

NEW QUESTION 15
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 16
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 17
Examine the description of the CUSTOMERS table:

For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?

• A. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHEREcust_incoms_level IS NOT NULLAND due_amount IS NOT NULL;
• B. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND cust_credit_level !=NULL;
• C. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level <> NULLAND due_amount <> NULL;
• D. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND due_amount !=NULL;
• E. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level IS NOT NULLAND cust_credit_limit IS NOT NULL;

Answer: E

NEW QUESTION 18
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 19
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

Answer: CDE

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

Answer: BCF

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

Answer: CDF

NEW QUESTION 22
Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)

• A. Connect Time Failover requires the use of Transparent Application Failover (TAF)
• B. Source Routing requires the use of a name server
• C. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall
• D. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration
• E. Load Balancing requires the use of a name server
• F. Connect Time Failover requires the connect string to have two or more listener addresses configured

Answer: BCF

NEW QUESTION 23
......