1Z0-082 Exam Questions

Which two statements are true about single row functions? (Choose two.)

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

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

Which three statements are true about the Oracle Data Dictionary? (Choose three.)

Which two are true about Oracle recovery and data protection solutions? (Choose two.)

Which two are true about complete and incomplete recovery? (Choose two.)

Which two tasks can be performed in the NOMOUNT state? (Choose two.)

In one of your databases, the user HR has the password HRMGR. You want to connect to a database instance whose listener listens on port 1531 by using this statement: CONNECT HR/HRM...

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

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

In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties: 1. A size of 100 MB 2. AUTOEXTEND is off 3. UNDO_RETENTION is set to 15 minutes 4. It has RETENT...

Which two statements are true about the rules of precedence for operators? (Choose two.)

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

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables. You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promoti...

Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)

The stores table has a column START_DATE of data type DATE, containing the date the row was inserted. You only want to display details of rows where START_DATE is within the last 2...

Which two statements are true about segment types in an Oracle Database?

Examine these SQL statements which execute successfully: Which two statements are true after execution?

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

Which three statements are true about using SQL*Plus?

An Oracle database session has an uncommitted transaction in progress which updated 5000 rows in a table. Which three situations does the transaction complete thereby committing th...

Which three statements are true about roles?

Which two actions can you perform using DBCA for an existing database?

Which statement is true about database links?

Which two statements are true about User Authentication in an Oracle Database?

In the promotions table, the PROMO_BEGIN_DATE column is of data type date and the default date format Is DD-MON-RR. h two statements are true about expressions using PROMO_BEGIN_DA...

Which two statements are true about Oracle synonyms?

Examine the description of the PRODUCT_STATUS table: The status column contains the values 'in stock' or 'out of stock' for each row. Which two queries will execute successfully?

Which three statements are true about Deferred Segment Creation in Oracle databases?

Which three statements are true about the Automatic Diagnostic Repository (ADR)?

The sales table has columns prod_id and quantity_sold of data type number In two queries execute successfully?

Which two statements are true?

View the Exhibit and examine the description of the tables. You execute this SQL statement: Which three statements are true?

Which two statements are true about substitution variables?

Examine the description of the BOOKS_TRANSACTIONS table:

Which two queries execute successfully?

Which three statements are true about data block storage in an Oracle Database?

Which three statements are true about connection strings and service names used to connect to an Oracle database instance?

You must create a tablespace of non-standard block size in a new file system and plan to use this command: The standard block size is 8k but other non-standard block sizes will als...

Your database instance is started with an SPFILE. A PFILE is also available. You execute this command: ALTER SYSTEM SET DB_CACHE_SIZE=100K; Where Is the value changed?

Which three statements are true regarding single row subqueries?

Examine the description of the product_details table: Which two statements are true?

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

Examine the description of the employees table: Which query requires explicit data type conversion?

Which two statements are true about the Oracle Data Dictionary?

Examine this command: SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT Which two statements are true?

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

Examine this description of the books table containing 100 rows: Now examine this sequence of statements Issued In a new session; Examine this description of the books table contai...

The customers table has a cust_last_name column of data type varchar2. The table has two rows whose "jst_last_name values are Andersen and Ausson. Which query produces output for c...