copy and paste for reference

ocp - backup and recovery

Questions Report

The EXPORT utility can back up the

database at which three levels?

A. Database, user, and segment

B. User, table, and segment

C. Database, user, and table

D. Database, table, and column

You answered:
The correct answer is: C




Which of the following problems

would cause you to recover a

database?

A. When the data has become

corrupt or damaged

B. When an Index segment becomes

corrupt

C. When a rollback segment becomes

corrupt

D. When a backup fails

You answered:
The correct answer is: A




To recreate a sequence by using

the Import utility...

A. the sequence must be dropped.

B. the sequence must be altered.

C. the sequence must be granted to

system.

D. the Import utility cannot

restore sequences.

You answered:
The correct answer is: A




Which Import keyword will allow

only the structure to be built and

not load the data?

A. FULL=n

B. DATA=n

C. Rows=n

D. It cannot be done.

You answered:
The correct answer is: C




You have renamed and moved a

datafile to a different physical

location. Which file needs to be
manually updated?


A. init.ora

B. alert.log

C. trace file

D. none of the above

You answered:
The correct answer is: D




What utility can be used to verify

the integrity of database files?

A. Export utility

B. Import utility

C. DBVERIFY

D. INTEGRITY

You answered:
The correct answer is: C




What are the three database

options that can be used to start

a database?

A. Nomount, mount, and open

B. Normal, mount, and open

C. Nomount, mount, and normal

D. Open, recover mode, and normal

You answered:
The correct answer is: A




What background process will

synchronize the database files and

control files SCN?

A. DBWR

B. PMON

C. RECO

D. SMON

You answered:
The correct answer is: D




In the event of a problem, in

which file would you look for

clues?

A. alert log

B. trace file

C. init.ora file

D. control file

You answered:
The correct answer is: A




Which command can be used to

obtain an editable script to

create a new control file?

A. ALTER DATABASE BACKUP

CONTROLFILE TO TRACE

B. ALTER SYSTEM BACKUP CONTROLFILE

TO TRACE

C. ALTER SYSTEM BACKUP CONTROLFILE

TO TRACE

D. DUMP CONTROLFILE

You answered:
The correct answer is: A




What one tablespace cannot be

taken offline?

A. The temporary tablespace

B. The system tablespace

C. The tablespace used by rollback

segments

D. The tablespace used by the

control files

You answered:
The correct answer is: B




You want to restore individual

datafiles or tablespaces. How

would you start the database?

A. STARTUP MOUNT

B. STARTUP NOMOUNT

C. STARTUP RESTRICT

D. STARTUP FORCE

You answered:
The correct answer is: A




To increase the speed of the

EXPORT, what parameter should be

increased?

A. Buffer

B. Feedback

C. Optimize

D. Commit

You answered:
The correct answer is: A




Which file contains the sequence

number of the current redo log?

A. Alert log

B. Control file

C. Initialization file

D. Configuration file

You answered:
The correct answer is: B




You are running a database that

can tolerate loss of data between

backups. In which mode can the
database be run?


A. ARCHIVELOG

B. NOARCHIVELOG

C. READ-ONLY

D. MOUNTED

You answered:
The correct answer is: B




Where are the options for running

a database in archivelog mode kept

in the database?

A. The control file

B. The system tablespace

C. The INIT.ORA file

D. The redo log files

You answered:
The correct answer is: C




A physical backup is best

described by the following:

A. Backing up all external

structures of an Oracle database

B. Backing up all datafiles

C. Use the EXPORT utility to

backup the database

D. Shutting down the database and

backing up all the external files

You answered:
The correct answer is: A




A database that is logically

corrupt will need to be:

A. Restored, as if it were

physically corrupt

B. A database cannot become

logically corrupt

C. Restored by using the Import

utility

D. Recovered manually

You answered:
The correct answer is: A




The instance has suddenly shut

down. Looking at the alert log,

you see that the SMON
background process has failed.

What can be done to bring the

database online?

A. Reboot the operating system

B. Restart the instance

C. Recreate the database

D. Recreate the control file

You answered:
The correct answer is: B




An inconsistent backup is:

A. An offline backup

B. An online backup

C. A backup created by the EXPORT

utility

D. There is no such thing.

You answered:
The correct answer is: B




