Sure, please send dumps and papers to [email protected]
Thanks for offering.
Printable View
Sure, please send dumps and papers to [email protected]
Thanks for offering.
please chckout next week, i will try to add more
The set role command can be used for a role that has been granted to a user, but cannot
what?
A. Be granted to other users
B. Contain system privileges
C. Be part of the user default roles
D. Have roles granted to other roles
You answered:
The correct answer is: C
What DCL statement can be used to change a user password or authentication method, assign
tablespace quotas, set default and temporary tablespaces?
A. Alter user
B. Update user
C. Create user
D. Drop user
You answered:
The correct answer is: A
Which memory structure is also referred to as the library cache?
A. Database buffer cache
B. Redo log buffer
C. Data dictionary cache
D. Shared SQL area
You answered:
The correct answer is: D
The shared pool contains execution plans for recent SQL statements (library cache), the data
dictionary cache, and other session information.
What is a database entity that can be granted privileges and then be granted to users?
A. User
B. System privilege
C. Role
D. Security setting
You answered:
The correct answer is: C
To create a cluster in another user's schema, you must have which system privilege?
A. ALTER SYSTEM
B. CREATE CLUSTER
C. CREATE ANY CLUSTER
D. ALTER CLUSTER
You answered:
The correct answer is: C
You can create a CLUSTER in another's schema if you have CREATE ANY CLUSTER.
Which background process is used to recover from failure of distributed transactions?
A. PMON
B. SMON
C. LGWR
D. RECO
You answered:
The correct answer is: D
The RECO background process is responsible for recovering in-doubt transactions in a distributed
database environment. The initialization parameter DISTRIBUTED_TRANSACTIONS should be set
to a value greater than zero in order for this process to start.
The SQL*LOADER Insert option will do the following:
A. Add data to a table
B. Will fail if data currently exists in the table
C. Put an exclusive lock on the table
D. Remove data and then insert data
You answered:
The correct answer is: AB
The command to specify a rollback segment for a transaction is:
A. ALTER SESSION
B. SET TRANSACTION
C. ALTER USER
D. SET SESSION
You answered:
The correct answer is: B
The SET TRANSACTION USE ROLLBACK SEGMENT command specifies the rollback segment for
a transaction. This command must be issued after a commit or rollback statement.
By default, how many bad records are allowed before SQL*LOADER will stop the running?
A. 1000
B. 10
C. 100
D. 50
You answered:
The correct answer is: D
What is the default shutdown mode?
A. normal
B. immediate
C. abort
D. crash
You answered:
The correct answer is: A
A rollback segment will always have PCTINCREASE of:
A. 0
B. 50
C. 100
D. Depends on the transaction
You answered:
The correct answer is: A
Rollbacks grow in uniform extents and do not expand as they extend and shrink.
The parameter name in the database parameter file that instructs the database to place certain
rollback segments online at start up is named:
A. Rollsegs
B. Start_rollbacks
C. Rollback_segments
D. Can't be done at database startup
You answered:
The correct answer is: C
By naming the rollback segments after the rollback_segment pfile parameter, you will automatically
bring these rollback segments online at database startup.
What command would you use to alter the storage parameters of an index?
A. MODIFY INDEX
B. ALTER TABLE
C. ALTER INDEX
D. ALTER TABLESPACE
You answered:
The correct answer is: C
An index's storage parameters can be modified by altering the index. Some storage parameters
cannot be changed once the index is created like INITIAL and MINEXTENTS.
Which of the following background processes are used to reclaim space used during sorting of data
using temporary segments?
A. PMON
B. SMON
C. LGWR
D. CKPT
You answered:
The correct answer is: B
The SMON background process performs operations such as freeing the sort space, and coalescing
the adjacent free extents in one big extent, etc.
Catalog.sql creates the base data dictionary views and must be used by which user id?
A. SYSTEM
B. Every DBA that administers the database
C. Must be run as the internal id
D. SYS
You answered:
The correct answer is: D
What is it that you cannot audit in an Oracle database?
A. Statements issued by DBAs
B. DATA
C. Client side activity on the database
D. Sessions made by DBAs tools
You answered:
The correct answer is: B
DBNAME and block size for a database are defined when...
A. The database is created
B. Can be modifed by using the ALTER database command
C. Can be modified in the INIT.ORA file
D. Can be modified using the ALTER control file command
You answered:
The correct answer is: A
CASCADE CONSTRAINTS can be used with what DCL command?
A. Grant
B. Revoke
C. Create user
D. Drop user
You answered:
The correct answer is: B
The maximum number of check constraints on a table is:
A. 1
B. 2
C. 8
D. 16
E. Unlimited
You answered:
The correct answer is: E
A table can have an unlimited number of check constraints.
If the key word externally is used in the password clause of the create user statement,
the password will be authenticated where?
A. Database
B. By the controlfile
C. By the operating system
D. By the network
You answered:
The correct answer is: C
The high-water mark for a rollback segment is larger than the actual size and optimal setting of the
rollback segment. What might have happened?
A. The rollback ran out of space to grow.
B. The rollback grew past the optimal setting and then shrank back to the optimal setting.
C. The optimal setting ought to be increased.
D. An Oracle error occurred during database startup.
You answered:
The correct answer is: B
A rollback segment extends as needed for transactions. Its size will return to the optimal setting if it
expands past this setting.
Which option of SQL*Loader competes for resources with other Oracle8 processes?
A. Conventional path load
B. Direct path load
C. Parallel load
D. None of the above
You answered:
The correct answer is: A
SQL*Loader runs in one of two modes: conventional path load (default and less efficient) and direct
path load.
What is a name that Oracle uses to determine whether a database session has the privilege to
perform a database activity?
A. User Session
B. Profile
C. Privilege
D. Role
You answered:
The correct answer is: A
Constraints provide data integrity in an Oracle database. Constraints can be:
A. Dropped
B. Enabled
C. Truncated
D. Disabled
You answered:
The correct answer is: ABD
Once a constraint has been created on a table, it can be put into force (enabled), taken out of force
(disabled), or dropped.
What, if any, user id is not audited?
A. System
B. Any user with DBA privileges
C. SYS
D. INTERNAL
You answered:
The correct answer is: CD
Which privileges are broken out into two categories?
A. System and user
B. User and table
C. System and object
D. Object and user
You answered:
The correct answer is: C
The customer table has a foreign key on the state column to the primary key of the state table. If
John inserts a row into the customer table and receives a constraint error against the state table,
this means that:
A. John tried to insert a customer into the state table incorrectly.
B. John tried to insert a customer into the customer table with a state that does not exist in the state table.
C. John needs to delete states from the state table first.
D. John should rollback his insert, wait one minute, then try again.
You answered:
The correct answer is: B
A foreign key on the customer table requires that all values in the state column must exist first on the
state table.
To implement resource limits using profiles, this option of the database must be used.
A. Alter database command
B. Alter the controlfile
C. resource_limit parameter set to true in the inti.ora file
D. Nothing has to be done.
You answered:
The correct answer is: C
Three tables are accessed almost exclusively as joins in a database. The primary reason to place
them in a cluster is:
A. Ease of use
B. Increase performance
C. Reduce disk I/O
D. Throughput
You answered:
The correct answer is: C
A cluster stores table rows that share a common key in a database block. When reading from the
tables, disk I/O is minimized as the data is fetched.
To identify conflicting rows when a constraint has been enabled, you can look in a table named
EXCEPTIONS. To find the conflicting rows in the table where the constraint exists, you would join
with the:
A. Exception id
B. Row id
C. Error id
D. Error number
You answered:
The correct answer is: B
The row id of the constraint offending rows are stored in the row_id column of the exceptions table.
An Oracle instance is made up of the following:
A. External files and memory structures
B. External files, memory structures, and background processes
C. Memory structures and background processes
D. External files and background processes
You answered:
The correct answer is: C
Which prerequisites must be met before you can make a tablespace read-only with the ALTER
TABLESPACE command?
A. The tablespace must be online.
B. The database must be in RESTRICTED MODE.
C. There must not be any active transactions in the entire database.
D. The tablespace must not contain any active rollback segments.
You answered:
The correct answer is: ACD
An online tablespace can be changed to read-only while the database is open. All the rest apply.
SQL*LOADER can do the following:
A. Read data from a flat file and load the data into an Oracle database
B. Allow criteria to be placed on the incoming data
C. Can remove data, as well as insert data
D. Can load only one table
You answered:
The correct answer is: AB
Which shutdown mode is used to wait for the user to disconnect before shutting down?
A. normal
B. immediate
C. abort
D. wait
You answered:
The correct answer is: A
What type of shutdown shuts down the instance, but doesn't close and dismount the database. This
type of shutdown requires that the SMON process perform automatic recovery, when started.
A. Shutdown abort
B. Shutdown force
C. Shutdown immediate
D. Shutdown
You answered:
The correct answer is: A
What shutdown command terminates all user sessions and rolls back all transactions not committed
to the database?
A. Shutdown normal
B. Shutdown immediate
C. Shutdown abort
D. Shutdown force
You answered:
The correct answer is: B
If you want to remove a user from the database and the user has objects on the database, you must
include the following option:
A. TRUNCATE
B. UNRECOVERABLE
C. DELETE
D. CASCADE
You answered:
The correct answer is: D
If a user has objects and you want to remove the user from the database, use the CASCADE option
on the delete command.
The name of the profile must be ...
A. Unique in the database
B. Will have a schema prefix
C. Greater then 10 bytes
D. Less then 20 bytes
You answered:
The correct answer is: A
An index named CUSTOMER_IDX is created with a storage parameters INITIAL of 100K, NEXT of
100K, MINEXTENTS of 2, MAXEXTENTS of 5, and PCTINCREASE of 50. When the index is
created, what will be the size of the index initially?
A. 100K
B. 150K
C. 200K
D. 250K
You answered:
The correct answer is: C
The CUSTOMER_IDX index will have two extents (MINEXTENTS). The first extent will be 100K and
the second extent will be 100K.
The instance is created and the control file is opened at the ____. What startup state is this?
A. Mount
B. Nomount
C. Open
D. This is not a valid startup state.
You answered:
The correct answer is: A
The SQL*LOADER TRUNCATE option will do the following:
A. Will require referential integrity constraints for the table to be disabled
B. Will insert data into the table
C. Will add data only
D. Is not a valid command
You answered:
The correct answer is: AB
A logical unit of work that utilizes SQL statements and has a begin point and endpoint on an Oracle
database. What is it?
A. Background process
B. Transaction
C. Server process
D. Rollback entries
You answered:
The correct answer is: B
Which component of the SGA records all the database changes?
A. Database buffer cache
B. Redo log buffer
C. Shared pool
D. Data dictionary
You answered:
The correct answer is: B
When a buffer is modified by a process, the buffer is considered "dirty'"and is no longer free to be
used. When does it become clean?
A. When the LGWR process writes it to disk
B. When it is written to disk by the DBWR process
C. There is no such thing.
D. When the transaction is complete
You answered:
The correct answer is: B
When managing space in data blocks, you can modify a segments PCTFREE and PCTUSED
parameters. Be sure that:
A. The sum of PCTFREE and PCTUSED does not exceed 100.
B. The PCTFREE is not greater than PCTUSED.
C. The PCTUSED is not greater than PCTFREE.
D. The PCTFREE and PCTUSED have different values.
You answered:
The correct answer is: A
PCTFREE and PCTUSED control available space within a data block for a segment. The sum of the
two cannot be greater than 100 percent.
If the privilege is granted with this option, the grantee can grant the privilege to another user or
role.
A. Admin option
B. Cascade option
C. Supervisor option
D. Grant option
You answered:
The correct answer is: D
An LRU (least recently used) algorithm keeps only the most active data in the buffer pool. The LRU
list contains what?
A. Only buffers that are not being used by a process
B. Free buffers and pinned buffers
C. Free buffers
D. Dirty buffers (modified buffers), free buffers (buffers that have not been modified), and pinned buffers (buffers that
are currently being used by a process)
You answered:
The correct answer is: D
As a table has rows deleted from it, indexes need to be rebuilt. Using the ALTER INDEX REBUILD
command is preferable because of these reasons:
A. The rebuild command takes less temporary space.
B. The rebuild command is faster.
C. The database definition of the index does not have to be regenerated.
D. The rebuild command creates a more efficient index.
You answered:
The correct answer is: BC
The rebuild command uses the existing index to regenerate the new index. Thus, it takes additional
space, but generates an index more quickly from the existing index definition.
User processes and server processes are separate and have a one-to-one relationship. This means
the database is not using ..
A. MTS
B. Is a not a distributive database
C. Is being shutdown
D. Is using dedicated server mode
You answered:
The correct answer is: A
When a profile session limit is exceeded by the user, what happens?
A. A warning message is sent to the user.
B. A warning message is sent to the alert log.
C. The current statement is rolled back and only a commit, rollback, or disconnect are allowed.
D. The transaction is aborted.
You answered:
The correct answer is: C
A bitmap index provides an alternative to standard Oracle b*tree indexes. A column that would be
best suited for a bitmap index is a column on a:
A. Small table with high cardinality
B. Small table with low cardinality
C. Large table with high cardinality
D. Large table with low cardinality
You answered:
The correct answer is: D
A bitmap index yields the best performance on a large table with a column with only a few distinct
values (low cardinality).
Which file is used by SQL*Loader to specify the tables in the database that are loaded?
A. init.ora
B. control file
C. loader file
D. dump file
You answered:
The correct answer is: B
An index named CUSTOMER_IDX is created with a storage parameters INITIAL of 100K, NEXT of
100K, MINEXTENTS of 2, MAXEXTENTS of 5, and PCTINCREASE of 50. What will be the size of
the 4th extent?
A. 100K
B. 150K
C. 228K
D. 342K
You answered:
The correct answer is: C
After the first two extents, each subsequent extent will be 50% larger that the one before. So the
extent sizes will be 100K, 100K, 150K, 225K, and 338K.
Which file contains the physical structure of the database?
A. init.ora
B. alert log
C. trace file
D. control file
You answered:
The correct answer is: D
The security domain settings can be modified by using the following command:
A. Alter user
B. Alter profile
C. Alter role
D. Alter database
You answered:
The correct answer is: A
A role can be activated dynamically by using what command?
A. SET ROLE
B. Alter role
C. Grant role
D. Execute role
You answered:
The correct answer is: A
This command is used to turn auditing off for all auditing options.
A. Audit option drop
B. Audit option delete
C. Noaudit option
D. Truncate audit option
You answered:
The correct answer is: C
What are the two implied characteristics of a primary key?
A. Unique
B. Referential
C. Check
D. Not null
You answered:
The correct answer is: AD
A primary key uniquely identifies a table row and must be unique and have a value.
A user named John has a default tablespace of USER_DATA. The USER_DATA tablespace has a
default MAXEXTENTS of 100. The system tablespace has a MAXEXTENTS of 200. The SYSTEM
user creates a table owned by John named CUSTOMER. If the MAXEXTENTS is not defined in the
create table statement, John's CUSTOMER table will have a MAXEXTENTS value of:
A. Unlimited
B. SYSTEM
C. 100
D. 200
You answered:
The correct answer is: C
The storage parameters of the default tablespace of the table owner are used in the create
statement.
The database administrator privilege user account can have additional authentication added by
using what utility?
A. SVRMGR
B. SQLPLUS
C. ORAPWD
D. SECPLUS
You answered:
The correct answer is: C
Missed 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
Missed 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
Nikki please send some dumps to my id
[email protected]
thanks nikki for sending the dumps
1. What's incompleted recovery (choose 3)?
- Time-based
- cancel-based
- change-based
- tablespace recovery
2. LGWR will hang if the online redo logs were filled faster
than the archiving process.
- True
- False
3. What can be recovered while others are still run? (choose 2)
- data tablespace
- index tablespace
- system tablespace
4. What's completed recovery?
- Time-based
- cancel-based
- change-based
- tablespace recovery
5. When should you backup control file? after you do
- alter tablespace add datafile ...
- alter system archive log all
6. When should you backup control file? after you do
- alter database drop logfile ...
7. When should you backup control file? after you do
- alter database rename file ...
- alter system archive log all
8. What's the disadvantage of NOARCHIVELOG
- lost transactions must be re-entered
9. in which state you can re-create control file
- nomount
- mount
- open
10. You import a full exported file to a database and than
apply all archived log files can do a completed recovery
- true
- fales
11. The characteristics of direct path export (choose 2)
- does not compete recource with other users
- the buffer size has no impact
12. rolling forward will
- apply all entries in redo log file
- apply only commited entries in redo log file
13. alter tablespace ... begin backup
will backup all of the data files in that tablespace
- true
- false
14. What's the characteristics of direct path export
- compete recource with other users
- direct retrive blocks to DB buffer cache
- use a optimized "select * from table" statement
15. The company's data is highly volatile. You should
- backup more often
- backup less often
- no backup needed
16. ARCH process will automatic started when you run
alter database archivelog;
- true
- false
17. when a data file corrupted, you want to minimize the
down time. you run
startup mount;
alter database datafile ... offline;
what should you do next?
- restore the corrupted data file
- alter database open
- recover data file
18. where is the path of all control files stored?
- control file
- init.ora file
- log file
19. after you activate a standby database. what should you do next?
- recover the primary database
- create a new standby database
20. why Oracle recover instance faster?
- uncommited transactions will not be roll back immediately
21. To do a completed recovery, the database must be in which mode
- ARCHIVELOG
- NOARCHIVELOG
22. incompeted recovery must restore
- damaged files
- all data files in the tablespace
- all data files
23. after incompleted recovery, you need open database
- RESETLOGS
- NORESETLOGS
24. change a database to archive log mode must be in
- mount
- nomount
- open
25. what privilege you must have to change database to
archive log mode
- alter system
- alter database
26. which recovery will recover the database to a time in
the past? (choose 3)
- Time-based
- cancel-based
- change-based
- datafile recovery
27. what's the result of
alter database backup controlfile to trace;
- a copy of control file
- generate a editable script file
28. if a backgroud process has an error, where the trace file
will be
- BACKGROUND_DUMP_DEST
- USER_DUMP_DEST
29. import the full exported file and apply all the archive logs
will recover the database to the point of failure
- true
- false
30. when should you perform a change based recovery?
- lost redo log file
- user dropped a wrong table. the time of the event was known
- in a distributed environment
31. What is the true for standby database?
- constant recovery mode
32. a DBA want to export the full database but the user still
logged on. Which option should he/she use
- direct=y
- consistent=y
- ignore=y
33. when you want to do a full offline backup, some processes may
access the data. what should you do?
- shutdown abort
- shutdown immediate
- shutdown deferred
- shutdown mornal
34. when should you backup read-only tablespace?
- once, right after the tablespace become read-only
- every time you do a online backup
35. when a online redo log can be reused?
- after checkpoint, after the log file was archived
- after checkpoint, before the log file was archived
- before checkpoint, after the log file was archived
- before checkpoint, before the log file was archived
36. all of the members in a redo log group has to be archived before
this group can be reused
- true
- false
37. a DBA can run a command to archive a online redo log file
- true
- false
38. which server manager command can show the database archive status
- archive log list
- alter database ...
39. where the current log sequence number stored? (choose 2)
- archived log file
- control file
- system tablespace data file
40. use a full offline backup in NOARCHIVELOG mode can recover
database to
- a time in the past
- the point of failure
41. what is true for COLD backup (choose 3)
- backup all datafiles, redo log files, control files and
parameter file
- database not available to the user while backup
- simple
42. Full export can NOT be used in
- user lost a table
- create a new database and import the data
- recover the database to the last commited transaction
43. which one can recover to the point of failure?
- database was changed from NOARCHIVELOG to ARCHIVELOG, not
shutdown, keep all archived redo logs
- database was changed from NOARCHIVELOG to ARCHIVELOG, shutdown,
do a full backup
1. what command to take a data file offline?
- alter database datafile ... offline *
- alter tablespace datafile ... offline
2. what is the advantage of NOARCHIVELOG
- few errors
-
3. in parameter file. how to set archive log start automatic
- archive_log_start = true
- archive_log_start = 'true'
- log_archive_start = true *
- log_archive_start = 'true'
5. When the control file will be updated?
- alter database rename file ...
6. Administrator do not want to invest any more money in the
physical disk. The database may tolerate some data lose
- change checkpoint more frequently without archiving*
- use archiving
------------
7. Disk crash, all files on that disk are not recoverable
- restore files to different disk and rename data file.
8. in recovery, server (recover processes) exceed max number, which parameter
should you change
- increase parallel_max_servers*
- increase max_parallel_servers
9. user dropped a table, you imported the table from a previous exported file.
anything you can to bring the table up to date?
- nothing you can do *
- apply all archived redo log files
11. You put your tablespaces in backup mode, The users are still doing update,
what should you considered?
- data consistency
12. You do online backup of the database files but did not put the tablespaces
in backup mode.
- The backup is not usable *
- The backup is OK
----------------------- More -----------------
14. Before activate the standby DB, it is in
--mount mode
16. dbverify
--verify structure integrity of db file*
--can't be external
--can't do a subset datafile
19. DB too big, backup too slow, but it has a lot of query only tables
--put them in readonly tablespace
21. you just found out one of the datafile corrupted, the next thing you
should do
--restore in most recent backup file*
--back up the corrupted file
--apply redo log to undamaged files
22. datafile corrupted, after restore the file, try to open DB but with
error message, why?
--backup not sync with control file*
--must backup the control file
--must update init.ora file for new location of the restored file
26. default # of recovery process per session
--recovery_parallelism
27. what to do for a 7x24 operation (choose 3)
--must be in archivelog mode
--online backup
--backup all datafiles
- You have decided to use standby database. To ensure
resilience to failure, what action will you take?
a. Use the same control file for both primary and
standby database.
b. Place primary and standby database in seperate
physical location. *
c. Seperate data file from each database and share the
same device for all redo log file.
d. Place primary and standby database on the same physical
device.
I picked b.
- After attempting to drop a non-current redo log file, you realize
this is not possible. You decided
to re-initialize this redo log file instead.
Which option of the ALTER DATABASE should you use?
a. Initilize
b. RESET LOGFILE
c. Clear LOGFILE
c. RESETLOGS
I picked c.
- Database is in Noarchivelog mode. Database has crashed due to a
disk drive that is no longer operatable. You determine that a
datafile can not be restored to its original location. After restoring
the datafile to a different location, which file must you
mannually edit to indicate this change?
a. Initilize file
b. Control file
c. All log file
d. All datafile
e. None
I piked e.
- You change your database to Archivelog mode. Why must
you perform a full database backup?
a. To update control file to reflect the change.
b. Your previous backup is not usable for recovery
any more since it was taken while database was
in Noarchivelog mode.
c. Only last backup is used for all future
instance recovery.
d. There is no reason to perform a full dtabase
backup if the previous backup is still available.
I picked b.
bye
Hi Nikki,
Congratulations for getting OCP.... and good luck for job..
Can I have one copy of dumps or papers... I am preparing for Oracle 8i DBA exams.... my email is [email protected]
Thanks in advance.
Korranat
About a week ago I finished passing all 5 exams for Oracle
Certification. I found that buy taking the Instructor Led
Courses (ILT) and then going through the STS exams;
I was really prepared.
I am in the process of getting ready to take the Oracle8
to Oracle8i upgrade exam. I would be interested
in exchanging materials.
Hi,
How long did u take to complete all your Oracle8 five exams??
BTW, since Oracle9i will be out in a few month's time...how will it
impact the OCP market of the old release?? comments pls...
junior
Certified Oracle8i DBA
Hi,
Congrats.
Could you please e mail me copies of dumps or papers. I am preparing to take the OCP exams. My e mail id is [email protected]. Would appreciate details about your OCP preparation.
Thanks.
Tan_swap.
Hey Niki Way to go and Congratulations on finally making the OCP club. I have 3 to go and wonder if you could pass along some study information on Netadmin, PT or SQL. My email is [email protected]. Thanks and Good Luck on Future Endeavors!!!
Congratulations Nikki !!!!
May you succeed in your new job and career just like your OCP exams.
Can u please send me the dumps and advice at my email address, [email protected]
Hi, Nikki
Congratulations!!
I am preparing for the exams, but I have no such materials. Could anyone who got the dumps or papers share them with me? My e mail id is [email protected]
Thanks in advance.
martensite
Plz send me dumps for "New Features of Oracle 8i" paper
Thanks a lot
Shabee
Hi
friends
I am preoccupied with large assignments.
sorry.. i could'nt mail all dumps and papers to everybody.
i will be participating actively as soon i am free.
whoever received the dumps ,please pass to others.
Bye
Nikki
Hi Nikki,
Congrats! for your achievement.
It would be a great help if you can send me a copy of dumps and papers .My email id is [email protected]
thanxs in advance
Hi
I passed 8i performance tuning.
O god ... it's really most toughest exams.
i passed by a whisker.
Sybex and examcram books are very good for these exams.
Thanks lot to ocp9i for sending me updated exams papers.
also thanks to Nikki.
I will be writing 8i backup and recovery soon,
if any body has latest Q's please mail or make available on this thread.
Thanks lot to this forum for making me sucessfull.
Bye
Take care
Mercy.
Hi everyone,
I am in the process of preparing for OCP.Could u please pass on any dumps,STS or ILT pdfs to my mail-id [email protected]?
thanks in advance
vanitha.
hi,
r u send me the ocp dba8 practice exam test to me at
[email protected]
please send me a copy pls. and tnx for sharing your succe with us....
and that's [email protected]
Hi
It would be a great help if any of you could send me a copy of the dumps and papers which have been circulated. My email is [email protected].
Thanks.
Regards
yes!!! i have finally received my OCP kit today!!! no big deal BUT!! hey!!
at least its something to look forward for....well nothing much inside except for
the dull looking OCP membership card and a few pieces of ads and nice looking
certificate !!! hahaha...
ok now..so what's next?? Oracle9i ?? guys care to share any dumps when
they are ready?? heee...
junior
Next? After OPC comes Oracle Master. Go to:Quote:
Originally posted by ngwh
yes!!! i have finally received my OCP kit today!!!
ok now..so what's next??
junior
http://www.oracle.com/global/us/educ...l?content.html
and choose an area of specialaization. You must be OCP in order by become an Oracle Master.
Personally, I will go after Enterprise Scalable DBA since I administer Oracle Parallel Server. There are 7 areas of specialaization, OEM seems to be the easiest.
Any "Masters" out there :-)
Hi Everyone,
Please send me your braindumps and exam resources.
I am studying for OCP and have my first exam SQL/PLSQL
in the next two weeks.
I will be extremely grateful for any help.
Please email me at [email protected]
Thank you very much in advance.
Regards
mufec
As you can see I am very new to the forum but have already gained loads of information. I am in the process of switching careers from the chemical/food/sensory industry into a career (cross your fingers) using Oracle. I have a chunck of money allocated for training etc and have been scouring my local education centers and the net to find the best bang for the buck. It seems that the ILT and STS are the most focused and ways to go. One question, did you buy the ILT books on an online store or through an individual?
My question is how well do these study materials prepare you for real world scenarios?
I would be very interested to hear from those who have used these methods and have gained employment on how well they are coping.....?
In addition please send me (Nikki et al) at your earliest convenience any dumps/papers/etc you feel worthwhile to [email protected]
Oh yes and congratulations to Nikki and the rest on their recent achievement.....I hope to hear the kudos from you in the relatively near future :)
[Edited by L-Carvone on 08-07-2001 at 10:57 AM]
Hi Nikki,
Congrats.
I still have problem getting the ILT books.
Can you give me some details?
Can you also send me any dumps and helpful resources to [email protected]?
Thank you very much in advance.
Good luck in your Oracle career.
Thanks,
Ka
Hi moderators
is it legal to publish ocppaper or dumps on dbasupport.com
as i want to help some of my friends in this forum.
i don't see anybody publishing anything expect me...
some questions from performance tuning which can help you.
Find te best answer for yourself
1. The most useful measure of database buffer cache performance is ______.
a. Consistent gets
b. Free buffer inspected
c. Buffer busy rates
d. Latch free
e. Cache hit ratio
f. Physical reads
2. To issue an alter system kill session statement, which two values would you retrieve from V$SESSION?
a. SID
b. PROCESS ID
c. USER_NAME
d. SESSION NAME
e. SERIAL#
3. In the analysis report generated by Oracle Expert for a tuning session, what information is included?
a. Recommendations.
b. All collected data to be analyzed.
c. Detailed information about the collected data in the repository for a tuning session.
d. Listing of all attributes for the instance for which you want tuning recommendations to be generated.
4. You suspect redo latch contention in the PROD instance and query V$LATCH and V$LATCHNAME to obtain statistics. The ideal percentage of latch contention time should be ______.
a. Less than 1%
b. Less than 5%
c. Less than 10%
d. Less than 90%
5. Given the following:
DB_BLOCK_LRU_EXTENDED_STATISTICS
What is the purpose of this parameter?
a. Increase the number of blocks in the database buffer cache.
b. Compute the cache hit ratio.
c. Allow evaluation of the effect of increasing the size of the buffers in the database buffer cache.
d. Allow evaluation of the effect of adding buffers to the database buffer cache.
6. Where are temporary segments created if a temporary table space is not specified for users?
a. RBS table space
b. SYSTEM table space
c. USERS table space
d. TEMP table space
e. INDEX table space
7. What is the minimum number of extends required in a rollback segment?
a. 1
b. 2
c. 5
d. 20
e. 100
8. Users are reporting slow response time on your system. You think that the problem can be solved by increasing the size database buffer cache. But you want to make sure your solution is correct. Which two steps are necessary to evaluate the impact of adding buffers to database buffer cache?
a. Set the parameter DB_BLOCK_LRU_EXPANDED_STATISTICS to the number of buffers you want to add.
b. Set the parameter DB_BLOCK_LRU_EXPANDED_STATISTICS=True.
c. Query the V$RECENT_BUCKET view.
d. Query V$FILESTAT.
9. You suspect there is I/O contention with the log files. Which view would you query for confirmation?
a. V$LOG_HISTORY
b. V$LOGFILE
c. V$SYSTEM_EVENT
d. V$ARCHIEVE
10. You are monitoring rollback segment usage for the PROD database to determine if you need to add additional rollback segments. Frequent queries of V$WAITSTAT during normal processing hours indicates an average value of 115 for the undo header column. What does the average value of this column indicate to you?
a. Rollback segment header blocks are being used efficiently.
b. Rollback segments are sized too large.
c. The largest rollback segment for the prod database is too small for normal transaction processing.
d. Contention exists for rollback segment header blocks in the transaction table.
11. Trace files for deadlock situations are recorded where?
a. USER_DUMP_DEST
b. BACKGROUND_DUMP_DEST
c. CORE_DUMP_DEST
d. TRACE_DUMP_DEST
12. When creating temporary table space, which two storage parameters should be set as integer multiples of SORT_AREA_SIZE?
a. MAXEXTENTS
b. INITIAL
c. NEXT
d. MINEXTENTS
e. OPTIMAL
13. When will the change to a storage parameter be used if you are changing the storage parameter for the EMP table by setting PCTUSED to 250?
a. Immediately
b. When the further queries are made on the table
c. When future DML activity occurs on the table
d. When the database is shut down and restarted
14. In your efforts to improve performance you altered several frequently accessed small tables with the CACHE clause. To prevent over-crowding in the buffer cache, which initialization parameter you can set?
a. CACHE_THRESHOLD
b. DB_BLOCK_BUFFERS
c. DB_BUFFER_CACHE
d. CACAHE_SIZE_THRESHOLD
15. The alert log file contains which type of information?
a. Default initialization parameter
b. Messages and errors
c. Name and location of all databases
d. SQL statement error messages generated by applications
16. The database includes tables with static data that are used for queries only. For this type of table to which size should you set PCTFREE?
a. 0
b. 10
c. 20
d. 50
17. When are packages loaded into library cache?
a. At instance startup
b. After all parts of the package have been accessed
c. As soon as any part of them is accessed
d. When an application using the packet is started
18. You have just implemented the new financials application and want to track usage of various modules. To track the usage of modules in the application, what should be used?
a. TKPROF
b. SQL* trace
c. EXPLAIN plan
d. ANALYZE
e. DBMS_APPLICATION_INFO
19. You have been asked to develop a tuning plan for an application that has been in production for a year. Your most important tuning goal should be to ______.
a. Tune the internal database structure so that you can see performance improvements.
b. Tune all elements necessary for users to see noticeable performance improvements.
c. Tune the database so that you can perform backups more quickly.
d. Reorganize the data files on the system to take advantage of available disk space.
20. Payroll application users are complaining about the length of time it takes to run the earnings calculation program, you have enabled tracing for this process and trace is now complete. To format information about the execution of the SQL statements for the process, what should be used?
a. SQL Plus Trace.
b. EXPLAIN
c. DBMS_APPLICATION_INFO
d. ANALYZE
21. To find out how a statement would be executed if you ran it at a particular moment what, what should be used in SQL*Plus?
a. TKPROF
b. SQL*TRACE
c. ANALIZE
d. EXPLAIN
22. You query INDEX_STAT because you suspect there is a problem with the ACCT_NO_IDX index. What information is returned?
a. Information about the current state of all indexes
b. Information about the current state of an index
c. Information about the index from the time of creation
d. Information from the last analyze index validate structure command issued
23. Performance for queries in your decision support system has degraded and you decide to create indexes for the relevant tables. The queries usually involve multiple predicates on a low cardinality column and tables are read only. Which index type should you create?
a. B-tree
b. Reverse key
c. Bit mapped
d. Concatenate
24. You have created keep, recycle and default buffer pools for the PROD instance. However when you start up the instance an error occurs and the database is not mounted. What could cause this?
a. Total allocation to the buffer pools has exceeded the allocation to the PGA.
b. Multiple buffer pools can only be created when a database is created.
c. Total allocation to the buffer pools is less than the value for DB_BLOCK_BUFFER.
d. Total allocation to the buffer pools has exceeded the DB_BLOCK_BUFFER and /or DB_BLOCK_LRU_LATCHES parameters.
25. Your company is planning to design and implement a custom payroll application. During this proces,s at which time is it most important for performance to be addressed?
a. Design
b. Testing
c. Application development
d. Production
26. What should you use as a sizing guideline when creating a recycle buffer pool?
a. It should be large enough to retain blocks for the duration of a session.
b. It should be large enough to retain blocks for the duration of the application process.
c. It should be large enough to retain blocks for the duration of all sessions.
d. It should be large enough to retain blocks for the duration of a transaction
27. You have determined that row migration is occurring for several tables in the PROD database. To prevent further migration for the involved tables and any other tables where you do not want this to occur, which storage parameter can you set?
a. PCTFREE
b. PCTUSED
c. MINEXTENTS
d. MAXEXTENT
28. What will a trace file contain if you have enabled SQL Tracing at the session level?
a. Statistics for buffer usage for the instance
b. Statistics for all processes during that time
c. Statistics for the user application process
d. Statistics for SQL statements for the session
29. You created a test database recently. You think you may not have made the redolog buffer large enough. Which view should be queried to see if waits are occurring for the event log buffer space?
a. V$PROCESS
b. V$ROWSTAT
c. V$TRANSACTION
d. V$WAITSTAT
e. V$ SYSTEM_EVENT
30. You are performing a direct load to the TEMP_DATATABLE using SQL*Loader. You issue this command prior to the task, ALTER TABLE temp_date NOLOGGING; which task is accomplished?
a. Redo log entries will not be generated for the load to the temp_data table.
b. Redo log entries will be generated but will not be archived for the load to temp_data.
c. Redo log entries will not be archived until the load to the temp_data table is complete.
d. Log entries will not be generated until the load to the temp_data table is complete.
more soooon...if moderator agrees
Bye..............
mercy
A few of those were on my exam.
I got them from Oracle Univeristy after attending all DBA courses.Quote:
Originally posted by L-Carvone
One question, did you buy the ILT books on an online store or through an individual?
[Edited by L-Carvone on 08-07-2001 at 10:57 AM]
Well, I guess after spending that much money with them, you should get something. Altohugh, It took me three days to convince my Instuctor to give me an Oracle Pen and Coffee Mug.
And now I think about it.. where is my Coffee Cup...Sheezzz!
:-) I've been to about 15 Oracle courses at Oracle University and also did get those pens. Never got a cofee mug however...Quote:
Originally posted by grjohnson
Well, I guess after spending that much money with them, you should get something. Altohugh, It took me three days to convince my Instuctor to give me an Oracle Pen and Coffee Mug.
And now I think about it.. where is my Coffee Cup...Sheezzz!
Thanks Mercy,
For your PT info. I will be studying for that exam soon...did you find that PT was hard...what did you use for studying. I have found that the Oracle University ILT books to be not as good as using ExamCram or Sybex. Could you send me some more questions- I find them useful to [email protected]
Hi Mercy,
It would of great help if you could send some dumps for SQL/PLSQL exam.My email id is [email protected]
lucky133
Congratutions
please send me a copy pls. and tnx for sharing your success .
[email protected]
here's by recent oracle8i test results:
1)PL/SQL =44/57
2)Architecture =51/64
3)Network Admin =44/59
4)BackupRecovery =50/60
5)PerformanceTune =47/57
...wonder how does the rest fair??
junior
Hi
I dont have all papers , get it from [email protected]
he has some updated papers or purchase cheetsheets.
checkout examcram or ILT + STS for success
some backup and recovery questions
Question:
You received an insufficient privileges error message while trying to add data to another user's
table. Which type of failure has occurred?
Answer:
(C) statement
Question:
Your control file was not mirrored and it is now lost because of a media failure. Which command
will you use to recover the database?
Answer:
(A) BACKUP CONTROLFILE
Question:
You are preparing for a traditional TSPITR to replace invalid data inserted into a table when a
constraint on that table was inadvertently disabled. You have all other datafiles and you have
backed up the required control file. What must you do before you begin?
Answer:
(B) check for adequate memory and disk space
Question:
During the recovery of a user's schema that you are unfamiliar with, you import the tables in
alphabetical order. Which problem might you encounter?
Answer:
(D) A foreign key table is imported prior to its corresponding primary key table causing rows
that reference the primary key to be rejected.
Question:
The database is hanging and the current online redo log is damaged. As the DBA, you have
identified which group is current and cleared the unarchived logfile group. What is recommended
that you do next?
Answer:
(A) Perform a whole backup with the database closed.
Question:
You lost a datafile due to disk failure. You are restoring the datafile to a new location
because the disk is corrupted. After using the SWITCH command to modify the control file,
what is the next step?
Answer:
(D) Apply archives, incrementals, cumulative, and redo logs with the RECOVER command.
Question:
Which statement concerning the recovery of a NOARCHIVELOG mode database from a closed database backup is true?
Answer:
(C) Manual entry of lost transactions may be needed after recovery.
Question:
Which statement concerning a database running in ARCHIVELOG mode is true?
Answer:
(B) The database can be restored to a specific SCN or point-in-time.
Question:
Which two data dictionary views can be accessed during an opened database backup for backup
status information? (Choose two.)
Answer:
(A) V$BACKUP
(F) V$DATAFILE_HEADER
Question:
You plan to use LogMiner to reverse invalid changes made to a table by a particular user.
After modifying the init.ora file to indicate where the new dictionary file will reside, you
use the BUILD procedure to generate the file. Which procedure will you use to identify log
files to be analyzed?
Answer:
(A) ADD_LOGFILE
Question:
Which statement concerning an incomplete recovery using RMAN is true?
Answer:
(A) All datafiles must be restored.
Question:
You are using the CATALOG command to add information to a recovery catalog. Which two event's information are you recording? (Choose two.)
Answer:
(A) datafiles that were copied without using RMAN
(D) a tablespace backup that occurred before RMAN was installed
Question:
You issued this command:
RECOVER AUTOMATIC DATABASE
In which situation is this command used?
Answer:
(A) a closed database recovery
Question:
Which two statements concerning the alert.log file are true? (Choose two.)
Answer:
(A) It contains system error information.
(B) It contains recovery operations information.
Question:
Your database is running in ARCHIVELOG mode. It has suffered a media failure resulting in a
number of damaged files. As the DBA, which recovery option is available to you that would
impose the least impact on users?
Answer:
(C) an online restoration of the damaged files
Question:
You have a standby database that is kept in close synchronization with your primary database.
How are the databases' kept in synchronization efficiently?
Answer:
(D) The primary database's archive logs are applied to the standby database by placing the
database in managed recovery mode.
Question:
Place the steps required to multiplex a control file in the proper order.
Step 1 -> Shut down the database
Step 2 -> Copy existing control file to a different device
Step 3 -> Add all control file names to init.ora using the CONTROL_FILES parameter
Step 4 -> Start the database
Question:
You are temporarily using your standby database as a reporting database. Because you are only
allowing users to query information for their reports from this database, you opened the
database in ______ mode.
Answer:
read only
read-only
Question:
Examine these recovery catalog details:
username: RCATMAN
password: RCATMAN
connect string: RCVCAT
Which command will connect to this recovery catalog?
Answer:
(C) $ rman rcvcat rcatman/rcatman@RCVCAT
rman> connect target
Question:
Before executing a backup script, you need to copy a file using operating system commands.
You are logged in to Recovery Manager. Which command should you use to execute the copy command from the Recovery Manager prompt?
Answer:
(A) run
Question:
At approximately 7:00am today, the DEPARTMENT table was accidentally dropped. The database structure has not changed since last Friday and you decide to perform an incomplete database recovery through 6:45am today. Using Recovery Manager, which RUN command clause will perform this recovery?
Answer:
(C) SET UNTIL TIME = '1998-06-08:06:45:00'
Question:
You shut down the database to place the database in archivelog mode. In which state should you restart the database to alter the archive mode?
Answer:
(B) MOUNT
Question:
You removed the archived log file named arch_232.rdo located in the '/disk2/archive' directory
using an operating system utility. You are using a recovery catalog. Which Recovery Manager
command should you issue to inform the recovery catalog to no longer reference this file?
Answer:
(D) CHANGE ARCHIVELOG '/disk2/archive/arch_232.rdo' UNCATALOG;
Question:
Due to the size of your database, you are concerned with the amount of time that must be
allocated for backups. You decide to use Recovery Manager to expedite your backups for which
reason?
Answer:
(B) The use of incremental backups is available.
Question:
Saturday is the start of your weekly backup strategy and a level 0 backup is performed.
For subsequent daily backups throughout the week, you only want to back up those blocks that
have changed since the previous day's backup. Which RUN command will you use?
Answer:
(D) rman> run { allocate channel c1 type disk
format = '/disk1/backup/tue_%s_%p.bck';
backup incremental level = 1 (database); }
Question:
Using the Export/Import utility as your backup and recovery strategy, you must now recover a
table that was accidentally dropped. This table is very large and has several indexes on it.
Which Import clause could you use to help speed up this process by preventing the index
structures from being imported?
Answer:
(B) INDEXES = NO
Question:
You create a new database in NOARCHIVELOG mode. What is an implication of running a database that is not archiving log files?
Answer:
(A) You cannot perform online backups.
Question:
You set a number of tablespaces in backup mode by issuing the ALTER TABLESPACE command. You want to verify that all the files you are about to backup are indeed in "begin backup" mode. Which data dictionary view can you query to verify this information?
Answer:
(A) V$BACKUP
Question:
Recovering a database in ARCHIVELOG mode requires access to all archived log files created since the last backup. If a recovery operation required archived log files with sequence number 122 through 134 and sequence number 125 is missing, what would be the result?
Answer:
(B) The database would only be recovered through archive log file sequence number 124 in this
operation.
Question:
Datafiles for the STAT_DATA tablespace are lost due to media failure and the disk is
Unrecoverable. The database is in NOARCHIVELOG mode. After restoring the backups to a
Different locations, which action must you take before updating the control file to specify this
New location?
Answer:
(B) Mount the database.
Question:
Examine this redo log file configuration:
Member Disk
Group 1: log1a.rdo u02
log1b.rdo u02
Group 2: log2a.rdo u04
log2b.rdo u04
Group 3: log3a.rdo u04
log3b.rdo u04
Which change should you make to this configuration to minimize single-point-of-failure in
case of media corruption?
Answer:
(C) Place each member of a particular group on a separate disk.
Question:
The SALES_STAT table was dropped two days ago. You decide to perform tablespace point-in-time recovery without Recovery Manager. This option includes which task(s)?
Answer:
(B) Create, recover, and export the table from the clone database and import into the primary
database.
Question:
You are considering physical image copies as a backup solution. Which factor is likely to have
a high impact on your strategy?
Answer:
(D) Available storage space required for physical image copies must be sufficient.
Question:
The Production database experiences a media failure. The lost disk contains the datafile for
The USER01 tablespace, but not the Datafiles for the system or rollback segment tablespaces.
To perform a complete recovery, you mount the database, take the datafile offline, and open the
Database. What should you do next?
Answer:
(B) Restore the Datafiles to a new location.
Question:
An electrical storm shut down the database abnormally. Instance recovery will begin the next
Time the database is started. Which server process writes both committed and uncommitted data to the Datafiles during instance recovery?
Answer:
(C) DBWR
Question:
The SYNC_MASTER table will be loaded each day with statistics generated during that day
using SQL* Loader. You set the table in NOLOGGING mode to speed the loading of data.
Why is it advisable to take a backup of the table after this data load?
Answer:
(D) Changes resulting from the direct insert operation are not recorded in the redo log files.
Question:
Your database is in NOARCHIVELOG mode and a datafile has just been lost due to a power outage that corrupted a disk. Which steps must you perform to recover this database?
Answer:
(A) Restore the last full offline backup of the entire database.
Question:
Block corruption of a specified file has just been indicated by the error message ORA-1578.
If an index is available on the table in which the corrupted block resides, how can the
uncorrupted data be retrieved?
Answer:
(A) index scan
After an instance crash, when are the uncommitted transactions rolled back?
1) During the startup open.
2) Data is never rolled back since rollback segments are lost.
3) After the database is opened.
4) When the DBA issues a Global Rollback.
5) During the startup mount.
Due to a prolonged power failure, your database server goes down overnight. You are running the database in ARCHIVELOG mode.
Referring to the above, when the power to the database server is restored, what type of recovery must you perform in order to start the database?
1) Time-based Recovery
2) Cancel-based Recovery
3) Restore the last cold backup and perform a full database recovery.
4) You only need to recover data files with active transactions.
5) No manual recovery is required.
A disk crashes in your database. You have backups, but cannot restore all of the files to there original location. What command must you issue to inform Oracle of the new file locations prior to opening/recovering the database?
1) No command is necessary. Oracle will find the file.
2) alter database rename file
3) alter database backup controlfile to trace
4) startup nomount
5) create control file
alter database backup controlfile to trace;
When the above command is executed, where will the trace file be written?
1) The user's current directory.
2) BACKGROUND_DUMP_DEST
3) USER_DUMP_DEST
4) The user's HOME directory.
5) ARCHIVE_LOG_DEST
Which of the following is a characteristic of a cancel-based recovery?
1) Automatic application of Oracle's archive redo suggestions
2) Tablespace recovery with on-line backups
3) Use of the alter database recover database until cancel statement
4) Availability of the database during the recovery process
5) Use of the alter system recover database until cancel statement
Which tablespace cannot be recovered with the database open?
1) SYSTEM
2) USERS
3) DATA
4) TEMP
5) TOOLS
In the event that a data recovery is necessary, what must occur?
A: restoration of the data file from the backup
B: drop the corresponding tables related to the bad data file
C: application of all archive log files and the redo log files
D: a and c above
E: all of the above
Oracle jobs can be scheduled through the Enterprise Manager only.
A: true
B: false
A replicated system requires
A: a master site
B: a snapshot site
C: a replication server
D: a and b above
E: none of the above
When this Oracle object is lost, the database is nearly impossible to recover the database and should be protected by some type of data mirroring.
A: redo log
B: control file
C: rollback segment
D: all of the above
E: none of the above
If ARCHIVELOG mode is turned on, a redo log group must be archived before it is used.
A: true
B: false
Under what condition will a point-in-time recovery be necessary?
A: power loss
B: user error
C: hardware failure
D: disk drive failure
A log file is just like any other data file and may be recovered.
A: true
B: false
In order for a transaction to be eligible for recovery,
A: a checkpoint must occur
B: the data must be backed up
C: the data must be written to the archive log
D: the redo log entry must be written out to disk
The Oracle Export/Import Utilities can be used for the following functions.
A: backing up the database
B: rebuilding the database
C: reorganizing the database
D: a and b above
E: all of the above
If no hardware or operating system mirroring is available and recoverability is required, the redo log files within the same redo log file group
A: must be stored on the same disk
B: must be stored on separate disks
C: must be stored on a separate disk from the rollback segments
D: can be stored anywhere, because the redo logs are not needed for recoverability
When recovering from a lost datafile, it is only necessary to recover
A: the instance
B: the entire database
C: the datafile that was lost
D: the tablespace that was lost
Instance recovery is automatic.
A: true
B: false
What Oracle objects are used for recovery operations?
A: redo log files, query
B: rollback segments, query
C: redo log files, rollback segments
D: all of the above
E: none of the above
In the event of a power loss, what recovery method is required?
A: media recovery
B: instance recovery
C: database recovery
D: point in time recovery
When recovering from a lost datafile, it is only necessary to recover
A: the instance
B: the entire database
C: the datafile that was lost
D: the tablespace that was lost
The Oracle Export utility stores Oracle data and table definitions externally in an Oracle-specific log file.
A: true
B: false
Question:
You issue these commands:
$rman target system/manager@prod8db \
> rcvcat system/manager@prod8rcat
rman> report need backup days 5 database;
Which type of list is generated by the second command?
Answer:
(D) all the datafiles that have not been backed up in the last 5 days
Question:
Which statement about RMAN is true?
Answer:
(D) Recovery Manager allows backups of changed blocks, but does not support point-in-time
recovery of the SYSTEM tablespace.
if anybody has 8ibackup and recovery papers, please publish it....
All the best
Bye
mercy
Hello Mercy
Thanks for your question. can you send me one copy of all
question to my email-id [email protected]
Rakesh Sanghvi
dang!
anyone notice that there are a good number of questions with innacurate or wrong answers/questions?
example:
one questions/answer stated you cannot delete/remove table data when using SQL*Loader. That is not correct.
- Magnus
Hi
passed Sqlplus
Thanks to dbasupport.com and other friends
check oracle documentation for sucess.
Byw
For clarification when you say "oracle documentation" you mean the topics listed by Oracle as being on the test correct?
Thanks
L-Carvone
Hi
oracle documentation is good.
download candidate guide
from education.oracle.com and check out
all chapters and prepare for the exams.
Bye
Hello Nikky,
I am also studying for my OCP-DBA-(for Oracle8i) here in Australia.
I haven't done any exams yet and have little computer experience. I am therefore looking for any help that I can get!!
If you or anyone else out there do have any Oracle Dumps or anything that can help me pass then please forward them to my email address which is:-
[email protected]
Cheers and thanks heaps in advance!
Tom.