1Z0-082 Exam Dumps – Our Features

Which two statements are true regarding a SAVEPOINT? (Choose two.)

• Rolling back to a SAVEPOINT can undo a CREATE INDEX statement
• Rolling back to a SAVEPOINT can undo a TRUNCATE statement
• Only one SAVEPOINT may be issued in a transaction
• A SAVEPOINT does not issue a COMMIT
• Rolling back to a SAVEPOINT can undo a DELETE statement

Which three statements are true about a self join? (Choose three.)

• The ON clause must be used
• The query must use two different aliases for the table
• It must be an equijoin
• It must be an inner join
• The ON clause can be used
• It can be an outer join

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

• A full outer join returns matched and unmatched rows
• An inner join returns matched rows
• Outer joins can only be used between two tables per query
• A full outer join must use Oracle syntax
• Outer joins can be used when there are multiple join conditions on two tables
• A left or right outer join returns only unmatched rows

You execute this query: SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), ‘MON’), ‘dd “Monday for” fmMonth rrrr’) What is the result?

• It executes successfully but does not return any result
• It returns the date for the first Monday of the next month
• It generates an error
• It returns the date for the last Monday of the current month

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 UNDO tablespace? (Choose two.)

• Add the SEGMENT SPACE MANAGEMENT AUTO clause
• Set UNDO_TABLESPACE to UNDOTBS01
• Add the NOLOGGING clause
• Make certain that the database operates in automatic undo management mode
• Add the ONLINE clause

Which three statements are true concerning logical and physical database structures? (Choose three.)

• All tablespaces may have one or more data files
• The extents of a segment must always reside in the same datafile
• A smallfile tablespace might be bigger than a bigfile tablespace
• A segment can span multiple data files in some tablespaces
• A segment’s blocks can be of different sizes
• A segment might have only one extent
• Segments can span multiple tablespaces

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

• dump files
• control files
• password files
• bad files
• input files

Which two statements are true about substitution variables?

• A substitution variable prefixed with & always prompts only once for a value in a session.
• A substitution variable prefixed with to prompts only once for a value in a session unless it is set to undefined in the session
• A substitution variable can be used only in a select statement.
• A substitution variable used to prompt for a column name must be enclosed in single quotation marks.
• A substitution variable can be used with any clause in a select statement.
• A substitution variable used to prompt for a column name must be enclosed in double quotation marks.

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

• They can be written by server processes
• Trace files are written to the Fast Recovery Area (FRA)
• They can be written by background processes
• All trace files contain error information that require contacting Oracle Support
• Trace file names are based on the database name concatenated with a sequential number

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 SALES tablespace? (Choose two.)

• It must be smaller than the smallest BIGFILE tablespace
• Free space is managed using freelists
• Any data files added to the tablespace must have a size of 5 gigabytes
• It uses the database default blocksize
• It is a locally managed tablespace