Free 1z0-082: Oracle Database Administration I Exam Questions and Answers

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: Which two statements are true? (Choose two.)

Select 2 answers.

• AA. Employee 100 will have SALARY set to the same value as the SALARY of employee 200
• BB. Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100
• CC. Employee 200 will have SALARY set to the same value as the SALARY of employee 100
• DD. Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200
• EE. Employees 100 and 200 will have the same JOB_ID as before the update command
• FF. Employees 100 and 200 will have the same SALARY as before the update command

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

Select 2 answers.

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

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

Select 3 answers.

• AA. The Oracle Net Configuration Assistant is only used when running the Oracle installer
• BB. Oracle Net Manager can be used to centrally configure listeners on any database server target
• CC. The lsnrctl utility requires a listener.ora file to exist before it is started
• DD. Oracle Net Manager can be used to locally configure naming methods on a database server
• EE. Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server
• FF. Enterprise Manager Cloud Control can be used to centrally configure net service names for any databaseserver target

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

Select 2 answers.

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

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

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

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 RETENTION GUARANTEE UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens. What will happen when the next update is attempted by any transaction?

• AA. It succeeds and the generated undo is stored in SYSTEM.
• BB. It fails and returns the error message “ORA-30036: unable to extend segment by 8 in undo tablespace ‘UNDOTBS1’ “.
• CC. It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.
• DD. It succeeds and the generated undo is stored in SYSAUX.
• EE. It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.

You have been tasked to create a table for a banking application. One of the columns must meet three requirements: Be stored in a format supporting date arithmetic without using conversion functions Store a loan period of up to 10 years Be used for calculating interest for the number of days the loan remains unpaid Which data type should you use?

• AA. INTERVAL YEAR TO MONTH
• BB. INTERVAL DAY TO SECOND
• CC. TIMESTAMP WITH LOCAL TIMEZONE
• DD. TIMESTAMP
• EE. TIMESTAMP WITH TIMEZONE

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 database. Examine this command which is about to be issued by a DBA logged in to the SALES database: ALTER TABLESPACE sales_q1 ADD DATAFILE; Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)

Select 2 answers.

• AA. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least50 Mb of available space.
• BB. Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.
• CC. Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.
• DD. Add the AUTOEXTEND ON clause with NEXT set to 100M.
• EE. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.

Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)? (Choose two.)

Select 2 answers.

• AA. PCTFREE defaults to 10% for all blocks in all segments for all compression methods
• BB. ASSM assigns blocks to one of four fullness categories based on what percentage of the block is allocated for rows
• CC. Update operations always attempt to find blocks with free space appropriate to the length of the row being updated
• DD. Insert operations always attempt to find blocks with free space appropriate to the length of the row being inserted
• EE. A block will always be eligible for inserts if the row is short enough to fit into the block

Which two statements are true about the PMON background process? (Choose two.)

Select 2 answers.

• AA. It registers database services with all local and remote listeners known to the database instance
• BB. It frees resources held by abnormally terminated processes
• CC. It records checkpoint information in the control file
• DD. It frees unused temporary segments
• EE. It kills sessions that exceed idle time