A checkpoint will do the

following:

A. Write data buffers to disk;

update the control file and data

file headers with new SCN

information

B. Write data buffers to disk only

C. Update the controlfile and

write data buffers to disk

D. Update the controlfile and file

headers with new SCN information

You answered:
The correct answer is: A




In order for recovery to be

successful, which files must be in

sync?

A. datafiles

B. control files

C. alert log

D. redo log files

E. archive log files

You answered:
The correct answer is: ABD




Your database could go all day

without a checkpoint occuring due

to the configuration of the
database. As a DBA, what is the

best way to force a checkpoint?

A. Alter a small tablespace

offline and online throughout the

day

B. Create smaller redo logs

C. Shut down the database at noon

every day

D. Modify the checkpoint INIT.ORA

parameters to force a checkpoint

(LOG_CHECKPOINT_TIMEOUT,
LOG_CHECKPOINT_INTERVAL)

You answered:
The correct answer is: D




Which of the following can be set

in the init.ora file to detect

corruption in redo log files

before they
are archived?

A. LOG_ARCHIVE_FORMAT

B. LOG_CHECKSUM

C. LOG_BLOCK_CHECKSUM

D. DETECT_REDO_CORRUPTION

You answered:
The correct answer is: C




What are the three shutdown

options?

A. Normal, immediate, and abort

B. Normal, nomount, and abort

C. Abort, immediate, close

D. There are only two options:

abort and normal.

You answered:
The correct answer is: A




What database command is used to

place the database in archivedlog

mode?

A. Alter database

B. Alter system

C. Alter instance

D. No command is specified.

You answered:
The correct answer is: A




What can cause an Import from

completing successfully?

A. Temporary segments that are too

small

B. Rollback segments that are too

small

C. Redo logs that are too small

D. Control files that are too

small

You answered:
The correct answer is: AB




You are running a database in the

ARCHIVELOG mode and a hard disk

containing datafiles is lost.
What can be done to recover the

database to a point in time before

the failure?

A. Restart the instance

B. Restore from a cold backup and

apply the archived redo log files

C. Recreate the database

D. Reboot the operating system

You answered:
The correct answer is: B




To recover a tablespace, it must

first be taken offline. What

command will do this?

A. Alter database

B. Alter system

C. Alter tablespace

D. Alter datafile

You answered:
The correct answer is: C




Which file contains the sequence

number of the earliest redo log

file to apply for recovering a
database that is in the ARCHIVELOG

mode?

A. control file

B. alert log

C. initialization file

D. database file header

You answered:
The correct answer is: D




When should a DBA use the recover

datafile command?

A. When a tablespace with multiple

datafiles does not lose all of the

datafiles

B. When the system tablespace

loses a datafile

C. When a tablespace that only has

one datafile loses the datafile

D. When the temporary segment

tablespace loses a datafile

You answered:
The correct answer is: A




What option will optimize the

EXPORT utility for speed?

A. Direct

B. Commit

C. Optimize

D. Feedback

You answered:
The correct answer is: A




To execute the Oracle EXPORT

utility, the DATABASE must be in

what state?

A. Closed

B. Open

C. Nomount

D. Mount

You answered:
The correct answer is: B




Which of the following commands

can be issued to find out if the

database is running in the
ARCHIVELOG mode?

A. SELECT * FROMV$LOGFILE;

B. SELECT * FROM V$DATABASE;

C. SELECT * FROM V$DATAFILE;

D. SELECT * FROM V$RECOVER_FILES;

You answered:
The correct answer is: B




A database is comprised of many

tablespaces. Which one cannot be

taken offline?

A. Rollback segment tablespace

B. Temporary tablespace

C. System tablespace

D. All tablespaces can be taken

offline

You answered:
The correct answer is: C




A logical backup can be

accomplished by the following

utility:

A. SQL*LOADER

B. EXPORT

C. IMPORT

D. Operating system backup

You answered:
The correct answer is: B




The STARTUP NOMOUNT option will do

the following:

A. Read the INIT.ora file to

configure the instance

B. Read the INIT.ora file to

configure the instance and start

the background processes

C. Read the controlfile and

INIT.ora file to configure the

instance

D. Open the datafiles and read the

init.ora file

