网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
You have a listener process, L1, currently listening for the connections to the PROD and ADMIN databases. You create a new database, PAY, using CREATE  DATABASE.. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA file manually to include PAY database for L1 listener process.  Which command of Listener control utility (LSNRCTL) would you use to enable L1 process to start listening for the connections to the PAY database without disrupting any existing database communications?()
A

START

B

RELOAD

C

RESTART

D

REFRESH

E

START L1

F

RELOAD L1

G

RESTART L1

H

REFRESH L1


参考答案

参考解析
解析: 暂无解析
更多 “单选题You have a listener process, L1, currently listening for the connections to the PROD and ADMIN databases. You create a new database, PAY, using CREATE  DATABASE.. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA file manually to include PAY database for L1 listener process.  Which command of Listener control utility (LSNRCTL) would you use to enable L1 process to start listening for the connections to the PAY database without disrupting any existing database communications?()A STARTB RELOADC RESTARTD REFRESHE START L1F RELOAD L1G RESTART L1H REFRESH L1” 相关考题
考题 You plan to use static database registration for a new listener when you create it.What could be the two reasons for this?()A、More than one database is to be registered with the listener.B、The users will connect the database by using the host naming method.C、The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.D、The database that is to be registered with the listener is configured in shared server mode.E、The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.

考题 You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database?()A、Start the instance and open the database, instance recovery automatically recoverscontrol filesB、Create a file based on the contents of the trace file and save it to the control file locations and start the databaseC、Re-create the database (The recovery of the control file is not possible because you have lost all the control files.)D、Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file.E、Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.

考题 You were recently hired by Certkiller .com as a database administrator. You are asked to find out whether the currently functional listener process, named L1, has been password protected or not. You are not familiar with the file system of the new organization. How would you accomplish the task?()A、 by using the STATUS command of the Listener control utilityB、 by using the STATUS L1 command of the Listener control utilityC、 by using the SHOW RULES command of the Listener control utilityD、 by using the SET PASSWORD command of the Listener control utilityE、 by searching for the PASSWORD_LISTENER entry in the listener.ora file

考题 You are maintaining the database of a company. The listener process, listener1, is configured for remote access. You have issued the following command:   LSNRCTLSTATUS listener1   Which information will NOT be displayed when you issue the above command?() A、 whether the password is set in the listener or a file or notB、 the number of client connections the service handler has refusedC、 the information will be displayed whether the instance can accept connections or notD、 the protocol addresses on which the listener is configured to listen

考题 You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure.  How would you proceed to recover the database?()A、Start the instance and open the database, instance recovery automatically recovers control files B、Create a file based on the contents of the trace file and save it to the control file locations and start the database C、Re-create the database (The recovery of the control file is not possible because you have lost all the control files.) D、Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. E、Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.

考题 You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery?()  A、 You will need to open the database with the resetlogs command.B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C、 You will use the resetlogs version of the create controlfile command.D、 You will use the noresetlogs version of the create controlfile command.E、 You will use the trace file to create a backup control file, and then you will recover the database with the recover database using backup controlfile command

考题 You work as a database administrator for Supportcenter.cn. In your production database, the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database, you want to accomplish this task with no impact on the user’s connections. Which activity must you have completed before accomplishing this task?()A、You must have started the database instance in restricted mode.B、You must have started the database instance inNORMALmode.C、You must have started the database instance with server parameter file.D、You must have started the database instance but must not have mounted.E、You must have started the database instance but must not have opened.

考题 You work as a network Exchange administrator at Company.com.The Company.com network currently consists of a single Active Directory forest containing a single site named KingSite1.The Company.com organization makes use of Microsoft Exchange Server 2010 as their messaging  solution.Company.com has recently configured the mailbox server as members of a database availability group (DAG) with a public folder database. During the course of the business week you receive instruction from Company.com to create a new Active Directory site and install Exchange server in the site whilst ensuring the public folders are stored on servers in both sites. What should you do?()A、You should consider having clustered continuous replication (CCR) configured on two servers in the new site.You should then have the replication settings for all public folder databases modified.B、You should consider having the standby continuous replication (SCR) configured on a server in the new site.You should then have the Enable-StorageGroupCopy cmdlet run from a server in the new site.C、You should consider having a public folder database created on a server in the new site.You should then have the replication settings for all public folders modified.D、You should consider having a public folder database created on a server in the new site.You should then have the set-DatabaseAvailabilityGroup cmdlet run from a server in the new site.

