问题:多选题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
Tuesday, October 17, 2023
问题:多选题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
Thursday, May 16, 2024
问题:单选题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
Monday, March 18, 2024
问题:单选题Your Certkiller .com database is in ARCHIVELOG mode. The data file that belongs to the SYSTEMtablespacehas become corrupted. Up to what point can you recover the database?()A Until last commitB Until the time you perform recoveryC Until the time the date file got corruptedD Until the point where the last transaction begunE You cannot recover the SYSTEMtablespaceand must re-create the database.
问题:单选题Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?()A PMONB SMONC MMNLD MMANE MMON
Saturday, September 17, 2022
问题:单选题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 re-create 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 re-create the control file.E The trace file is an image copy of the control file created during the backup of the control file.
Wednesday, January 31, 2024
问题:单选题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.
问题:单选题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.
Monday, January 15, 2024
问题:多选题You work as a database administrator for Supportcenter.cn. You have set the retention period for Automatic Repository (AWR) statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics?()Ause enterprise managerBuse DBMS_SQL packageCuse DBMS_AWR packageDuse PRVT_WORKLOAD packageEquery the AWR snapshot repository objectsFuse DBMS_WORKLOAD_REPOSITORY package
Sunday, December 10, 2023
问题:单选题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.
Wednesday, December 14, 2022
问题:多选题On which three can you use Recovery Manager (RMAN) to perform incremental backup?()Adata filesBcontrol filesCtablespacesDpassword fileEparameter fileFwhole databaseGflashback log fileHarchived log filesIchange tracking file
Wednesday, March 22, 2023
问题:单选题You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this task efficiently without using command-line interfaces?()A SQL*PlusB iSQL*PlusC Management ServerD Management RepositoryE Oracle Enterprise Manager 10g Database Control
Monday, May 8, 2023
问题:单选题When you try to open your database, you receive the following error: ORA-00205: error in identifying controlfile Where would you find the details required to resolve this error?()A audit trailB alert log fileC user trace fileD online trace fileE background trace fileF operating system event viewer
问题:单选题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
问题:单选题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
Tuesday, September 20, 2022
问题:单选题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
问题:单选题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? ()A Assign the DEFAULT profile to the usersB Set the RESOURCE_LIMIT parameter to TRUE in the parameter fileC Create a new profile with CPU restrictions and assign it to the usersD Specify the users as members of the DEFAULT_CONSUMER_GROUPE Revoke the DBA role and grant CONNECT and RESOURCE role to the users
Monday, February 27, 2023
问题:多选题You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time?()ABy multiplexing the control filesBBy multiplexing the redo log filesCBy decreasing the size of redo log filesDBy configuring mean time to recover (MTTR) to a lower valueEBy setting the UNDO_RETENTION parameter to a higher value
Friday, September 16, 2022
问题:单选题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
Sunday, January 1, 2023
问题:单选题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