单选题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 followi

题目
单选题
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 client

B

to restrict the scope of administration to identical operating systems

C

to allow the start up and shut down of the database from a remote client

D

to enable the administration of the operating system from a remote client

E

to disable the administration of the operating system from a remote client

相似考题

1. You are using a recovery catalog to maintain Recovery Manager （RMAN） backup information for your production database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups.  Identify two options for completing this task.（）A、 Reregistering the target database in recovery catalogB、 Transporting the new tablespaces to the recovery catalog databaseC、 Syncronizing the recovery catalog with the target database control fileD、 Performing a fresh backup of the target database to include the new data files in the catalog database

2. You work as a database administrator for Certkiller .com. 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.

3.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.

4.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？（）A、Application Server ControlB、Oracle Management ServiceC、Oracle Enterprise Manager RepositoryD、Oracle Enterprise Manager Database Control

更多“单选题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 followi”相关问题

  • 第1题：

    In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）

    • A、the V$LOG view
    • B、the V$DBFILE view
    • C、the V$LOGFILE view
    • D、the V$INSTANCE_RECOVERY view
    • E、Oracle Enterprise Manager Database Control

    正确答案:D,E

  • 第2题：

    In your production database， you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation， you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members.  Which two actions would you take to improve the performance of the database server？ （）

    • A、increase the size of the redo log buffer
    • B、increase the number of redo log groups
    • C、increase the number of log writer processes
    • D、increase the number of ARCn processes
    • E、change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location

    正确答案:B,E

  • 第3题：

    You work as a database administrator for Certkiller .com. 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 Control
    • B、Management Server
    • C、Management Repository
    • D、Application Server Control
    • E、Oracle Management Agent

    正确答案:E

  • 第4题：

    You have an Exchange Server 2010 organization that contains three Mailbox servers.All Mailbox servers are members of a database availability group （DAG） and have a public folder database.The Active Directory forest contains one site.You create a new site and install new Exchange Server 2010 servers in the site.You need to ensure that public folders are stored on servers in both sites.What should you do？（）

    • A、Create a public folder database on a server in the new site. Modify the replication settings for all public folders
    • B、Create a public folder database on a server in the new site.Run the Set-DatabaseAvailabilityGroup cmdlet from a server in the new site
    • C、Configure clustered continuous replication （CCR） on two servers in the new site. Modify the replication settings for all public folder databases
    • D、Configure standby continuous replication （SCR） on a server in the new site. Run the Enable-StorageGroupCopy cmdlet from a server in the new site

    正确答案:A

  • 第5题：

    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 must make sure that all SQL Server instances are consistently configured for naming conventions, security settings, force index creation and avoidance of data fragmentation. So what action should you perform to achieve this goal?（）  

    • A、You should use the Database Engine Tuning Advisor. 
    • B、In Microsoft SQL Server Management Studio, you should create a maintenance plan 
    • C、You should use the SQL Server Configuration Manager 
    • D、In Microsoft SQL Server Management Studio, you should create a policy

    正确答案:D

  • 第6题：

    多选题
    In your production database， you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation， you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members.  Which two actions would you take to improve the performance of the database server？ （）
    A

    increase the size of the redo log buffer

    B

    increase the number of redo log groups

    C

    increase the number of log writer processes

    D

    increase the number of ARCn processes

    E

    change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location


    正确答案： B,E
    解析： 暂无解析

  • 第7题：

    单选题
    You are part of the DBA team working for a multinational bank. The team is responsible for performing administrative tasks on the database server located at the home office. The database server at the home office has a production database and a test database named TESTDB. The test database is primarily used for testing database commands and configuration settings befor implementing these settings on the production database. The test database is also used for the development of database applications. You have been asked by the senior DBA to grant the SYSDBA privilege to a new team member， John， so that he can perform some administrative tasks， such as shutdown and startup operations， on TESTDB. You use the password file to configure remote authentication on the TESTDB database. You execute the following statement to grant the SYSDBA privilege to John：   SQL>GRANT SYSDBA TO john；   However， you receive the following error：   ORA-01996： GRANT failed： password file   ’c：/oracle/ora9i/dbs/testdb.pwd’ is full   Which action should you take to add the user john to the password file without removing any of the existing users？（）
    A

     Create another password file and then re-execute the GRANT statement.

    B

     Re-create the password file， specifying a larger number of allowed entries， and then re-execute the GRANT statement.

    C

     Change the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter in theinitialization parameter file to NONE and then re-execute the GRANT statement.

    D

     Change the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter in the initialization parameter file to SHARED and then re-execute the GRANT statement.


    正确答案： B
    解析： 暂无解析

  • 第8题：

    单选题
    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 client

    B

    to restrict the scope of administration to identical operating systems

    C

    to allow the start up and shut down of the database from a remote client

    D

    to enable the administration of the operating system from a remote client

    E

    to disable the administration of the operating system from a remote client


    正确答案： A
    解析： 暂无解析

  • 第9题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第10题：

    单选题
    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 must make sure that all SQL Server instances are consistently configured for naming conventions, security settings, force index creation and avoidance of data fragmentation. So what action should you perform to achieve this goal?（）
    A

    You should use the Database Engine Tuning Advisor. 

    B

    In Microsoft SQL Server Management Studio, you should create a maintenance plan 

    C

    You should use the SQL Server Configuration Manager 

    D

    In Microsoft SQL Server Management Studio, you should create a policy


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    You work as a database administrator for Certkiller .com. 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.


    正确答案： E
    解析： 暂无解析

  • 第12题：

    多选题
    In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）
    A

    the V$LOG view

    B

    the V$DBFILE view

    C

    the V$LOGFILE view

    D

    the V$INSTANCE_RECOVERY view

    E

    Oracle Enterprise Manager Database Control


    正确答案： A,C
    解析： 暂无解析

  • 第13题：

    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 client
    • B、to restrict the scope of administration to identical operating systems
    • C、to allow the start up and shut down of the database from a remote client
    • D、to enable the administration of the operating system from a remote client
    • E、to disable the administration of the operating system from a remote client

    正确答案:A

  • 第14题：

    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 DB  A. 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 client
    • B、to restrict the scope of administration to identical operating systems
    • C、to allow the start up and shut down of the database from a remote client
    • D、to enable the administration of the operating system from a remote client
    • E、to disable the administration of the operating system from a remote client

    正确答案:A

  • 第15题：

    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.

    正确答案:C

  • 第16题：

    You work in a company which 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. You put forward a database maintenance plan. The maintenance plan rebuilds indexes, checks database integrity, writes a report to a text file. Now the company requires that when the maintenance plan executes abnormally, the operators can be notified by an e-mail message. You've been assigned this task. So you have to make modifications on the SQL Server instance. What should you do?（）

    • A、For the SQL Server Agent, you should enable a fail-safe operator 
    • B、You should modify the database maintenance plan, making it send an e-mail to the appropriate operators 
    • C、You should modify the database maintenance plan, making it include a Notify Operator task that e-mails the appropriate operators. 
    • D、You should modify the SQL Server Agent job. The job executes the database maintenance plan to notify the appropriate operators.

    正确答案:D

  • 第17题：

    You work as an administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. All servers on the ABC.com network have Windows Server 2008 R2 installed. Some of ABC.com’s workstations have Windows 7 installed， while the rest have Windows 8 installed.  After installing a new Windows Server 2012 R2 computer in the ABC.com domain， you configure it to run the File and Storage Services server role.You are instructed to create a shared folder on the new server， and configure the use of Previous Versions for restoring files located in the shared folder.  Which of the following actions should you take？（）

    • A、You should consider configuring the Shadow Copies settings on the new server.
    • B、You should consider configuring the Snapshot settings on the new server.
    • C、You should consider configuring the Background Copy settings on the new server.
    • D、You should consider configuring the Permission settings on the new server.

    正确答案:A

  • 第18题：

    单选题
    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 Control

    B

    Management Server

    C

    Management Repository

    D

    Application Server Control

    E

    Oracle Management Agent


    正确答案： E
    解析： 暂无解析

  • 第19题：

    单选题
    You have a Web server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). You replace the network adapter. Users report that they are unable to access Server1. You need to ensure that users can access Server1. What should you do?（）
    A

    From Network Connections, configure the Provider Order settings.

    B

    From Network Connections, configure the Adapters and Bindings settings.

    C

    From the Local Area Connection properties, configure the Internet Protocol (TCP/IP) settings.

    D

    From the Local Area Connection properties, configure the File and Printer Sharing for Microsoft Networks settings.


    正确答案： B
    解析： 暂无解析

  • 第20题：

    单选题
    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 DB  A. 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 client

    B

    to restrict the scope of administration to identical operating systems

    C

    to allow the start up and shut down of the database from a remote client

    D

    to enable the administration of the operating system from a remote client

    E

    to disable the administration of the operating system from a remote client


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    You have an Exchange Server 2010 organization that contains three Mailbox servers.All Mailbox servers are members of a database availability group （DAG） and have a public folder database.The Active Directory forest contains one site.You create a new site and install new Exchange Server 2010 servers in the site.You need to ensure that public folders are stored on servers in both sites.What should you do？（）
    A

    Create a public folder database on a server in the new site. Modify the replication settings for all public folders

    B

    Create a public folder database on a server in the new site.Run the Set-DatabaseAvailabilityGroup cmdlet from a server in the new site

    C

    Configure clustered continuous replication （CCR） on two servers in the new site. Modify the replication settings for all public folder databases

    D

    Configure standby continuous replication （SCR） on a server in the new site. Run the Enable-StorageGroupCopy cmdlet from a server in the new site


    正确答案： B
    解析： 暂无解析

  • 第22题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    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. The server has a very large database named DB1. An application which is constantly available uses DB1. Now you get a report from users, in the report users complain that server has a poor performance. As the technical support, you have to improve the performance of the application by using the Database Engine Tuning Advisor. Besides this, you must make sure that the action of analyzing the workload will not affect the performance of the production server.So what should you do?（）
    A

    On the local server, enable the XP_MSVER stored procedure 

    B

    On the remote server, enable the XP_MSVER stored procedure. 

    C

    On the production server, use the dta.exe utility along with an XML input file. 

    D

    You should configure a test server that has a similar hardware configuration. Use the dta.exe utility on the test server along with an XML input file


    正确答案： D
    解析： 暂无解析

  • 第24题：

    单选题
    Your network consists of a single Active Directory domain. You have a terminal server that runs Windows Server 2003 Service Pack 2 (SP2). You need to prevent users from establishing multiple Remote Desktop connections to the server. What should you do?（）
    A

    Install and configure Terminal Server Licensing.

    B

    From Terminal Services Manager, modify the user sessions.

    C

    From Terminal Services Configuration, modify the server settings.

    D

    From Active Directory Users and Computers, modify the Sessions settings for each user account.


    正确答案： B
    解析： 暂无解析

相关内容