You answered:
The correct answer is: B




What happens to archiving when an

invalid checksum is detected on a

redo log group member?

A. The database hangs.

B. The database crashes.

C. The redo log group is still

archived.

D. An attempt is made to archive

another redo log member.

You answered:
The correct answer is: D




What option controls how big an

array is used by Import?

A. COMMIT

B. BUFFER

C. ARRAY

D. ARRAY_SIZE

You answered:
The correct answer is: AB




A complete recovery of a database

means that no data was lost. To

accomplish this, the DBA must
do the following:

A. Run the database in ARCHIVEDLOG

mode

B. Back up the database regularly

C. Test the recovery of the

database from the backup files

D. All of the above

You answered:
The correct answer is: D




If a database administrator is

running a database in NOARCHIVELOG

mode, what type of recovery
will they have to perform?

A. Incomplete

B. Complete or incomplete

C. Database only

D. Database, tablespace, or

datafile

You answered:
The correct answer is: A




To speed instance recovery of your

database if it crashes, what

action should you take?

A. Have small rollback segments

B. Have small controlfiles

C. Have a small SGA

D. Make sure a checkpoint occurs

fairly regularly on your database

You answered:
The correct answer is: D




When would you want to force a

checkpoint in a database?

A. When redo logs are large

B. When rollback segments are

large

C. When temporary segments are

large

D. You never want to force a

checkpoint.

You answered:
The correct answer is: A




An online database backup can be

accomplished only if the following

is true:

A. If the operating system will

allow it.

B. The database has multiple

controlfiles.

C. The database must be in

noarchivedlog mode.

D. The database must be in

archivedlog mode.

You answered:
The correct answer is: D




Which of the following is the file

created by the EXPORT utility?

A. text file

B. binary file

C. data file

D. system data file

You answered:
The correct answer is: B




Incomplete recovery occurs when a

database is restored and ..?

A. data is lost

B. whenever a database is run in

NOARCHIVEDLOG mode

C. whenever a checkpoint does not

occur

D. A and B

You answered:
The correct answer is: D




A user has truncated the

"inventory" table. What type of

failure has occurred?

A. Instance failure

B. Media failure

C. User error

D. System failure

You answered:
The correct answer is: C




A statement failure will cause the

DBA to do the following:

A. Monitor the PMON process

B. Restore from the last backup

C. Shut down the database with the

abort option

D. Nothing is required

You answered:
The correct answer is: D




Which of the following commands

would you use to rename a

datafile?

ALTER DATABASE RENAME

FILE

What mode should the database be

in when you do this?

A. NOMOUNT

B. MOUNT

C. OPEN

D. RESTRICT

You answered:
The correct answer is: B




When an instance fails, what must

a DBA do to recover the instance?

A. Issue the STARTUP command; SMON

will perform all needed recovery

actions.

B. Issue the STARTUP command, and

then issue the RECOVER command.

C. Issue the ROLLBACK command.

D. Restore all the datafiles, and

then issue the STARTUP command.

You answered:
The correct answer is: A




An alter tablespace command will

cause what type of checkpoint to

occur?

A. Normal

B. Global

C. Local

D. File

You answered:
The correct answer is: D




A consistent backup is:

A. An offline backup

B. An online backup

C. A backup created by the export

utility

D. There is no such thing.

You answered:
The correct answer is: A




The Destroy option will do the

following:

A. Initialize the tablespace and

recreate all objects

B. Initialize all of the

tablespaces

C. This is not a valid option.

D. Can only be used by the sys

user

You answered:
The correct answer is: A




When a tablespace is taken

offline, what are the three

options?

A. normal, temporary, immediate

B. disable, temporary, immediate

C. normal, temporary, including

contents

D. normal, abort, immediate

You answered:
The correct answer is: A




A database that is running in

ARCHIVEDLOG mode has the option of

being recovered with the
following options:

A. Database, tablespace, or file

level

B. Complete or incomplete

C. Complete only

D. A and B

You answered:
The correct answer is: D




A DBA has a database running in

NOARCHIVEDLOG mode. What types of

backups must they
perform on the database?

A. Online backups

B. They have a choice: online or

offline backups.

C. Offline backups only

D. They can use only the EXPORT

utility to back up the database.

