1Z0-042 题目列表
单选题Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）AThe database is in mount state.BOne of the tablespaces is offline.COne of the tablespaces is read only.DThe database operates in ARCHIEVELOG mode. EThe database operates in NOARCHIEVELOG mode.
单选题You want to set up the Oracle Database 10g installation to follow the French language， with France as the territory， and the date to be displayed in French for all users’ sessions. Which environmental variable would you set to achieve this objective？（）ANLSLANGBNLSLENGTHSEMANTICSCNLSTERRITORYDNLSLANGUAGEENLSCHARACTERSETFNLSDATELANGUAGEGNLSNCHARCHARACTERSET
单选题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？（）Ause the external table populationBuse the Oracle Data Pump export and import utilityCuse the conventional path data load of SQL*Loader utilityDuse the direct path data load of Oracle export and import utility
单选题While running the Oracle Universal Installer on a Unix platform to install Oracle Database 10g software， you are prompted to run orainstRoot.sh script. What does this script accomplish？（）AIt creates the pointer file.BIt creates the base directory.CIt creates the Inventory pointer file.DIt creates the Oracle user for installation.EIt modifies the Unix kernel parameters to match Oracle’s requirement.
单选题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？（）Aby using the SQL access advisorBby using the Automatic Workload Repository reportCby running the Automatic Database Diagnostic Monitor （ADDM）Dby using the Automatic Workload Repository Compare Period reportEby analyzing the output of the V$ACTIVE_SESSION_HISTORY view
单选题Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in iSQL*Plus？（）AThe user must be granted the database administrator （DBA） privilege.BThe user must be listed in the password file for the authentication.CNo special setup is needed for the user to connect as SYSDBA in iSQL*Plus.DSet up a user in the Oracle Application Server Containers for J2EE （OC4J） user manager，and grant the webDba role to the user.
单选题Your database is in the NOARCHIVELOG mode. Since last night’s offline backup， the logs in group 1 have been written to twice. This morning， the SYSTEM data file has become corrupted. Up to what point can it be recovered？（）Auntil the last commitBcannot be recoveredCuntil the last offline backupDuntil the beginning of the last transaction
多选题What are the consequences of executing the SHUTDOWN ABORT command？ （）AThe database files are synchronized.BUncommitted changes are not rolled back.CThe database is closed， but the instance is still started.DDatabase buffers and redo buffers are not written to the disk.EThe database undergoes automatic media recovery during the next startup.
单选题You work as a database administrator for Certkiller .com. You find that users with DBA role are using more CPU resources than what is allocated in their profiles. Which action would you take to ensure that resources limits are imposed on these users？ （）AAssign the DEFAULT profile to the usersBSet the RESOURCE_LIMIT parameter to TRUE in the parameter fileCCreate a new profile with CPU restrictions and assign it to the usersDSpecify the users as members of the DEFAULT_CONSUMER_GROUPERevoke the DBA role and grant CONNECT and RESOURCE role to the users
单选题In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）Aflash back the databaseBperform point-in-time recoveryCperform a full database recoveryDdrop and re-create the tablespaceEuse Recovery Manager （RMAN） to recover the database
多选题You work as a database administrator for Supportcenter.cn. Users in the SupportCenter 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
多选题You work as a database administrator for Certkiller .com. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）AA backup of the target database when it is mountedBA backup of online redo log files when the database is openCA backup of only used data blocks in the file beingbeingbackup upDA backup of online， read/write data files when the database is openEA backup of only those data blocks that have changed since a previous backupFA backup of online， read/write data files when the database is in the NOMOUNT state.
单选题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？（）Ause the external table populationBuse the Oracle Data Pump export and import utilityCuse the conventional path data load of SQL*Loader utilityDuse the direct path data load of Oracle export and import utility
单选题The database users are connecting to the PROD database from different applications， thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one. Which action would you take to achieve this objective？（）Aset the SESSIONS to 1 in the parameter fileBgrant SINGLE SESSION privilege to all of the usersCset the SESSIONS_PER_USER to 1 in the users’ profileDgrant RESTRICTED SESSION privilege to all of the database usersEcreate a role with SINGLE SESSION privilege and assign the role to the users
多选题Which two statements about Automatic Storage Management （ASM） are true？（）AASM provides mirroring on file by file basis.BASM provides automatic load balancing across all ASM disks.CASM supports the Oracle database and operating system files.DASM can be used to store trace files， alert log files， and the server parameter file （SPFILE）.