站内搜索
1Z0-042 问题列表
问题
多选题You work as a database administrator for Certkiller .com. Users in the Certkiller PROD database complain about the slow response when accessing the database. In the Active Session Waiting: Configuration page you find that the majority of the wait time is for the redo log buffer.Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks, and that the disk I/O for the redo log files is the reason for the performance degradation. Which two actions would you take to gain performance?()AIncrease the size of redo log filesBIncrease the size of redo log bufferCIncrease the number of redo log filesDPlace the redo log files on a separate diskEDecrease the number of redo log groups to twoFIncreate the number Log Writer (LGWR) process
问题
单选题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.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.
问题
多选题You plan to use static database registration for a new listener when you create it.What could be the two reasons for this?()AMore than one database is to be registered with the listener.BThe users will connect the database by using the host naming method.CThe Oracle Enterprise Manager is to be used to monitor an Oracle9i database.DThe database that is to be registered with the listener is configured in shared server mode.EThe listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.
问题
多选题You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this?()ASet the UNDO_RETENTION parameter to AUTO.BCreate an initial undo segment in undotablespace.CSet the UNDO_RETENTION parameter to 900 or moreDSet the initialization parameter UNDO_MANAGEMENT to AUTOESet the UNDO_MANAGEMENT parameter to the name of an undotablespace
问题
单选题You work as a database administrator for Supportcenter.cn. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file. How does the loss of a redo log member affect the instance of the database that is currently running?()A
The instance would normally abort.B
The instance would not be affected.C
The instance would be invalid, so would have to be aborted.D
The instance would remain open, but the LGWR process would fail.E
The instance would remain open and would automatically create the missing file
问题
单选题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
FULLB
SCHEMASC
REMAP_SCHEMAD
REMAP_DATAFILESE
REMAP_TABLESPACE
问题
多选题Which two statements about bigfile tablespaces are true? ()AThe bigfile tablespace have only one data file.BThe segment space management is automatic.CThe extent management is dictionary managed.DThe database can have only one bigfile tablespace.EThe bigfile tablespace can be converted to a smallfile tablespace.
问题
单选题You work as a database administrator for Supportcenter.cn. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation. Which advisory component would you refer to, in order to determine the appropriate indexes?()A
Memory AdvisorsB
Segment AdvisorsC
SQL Tuning and Access AdvisorsD
Automated Workload Repository (AWR)E
Automatic Database Diagnostic Monitor (ADDM)
问题
单选题You manually create an additional listener process,L1,for databases PROD, PAYDB and FINDB. While starting up the listener process,you get the following error message: LSNRCTL start l1 Starting /u01/app/oracle/product/10.1.0/db_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 10.1.0.2.0 - Production System parameter file is /u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora Log messages written to /u01/app/oracle/product/10.1.0/db_1/network/log/l1.log Error listening on: (ADDRESS=(PROTOCOL=TCP)(HOST=144.23.230.185)(port=8899)) TNS-12542: TNS:address already in use TNS-12560: TNS:protocol adapter error TNS-00512: Address already in use Linux Error: 98: Address already in use Listener failed to start. See the error message(s) above... What action would you take to overcome this error without disrupting any existing database communications?()A
stop and restart the listener processB
set the TNS_ADMIN environmental variableC
stop all running listener processes and restart the listener processD
change the port number to an unused port number and restart the listener processE
change the IP address to host machine name in the LISTENER.ORA file and restart the listener process
问题
单选题Which statement is true about the loss of system-critical 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.
问题
单选题Which two operations can be flashed back using the Flashback technology? ()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;
问题
单选题The data file belonging to theSYSTEMtablespaceis corrupted and no backup of the file is available. How do you recover the data file?()A
The data file cannot be recovered.B
The date file can be restored from theSYSTEMauto backup.C
Take thetablespaceoffline,drop,kand re-create it.D
Recovery Manager (RMAN) is used to recover the data file.E
The ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.
问题
单选题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 scriptB
PL/SQL scriptC
Operating System (OS) scriptD
Enterprise Manager (EM) scriptE
Recovery Manager (RMAN) script
问题
单选题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 logB
checkpoint position to end of redo logC
beginning of redo log to end of redo logD
all redo logs before the point of last commitE
beginning of redo log to checkpoint position
问题
单选题The customer and order tables are often used in joins, thereby resulting in complex queries. You created views to simplify the writing of queries. These views are stored in().A
user tablesB
view segmentC
table segmentD
data dictionaryE
object segmentF
performance tables