Oracle 10g OCP 042 Question Bank 1-30 questions 168 questions

Statement: the answer is a personal understanding of Oracle.

1. Because of a power outage, instance failure has occurred. From what point in the redo log does recovery in 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. Data before Checkpoint has been written to the data file. Therefore, you can use restore to restore the data. The data after the checkpoint is not written to the data file, so a recovery is required. During Recovery, data that has been committed is written to the data file by rolling forward. Data without commit is rolled back.

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;

Answer: AB.

Summary of Oracle Flashback Technology

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 wocould open normally.

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

C. The database wocould open alter automatically refreshing instance recovery.

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

Answer: C.

If the instance is shut down abnormally (shutdown abort), and data files, control files, online logs are not lost. At the next startup, you need to use the online log Content for Recovery, which is Instance Recovery ).

Instance Recovery mainly includes three phases:

1) Perform a rolover Based on the online log Content.

2) Open the database and provide services

3) perform Rollback for SMON or user processes.

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 control file.

Answer: B

Online Documentation:

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.

Answer: C

You can view the content of the $ ORACLE_BASE/oraInventory/orainstRoot. sh script. The script actually completes the following tasks:

(1) Create the software inventory location pointer file:/etc/oraInst. loc. The content is

Inventory_loc = $ ORACLE_BASE/oraInventory

Inst_group = oinstall

Modify attributes of this file: chmod 644/etc/oraInst. loc

(2) Create inventory directory: $ ORACLE_BASE/oraInventory

Modify file attributes: chmod-R 770 $ ORACLE_BASE/oraInventory

Chgrp oinstall $ ORACLE_BASE/oraInventory

The oraInventory directory stores information about all software components installed in oracle. Each component may occupy KB of space.

 

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 (intervention ). what shoshould 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.

Answer: E.

When I first saw this answer, I thought there was a problem with the answer. Google. When installing the database, make sure that the database is backed up without any intervention. Only the DBCA tool in E is suitable. In addition, DBCA really has this function (I haven't noticed it after several years of using Oracle, but it is in the cup ...)

7. the application development team has developed PL/SQL procedures and functions for different purposes and callthem 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 Wocould you recommend to the application developers to solve this problem?

A. Avoiding the use of cursors in the subprograms.

B. Using anonymous (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 (correlation) subprograms.

Answer: 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

Answer: BCD.

See Overview of Tablespaces in the online document.

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 wocould be created automatically by the instance.

Answer: 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 (Consistent) to the type of activities stored med by you?

A. Oracle Managed Files.

B. Oracle Grid Architecture.

C. Optimal Flexible architecture.

D. Oracle database architecture.

Answer: C

Optimal Flexible Architecture

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

1 2 3 Next Page