考题 You have an Exchange Server 2010 Service Pack 1 (SP1) Mailbox server that contains multiple mailbox databases. You need to ensure that you are notified when deleted mailboxes are purged from the server.What should you do?()A、Attach a new task to the Application event log.B、Modify the properties of the mailbox database objects.C、Create a new Data Collector Set.D、Create a new Event Viewer Subscription.

考题 You have a computer that runs Windows 7. You install a second internal hard disk drive in the computer.You attempt to create a system image and discover that the new disk is not listed as a backup destination.You need to ensure that you can use the new disk as a backup destination for system images.  What should you do?()A、Create a NTFS partition.B、Create a mirrored volume.C、Create a system repair disc.D、Log on to the computer by using a different account.

考题 You are developing an application that receives events asynchronously.You create a WqlEventQuery instance to specify the events and event conditions to which the application must respond.You also create a ManagementEventWatcher instance to subscribe to events matching the query.You need to identify the other actions you must perform before the application can receive events asynchronously.Which two actions should you perform?()A、Start listening for events by calling the Start method of the ManagementEventWatcher.B、Set up a listener for events by using the EventArrived event of the ManagementEventWatcher.C、Use the WaitForNextEvent method of the ManagementEventWatcher to wait for the events.D、Create an event handler class that has a method that receives an ObjectReadyEventArgs parameter.E、Set up a listener for events by using the Stopped event of the ManagementEventWatcher.

考题 You administer a SQL Server 2008 instance. You plan to deploy a new database to the instance. The database will be subject to frequent inserts and updates. The database will have multiple schemas. One of the schemas will contain a large amount of read-only reference data. You need to design the physical database structure for optimal backup performance. What should you do?() A、Create the database by using a single data file and a single log file.B、Create the database by using a single data file and multiple log files.C、Create the database by using a single log file and multiple filegroups.D、Create the database by using a single log file and a filegroup that has multiple data files.

考题 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.

考题 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. You are going to use the data collector to gather performance data periodically on all instances. You must store all collected data in the same database. This database is hosted on a single instance. Every five hours, you have to collect and load performance data in the management data warehouse. Which data collection process should you implement? () A、You should create a cached data collection B、You should create an on-demand non-cached data collection C、You should create a scheduled non-cached data collection. D、You should create two different SQL Agent jobs. The two jobs are scheduled at the same time. One job uploads the data collection and the other job creates a data collection.

考题 You work in a company which uses SQL Server 2008. You are the administrator of the company database. In your company there is a server which contains a default SQL Server 2005 instance. For a new application, you have to install a SQL Server 2008 instance on the server. Your company CIO assigns a task to you. You must make sure that the respective certified third-party applications have access to both database instances. You have to achieve this goal without changing the existing application environments. So what should you do to achieve this by using as little database administrative effort as possible?()A、You should install SQL Server 2008 as a named instance, and make the new application to use the new instance. B、You should install SQL Server 2008 as the default instance, and make the new application to use the default instance. C、You should upgrade the SQL Server 2005 application to use SQL Server 2008. D、You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance. 

考题 You have a listener process, L1, currently listening for the connections to the PROD and ADMIN databases. You create a new database, PAY, using CREATE  DATABASE.. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA file manually to include PAY database for L1 listener process.  Which command of Listener control utility (LSNRCTL) would you use to enable L1 process to start listening for the connections to the PAY database without disrupting any existing database communications?()A、STARTB、RELOADC、RESTARTD、REFRESHE、START L1F、RELOAD L1G、RESTART L1H、REFRESH L1

考题 单选题You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6:00 P.M. on Monday, you issue the following command:       RMANBACKUP DATABASE;  At 8:00 A.M. on Tuesday, you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP; command. Which operation should you perform before using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP; command?()A  Start the database in the MOUNT stage.B  Back up the control file to trace.C  Set the DBIDD  Issue the RECOVER DATABASE command.

