问题:单选题Users in your PROD database complain about the slow response of the transactions. While investigating the reason, you find that the transactions are waiting for the undo segments to be available, and undo retention has been set to zero. What would you do to overcome this problem?()A increase the undo retentionB create more undo segmentsC create another undo tablespaceD increase the size of the undo tablespace
查看答案
问题:单选题It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager (RMAN). How would you make use of this consistent backup in RMAN?()A cannot be used in RMANB by starting up the database againC by using the CATALOG command of RMAND by using the RECOVER CATALOG command in RMANE by re-creating the target control file to rebuild the RMAN repository
问题:单选题The SCOTT user has an index on the ITEM_DESC column of the ITEM table. As part of the year-ending task, SCOTT updates the ITEM_DESC column for most of the rows in the ITEM table. How does this change to the table affect the index?()A An update in a leaf row takes place.B The index becomes invalid after the update.C The leaf block containing the row to be updated is marked as invalid.D A row in the leaf block of the index for the key value is deleted and inserted.
问题:单选题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?()A NLSLANGB NLSLENGTHSEMANTICSC NLSTERRITORYD NLSLANGUAGEE NLSCHARACTERSETF NLSDATELANGUAGEG NLSNCHARCHARACTERSET
问题:单选题While setting up an Oracle database for one of your critical applications, you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective?()A configure the database to run in ARCHIVELOG modeB configure the Flash Recovery Area to enable automatic database backupC schedule the database backup using DBMS_JOB package after creating the databaseD schedule the database backup using Recovery Manager (RMAN)commands after creating the databaseE schedule the database backup using Database Configuration Assistant (DBCA)while creating the database
问题:单选题Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups?()A The database is in mount state.B One of the tablespaces is offline.C One of the tablespaces is read only.D The database operates in ARCHIEVELOG mode. E The database operates in NOARCHIEVELOG mode.
问题:单选题You work as a database administrator for Certkiller .com. One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it?()A Uses undo data for roll forwardB Uses Flashback Log for recoveryC Uses online redo logs to roll backD Uses undo data to roll back the transactionE Uses Recovery Manager (RMAN) to roll backF Uses the System Monitor (SMON) background process to perform instance recovery
问题:单选题You work as a database administrator for Supportcenter.cn. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing?()A Information about each Oracle Net connection.B Information about each entry in theLinstener.orafileC Information about the changed done in the databaseD Information about the different listeners in your systemE Information about all thenondatabasefiles required to operate the database
问题:多选题Which three pieces of information are considered while deciding the size of the undo tablespace in your database?()Athe size of an undo blockBthe size of the redo log filesCundo blocks generated per secondDthe size of the database buffer cacheEthe value of the UNDO_RETENTION parameter
问题:多选题You work as a database administrator for Certkiller .com. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN; What two actions are performed as a result of this command?()AAll control files are openedBAll redo files are openedCThe password file is openedDThe parameter file is openedEAll online data files are opened
问题:单选题You work as a database administrator for Supportcenter.cn. Because of space constraints, you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows: ERROR at Line 1: ORA-10635: Invalid segment or tablespace type What could be the reason? ()A The table is partitionedB The table name is wrong.C It is an index-Organized table (IOT)D The table is stored in locally managedtablespace.E The table is stored in atablespacewhere segment space is managed manually.
问题:单选题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.
问题:单选题You work as a database administrator for Supportcenter.cn. In a production environment, users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response?()A The trace fileB The fixed viewsC The data dictionary viewsD The operating system log fieldsE The dynamic performance views.
问题:多选题Identify the two tablespaces whose data files are so critical that only a closed recovery is possible.()ASYSAUXBTOOLSCUNDODINDEXESYSTEMFUSERSGTEMP
问题:单选题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 populationB use the Oracle Data Pump export and import utilityC use the conventional path data load of SQL*Loader utilityD use 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?()A It creates the pointer file.B It creates the base directory.C It creates the Inventory pointer file.D It creates the Oracle user for installation.E It modifies the Unix kernel parameters to match Oracle’s requirement.
问题:多选题You work as a database administrator for Supportcenter.cn. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN; What two actions are performed as a result of this command?()AAll control files are openedBAll redo files are openedCThe password file is openedDThe parameter file is openedEAll online data files are opened
问题:单选题You work as a database administrator for Supportcenter.cn. When you tried to connect to the database, you received the following error: ERROR: ORA-12541:TNS:no_listener You found that the listener is not running on the server, so you issued the following command in the Listener Control utility to start the listener. lsnrctl>START What statement is true?()A It would attempt to start the default listenerB It would start the most recently created listener.C It would display an error with a message asking for the listener name to be specified.D It would show you a list of listeners and prompts for the listener name that you want to start.
问题:单选题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 advisorB by using the Automatic Workload Repository reportC by running the Automatic Database Diagnostic Monitor (ADDM)D by using the Automatic Workload Repository Compare Period reportE by analyzing the output of the V$ACTIVE_SESSION_HISTORY view
问题:单选题You are connecting to an Oracle database server from a client by using the following connect string: SQL> CONNECT hr/hr@pdserver.us.oracle.com:1521/proddb Which naming method is being used in this case?()A Local NamingB Easy ConnectC External NamingD Directory Naming