最新的Oracle 1Z0-082免費考試真題

問題1

Your database instance is started with a PFILE.
Examine these parameters:

You want to increase the size of the buffer cache.
Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
What is the outcome?

A. It fails because the SCOPE clause is missing

B. Change is applied to the current instance, but does not persist after instance restart

C. The value is changed only in the PFILE and takes effect at the next instance startup

D. The value is changed for the current instance and in the PFILE

正確答案: B

說明：（僅 Fast2test 成員可見）

問題2

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

A. A data block header is of a fixed length.

B. Row data is stored starting at the end of the block.

C. A block header contains a row directory pointing to all rows in the block.

D. An index block can contain row data.

E. A table block must always contain row data.

正確答案: A,C

問題3

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

A. Insert operations always attempt to find blocks with free space appropriate to the length of the row being inserted

B. A block will always be eligible for inserts if the row is short enough to fit into the block

C. ASSM assigns blocks to one of four fullness categories based on what percentage of the block is allocated for rows

D. Update operations always attempt to find blocks with free space appropriate to the length of the row being updated

E. PCTFREE defaults to 10% for all blocks in all segments for all compression methods

正確答案: B,D

問題4

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

A. non-default database parameters

B. deadlock errors

C. block corruption errors

D. Data Definition Language (DDL) statements

E. session logins and logouts

正確答案: A,B,C

說明：（僅 Fast2test 成員可見）

問題5

Which two functions are performed by a listener?

A. maintaining the connection to a client's user process until the user request is completed

B. returning the results of processing from the server process to the user process

C. verifying a user's authentication credentials

D. verifying the service name in an incoming user request

E. connecting a user process to a server process

F. creating a user session in the System Global Area (SGA)

正確答案: B,E

問題6

Which three are true about the Oracle Optimizer? (Choose three.)

A. It will only generate SQL Plan Directives specific to a given SQL statement.

B. It generates execution plans for SQL statements based on relevant schema objects, system and session parameters, and information found in the Data Dictionary.

C. It can re-optimize execution plans after previous executions detect suboptimal plans.

D. It updates stale object statistics in the Data Dictionary.

E. It determines the optimal table join order and method.

F. It can optimize only SELECT statements.

正確答案: B,E,F

問題7

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 containing 100 rows:
Which three statements are true?

A. The first rollback command leaves the table's 100 original rows locked.

B. The second rollback command restores the 100 rows that were in the table originally.

C. The first rollback command leaves the inserted row locked.

D. The second rollback command rolls back the rollback to savepoint a command.

E. The second rollback command restores the row that was inserted.

F. The first rollback command restores the 100 rows that were in the table originally.

G. The first RollBack command restores the row that was inserted.

正確答案: D,E,G

問題8

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

A. Employees 100 and 200 will have the same JOB_ID as before the update command

B. Employee 100 will have SALARY set to the same value as the SALARY of employee 200

C. Employees 100 and 200 will have the same SALARY as before the update command

D. Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100

E. Employee 200 will have SALARY set to the same value as the SALARY of employee 100

F. Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200

正確答案: B,D

問題9

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

A. Configure a nonstandard block size for a new database

B. Change the standard block size of an existing database

C. Configure incremental backups for a new database

D. Enable flashback database for an existing database

E. Register a new database with an available Enterprise Manager Management server

正確答案: B,E

說明：（僅 Fast2test 成員可見）

問題10

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

A. It kills sessions that exceed idle time

B. It records checkpoint information in the control file

C. It frees resources held by abnormally terminated processes

D. It frees unused temporary segments

E. It registers database services with all local and remote listeners known to the database instance

正確答案: C,E

說明：（僅 Fast2test 成員可見）

問題11

Which two are true about instance recovery for a database that is open in read write mode?
(Choose two.)

A. No users can log on until instance recovery has completed.

B. The database opens after the roll forward phase of instance recovery has completed.

C. It is guaranteed to complete within fast_start_mttr_target number of seconds.

D. It is always performed when opening a database.

E. It always occurs during instance startup performed immediately after a SHUTDOWN ABORT.

F. Only the CURRENT REDO log group is required to perform instance recovery.

正確答案: D,E

最新的Oracle Database Administration I - 1Z0-082免費考試真題

聯系我們

站內鏈接

最新更新