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]