You answered:
The correct answer is: C




The system administrator was

moving the files around in the

database and accidentally deleted

some
user datafiles. What kind of

failure has occurred?

A. Instance failure

B. Media failure

C. Statement failure

D. Administrator failure

You answered:
The correct answer is: B




If a user process fails, what

action must a DBA do?

A. Issue a rollback command.

B. Shut down the database.

C. Nothing. The PMON background

process will rollback the

transaction.

D. Issue the recover database

command.

You answered:
The correct answer is: C




What are the three types of

checkpoints?

A. Local, normal, and file

B. Local, global, and file

C. Normal, global, and local

D. File, normal, and global

You answered:
The correct answer is: A




When performing an online backup,

which of the following commands

are used?

A. Alter tablespace begin backup

B. Alter tablespace end backup

C. Alter database begin backup

D. Alter database end backup

You answered:
The correct answer is: AB



ALL PREVIOUS QUESTIONS & STS AVAILABLE FOR MINUMUM COST - CONTACT [email protected]




Performance and tuning

Questions Report

Which of the following statements about Dedicated Server configuration are true?

A. It is more efficient than multi-threaded server configuration.

B. It is not recommended for DBAs to user Dedicated Server process to attach to Oracle.

C. There is a one-to-one relationship between the number of server processes and user processes.

D. When Oracle is installed, it is the default configuration.

You answered:
The correct answer is: CD




You have just added a new datafile to the database. What is the next step that is recommended?

A. Back up the parameter file

B. Back up the control file

C. Back up the archive logs

D. Back up the datafile

You answered:
The correct answer is: B




You have two columns in the table MEMBERS:
FIRST_NAME CHAR(10)
LAST_NAME CHAR(10)
Which of the results is the following query most likely to bring?
SELECT FIRST_NAME || '*' || LAST_NAME || '*' FROM MEMBERS;

A. HASAN*MIR*

B. HASAN *MIR*

C. HASAN *MIR *

D. HASAN*MIR *

You answered:
The correct answer is: C

The CHAR data type will maintain placeholders for the unused character spaces. Therefore, you'll
see each of the first and last names taking 10 character spaces despite the shorter name.



You have run UTLBSTAT and UTLESTAT. What is the default name of the file that is created?

A. alert.log

B. init.ora

C. tune.log

D. report.txt

You answered:
The correct answer is: D




Which of the following tables will give information about total number of requests?

A. V$TRANSACTION

B. V$QUEUE

C. V$RESOURCE

D. V$SYSSTAT

E. V$SESSION

You answered:
The correct answer is: D




Sort segments in the temporary tablespace can be monitored using which of the following views?

A. V$SYSSTAT

B. V$SQLAREA

C. V$TEMP

D. V$SORT_SEGMENT

You answered:
The correct answer is: D




What can occur if the database buffer cache is not adequately sized?

A. Errors are generated by the application.

B. The application will hang the system.

C. Applications will run, but very slowly.

D. Database will get corrupted.

You answered:
The correct answer is: C




You have a 2-CPU machine. What value should the LOG_SIMULTANEOUS_COPIES parameter be
set to in the init.ora?

A. 1

B. 2

C. 4

D. 8

You answered:
The correct answer is: C

The maximum value of this parameter is twice the number of CPUs (4). The default value is the
number of CPUs. It is always recommended to maximize this parameter to reduce contention to redo
log buffers.



What is a benefit of placing static data on read-only tablespace?

A. Performance is better when reading read-only data.

B. Data load is faster for read-only data.

C. After the initial backup, you do not need to back up the read-only tablespace.

D. The read-only tablespace can be stored offline.

You answered:
The correct answer is: C




What is the function of a listener process?

A. To pick up the request from the request queue as soon as it arrives

B. To transfer the message of user process to its corresponding server process

C. To give the user process the address of its dispatcher process

D. To send the information back to the user process from the response queue

You answered:
The correct answer is: C




Which of the following statements will generate the least amount of rollback information?

A. SELECT

B. INSERT

C. UPDATE

D. DELETE

You answered:
The correct answer is: B




Which view can be used to determine the total number of event waits?

A. V$SYSTEM_EVENT

B. V$SYSTEM_WAIT

C. V$SESSION_EVENT

