Exam : Oracle 1Z0042
Title : Oracle Database 10g
Administration I
1. In your Oracle 10g database , you have scheduled a job to update the optimizer statistics at 05:00 pm
every Friday. The job has successfully completed. Which three pieces of information would you check to
confirm that the statistics have been collected? (Choose three.)
A. average row size
B. last analyzed date
C. size of table in bytes
D. size of table in database blocks
E. number of free blocks in the free list
F. number of extents present in the table
Answer: ABD
2. You are in the middle of a transaction and very crucial data has been modified. Because of a hardware
failure, the instance has shut down before synchronizing all the database files.
Which two statements are true? (Choose two.)
A. On startup, SMON coordinates instance recovery.
B. On startup, CKPT coordinates instance recovery.
C. On startup, use RMAN to perform instance recovery.
D. Uncommitted changes will be rolled back after the database is opened.
E. On startup, perform media recovery and then instance recovery.
F. On startup, all the files will be synchronized and you get both committed and uncommitted data.
Answer: AD
3. You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your
database.
Which type of script does the backup scheduler generate?
A. SQL script
B. PL/SQL script
C. Operating System (OS) script
D. Enterprise Manager (EM) script
E. Recovery Manager (RMAN) script
Answer: E
4. You executed the following command to export the EMPLOYEES table from a remote machine:
$ EXPDP hr/hr@data.us.oracle.com
DUMPFILE=my_dir:exp_hr.logTestinside
| English | Chinese(Traditional) | Chinese(Simplified) | 4 TestInside Information Co., Ltd. All rights reserved.
LOGFILE=data_pump_dir:log_hr.log
TABLES=employees
What would be the outcome of this command?
A. The command would execute successfully and the export dump file would be created in the destination
of the directory object MY_DIR.
B. The command would execute successfully. But log file would not be created as DATA_PUMP_DIR
directory is only accessible to user with SYSDBA privilege.
C. The command fails with an error because DATA_PUMP_DIR directory have higher precedence over
the perfile directory.
D. The command fails with an error because no absolute path is specified for log file and dumpfile.
Answer: A
5. Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in
iSQL*Plus?
A. The user must be granted the database administrator (DBA) privilege.
B. The user must be listed in the password file for the authentication.
C. No special setup is needed for the user to connect as SYSDBA in iSQL*Plus.
D. Set up a user in the Oracle Application Server Containers for J2EE (OC4J) user manager, and grant
the webDba role to the user.
Answer: D
6. Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. .. statement are
correct? (Choose two.)
A. This clause is not valid for a temporary or undo tablespace.
B. If the tablespace is in the NOLOGGING mode, no operation on the tablespace will generate redo.
C. The tablespace will be in the NOLOGGING mode by default, if not specified while creating a
tablespace.
D. The tablespacelevel logging attribute can be overridden by logging specifications at the table, index,
materialized view, materialized view log, and partition levels.
Answer: AD
7. Which two statements are true about the primary key constraint in a table? (Choose two.)
A. It is not possible to disable the primary key constraint.
B. It is possible to have more than one primary key constraint in a single table.
C. The primary key constraint can be referred by only one foreign key constraint.Testinside
| English | Chinese(Traditional) | Chinese(Simplified) | 5 TestInside Information Co., Ltd. All rights reserved.
D. The primary key constraint can be imposed by combining more than one column.
E. The nondeferrable primary key constraint creates an unique index on the primary key column if it is not
already indexed.
Answer: DE
8. You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is
granted the SYSDBA privilege to perform administrative tasks on the database.
Which file is used by the Oracle database server to authenticate APP_DBA?
A. control file
B. password file
C. listener controller file
D. control file and password file
Answer: B
9. Which three statements are true regarding the logical structure of the Oracle database? (Choose
three.)
A. Each segment contains one or more extents.
B. Multiple tablespaces can share single data file.
C. A data block is the smallest unit of I/O for data files.
D. It is possible to have tablespaces of different block sizes in a database.
E. Each data block in the database always corresponds to one OS block.
Answer: ACD
10. Which is the memory area that is created when a dedicated server process is started, and contains
data and control information for that server process?
A. SGA
B. PGA
C. Shared Pool
D. Streams Pool
Answer: B
11. You find that the database performance degrades while you backup the PROD database using
Recovery Manager (RMAN). The PROD database is running in shared server mode. The database
instance is currently using 60% of total operating system memory. You suspect the shared pool
fragmentation to be the reason.Testinside
| English | Chinese(Traditional) | Chinese(Simplified) | 6 TestInside Information Co., Ltd. All rights reserved.
Which action would you consider to overcome the performance degradation?
A. Configure Java Pool to cache the java objects.
B. Configure Streams Pool to enable parallel processing.
C. Increase Shared Pool size to cache more PL/SQL objects.
D. Increase Database Buffer Cache size to increase cache hits.
E. Configure Large Pool to be used by RMAN and shared server.
F. Increase the total System Global Area (SGA) size to increase memory hits.
Answer: E
12. You execute the following command to audit the database activities:
SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;
What is the effect of this command?
A. One audit record is created for the whole session if user SCOTT successfully drops one or more tables
in his session.
B. One audit record is created for every session when any user successfully drops a table owned by
SCOTT.
C. One audit record is created for each successful DROP TABLE command executed by any user to drop
tables owned by SCOTT.
D. One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to
other users in his session.
E. One audit record is created for each successful DROP TABLE command executed in the session of
SCOTT.
Answer: A
13. The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank.
As part of the yearend tax and interest calculation process, all the rows in the table need to be accessed.
The bank authorities want to track access to the rows containing balance amounts exceeding $200,000,
and then send an alert message to the administrator.
Which method would you suggest to the bank for achieving this task?
A. implementing valuebased auditing by using triggers
B. implementing finegrained auditing with audit condition and event handler
C. performing standard database auditing to audit object privileges by setting the AUDIT_TRAIL
parameter to EXTENDED
D. performing standard database auditing to audit SQL statements with granularity level set to ACCESS
Answer: BTestinside
| English | Chinese(Traditional) | Chinese(Simplified) | 7 TestInside Information Co., Ltd. All rights reserved.
14. Which three statements are true regarding the finegrained auditing (FGA)? (Choose three.)
A. FGA is possible on SELECT statements only.
B. The audit trail for FGA is stored in the FGA_LOG$ table.
C. The audit trail for FGA is stored in the AUD_LOG$ table.
D. FGA enables a SQL predicate to define when to audit an event.
E. FGA audits DELETE statements only when audit columns are specified.
F. FGA includes the SQL statement used by the user as part of the audit event entry.
Answer: BDF
15. You plan to use static database registration for a new listener when you create it. What could be the
two reasons for this? (Choose two.)
A. More than one database is to be registered with the listener.
B. The users will connect the database by using the host naming method.
C. The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.
D. The database that is to be registered with the listener is configured in shared server mode.
E. The listener is not configured on the default port of 1521 and the instance is not configured to register
with a nondefault port.
Answer: CE
16. Which three pieces of information are to be mandatorily provided while creating a new listener using
Enterprise Manager Database Control? (Choose three.)
A. the port used by the listener
B. the protocol used by the listener
C. the server name where the listener runs
D. the log file and trace file destination for the listener
E. the database services to be registered with the listener
Answer: ABC
17. You have been recently hired as a database administrator. Your senior manager asks you to study the
production database server and submit a report on the settings done by the previous DBA. While
observing the server settings, you find that the following parameter has been set in the parameter file of
the database:
REMOTE_OS_AUTHENT = TRUE
What could have been the reason to set this parameter as TRUE?
A. to enable operating system authentication for a remote clientTestinside
| English | Chinese(Traditional) | Chinese(Simplified) | 8 TestInside Information Co., Ltd. All rights reserved.
B. to restrict the scope of administration to identical operating systems
C. to allow the start up and shut down of the database from a remote client
D. to enable the administration of the operating system from a remote client
E. to disable the administration of the operating system from a remote client
Answer: A
18. Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client
while connecting to the database instance from a remote machine?
A. host naming method
B. local naming method
C. external naming method
D. directory naming method
Answer: B
19. Your tnsnames.ora file has the following entry for the service alias ORCL:
ORCL =
( DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.24.216)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.oracle.com)
)
)
The TNSPING command executes successfully when tested with ORCL but you are not able to connect
to the database instance with the following command:
SQL> CONNECT scott/tiger@orcl
What could be the reason for this?
A. The listener is not running at the server.
B. The TNS_ADMIN environmental variable is set to a wrong value.
C. The orcl.oracle.com database service is not registered with the listener.
D. The DEFAULT_DOMAIN parameter is set to a wrong value in the SQLNET.ORA file.
Answer: C
20. Your database is open and users are connected using the LISTENER listener. The new DBA of the
system stops the listener by using the following command:Testinside
| English | Chinese(Traditional) | Chinese(Simplified) | 9 TestInside Information Co., Ltd. All rights reserved.
LSNRCTL> STOP
What would happen to the sessions that are presently connected to the database instance?
A. The sessions are able to perform only queries.
B. The sessions are not affected and continue to function normally.
C. The active transactions are rolled back and the sessions get terminated.
D. The sessions are not allowed to perform any operations till the listener is started.
Answer: B
21. Your database is started with SPFILE. You want the database instance to be dynamically registered
with a listener L2 with the following details:
Protocol: TCP
Host: indl151e
Port: 1525
Which is the correct order of the steps that you would follow to achieve this?
1. Set the LOCAL_LISTENER parameter to L2 dynamically.
2. Make an entry for L2 in tnsnames.ora on the database server.
3. Restart L2.
4. Modify the listener.ora file to add the instance name in SID_LIST of L2.
A. 1, 2, 4, 3
B. 1, 2, 3; 4 is not required.
C. 2, 1; 3 and 4 are not required.
D. 1, 2; 3 and 4 are not required.
Answer: C
22. Your database is not configured for session failover. Your tnsnames.ora file contains the following
details:
test.us.oracle.com=
(DESCRIPTION=
(ADDRESS_LIST=
(LOAD_BALANCE=off)
(FAILOVER=ON)
(ADDRESS=(PROTOCOL=tcp)(HOST=test1server)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=test2server)(PORT=1521)))
(CONNECT_DATA=(SERVICE_NAME=test.us.oracle.com)))
Which feature is enabled in this case?Testinside
| English | Chinese(Traditional) | Chinese(Simplified) | 10 TestInside Information Co., Ltd. All rights reserved.
A. Load balancing
B. Instance failover
C. Database failover
D. Connecttime failover
E. Transparent Application Failover (TAF)
Answer: D
23. In which situation would you use the Oracle Shared Server configuration?
A. when performing export and import using Oracle Data Pump
B. when performing backup and recovery operations using Oracle Recovery Manager
C. when performing batch processing and bulk loading operation in a data warehouse environment
D. in an online transaction processing (OLTP) system where large number of client sessions are idle most
of the time
Answer: D
24. In your database, the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the
impact of this setting?
A. The optimizer statistics are collected automatically.
B. Only the timed operating system (OS) statistics and plan execution statistics are collected.
C. The Oracle server dynamically generates the necessary statistics on tables as part of query
optimization.
D. The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.
E. Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.
Answer: D
25. Your database is functional with peak load for one hour. You want to preserve the performance
statistics collected during this period so that they can be used for comparison while analyzing the
performance of the database in the future.
What action would you take to achieve this task?
A. Set the STATISTICS_LEVEL initialization parameter to ALL.
B. Create a baseline on a pair of snapshots that have the statistics of the peakload period in the
database.
C. Decrease the snapshot interval in the AWR to collect more number of snapshots during the peakload
period.
D. Set the snapshot retention period in the Automatic Workload Repository (AWR) to zero to avoid theTestinside
| English | Chinese(Traditional) | Chinese(Simplified) | 11 TestInside Information Co., Ltd. All rights reserved.
automatic purging of the snapshots.
Answer: B
26. The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays.
Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week.
How would you identify the changes in configuration settings, workload profile, and statistics to diagnose
the possible causes of the performance degradation?
A. by using the SQL access advisor
B. by using the Automatic Workload Repository report
C. by running the Automatic Database Diagnostic Monitor (ADDM)
D. by using the Automatic Workload Repository Compare Period report
E. by analyzing the output of the V$ACTIVE_SESSION_HISTORY view
Answer: D
27. In your database, the snapshot interval is set to 10 minutes for the Automatic Workload Repository
(AWR). The database instance is running for the past 30 days.
View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) task.
The ADDM task is performed every 10 minutes, except the last task. What could be the reason for this?
A. The snapshot retention period for the AWR was increased before the last task.
B. The optimizer statistics for few objects in the database were locked before the last task.
C. The STATISTICS_LEVEL initialization parameter was changed to BASIC and reset to TYPICAL before
the last task.
D. The optimizer statistics was collected manually by using the DBMS_STATS package before the last
task.
Answer: C
28. Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose
two.)
A. The ADDM runs after each AWR snapshot is collected.Testinside
| English | Chinese(Traditional) | Chinese(Simplified) | 12 TestInside Information Co., Ltd. All rights reserved.
B. The ADDM requires at least four AWR snapshots for analysis.
C. The ADDM analysis provides only the diagnostic information but does not provide recommendations.
D. The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR).
E. The ADDM calls other advisors if required, but does not provide recommendations about the advisors.
Answer: AD
29. You want to monitor and control the resource usage by sessions. You want to be warned automatically
when more than 100 sessions are opened with your database.
What action would you take to achieve this?
A. Use the Database Resource Manager.
B. Set the limits in the profiles used by users.
C. Modify the SESSIONS initialization parameter.
D. Set the warning threshold for the Current Logons Count metric.
Answer: D
30. View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERT view.
After 30 minutes, you executed the following command:
SQL> SELECT reason,metric_value FROM dba_outstanding_alerts;
REASON METRIC_VALUE
Tablespace [TEST] is [28 perce 28.125
nt] full
What could be the two reasons for the elimination of the other rows in the output? (Choose two.)
A. The threshold alert conditions are cleared.
B. The threshold alerts are transferred to DBA_ALERT_HISTORY .
C. The nonthresholdbased alerts are transferred to DBA_ALERT_HISTORY .Testinside
| English | Chinese(Traditional) | Chinese(Simplified) | 13 TestInside Information Co., Ltd. All rights reserved.
D. The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY
but not the threshold alerts related to instance metrics.
Answer: AB
31. You define an alert to be raised when the USERS tablespace usage has reached 80% of the total
space. Which area would you refer to, in order to confirm that the alert has been raised due the event?
A. the alert.log file
B. the DBA_ALERTS view
C. the Database Control Home page
D. the Database Control performance page
E. the Database Control Maintenance page
Answer: C
32. View the Exhibit, and examine the alert messages.
You added space to the TEST tablespace to bring the space usage below the threshold value.
Which statement is true about the Tablespace Full alert?
A. The alert is purged because it is a threshold alert.
B. The alert is cleared and transferred to the alert log file.
C. The alert is automatically cleared and sent to the alert history.
D. The alert appears in Oracle Enterprise Manager Database Control until it is manually cleared.
Answer: C
33. View the Exhibit and examine the output.Testinside
| English | Chinese(Traditional) | Chinese(Simplified) | 14 TestInside Information Co., Ltd. All rights reserved.
Which statement describes the conclusion?
A. The users should use bind variables instead of literals in the query.
B. The dictionary cache is consuming more space than the library cache.
C. The shared pool size should be increased to accommodate the SQL statements.
D. Preparing indexes on the tables used in the SQL statements would improve the library cache
performance.
Answer: A
34. You received complaints about the degradation of SQL query performance. You identified top SQL
queries that consume time. What would be your next step to find out recommendations about statistics
collection and restructuring of the SQL statement to improve query performance?
A. run Segment Advisor
B. run SQL Tuning Advisor on top SQL statements
C. run the Automatic Workload Repository (AWR) report
D. run the Automatic Database Diagnostic Monitor (ADDM) on top SQL statements
Answer: B
35. Users of HR schema complain about slowerthannormal performance. On investigation the DBA
found that maintenance was recently performed on some of the tables. The DBA traced the query that
takes longer than normal to execute.
View the Exhibit exhibit_before.
After the DBA resolves the problem, the query performs normally.Testinside
| English | Chinese(Traditional) | Chinese(Simplified) | 15 TestInside Information Co., Ltd. All rights reserved.
View the Exhibit exhibit_after.
What action would the DBA have taken to resolve the performance problem?
A. analyzed the EMPLOYEES table to collect the current statistics
B. moved the EMPLOYEES table in to a locally managed tablespace
C. moved the EMPLOYEES table to another location in the same tablespace
D. reorganized the associated indexes for the EMPLOYEES table that were in an unusable state
E. moved the indexes associated with the EMPLOYEES table to the same tablespace where the
EMPLOYEES table exists
Answer: D
36. Which statement is true when you run the SQL Tuning Advisor with limited scope?
A. Access path analysis is not performed for the SQL statements.
B. SQL structure analysis is not performed for the SQL statements.
C. SQL Profile recommendations are not generated for the SQL statements.
D. The staleness and absence of the statistics are not checked for the objects in the query supplied to the
SQL Tuning Advisor.
Answer: C
37. You work in a data warehouse environment that involves the execution of complex queries. The
current content of the SQL cache holds the ideal workload for analysis. You want to analyze only few most
resourceintensive statements.
What would be your suggestion to receive recommendations on the efficient use of indexes and
materialized views to improve query performance?Testinside
| English | Chinese(Traditional) | Chinese(Simplified) | 16 TestInside Information Co., Ltd. All rights reserved.
A. Run the SQL Access Advisor.
B. Run the SQL Tuning Advisor (STA).
C. Run the Automatic Workload Repository (AWR) report.
D. Run the Automatic Database Diagnostic Monitor (ADDM).
Answer: A
38. Your database is configured with the following parameters related to SGA:
SGA_TARGET=256MB
SHARED_POOL_SIZE=32MB
DB_CACHE_SIZE=100MB
LARGE_POOL_SIZE=0
JAVA_POOL_SIZE=0
STREAMS_POOL_SIZE=0
Which two statements are true about the configuration? (Choose two.)
A. The SGA_TARGET value cannot be sized smaller than 100 MB.
B. The shared pool and the default buffer pool will not be sized bigger than 32 MB and 100 MB,
respectively.
C. The shared pool and the default buffer pool will not be sized smaller than 32 MB and 100 MB,
respectively.
D. 124 MB (256 minus 132) of memory is available for use by all the manually sized components.
E. 124 MB (256 minus 132) of memory is available for use by all the manually and automatically sized
components.
Answer: CE
39. Which two statements are true regarding the SGA_TARGET initialization parameter? (Choose two.)
A. It can be increased up to the value of the SGA_MAX_SIZE parameter.
B. Increasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic
shared memory management feature.
C. Reducing the value of the SGA_TARGET parameter takes away memory from both autotuned and
manually sized components.
D. Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the
autotuned components.
Answer: AD
40. In the middle of a transaction, a user session was abnormally terminated but the instance is still upTestinside
| English | Chinese(Traditional) | Chinese(Simplified) | 17 TestInside Information Co., Ltd. All rights reserved.
and the database is open.
Which two statements are true in this scenario? (Choose two.)
A. Event Viewer gives more details on the failure.
B. The alert log file gives detailed information about the failure.
C. PMON rolls back the transaction and releases the locks.
D. SMON rolls back the transaction and releases the locks.
E. The transaction is rolled back by the next session that refers to any of the blocks updated by the failed
transaction.
F. Data modified by the transaction up to the last commit before the abnormal termination is retained in
the database.
Answer: CF
41. You are working on the 24X7 database with high transaction volume, to ensure faster instance
recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very
low value. What effect it will have on the database?
A. The database performance would be enhanced.
B. The redo log files would be get filled more frequently.
C. The overall database performance would be degraded.
D. The mean time to recover (MTTR) would be increased.
Answer: C
42. Because of a power outage, instance failure has occurred. From what point in the redo log does
recovery begin and where does it end?
A. current redo log and inactive redo log
B. checkpoint position to end of redo log
C. beginning of redo log to end of redo log
D. all redo logs before the point of last commit
E. beginning of redo log to checkpoint position
Answer: B
43. View the Exhibit.Testinside
| English | Chinese(Traditional) | Chinese(Simplified) | 18 TestInside Information Co., Ltd. All rights reserved.
What would happen if you change the value of Desired Mean Time To Recover to 30?
A. The MTTR Advisor would be enabled.
B. The Redo Log Advisor would be disabled.
C. Automatic checkpoint tuning would be disabled.
D. The redo log from log buffers would be written to redo log files at a slower rate.
Answer: A
44. What is the implication of setting the initialization parameter FAST_START_MTTR_TARGET to 0 in
your database?
A. MTTR Advisor would be disabled.
B. Redo Log Advisor would be disabled.
C. Automatic tuning of checkpoint would be disabled.
D. Checkpoint information would not be written to the alert log file.
Answer: C
45. You want to protect your database from single point of failure by multiplexing the control file. Your
database is started using SPFILE. You have to perform the following tasks:
1. Shut down the database instance.
2. Copy the control file to new location.
3. Configure the CONTROL_FILES parameter.
4. Restart the instance.
Select the correct order in which these tasks need to be performed.
A. 1,2,3,4
B. 3,2,1,4
C. 3,1,2,4
D. 2,3,1,4
Answer: CTestinside
| English | Chinese(Traditional) | Chinese(Simplified) | 19 TestInside Information Co., Ltd. All rights reserved.
46. Your database is having two control files, three redo log file groups with two members in each group.
Failure of which file would cause an instance to shut down?
A. any control file
B. any archive log file
C. one of the redo log members
D. loss of the initialization parameter file
E. any data file belonging to the default permanent tablespace
Answer: A
47. Which two statements are true regarding the database in ARCHIVELOG mode? (Choose two.)
A. You have to shut down the database to perform the backups.
B. Archiving information is written to the data files and redo log files.
C. You can perform complete database backups without closing the database.
D. Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
E. All the previous database backups become invalid after you configure the database to ARCHIVELOG
mode.
Answer: CE
48. Which two statements regarding archive log destinations are true? (Choose two.)
A. A maximum of 10 destinations can be specified.
B. The archive logs must be written to all the destinations.
C. The archive log files can be written only to local destinations.
D. The archiving information can be traced to the alert log file whenever the archiving to a destination is
successful.
E. The number of archiving destinations must be equal to the number of archive processes (ARCn).
Answer: AD
49. Your test database is running in NOARCHIVELOG mode. What are the implications of this?
A. You can perform open database backups.
B. You can perform closed database backups.
C. You cannot perform schemalevel logical backups.
D. You can perform the backup of only the SYSTEM tablespace when the database is open.
Answer: B
50. Which two statements about Recovery Manager (RMAN) backups are true? (Choose two.)Testinside
| English | Chinese(Traditional) | Chinese(Simplified) | 20 TestInside Information Co., Ltd. All rights reserved.
A. Online redo log files can be backed up.
B. Archived redo log files are backed up.
C. Only used data blocks can be backed up as backup sets.
D. Only consistent database backups can be performed.
E. RMAN backup can be taken only if the database is configured in ARCHIVELOG mode.
Answer: BC
51. Your database is open, and you plan to perform Recovery Manager (RMAN) backups. Which three
statements are true about these backups? (Choose three.)
A. The backups would be consistent.
B. The backups would be inconsistent.
C. The backups need to be restored and database has to be recovered in case of a media failure.
D. The backups need not be restored during recovery in case of a media failure.
E. The backups would be possible only if the database is running in ARCHIVELOG mode.
F. The backups would be possible only if the database is running in NOARCHIVELOG mode.
Answer: BCE
52. You perform differential incremental level 1 backups of your database on each working day and level 0
backup on Sundays.
Which two statements are true about the differential incremental backups? (Choose two.)
A. The backup performed on Sundays contains all the blocks that have ever been use in the database.
B. The backup performed on Sundays contains all the blocks that have changed since the last level 1
backup.
C. The backup performed on each working day contains all the blocks that have changed since the last
level 0 or level 1 backup.
D. The backup performed on each working day contains all the blocks that have changed since the last
level 0 backup.
Answer: AC
53. According to your backup strategy, you performed an incremental level 0 backup of your database.
Which statement regarding this backup is true?
A. The backup is similar to image copy.
B. The backup contains all used data blocks.
C. The backup contains only unused data blocks.
D. The backup contains all data blocks changed since the last incremental level 1 backup.Testinside
| English | Chinese(Traditional) | Chinese(Simplified) | 21 TestInside Information Co., Ltd. All rights reserved.
Answer: B
54. On which three can you use Recovery Manager (RMAN) to perform incremental backup? (Choose
three.)
A. data files
B. control files
C. tablespaces
D. password file
E. parameter file
F. whole database
G. flashback log file
H. archived log files
I. change tracking file
Answer: ACF
55. You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager.
Which statement about the script created by Oracle Enterprise Manager is true?
A. It is a SQL script.
B. It is a PL/SQL file.
C. It is an operating system (OS) file.
D. It is a Recovery Manager (RMAN) script.
Answer: D
56. You backed up the control file to trace. Which statement is true about the trace file generated?
A. The trace file is in binary format.
B. The trace file has a SQL script to recreate the control file.
C. The trace file is a backup set created during the backup of the control file.
D. The trace file contains the instructions to manually recreate the control file.
E. The trace file is an image copy of the control file created during the backup of the control file.
Answer: B
57. Your database is in NOARCHIVELOG mode. After which two operations you should take the backup
of control file ? (Choose two.)
A. adding a new user to the database
B. dropping a user from the databaseTestinside
| English | Chinese(Traditional) | Chinese(Simplified) | 22 TestInside Information Co., Ltd. All rights reserved.
C. dropping a table from the database
D. dropping a data file from a tablespace
E. adding a new tablespace to the database
Answer: DE
58. You executed the following command to back up your control file:
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
Which initialization parameter is used to specify the location of the trace file?
A. USER_DUMP_DEST
B. CORE_DUMP_DEST
C. TRACE_DUMP_DEST
D. BACKUP_DUMP_DEST
E. BACKGROUND_DUMP_DEST
Answer: A
59. You notice this warning in the alert log file:
ORA19815: WARNING: db_recovery_file_dest_size of 3221225472 bytes is 100.00% used, and has 0
remaining bytes available.
What would you do to reclaim the used space in the Flash Recovery Area?
A. Back up the Flash Recovery Area.
B. Increase the retention time for the files.
C. Decrease the retention time for the files.
D. Manually delete all the archived log files from the Flash Recovery Area by using operating system (OS)
commands.
Answer: AC
60. Your database instance is started using the server parameter file (SPFILE). Control files are
multiplexed and stored on different disks. Because of a disk failure, you lost one of these control files. You
replaced the damaged disk.
What is the correct sequence of steps that you would follow to recover the control file?
1. Shut down the instance, if not already done.
2. Copy one of the remaining control files to a new location.
3. Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of
the control files.
4. Start up the database instance to the NOMOUNT stage.Testinside
| English | Chinese(Traditional) | Chinese(Simplified) | 23 TestInside Information Co., Ltd. All rights reserved.
5. Recover the database to the point of failure of the control file.
6. Open the database.
A. 5,2,3,4
B. 1,2,4,3,5
C. 2,4,3,4,5
D. 4,5,6,2,3
Answer: B
61. Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a
hard disk failure but the data files are not lost. You have the closed whole database backup available to
you.
Which two statements are true in this scenario? (Choose two.)
A. The instance aborts.
B. The database cannot be recovered.
C. The database can be recovered by restoring the control files from the backup.
D. The database remains opened and you have to shut it down with the ABORT option.
E. The database can be restored till the point of the last closed whole database backup.
Answer: AE
62. In your database, the Log Writer (LGWR) process is unable to write to a member of a current redo log
group due to read/write failure. Which two effects would you see in your database? (Choose two.)
A. The database instance aborts.
B. The database operation temporarily halts till the member becomes available.
C. Writing proceeds as normal. LGWR writes to the available members of a group and ignores the
unavailable members.
D. The member would be marked as STALE and an error message would be written to the alert log file
and LGWR trace file.
E. The status of the group changes to INACTIVE and an error message would be written to the alert log
file and LGWR trace file.
Answer: CD
63. Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, and
archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has
written everything to disk. Which command would you execute to proceed further?
A. RECOVER LOGFILE BLOCK GROUP 2;Testinside
| English | Chinese(Traditional) | Chinese(Simplified) | 24 TestInside Information Co., Ltd. All rights reserved.
B. ALTER DATABASE DROP LOGFILE GROUP 2;
C. ALTER DATABASE CLEAR LOGFILE GROUP 2;
D. ALTER DATABASE RECOVER LOGFILE GROUP 2;
E. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2;
Answer: E
64. Which statement is true about the loss of systemcritical data files in ARCHIVELOG mode?
A. The data files can be recovered till the last committed transaction.
B. The data files can be recovered without shutting down the database.
C. The data file is taken offline automatically; the database remains open.
D. The data files can be recovered to the time of the most recent backup.
Answer: A
65. Data files of which three tablespaces can be recovered by performing an open recovery? (Choose
three.)
A. TEMP
B. UNDO
C. INDEX
D. SYSAUX
E. SYSTEM
Answer: ACD
66. Due to media failure you lost one of the data files belonging to the USERS tablespace, and the
tablespace is not available to use. Which statement regarding the status of the database is true?
A. The database remains open.
B. The database gets dismounted.
C. The database becomes read only.
D. The database instance gets aborted.
E. The database gets shut down automatically.
F. The status of the database depends on the status of the USERS tablespace.
Answer: A
67. Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday
morning, media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups
are taken on every Sunday.Testinside
| English | Chinese(Traditional) | Chinese(Simplified) | 25 TestInside Information Co., Ltd. All rights reserved.
What would you do in this situation?
A. recover using Oracle Flashback Database technology
B. restore the data files from backup and perform a complete recovery
C. restore only the corrupted data file and perform tablespace recovery
D. restore the data files from backup and perform cancelbased recovery
E. restore the entire database from the most recent backup and start the instance and open the database
Answer: E
68. Which two operations can be flashed back using the Flashback technology? (Choose two.)
A. DROP USER SMITH;
B. DROP TABLE EMPLOYEES;
C. DROP TABLESPACE USERS;
D. ALTER TABLE SALES_REP DROP PARTITION P1;
E. ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID;
Answer: AB
69. You are working on an online transaction processing (OLTP) system. You notice that a PL/SQL
procedure got executed twice at 2:00 p.m. This has incorrectly updated the EMP_SAL table.
How would you revert the table to its state at 2:00 p.m.?
A. Perform pointintime recovery to 2:00 p.m.
B. Use Flashback Table feature to revert the changes.
C. Restore the entire database from the recent backup and open it.
D. Issue the rollback statement with system change number (SCN).
Answer: B
70. Examine the following commands executed in your database:
SQL> ALTER SESSION RECYCLEBIN=ON;
Session altered
SQL> CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees;
Table created.
Further, you executed the following command to drop the table:
SQL> DROP TABLE emp;
Table dropped.
What happens in this scenario?
A. The table is moved to the SYSAUX tablespace.Testinside
| English | Chinese(Traditional) | Chinese(Simplified) | 26 TestInside Information Co., Ltd. All rights reserved.
B. The table is moved to the SYSTEM tablespace.
C. The table is removed from the database permanently.
D. The table is renamed and remains in the TBSFD tablespace.
Answer: D
71. Which two statements about Flashback Query are true? (Choose two.)
A. It is generated by using the redo log files.
B. It helps in rowlevel recovery from user errors.
C. It can be performed to recover ALTER TABLE statements
D. It fails when undo data pertaining to the transaction is overwritten.
E. The database has to be opened with the resetlogs option after performing Flashback Query.
Answer: BD
72. You want to move all the objects of the APPS user in the test database to the DB_USER schema of
the production database. Which option of IMPDP would you use to accomplish this task?
A. FULL
B. SCHEMAS
C. REMAP_SCHEMA
D. REMAP_DATAFILES
E. REMAP_TABLESPACE
Answer: C
73. User SCOTT wants to export his objects using Oracle Data Pump and executes the following
command:
$ expdp scott/tiger
directory = EXPORT_DIR
dumpfile = scott.dmp
include = table
include = view:"like '�PARTMENTS%'"
content = DATA_ONLY
Which task would the command accomplish?
A. Oracle Data Pump would export only the data of all of the tables and views.
B. Oracle Data Pump would export all of the table structures along with data and all the views.
C. Oracle Data Pump would export the table data and the view definitions where the view name contains
a string named DEPARTMENTS.Testinside
| English | Chinese(Traditional) | Chinese(Simplified) | 27 TestInside Information Co., Ltd. All rights reserved.
D. Oracle Data Pump would export the table data and the view definitions with data where view name
contains a string named DEPARTMENTS.
E. Oracle Data Pump would export all of the table structures and the view definitions with data where view
name contains a string named DEPARTMENTS.
Answer: C
74. View the Exhibit to see the source and target databases.
You have created a database link, devdb.us.oracle.com, between the databases PRODDB and DEVDB.
You want to import schema objects of the HR user using Oracle Data Pump from the development
database, DEVDB, to the production database, PRODDB. You execute the following command on the
target database server:
$impdp system/manager directory = DB_DATA
dumpfile = schemas.dat
schemas = hr
flashback_time = 20040203 09:00
The command fails, displaying the following error:
ORA39001: invalid argument value
ORA39000: bad dump file specification
ORA31640: unable to open dump file "/home/oracle/schema/schemas.dat" for read
ORA27037: unable to obtain file status
What would you do to overcome the error?
A. remove the dumpfile option in the command
B. remove the flashback_time option in the command
C. add the user, SYSTEM, to the schemas option in the command
D. add network_link = devdb.us.oracle.com option in the command
E. remove the schemas option and add the network_link = devdb.us.oracle.com option in the commandTestinside
| English | Chinese(Traditional) | Chinese(Simplified) | 28 TestInside Information Co., Ltd. All rights reserved.
F. remove the dumpfile option and add the network_link = devdb.us.oracle.com option in the command
Answer: F
75. You are using flat files as the data source for one of your data warehousing applications. You plan to
move the data from the flat file structures to an Oracle database to optimize the application performance.
In your database you have clustered tables.
While migrating the data, you want to have minimal impact on the database performance and optimize the
data load operation. Which method would you use to load data into Oracle database?
A. use the external table population
B. use the Oracle Data Pump export and import utility
C. use the conventional path data load of SQL*Loader utility
D. use the direct path data load of Oracle export and import utility
Answer: C
3510
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
