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