D. V$SESSION_WAIT

You answered:
The correct answer is: A




Which of the following initialization parametes specifies the minimum number of shared server
processes in multi-threaded configuration?

A. MTS_DIPATCHER

B. MTS_SERVERS

C. MTS_MAX_DIPATCHERS

D. MTS_MAX_SERVERS

E. MTS_MIN_SERVERS

You answered:
The correct answer is: B




Which Oracle8 facility can be used to identify SQL areas with performance problems?

A. EXPLAIN PLAN

B. BSTAT/ESTAT report

C. TKPROF

D. SQL Trace

You answered:
The correct answer is: D




Which of the following SQL statements would require a SORT operation?

A. Select * from dept;

B. Select dept_id, dept_name from dept order by dept_id;

C. Select dept_id, dept_name from dept where dept_name = "MANUFACTURING";

D. Select dept_id, dept_name from dept where dept_id between 10 and 20;

E. Select dept_id, dept_name from dept where dept_id = 10;

You answered:
The correct answer is: B




When should the CACHE hint be used in a query?

A. when creating large tables

B. when running very large queries

C. when you have small lookup tables that are accessed by many users

D. when indexes are not being used

You answered:
The correct answer is: C




For which of the following objectives are you most likely to use the ANALYZE command?

A. Check the structural integrity of tables

B. Show the existence of chained rows

C. Store table's statistics in data dictionary

D. All of the above

You answered:
The correct answer is: D




Which of the following best describes the characteristics of Oracle Distributed system?

A. Distributed Lock Manager, Location Transparency, Replication

B. Distributed Lock Manager, Interconnect, Transaction Recovery Management

C. Parallel Query Execution, Parallel Recovery, Parallel Loading

D. Replication, Transaction Recovery Management, Location Transparency

You answered:
The correct answer is: D




Which of the following statements is true about the Oracle Parallel Server?

A. It allows better performance for Oracle Parallel Query option.

B. One major disadvantage is that if one node fails, all the nodes stop working.

C. Each node has its own redo log files and database files.

D. Each node has its separate Oracle database.

You answered:
The correct answer is: A




You notice that the system performance has degraded and there is excessive paging and swapping.
What could be a cause?

A. SGA too large

B. SGA too small

C. PGA too large

D. PGA too small

You answered:
The correct answer is: A

The SGA is too large to fit in the available part of the physical memory, and a large portion of the SGA
is located in virtual memory on disk.



Under normal processing, the PCTINCREASE for the TEMPORARY tablespace should be set to what
value?

A. 0

B. 10

C. 50

D. 100

You answered:
The correct answer is: A




Which column is the most important when analyzing latch statistics from the report.txt file?

A. GETS

B. MISSES

C. HIT_RATIO

D. PERCENTAGE

You answered:
The correct answer is: C




Which view can be checked to see the amount of shareable memory used by a cached PL/SQL
object?

A. V$DB_OBJECT_CACHE

B. V$LIBRARYCACHE

C. V$SHARED_SQL_AREA

D. V$SHARED_POOL

You answered:
The correct answer is: A




Which of the following is equal to total number of requests for data?

A. sum of execute count and consistent gets

B. sum of consistent gets and db block gets

C. sum of db block changes and db block gets

D. sum of consistent gets and db block changes

You answered:
The correct answer is: B




Your system contains Oracle and non-Oracle files. What tool can be used to monitor physical I/O?

A. UTLBSTAT/UTLESTAT

B. TKPROF

C. ANALYZE command

D. Operating System monitoring tools

You answered:
The correct answer is: D




Which of the following parameters specifies the number of lock processes in an instance in Oracle
Parallel Server?

A. GC_LCK_PROCS

B. GC_DB_LOCKS

C. GC_FILES_TO_LOCKS

D. GC_ROLLBACK_LOCKS

You answered:
The correct answer is: A




Which parameter can be set to control sort writes to the database buffer cache?

A. SORT_DIRECT_WRITES

B. SORT_AREA_SIZE

C. SORT_AREA_RETAINED_SIZE

D. SORT_WRITE_BUFFERS

You answered:
The correct answer is: A




Which type of application is least likely to take the most advantage of Oracle Parallel Server?

A. Each set of users are accessing separate sets of tables in the database.

