High Quality 1z0-082 Bootcamp 2021

NEW QUESTION 1
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 2
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 3
Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)? (Choose two.)

• A. PCTFREE defaults to 10% for all blocks in all segments for all compression methods
• B. ASSM assigns blocks to one of four fullness categories based on what percentage of the block is allocated for rows
• C. Update operations always attempt to find blocks with free space appropriate to the length of the row being updated
• D. Insert operations always attempt to find blocks with free space appropriate to the length of the row being inserted
• E. A block will always be eligible for inserts if the row is short enough to fit into the block

Answer: CE

NEW QUESTION 4
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 5
Examine the description of the CUSTOMERS table:

You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.
Which query can be used?

• A. SELECT * FROM customers WHERE city LIKE ‘D_%’;
• B. SELECT * FROM customers WHERE city = ‘%D_’;
• C. SELECT * FROM customers WHERE city LIKE ‘D_’;
• D. SELECT * FROM customers WHERE city = ‘D_%’;

Answer: A

NEW QUESTION 6
Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:
ALTER DATABASE MOUNT;
Which two actions are performed? (Choose two.)

• A. The online redo logs are opened
• B. The online data files are opened
• C. The alert log records the execution details
• D. The Oracle background processes are started
• E. The initialization parameter file is read
• F. The control file is read

Answer: DF

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

You want to display the unique promotion costs in each promotion category. Which two queries can be used? (Choose two.)

• A. SELECT promo_cost, promo_category FROM promotions ORDER BY 1;
• B. SELECT DISTINCT promo_cost || ’ in ‘ || DISTINCT promo_category FROM promotions ORDER BY 1;
• C. SELECT DISTINCT promo_category || ‘ has ‘ || promo_cost AS COSTS FROM promotions ORDER BY 1;
• D. SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;
• E. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

Answer: DE

NEW QUESTION 10
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 11
Which three statements are true about single-row functions? (Choose three.)

• A. They can be used only in the WHERE clause of a SELECT statement
• B. The argument can be a column name, variable, literal or an expression
• C. The data type returned can be different from the data type of the argument
• D. They can be nested to any level
• E. They can accept only one argument
• F. They return a single result row per table

Answer: BCF

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

Answer: DE

NEW QUESTION 13
Which three statements are true about a self-join? (Choose three.)

• A. The ON clause must be used
• B. The query must use two different aliases for the table
• C. It must be an equi join
• D. It must be an inner join
• E. The ON clause can be used
• F. It can be an outer join

Answer: BDE

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

Answer: B

NEW QUESTION 15
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 16
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 17
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

Answer: BDF

NEW QUESTION 18
Which two statements are true about UNDO and REDO? (Choose two.)

• A. The generation of UNDO generates REDO
• B. DML modifies Oracle database objects and only generates UNDO
• C. The generation of REDO generates UNDO
• D. DML modifies Oracle database objects and only generates REDO

Answer: AC

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 the SET VERIFY ON command? (Choose two.)

• A. It can be used only in SQL*Plus
• B. It displays values for variables used only in the WHERE clause of a query
• C. It can be used in SQL Developer and SQL*Plus
• D. It displays values for variables created by the DEFINE command
• E. It displays values for variables prefixed with &&

Answer: AD

NEW QUESTION 21
You need to calculate the number of days from 1st January 2021 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-2021’ FROM DUAL;
• B. SELECT ROUND(SYSDATE – ’01-JAN-2021’) FROM DUAL;
• C. SELECT ROUND(SYSDATE – TO_DATE(‘01/JANUARY/2021’)) FROM DUAL;
• D. SELECT TO_DATE(SYSDATE, ‘DD/MONTH/YYYY’) – ‘01/JANUARY/2021’ FROM DUAL;
• E. SELECT SYSDATE – TO_DATE(’01-JANUARY-2021’) FROM DUAL;

Answer: AB

NEW QUESTION 22
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 23
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 24
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 25
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 26
......