网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
In which situation would you use static database registration for a listener（）
A
when multiple databases are to be registered with the listener
B
when DBAs need to connect remotely to start up the database instance
C
when users need to connect the database instance using the host naming method
D
when the database instance that is to be registered with the listener is configured in shared server mode
参考答案
参考解析
解析：
暂无解析
更多 “单选题In which situation would you use static database registration for a listener（）A when multiple databases are to be registered with the listenerB when DBAs need to connect remotely to start up the database instanceC when users need to connect the database instance using the host naming methodD when the database instance that is to be registered with the listener is configured in shared server mode” 相关考题
考题
Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?()
A. Oracle Net ManagerB. Listener Control utilityC. Database Configuration AssistantD. Oracle Net Configuration Assistant
考题
You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）A、Database ControlB、Management ServerC、Management RepositoryD、Application Server ControlE、Oracle Management Agent
考题
Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member， which is not a member of the current group. How would you recover from the loss of the redo log member？（）A、SMON would automatically restore the lost file.B、You would need to restore the whole database from the last backup.C、You would need to restore the file from the last full database backup.D、You would need to use flashback technology to restore the lost redo log member.E、You would need to use Recovery Manager （RMAN） to restore the lost redo log member.F、You would need to restore the missing log file by copying one of the remaining files from the same group.
考题
Which command would you use to determine what database backups are currently available for restore?（）A、list database backupB、report database backup C、list backup of databaseD、list summary backupE、report backup of database
考题
You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance. Which advisor would you use to determine the suitable size of the SGA？（）A、 SQL Tuning AdvisorB、 Undo AdvisorC、 ADDMD、 Memory Advisor
考题
You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database， you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective？（）A、Use the CREATE DATABASE .. command to create the database with Oracle-managed files. B、Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. C、Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. D、Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. E、Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.
考题
In which case would you use the Flashback Database feature to perform a recovery？（）A、to recover a dropped tablespaceB、to recover data from a truncated tableC、to recover a data file that has been shrunkD、to recover a database to the state that existed before the RESETLOGS operation
考题
In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）A、Oracle Migration AssistantB、Recovery Manager （RMAN）C、Oracle Data Pump Export and ImportD、conventional Oracle Export and ImportE、operating system utilities to copy the files to the ASM instance
考题
You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task？（）A、FULLB、SCHEMASC、REMAP_SCHEMAD、REMAP_DATAFILESE、REMAP_TABLESPACE
考题
Which command would you use to determine what database backups are currently available for restore？（） A、 list database backupB、 report database backupC、 list backup of databaseD、 list summary backupE、 report backup of database
考题
The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump. Which option of Data Pump Import would you use to accomplish this？（） A、 ownerB、 touserC、 attachD、 remap_schema
考题
Which of the following would you use to enable automatic media recovery for a database？（）A、SET AUTORECOVERY ONB、SET RECOVERY ONC、SET AUTO OND、You cannot enable automatic media recovery.
考题
You want to migrate your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task？（）A、the CONVERT command of RMANB、Data Pump Export and Import into the same databaseC、conventional export and import into the same databaseD、the BACKUP DATABASE and RESTORE DATABASE commands of RMANE、the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN
考题
You want to move all objects of the APPS user in the test database to the DB_USER schema of theproduction database. Which option of IMPDP would you use to accomplish this task（）A、FULLB、SCHEMASC、TRANSFORMD、REMAP_SCHEMAE、REMAP_TABLESPACE
考题
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
考题
Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to start the listener？（）A、 Oracle Net ManagerB、 Listener Control utilityC、 Database Configuration AssistantD、 Oracle Net Configuration Assistant
考题
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. In the database, a small percentage of data is modified everyday. Ever day in the morning, you have to create a read-only copy of the database for reporting purposes and make sure that you use as little disk space as possible. In the options below, which strategy should you use? （） A、You should use database snapshots B、You should use database backup and restore C、You should use database backup and restore along with compression D、You should use schema-bound views in a read-only database. The database resides on the same instance.
考题
单选题Which of the following would you use to enable automatic media recovery for a database？（）A
SET AUTORECOVERY ONB
SET RECOVERY ONC
SET AUTO OND
You cannot enable automatic media recovery.
考题
单选题You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）A
Database ControlB
Management ServerC
Management RepositoryD
Application Server ControlE
Oracle Management Agent
考题
单选题You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task？（）A
FULLB
SCHEMASC
REMAP_SCHEMAD
REMAP_DATAFILESE
REMAP_TABLESPACE
考题
单选题You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance. Which advisor would you use to determine the suitable size of the SGA？（）A
SQL Tuning AdvisorB
Undo AdvisorC
ADDMD
Memory Advisor
考题
单选题You want to move all objects of the APPS user in the test database to the DB_USER schema of the productiondatabase. Which option of IMPDP would you use to accomplish this task（）A
FULLB
SCHEMASC
TRANSFORMD
REMAP_SCHEMAE
REMAP_TABLESPACE
考题
单选题Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to start the listener？（）A
Oracle Net ManagerB
Listener Control utilityC
Database Configuration AssistantD
Oracle Net Configuration Assistant
考题
单选题Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）A
Oracle Net ManagerB
Listener Control utilityC
Database Configuration AssistantD
Oracle Net Configuration Assistant
考题
单选题Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member， which is not a member of the current group. How would you recover from the loss of the redo log member？（）A
SMON would automatically restore the lost file.B
You would need to restore the whole database from the last backup.C
You would need to restore the file from the last full database backup.D
You would need to use flashback technology to restore the lost redo log member.E
You would need to use Recovery Manager （RMAN） to restore the lost redo log member.F
You would need to restore the missing log file by copying one of the remaining files from the same group.
考题
单选题In which situation would you use static database registration for a listener（）A
when multiple databases are to be registered with the listenerB
when DBAs need to connect remotely to start up the database instanceC
when users need to connect the database instance using the host naming methodD
when the database instance that is to be registered with the listener is configured in shared server mode
考题
单选题Which command would you use to determine what database backups are currently available for restore？（）A
list database backupB
report database backupC
list backup of databaseD
list summary backupE
report backup of database
考题
单选题You want to move all objects of the APPS user in the test database to the DB_USER schema of theproduction database. Which option of IMPDP would you use to accomplish this task（）A
FULLB
SCHEMASC
TRANSFORMD
REMAP_SCHEMAE
REMAP_TABLESPACE
热门标签
最新试卷