多选题Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP OFF； RMAN BACKUP DATABASE； Which files from the database will be backed up as a result of this BACKUP command？（）Acontrol fileBall datafilesCpassword fileDonline redo log fileEarchive redo log fileFserver parameter fileGonly the SYSTEM datafile
多选题
Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt： RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF； RMAN> BACKUP DATABASE； Which files from the database will be backed up as a result of this BACKUP command？（）
A
control file
B
all datafiles
C
password file
D
online redo log file
E
archive redo log file
F
server parameter file
G
only the SYSTEM datafile
参考解析
解析：
暂无解析
相关考题：
You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:What is the outcome of the above commands?（）A. They execute and create a virtual catalog for pre-Oracle 11g clients.B. They produce an error because PROD1 and PROD2 databases belong to the older version.C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.D. They produce an error because you need to connect to the target database to execute this packaged procedure.
In your database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command:Which authentication method would be used first?（）A. authentication by password fileB. authentication by using certificates over SSLC. authentication by using the Oracle Internet DirectoryD. authentication by using the local OS of the database server
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
WebSphere Commerce has been successfully installed and tested. WebSphere Commerce Analyzer has been installed and the extraction programs have run with no errors but there is no data in any reports when viewed from the WebSphere Commerce Accelerator. What could be the cause of this problem？（）A、The WebSphere Commerce application server was not startedB、The web server was not startedC、SSL has not been configured on the web serverD、The appropriate listeners were not enabled in Configuration ManagerE、The database server was not started
Company.com has a database application and a Web server application running on the same p5-570 server in a single partition. Recently there have been a number of instances where the increased load on the database server has impacted the performance of the Web server. What can the technical specialist recommend to keep the database application from impacting the performance of the Web server？（）A、Create a VLAN between the web server and database server.B、Purchase APV and install the VIOS.C、Increase the priority of the Web server.D、Create separate LPARs for Web and database workloads.
After installing WebSphere Commerce V 5.6 using a quick installation， which of the following should be checked to verify the installation？（）A、The installation log filesB、The Commerce tools can be launched and logged into properlyC、User ’wpadmin’ has been createdD、The structure of the installation directoryE、The WebSphere Application Server database schema
Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP OFF； RMAN BACKUP DATABASE； Which files from the database will be backed up as a result of this BACKUP command？（）A、 control fileB、 all datafilesC、 password fileD、 online redo log fileE、 archive redo log fileF、 server parameter fileG、 only the SYSTEM datafile
You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set. How will you migrate your database from UTF8 to AL16UTF16？（） A、 by using the RMAN utilityB、 by using the export/import utilityC、 by using the ALTER DATABASE commandD、 by enabling the change tracking feature
You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings， you find that the following parameter has been set in the parameter file of the database： REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE？（）A、to enable operating system authentication for a remote clientB、to restrict the scope of administration to identical operating systemsC、to allow the start up and shut down of the database from a remote clientD、to enable the administration of the operating system from a remote clientE、to disable the administration of the operating system from a remote client
In your database，the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory （OID）. SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command：$ SQLPLUS scott/tiger@DB01 AS SYSDBA where DB01 is the net service name. Which authentication method would be used first？（） A、 authentication by password fileB、 authentication by using certificates over SSLC、 authentication by using the Oracle Internet DirectoryD、 authentication by using the local OS of the database server
A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）A、 backup database allB、 backup compressed databaseC、 backup as compressed backupset databaseD、 backup as compressed backup database plus archivelog allE、 backup as compressed backupset database plus compress archivelog all
You observe that in your PROD database， customer information is being modified by some unauthorized users. You want to keep track of all of the transactions happening on the table using PL/SQL. Which type of PL/SQL subprogram or construct would you use to accomplish this task？（）A、functionsB、packagesC、proceduresD、database triggersE、anonymous PL/SQL block
You are a systems administrator who is attempting to troubleshoot a problem with accessing a Web site ona computer running Windows Server 2008. In the past， users have been able to access the Web site byusing http：//hr.contoso.com. However， when they attempt to access the site now， they receive the errormessage "Internet Explorer Cannot Display The Web page." Which of the following steps should you taketo resolve the error？（）A、Using Server Manager， add the HTTP Errors server role.B、Using Server Manager， verify that the World Wide Web Publishing Service has been started.C、Verify the configuration of the usersWeb browsers.D、Using Server Manager， add the HTTP Logging server role.
单选题Your company has two SQL Server 2005 computers named SQL1 and SQL2. A user in your company named Eric writes many ad hoc queries against the company databases. Eric has access to the Customer database on SQL1. He does not have access to the Sales database on SQL2. You need to ensure that Eric can write queries that join information from both servers. What should you do first?（）ACreate a linked server on SQL1 to SQL2. Configure the linked server to use impersonation. BCreate a linked server on SQL1 to SQL2. Configure the linked server to use mapped logins. CInstruct Eric to write the queries on SQL2 by using the OPENQUERY statement and specifying SQL1 as the server name. DInstruct Eric to specify SQL Server object names by using four-part notation.
单选题You have created a baseline metric， DISK_IO_BL， for the disk I/O metrics in your PROD database and you have been getting notifications whenever the database performance degrades. You optimize the database I/O to gain the performance and you decide to remove the baseline metrics. Which method would you use to remove the DISK_IO_BL baseline metrics？（）AThe baseline， once created， cannot be removed.BDisable the baseline metrics in the Database Control Manage Metrics page.CThe baseline will be automatically removed once the database performance has been optimized.DDrop the baseline metrics by usingDBMS_WORKLOAD_REPOSITORY.DROP_BASELINE procedure.
单选题You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings， you find that the following parameter has been set in the parameter file of the database： REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE？（）Ato enable operating system authentication for a remote clientBto restrict the scope of administration to identical operating systemsCto allow the start up and shut down of the database from a remote clientDto enable the administration of the operating system from a remote clientEto disable the administration of the operating system from a remote client
单选题Users in your PROD database complain about the slow response of the transactions. While investigating the reason， you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）Aincrease the undo retentionBcreate more undo segmentsCcreate another undo tablespaceDincrease the size of the undo tablespace
单选题A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）A backup database allB backup compressed databaseC backup as compressed backupset databaseD backup as compressed backup database plus archivelog allE backup as compressed backupset database plus compress archivelog all
多选题After installing WebSphere Commerce V 5.6 using a quick installation， which of the following should be checked to verify the installation？（）AThe installation log filesBThe Commerce tools can be launched and logged into properlyCUser ’wpadmin’ has been createdDThe structure of the installation directoryEThe WebSphere Application Server database schema
单选题Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?（）AWhen you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.BWhen a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.CWhen a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.DWhen you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.
单选题Clients using Cisco-LEAP and EAP-FAST authentication are having no problems logging on to thewireless network， but clients using PEAP are failing to log on. Which situation would result in thistype ofproblem？（）APosture validation has not been enabledBThe AAA server is set to accept both MS-CHAP v2 and GTC for PEAP authenticationCClients and server are not using certificatesDClients have been set to validate the server identity
单选题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？（）AYou must have started the database instance in restricted mode.BYou must have started the database instance inNORMALmode.CYou must have started the database instance with server parameter file.DYou must have started the database instance but must not have mounted.EYou must have started the database instance but must not have opened.
单选题You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）AConfigure Java Pool to cache the java objects.BConfigure Streams Pool to enable parallel processing.CIncrease Shared Pool size to cache more PL/SQL objects.DIncrease Database Buffer Cache size to increase cache hits.EConfigure Large Pool to be used by RMAN and shared server.FIncrease the total System Global Area （SGA） size to increase memory hits.
单选题You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set. How will you migrate your database from UTF8 to AL16UTF16？（）A by using the RMAN utilityB by using the export/import utilityC by using the ALTER DATABASE commandD by enabling the change tracking feature
单选题The production database has been functional for the last seven days. Because of application requirements， some of the initialization parameters were changed during run time without any comments. You have been asked to find out the value of the parameters when the instance was started. Which source would you use to locate this information？（）Afixed viewsBthe alert log fileCthe parameter fileDthe server parameter fileEdynamic performance views
单选题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？（）ASQL*PlusBiSQL*PlusCManagement ServerDManagement RepositoryEOracle Enterprise Manager 10g Database Control
多选题You work as a database administrator for Supportcenter.cn. You want to administer your database servers， which are running on different host machines， using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）AApplication Server ControlBOracle Management ServiceCOracle Enterprise Manager RepositoryDOracle Enterprise Manager Database Control