Online Access Free 1Z0-082 Practice Test

Which is the default column or columns for sorting output from compound queries using SET operators such as intersect In a SQL statement?

• A.the first varchab2 column in the first select of the compound query
• B.the first number column in the first select of the compound query
• C.the first number or varchar2 column in the last select of the compound query
• D.the first column in the first select of the compound query
• E.the first column in the last select of the compound query

Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)

• A.The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table
• B.They cannot be partitioned
• C.The ORACLE_LOADER access driver can be used to unload data from a database into an external table
• D.They support UPDATEs but not INSERTs and DELETEs
• E.The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table
• F.External table files can be used for other external tables in a different database

While one of your databases was in mount state, the datafiles were renamed because they had been moved to a new file system. The database was then opened.
Which two statements are true?

• A.DBA_DATA_FILES displays the original name for the data files.
• B.DBA_DATA_FILES must be resynchronized manually with the control file an order to have it display the new file names.
• C.DBA_DATA _FILES displays both the new name and the old name for the data files.
• D.DBA_DATA_FILES displays the new name for the data files.
• E.V$DATAFILE displays the new names for the data files.

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

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

You currently have an active transaction in your session and have been granted select access to vstransaction.

In which three situations will re-executing this query still return a row but with a different XID, indicating a new transaction has started?

• A.after successfully executing a commit or rollback followed by a DML statement
• B.after successfully executing a DML statement following a failed DML statement
• C.after successfully executing a create table statement followed by a create index statement
• D.after successfully executing a commit or rollback followed by a select statement
• E.after successfully executing a create table as select statement followed by a select for update statement
• F.after successfully executing a truncate statement followed by a DML statement