The Secret Of Oracle 1z0-082 Dumps Questions

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

• A. An undo segment may be used by multiple transactions simultaneously
• B. Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment
• C. Undo segments have a minimum of three extents
• D. Undo segments can extend when a transaction fills the last extent of the undo segment
• E. A single transaction may use multiple undo segments simultaneously
• F. Undo segments must be stored in a BIGFILE tablespace
• G. Undo segments must be stored in a SMALLFILE tablespace

Answer: ADG

NEW QUESTION 2
In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.
The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

Which statement is true?

• A. Dynamic service registration cannot be used for this database instance
• B. The LREG process registers services dynamically with the LISTENER_1 listener
• C. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
• D. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
• E. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration

Answer: C

NEW QUESTION 3
Evaluate these commands which execute successfully:

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)

• A. If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS
• B. Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ
• C. Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO
• D. Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times
• E. Sequence ORD_SEQ is guaranteed not to generate duplicate numbers

Answer: BE

NEW QUESTION 4
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 5
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 6
Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

• A. The ADR base defaults to $ORACLE_HOME/rdbms/admin ifneither DIAGNOSTIC_DEST nor ORACLE_BASE is set
• B. The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set
• C. It supports diagnostics for Automatic Storage Management (ASM)
• D. It supports diagnostics for Oracle Clusterware
• E. It is held inside an Oracle database schema

Answer: AE

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

• A. It is not possible to shrink either indexes or Index Organized Tables (IOTs)
• B. It always eliminates all migrated rows if any exist in the table
• C. To shrink a table it must have a PRIMARY KEY constraint
• D. To shrink a table it must have a UNIQUE KEY constraint
• E. To shrink a table it must have row movement enabled
• F. It must be in a tablespace that uses Automatic Segment Space Management (ASSM)

Answer: CE

NEW QUESTION 8
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 9
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 10
Which two statements are true about the rules of precedence for operators? (Choose two.)

• A. The concatenation operator | | is always evaluated before addition and subtraction in an expression
• B. NULLS influence the precedence of operators in an expression
• C. The + binary operator has the highest precedence in an expression in a SQL statement
• D. Arithmetic operators with equal precedence are evaluated from left to right within an expression
• E. Multiple parentheses can be used to override the default precedence of operators in an expression

Answer: CE

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

• A. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
• B. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
• C. GLOBAL TEMPORARY TABLE space allocation occurs at session start.
• D. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
• E. A GLOBAL TEMPORARY TABLE’S definition is available to multiple sessions.
• F. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

Answer: BCF

NEW QUESTION 12
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 13
Which three statements are true about Oracle synonyms? (Choose three.)

• A. A synonym cannot be created for a PL/SQL package
• B. A synonym can be available to all users
• C. A SEQUENCE can have a synonym
• D. A synonym created by one user can refer to an object belonging to another user
• E. Any user can drop a PUBLIC synonym

Answer: BCD

NEW QUESTION 14
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 15
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 16
Examine this command and some partial output:

Why does the DB01.abc.com service show unknown status?

• A. The service DB01.abc.com is dynamically registered
• B. The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1
• C. The service DB01.abc.com is statically registered
• D. The listener is not listening on the default port 1521
• E. The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file

Answer: B

NEW QUESTION 17
......