1Z0-082 Exam Questions

You need to calculate the number of days from 1st January 2019 until today. Dates are stored in the default format of DD-MON-RR. Which two queries give the required output? (Choose...

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

Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

Examine the description of the EMPLOYEES table: Which query is valid?

What is true about non-equijoin statement performance? (Choose two.)

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 d...

Examine this command and some partial output: Why does the DB01.abc.com service show unknown status?

Which three statements are true about the tools used to configure Oracle Net Services? (Choose three.)

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

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

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 Privi...

Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance? (Choose three.)

Which two statements are true about Enterprise Manager Database Express? (Choose two.)

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: Whi...

Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)

Which three statements are true about inner and outer joins? (Choose three.)

Examine this description of the TRANSACTIONS table: Which two SQL statements execute successfully? (Choose two.)

The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER. Which two queries execute successfully? (Choose two.)

Which statement is true about aggregate functions?

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.)

Which two are true about shrinking a segment online? (Choose two.)

Examine these commands: Which two statements are true about the sqlldr execution? (Choose two.)

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...

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

Which three statements are true about Oracle synonyms? (Choose three.)

View the Exhibit and examine the structure of the PRODUCTS table. Which two tasks require subqueries? (Choose two.)

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 statem...

Which three statements are true about table data storage in an Oracle Database? (Choose three.)

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...

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

Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)

Which two tasks can you perform using DBCA for databases? (Choose two.)

You execute this query: SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), `MON'), `dd "Monday for" fmMonth rrrr') What is the result?

Examine this command: CREATE UNDO TABLESPACE undotbs01 DATAFILE `undotbs_01.dbf' SIZE 100M AUTOEXTEND ON; Which two actions must you take to ensure UNDOTBS01 is used as the default...

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

You execute this command: CREATE SMALLFILE TABLESPACE sales DATAFILE `/u01/app/oracle/sales01.dbf SIZE 5G SEGMENT SPACE MANAGEMENT AUTO; Which two statements are true about the SAL...

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...

Which three activities are recorded in the database alert log? (Choose three.)

Which two statements are true about Enterprise Manager (EM) Express?

Examine this SQL statement: SELECT cust_id, cust_last_name "Last Name" FROM customers WHERE country_id = 10 UNION SELECT cust_id CUST_NO, cust_last_name FROM customers WHERE countr...

Which two statements are true about the configuration and use of UNDO_RETENTION with GURANTEED ? (Choose two.) RETENTION

Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER. Examine these SQL statements: Statement 1: SELECT MAX(unit_price * quantity) "Maximum Ord...

Which three files are used by conventional path SQL*Loader when the TABLE option is not specified? (Choose three.)

Which three failures require intervention for recovery? (Choose three.)

Which statement is true about smallfile tablespaces?

Which two are true about RETENTION GUARANTEE? (Choose two.)

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

Which statement is true about the INTERSECT operator used in compound queries?

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