当前分类： 1Z0-042
问题：多选题While setting up the database for your production environment， you want to create a user with following requirements. 1.The objects created by the user must be stored in a tablespace， TBS1， if the TABLESPACE option is not defined during the object cre...
查看答案
问题：多选题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 open...
问题：单选题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 ...
问题：多选题When you try to start the Database Control by using the emctl start dbconsole command the following error is displayed： TZ set to America/New_york OC4J Configuration issue. /u01/app/oracle/product/10.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_orcl.us.oracle....
问题：单选题Which is the correct description of the significance of the ORACLE_HOME environmental variable？（）A It specifies the directory containing the Oracle software.B It specifies the directory containing the Oracle-Managed Files.C It specifies the directory f...
问题：单选题You work as a database administrator for Supportcenter.cn. Client connection requests are failing because the listener is not responding. You want to forward client connect requests to another listener if one listener is not responding. How do you achi...
问题：多选题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 wri...
问题：多选题You work as a database administrator for Certkiller .com. You decided to manage client and server connections using Local Naming method in Certkiller .com. When you try to connect to the database you get the following error： ERROR： ORA-12154：TNS：could...
问题：单选题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？（）...
问题：单选题In your Supportcenter.cn database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting？（）A The source PL/SQL code will be stored in native machine code.B The source PL/SQL code will be stored in int...
问题：单选题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...
问题：多选题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 ope...
问题：单选题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， worklo...
问题：单选题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...
问题：单选题You work as a database administrator for Supportcenter.cn. The database is open. A media failure has occurred， resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario？（）A The...
问题：单选题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 Inform...
问题：多选题Which two operations require undo data？（）Acommitting a transactionBrolling back a transactionCrecovering from failed transactionsDrecording a transaction to redo log filesErolling forward during instance recovery...
问题：单选题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 f...
问题：单选题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 I...
问题：单选题You work as a database administrator for Certkiller .com. In your organization， you have four databases， Certkiller DB01， Certkiller DB02， Certkiller DB03， and Certkiller DB04， which are located in Berlin， Frankfurt，Rammstein， and Munich respectively， ...
