当前分类： 1Z0-042
问题：You want to create a new optimized database for your transac...
查看答案
问题：多选题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 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 meth...
问题：单选题You executed the following command in the lsnrctl utility to stop the listener： lsnrctl STOP L1 What is the effect of this command if L1 is the only listener configured for your database？（）A It terminates all user sessions.B It prevents users from log...
问题：单选题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...
问题：单选题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 NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your ...
问题：单选题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...
问题：单选题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？（）A flash back the databaseB perform point-in-time recoveryC perform a full ...
问题：多选题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 configur...
问题：单选题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 ...
问题：单选题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...
问题：单选题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？（）...
问题：单选题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 following are the details of your database： Instance name：test Host name：tech1.us.oracle.com IP address：145.33.230.186 Enterprise Manager Console HTTP Port number：5500 You started the database instance and you want to manage your database ...
问题：多选题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...
问题：You are unable to move the Unified Job Scheduler occupant fr...
问题：多选题A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled. What are the two effects of this command？（）AIt fails if any existin...
问题：单选题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 ro...