B. There is very little data update activity.

C. Very large applications that have small cache hit ratio.

D. Every user is manipulating almost all the tables.

You answered:
The correct answer is: D




For which of the following objectives are you most likely to use EXPLAIN PLAN command?

A. To check the structural integrity of the objects

B. To see the errors in SQL

C. To look at the the data access path Oracle has chosen

D. To tell Oracle which data access path you want to use

You answered:
The correct answer is: C




I/O contention for redo log files is indicated in which view?

A. V$SYSTEM_EVENT

B. V$LOG

C. V$DATABASE

D. V$ARCHIVE_LOGS

You answered:
The correct answer is: A




What should be done if the redo allocation latch shows a MISSES to GETS ratio of 3%?

A. Increase the number of redo copy latches

B. Decrease the number of redo copy latches

C. Increase the number of redo allocation latches

D. Decrease the number of redo allocation latches

You answered:
The correct answer is: A




What does the following message in the alert log indicate: "Checkpoint not complete. Unable to
allocate file" ?

A. LGWR has waited for a checkpoint to complete.

B. DBWR has waited for a checkpoint to complete.

C. LGWR has waited for the RECO process to complete.

D. RECO has waited for the LGWR to complete.

You answered:
The correct answer is: A




Which of the following parameters specifies the minimum number of Query Servers in Oracle Parallel
Query Option?

A. PARALLEL_SERVERS

B. PARALLEL_MIN_SERVERS

C. MTS_SERVERS

D. MTS_MIN_SERVERS

You answered:
The correct answer is: B




Which of the following statement(s) are most likely to take advantage of Oracle Parallel Query
Option?

A. CREATE TABLE STUDENTS (ID NUMBER, NAME VARCHAR2);

B. INSERT INTO STUDENTS VALUES (1, 'HASAN');

C. CREATE TABLE STUDENTS AS SELECT * FROM TEMP_STUDENTS;

D. SELECT * FROM STUDENTS;

You answered:
The correct answer is: CD




What is degree of parallelism?

A. Number of query servers running in the memory

B. Number of disks Oracle has to read in order to bring the requested information

C. Number of tables Oracle has to read in order to bring the requested information

D. Number of query servers that are given a single task to perform in pieces

You answered:
The correct answer is: D




Which of the following can cause heavy I/O to rollback segments?

A. DDL statements

B. DML statements

C. All SQL statements

D. Only PL/SQL statements

You answered:
The correct answer is: B




Which statistic indicates proper sizing of the buffer cache?

A. latch contention

B. cache hit ratio

C. buffer busy waits

D. lru contention

You answered:
The correct answer is: B




Which of the following tables will benefit most with high value of PCTFREE?

A. Table that has high delete activity

B. Table that has high insert activity

C. Table that has high update activity

D. Table on which many queries are performed

You answered:
The correct answer is: C




Which of the following statements is true for multi-threaded configuration?

A. It results in a more efficient usage of resources than dedicated server processes.

B. DBAs uses it to start and shut down the instance.

C. A very limited number of users can connect to Oracle.

D. There are as many request queues and response queues as number of users.

You answered:
The correct answer is: A




You have run utlbstat.sql and the database is shut down and restarted. In order to obtain a
meaningful report, what has to be done now?

A. rerun utlbstat.sql

B. run utlestat.sql

C. run utlbstat.sql and utlesat.sql again

D. run utlestat.sql and then run utlbstat.sql

You answered:
The correct answer is: C




Which of the following data dictionary views can be used to obtain details of a specific user
transaction?

A. V$TRANSACTION

B. V$ROLLSTAT

C. V$RECOVER_FILE

D. V$SESSION

You answered:
The correct answer is: AD




What should be the goal for the GETHITRATIO column of the V$LIBRARYCACHE view?

A. less than 0.9

B. greater than 0.9

C. less than 0.1

D. greater than 0.1

You answered:
The correct answer is: B




Queries to the payroll database are very slow. What is the first thing that should be checked for
problems?

A. SQL Statements

B. Database design

C. Memory

D. Network

You answered:
The correct answer is: A




Which table can be created to evaluate the SQL statement being run using EXPLAIN
without tracing?

A. PLAN_TABLE

B. EXCEPTIONS

C. TABS