考题 单选题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 which is named Sellings in the instance. The Sellings database contains a table named Productions. The table is used to stores information about all types of products. The Productions table is often queried by users on the basis of the RadioSize column. The RadioSize column contains the NULL value for all products other than Radios. Currently no index exists on the RadionSize column. According to the requirement of the company CIO, you have to optimize the query performance and reduce the effect on the disk space to the least. So what action should you perform to achieve this goal?()A On the Products table, you should create a view. B On the RadioSize column, you should create a clustered index C On the RadioSize column, you should create a filtered index D On the RadioSize column, you should create a unique clustered index

考题 单选题You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure.  How would you proceed to recover the database?()A Start the instance and open the database, instance recovery automatically recovers control files B Create a file based on the contents of the trace file and save it to the control file locations and start the database C Re-create the database (The recovery of the control file is not possible because you have lost all the control files.) D Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. E Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.

考题 多选题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 method.CThe Oracle Enterprise Manager is to be used to monitor an Oracle9i database.DThe database that is to be registered with the listener is configured in shared server mode.EThe listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.

考题 单选题You were recently hired by an organization as a database administrator. You are asked to find out whether the currently functional listener process, named L1, has been password protected or not. You are not familiar with the file system of the new organization. How would you accomplish the task?()A by using the STATUS command of the Listener control utilityB by using the STATUS L1 command of the Listener control utilityC by using the SHOW RULES command of the Listener control utilityD by using the SET PASSWORD command of the Listener control utilityE by searching for the PASSWORD_LISTENER entry in the listener.ora file

考题 单选题You have two listener processes, named L1 and L2. Both the listener processes are currently functional. While viewing the listener.ora file on your database server, you find the following entry: PASSWORDS_L1 = (1sanfrjp43) What would be the impact of this setting?()A The listener process named L1 will disconnect the unauthorized users.B The listener process named L1 will be prevented from being started by unauthorized users. C The listener process named L1 will be prevented from being stopped by unauthorized users. D The listener process named L1 will be prevented from being reloaded by unauthorized users.E The listener process named L1 will be prevented from accepting connections from unauthorized users.

考题 单选题You are maintaining the database of a company. The listener process, listener1, is configured for remote access. You have issued the following command:   LSNRCTLSTATUS listener1   Which information will NOT be displayed when you issue the above command?()A  whether the password is set in the listener or a file or notB  the number of client connections the service handler has refusedC  the information will be displayed whether the instance can accept connections or notD  the protocol addresses on which the listener is configured to listen

考题 多选题You are developing an application that receives events asynchronously.You create a WqlEventQuery instance to specify the events and event conditions to which the application must respond.You also create a ManagementEventWatcher instance to subscribe to events matching the query.You need to identify the other actions you must perform before the application can receive events asynchronously.Which two actions should you perform?()AStart listening for events by calling the Start method of the ManagementEventWatcher.BSet up a listener for events by using the EventArrived event of the ManagementEventWatcher.CUse the WaitForNextEvent method of the ManagementEventWatcher to wait for the events.DCreate an event handler class that has a method that receives an ObjectReadyEventArgs parameter.ESet up a listener for events by using the Stopped event of the ManagementEventWatcher.

考题 单选题You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database?()A Start the instance and open the database, instance recovery automatically recoverscontrol filesB Create a file based on the contents of the trace file and save it to the control file locations and start the databaseC Re-create the database (The recovery of the control file is not possible because you have lost all the control files.)D Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file.E Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.

考题 单选题You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery?()A  You will need to open the database with the resetlogs command.B  All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C  You will use the resetlogs version of the create controlfile command.D  You will use the noresetlogs version of the create controlfile command.E  You will use the trace file to create a backup control file, and then you will recover the database with the recover database using backup controlfile command

考题 多选题You work as a database administrator for Certkiller .com. Your listener process, L1,is currently listening to three databases:CertK INDB04,Certkiller DB05 and Certkiller DB06. Using Database Configuration Assistant (DBCA) you create one more database,Certkiller DB07,and enable dynamic registration.  Which two commands of Listener Control Utility (lsnrct1) would you use to determine whether the dynamic registration occurred for the database, Certkiller DB07, with the L1 listener process?()ASHOW L1BSPAWN L1CSTATUS L1DSERVICES L1ESTATUS LISTENERFSERVICES LISTENERGSHOWcurrent_listener