Downloadable 1z0-082 Paper 2021

NEW QUESTION 1
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 2
Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (Choose two.)

• A. Aggregating functions and columns used in HAVING clauses must be specified in the SELECT list of a query
• B. WHERE and HAVING clauses can be used in the same statement only if applied to different table columns
• C. The HAVING clause can be used with aggregating functions in subqueries
• D. The WHERE clause can be used to exclude rows before dividing them into groups
• E. The WHERE clause can be used to exclude rows after dividing them into groups

Answer: CD

NEW QUESTION 3
You execute this command:

Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBS tablespace? (Choose two.)

• A. AUTOEXTEND is possible for the datafile
• B. It must be bigger than the largest SMALLFILE tablespace
• C. Additional data files may not be added
• D. It will be a dictionary-managed tablespace by default
• E. It will always have a 32K blocksize

Answer: AB

NEW QUESTION 4
Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)

• A. writing inbound request to the common request queue from all shared server connections
• B. checking for outbound shared server responses on the common outbound response queue
• C. receiving inbound requests from processes using shared server connections
• D. sending each connection input request to the appropriate shared server input queue
• E. broadcasting shared server session responses back to requesters on all connections
• F. sending shared server session responses back to requesters on the appropriate connection

Answer: ACD

NEW QUESTION 5
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. Column positions must be used in the ORDER BY clause
• B. Only column names from the first SELECT statement in the compound query are recognized
• C. 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
• 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

Answer: BE

NEW QUESTION 6
Which three statements are true about views in an Oracle database? (Choose three.)

• A. Views can be updated without the need to re-grant privileges on the view
• B. Tables in the defining query of a view must always exist in order to create the view
• C. The WITH CHECK clause prevents certain rows from being displayed when querying the view
• D. Data Manipulation Language (DML) can always be used on views
• E. Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
• F. Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
• G. The WITH CHECK clause prevents certain rows from being updated or inserted

Answer: BDE

NEW QUESTION 7
Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)

• A. Duplicates are eliminated automatically by the UNION ALL operator
• B. The number of columns selected in each SELECT statement must be identical
• C. The names of columns selected in each SELECT statement must be identical
• D. The output is sorted by the UNION ALL operator
• E. NULLS are not ignored during duplicate checking

Answer: BE

NEW QUESTION 8
Examine this command:

Which two statements are true? (Choose two.)

• A. DML may be performed on tables with one or more extents in this data file during the execution of this command.
• B. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
• C. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
• D. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
• E. The file is renamed and stored in the same location

Answer: AB

NEW QUESTION 9
You want to apply the principle of Least Privilege in all your live databases.
One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.
Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose three.)

• A. analysis of all privileges used by all users including administrative users in the database
• B. analysis of all privileges used by all users but excluding administrative users in the database
• C. analysis of privileges that a user has on their own schema objects that they did not use
• D. analysis of privileges that a user has on their own schema objects that they did use
• E. analysis of privileges granted directly to a role that are then used by a user who has been granted that role
• F. analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role

Answer: ACF

NEW QUESTION 10
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 11
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 12
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 13
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 14
Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)

• A. The Oracle join syntax supports creation of a Cartesian product of two tables
• B. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax
• C. The SQL:1999 compliant ANSI join syntax supports natural joins
• D. The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables
• E. The Oracle join syntax only supports right outer joins
• F. The Oracle join syntax supports natural joins
• G. The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax

Answer: CDF

NEW QUESTION 15
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. Employee 100 will have SALARY set to the same value as the SALARY of employee 200
• B. Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100
• C. Employee 200 will have SALARY set to the same value as the SALARY of employee 100
• D. Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200
• E. Employees 100 and 200 will have the same JOB_ID as before the update command
• F. Employees 100 and 200 will have the same SALARY as before the update command

Answer: AB

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
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 18
Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

• A. A table can have only one primary key but multiple foreign keys
• B. A table can have only one primary key and foreign key
• C. The foreign key columns and parent table primary key columns must have the same names
• D. It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted
• E. It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted
• F. Only the primary key can be defined at the column and table level
• G. Primary key and foreign key constraints can be defined at both the column and table level

Answer: ACEG

NEW QUESTION 19
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 20
In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE. Examine this command:
SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);
Which segment or segments, if any, are created as a result of executing the command?

• A. T1, an index segment for the primary key, a LOB segment, and a lobindex segment
• B. no segments are created
• C. T1 only
• D. T1 and an index segment created for the primary key only
• E. T1, an index segment for the primary key, and a LOB segment only

Answer: C

NEW QUESTION 21
Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)

• A. Column names in each SELECT in the compound query can be different
• B. The number of columns in each SELECT in the compound query can be different
• C. Reversing the order of the intersected tables can sometimes affect the output
• D. INTERSECT returns rows common to both sides of the compound query
• E. INTERSECT ignores NULLs

Answer: AE

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
Which two tasks can you perform using DBCA for databases? (Choose two.)

• A. Configure a nonstandard block size for a new database
• B. Register a new database with an available Enterprise Manager Management server
• C. Change the standard block size of an existing database
• D. Configure incremental backups for a new database
• E. Enable flashback database for an existing database

Answer: BC

NEW QUESTION 24
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 25
Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)

• A. The CURRENT_TIMESTAMP function returns data without time zone information
• B. A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row
• C. A TIMESTAMP data type column contains information about year, month, and day
• D. The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
• E. The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

Answer: ADE

NEW QUESTION 26
......