Oracle 10g OCP 042 題庫 1-30 題 共168題

聲明：對於答案的相關的說明，是個人對Oracle的理解。

1. Because of a power outage,instance failure has occurred. From what point in the redo log does recovery begin and where does it end?

A. Current redo log and inactive redo log

B. Checkpoint position to end of redo log

C. Beginning of redo log to end of redo log

D. All redo logs before the point of last commit

E. Beginning of redo log to checkpoint position.

答案B.  Checkpoint 之前的資料已經寫入到資料檔案。 所以用restore 就可以恢複。 而checkpoint之後的資料沒有寫入到資料檔案，所以需要進行recovery。 Recovery時，對於已經commit的資料，前滾寫入到資料檔案。 沒有commit的資料，進行復原。

2. Which two operations can be flashed back using the flashback technology? (choose two)

A. Drop user smith;

B. Drop table employees;

C. Drop tablespace users;

D. Alter table sales_rep drop partition p1;

E. Alter table employees drop column desig_id;

答案：AB。

Oracle Flashback 技術總結

3. You have to shut down the database instance with the abort option because of a hardware failure. Which statement is true about the subsequent opening of the database?

A. The database would open normally.

B. The database would not open,and it would stop at mount stage.

C. The database would open alter automatically performing instance recovery.

D. The database would not open, and have to perform database recovery to open it.

答案： C.

如果執行個體異常關閉（宕機，shutdown abort），並且資料檔案，控制檔案，聯機日誌都沒有丟失。在下次啟動時，要利用聯機日誌的內容進行恢複，這種恢複就是執行個體恢複（Instance Recovery）。

Instance Recovery 主要包括3個階段：

1） 根據聯機日誌內容進行Rollover。

2） 開啟資料庫，提供服務

3） SMON 或者使用者進程進行Rollback。

4. You backed up the control file to trace. Which statement is true about the trace file generated?

A. The trace file is in binary format.

B. The trace file has a SQL scripts to re-create the control file.

C. The trace file is a backup set created during the backup of the control file.

D. The trace file contains the instructions to manually re-create the control file.

E. The trace file is an image copy of the control file created during the backup of the the control file.

答案： B

聯機文檔：

An alternative to the CREATE CONTROLFILE statement is ALTER DATABASE BACKUP CONTROLFILE TO TRACE, which generates a SQL script in the trace file to re-create the controlfile

http://download.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_5003.htm

5. While running the Oracle Universal Installer on a Unix platform to install Oracle Database 10g software,you are prompted to run orainstRoot.sh. What does this scripts accomplish?

A. It creates the pointer file.

B. It creates the base directory.

C. It creates the inventory pointer file.

D. It creates the Oracle user for installation.

E. It modifies the Unix kernel parmeters to match Oracle's requirement.

答案： C

可以查看$ORACLE_BASE/oraInventory/orainstRoot.sh 指令碼的內容。該指令碼實際上完成了以下工作：

（1）建立software inventory location pointer file: /etc/oraInst.loc，內容為

      inventory_loc=$ORACLE_BASE/oraInventory

     inst_group=oinstall

   修改該檔案屬性:chmod 644 /etc/oraInst.loc

（2）建立inventory directory: $ORACLE_BASE/oraInventory

   修改檔案屬性： chmod -R 770 $ORACLE_BASE/oraInventory

                chgrp oinstall $ORACLE_BASE/oraInventory

  oraInventory目錄是用來儲存oracle安裝的所有軟體組件的資訊的，每個組件可能佔用150k的空間.

 

6. While setting up an Oracle database for one of your critical applications, you want to ensure that the database is backed up at regular intervals without your intervention(介入). What should you do to achieve the objective?

A. Configure the database to run in archivelog mode.

B. Configure the Flash recovery area to enable automatic database backup.

C. Schedule the database backup using DBMS_JOB package after creating the database.

D. Schedule the database backup using recovery manager(RMAN) commands after creating the database.

E. Schedule the database backup using Database Configuration Assistant(DBCA) while creating the database.

答案：E.

剛看到這個答案的時候，以為答案有問題。Google一下，真有。 我們注意看題目，在安裝資料庫的時候，確保資料庫在沒有幹預的情況下規則的備份。 只有E中的DBCA工具合適了。 而且DBCA 還真有這個功能(玩了幾年Oracle，都沒有留意到，杯具中...)

7. The application development team has developed PL/SQL procedures and functions for different purposes and calls them as and when required. The loading of individual procedures or functions into memory degrades performance with every call. Also, it causes a security problem for individual subprograms and loss of program units when the whole system is transported into a new location. Which method would you recommend to the application developers to solve this problem?

A. Avoiding the use of cursors in the subprograms.

B. Using anonymous（匿名） PL/SQL blocks instead of subprograms.

C. Referring to views instead of tables inside the subprograms.

D. creating PL/SQL packages to include interrelated(相關關聯) subprograms.

答案：D.

 

8. View the Exhibit.

Your Oracle 10g database has 6 tablespaces in which:

-TEMP is the default temporary tablespace

- UNDOTBS1 is the default undo tablespace

- USERS is the default permanent tablespace

In this database, which three tablespaces can be made offline? (Choose three.)

 

A) TEMP

B) PROD

C) USERS

D) SYSAUX

E) SYSTEM

F) UNDOTBS1

答案: BCD。

可以參考線上文檔中 Overview of Tablespaces 小節的內容。

http://download.oracle.com/docs/cd/B28359_01/server.111/b28318/physical.htm#CNCPT1089

9.  The junior DBA in your organization has accidentally deleted the alert log file. What will you do to create new alert log file?

A. Create the new text file as alert.log

B. You have to recover the alert log file from the valid backup.

C. Change the value for the BACKGROUND_DUMP_DEST parameter.

D. No action required. The file would be created automatically by the instance.

答案： D.

 

10. While planning to manage more than one database in your system,you perform the following activities:

（1） organize different categories of files into independent subdirectories.

（2） Use consistent naming convention for database files.

（3） Separate administrative information pertaining to each database.

Which option corresponds(一致) to the type of activities performed by you?

A. Oracle Managed Files.

B. Oracle Grid Architecture.

C. Optimal Flexible architecture.

D. Oracle database architecture.

答案：C

Optimal Flexible Architecture

http://download.oracle.com/docs/cd/B28359_01/install.111/b32002/app_ofa.htm#i633068

1 2 3 下一頁