D. SQL_TABLE

You answered:
The correct answer is: A




Which of the following should be used to determine the number of rollback segments?



A. number of concurrent users

B. number of concurrent DML transactions

C. number of data files

D. number of redo log groups

You answered:
The correct answer is: B




You get the following error: ORA-01555: snapshot too old
What can be done to correct this?

A. Reissue the statement that caused the error.

B. Use a larger rollback segment.

C. Add more rollback segments.

D. Recover the database.

You answered:
The correct answer is: C




The result of utlbstat/utlestat shows the following latch hit_ratios:

LATCH1 1
LATCH2 0.09
LATCH3 0
LATCH4 0.99

How many latches show contention?

A. 0

B. 1

C. 2

D. 3

E. 4

You answered:
The correct answer is: C




What can application developers do to minimize library cache tuning efforts?

A. Use constants as much as possible

B. Use SQL statements as much as possible

C. Use PL/SQL packages as much as possible

D. Perform frequent checkpoints

You answered:
The correct answer is: C




Which of the following initialization parameters specifies the maximum number of shared server
processes in multi-threaded configuration?

A. MTS_DIPATCHER

B. MTS_SERVERS

C. MTS_MAX_DIPATCHERS

D. MTS_MAX_SERVERS

E. MTS_MAX_SHARED_SERVERS

You answered:
The correct answer is: D




What can be done to ensure sorting in-memory?

A. Increase SORT_AREA_SIZE

B. Decrease SORT_AREA_SIZE

C. Increase SORT_AREA_RETAINED_SIZE

D. Decrease SORT_AREA_RETAINED_SIZE

You answered:
The correct answer is: A




What can be done to prevent wastage of rollback segments?

A. Perform your work in batches.

B. Log out when no interaction is needed.

C. Commit your work regularly.

D. Do not use adhoc queries.

You answered:
The correct answer is: C




The report.txt generated from running UTLBSTAT/UTLESTAT shows that the GETHITRATIO for
cursors is 96%. What needs to be done?

A. Increase the SHARED_POOL

B. Decrease the SHARED_POOL

C. Increase the BUFFER_CACHE

D. Decrease the BUFFER_CACHE

E. Nothing

You answered:
The correct answer is: E




Which of the following objects are populated when the instance is started?

A. Data dictionary views

B. Dynamic tables

C. Rollback segments

D. Application tables

You answered:
The correct answer is: AB




What is used when a process writes changes to the redo log buffer?

A. Redo allocation lock

B. Redo allocation latch

C. Redo log lock

D. Redo log latch

You answered:
The correct answer is: B




What is the correct order in which Oracle looks for degree of parallelism?

A. Hint, PARALLEL clause of CREATE TABLE statement, initialization parameter

B. PARALLEL clause of CREATE TABLE statement, initialization parameter, Hint

C. Initialization parameter, Hint, PARALLEL Clause of CREATE TABLE statement

D. Hint, Initialization parameter, PARALLEL Clause of CREATE TABLE statement

You answered:
The correct answer is: A




Which script create the DBMS_APPLCIATION_INFO package?

A. catalog.sql

B. catproc.sql

C. dbmsapps.sql

D. dbmsutil.sql

You answered:
The correct answer is: D




What information can be queried using the V$CACHE view?

A. objects that are too large to be cached

B. objects that are currently being cached

C. objects that are too small to be cached

D. data blocks currently in use

You answered:
The correct answer is: B




Application tuning has been performed and you are still having performance problems. What should
you tune next?

A. Database design

B. Memory

C. Operating system

D. Application tuning should have taken care of all the performance problems

You answered:
The correct answer is: B




The database buffer cache can be increased by using the following parameter?

A. DB_BLOCK_SIZE

B. DB_BLOCK_BUFFERS

C. DB_FILES

D. DB_FILE_MULTIBLOCK_READ_COUNT

You answered:
The correct answer is: B




Which of the following tables gives you the information about freelist contention?

A. V$QEUE

B. V$ROLLNAME

C. V$LATCH

D. V$SYSSTAT

E. V$WAITSTAT

You answered:
The correct answer is: D




ALL PREVIOUS QUESTIONS & STS AVAILABLE FOR MINUMUM COST - CONTACT [email protected]