单选题You have two database servers SEMP and SACCT. The database in the SEMP server maintains theemployee information and the database in the SACCT server maintains the accounts payable  information.The employees submit the expense reports to the accounts payable department. A user of the accountspayable database wants to extract the employee information from the database in the SEMP server for cross-verification.  Which schema object enables the user to access the information from the remote database()AClusterBDatabase linkCMapping tableDMaterialized view

单选题
You have two database servers SEMP and SACCT. The database in the SEMP server maintains theemployee information and the database in the SACCT server maintains the accounts payable  information.The employees submit the expense reports to the accounts payable department. A user of the accountspayable database wants to extract the employee information from the database in the SEMP server for cross-verification.  Which schema object enables the user to access the information from the remote database()
A

Cluster

B

Database link

C

Mapping table

D

Materialized view


参考解析

解析: 暂无解析

相关考题:

You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.Because you have had power interruptions in the past, you want to perfect the physical integrity of the Accounts database. You do not want to slow down server operations.What should you do?A.Enable the torn page detection database option for each database.B.Disable write caching on all disk controllers.C.Ensure that write caching disk controllers have battery backups.D.Create a database maintenance plan to check database integrity and make repairs each night.

You are the administrator of two SQL Server 2000 computers. One of these servers contains a 4-GB database named marketing. You want to remove the marketing database from one server and add it to the other as quickly as possible.What should you do?A.Detach the database from the original server by using the sp_detach_db stored procedure. Copy the database and the transaction log files to the new server, and attach them by using the sp_attach_db stored procedure.B.Use the DTS export wizard to transfer all database objects from the original server to the new server. Drop the database from the original server.C.Run a full backup of the database on the original server. Create a new database named marketing on the new server. Restore the backup in the new marketing database. Drop the database from the original server.D.Shut down the original server. Copy the database and the transaction log files to the new server. Use the DISK INIT and DISK REFIT statements to attach the data file to the new server. Drop the database from the original server.

You are the administrator of three SQL Server 2000 computers at Five Lakes Publishing. One server, FLPSQL01, stores order data. You want to be able to use the other two servers, FLPSQL02 and FLPSQL03, to answer queries and run report. The planned network configuration is shown in the exhibit.You want to use the database Maintenance Plan wizard to configure log shipping from FLPSQL01 to FLPSQL02 and FLPSQL03. You do not want users to add any new data on FLPSQL02 and FLPSQL03, but they must be able to run queries and reports.Which two actions should you take? (Each correct answer presents part of the solution. Choose two)A.Set the database load state for each destination server to No recovery mode.B.Set the database load state for each destination server to standby mode.C.Enable the allow database to assume primary role option for both destination servers.D.Enable the allow database to assume primary role option for one destination server and then disable this option for other destination server.E.Disable the allow database to assume primary role option for both destination servers.

You are the administrator of two Microsoft Windows 2000 advanced server computers. On these servers, you are configuring a database that will store accounting information for your company.The data must be available at all times. Interruptions in data connectivity should not last longer than five minutes. Any changes to the database should not require you to reconfigure the client computers.How should you configure the database?A.Configure the database on the two servers as a SQL Server 2000 cluster.B.Configure the database on one server, and then configure a standby database on the second server.C.Configure the database on each server. Use Microsoft Distributed Transaction Coordinator to keep the two servers perfectly synchronized.D.Configure the database as a federated database, and then partition half the data on each server.

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 two database servers SEMP and SACCT. The database in the SEMP server maintains the employeeinformation and the database in the SACCT server maintains the accounts payable information. The employeessubmit the expense reports to the accounts payable department. A user of the accounts payable databasewants to extract the employee information from the database in the SEMP server for cross-verification.  Whichschema object enables the user to access the information from the remote database()A、ClusterB、Database linkC、Mapping tableD、Materialized view

You have two database servers SEMP and SACCT. The database in the SEMP server maintains theemployee information and the database in the SACCT server maintains the accounts payable  information.The employees submit the expense reports to the accounts payable department. A user of the accountspayable database wants to extract the employee information from the database in the SEMP server for cross-verification.  Which schema object enables the user to access the information from the remote database()A、ClusterB、Database linkC、Mapping tableD、Materialized view

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 ControlB、Management ServerC、Management RepositoryD、Application Server ControlE、Oracle Management Agent

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 an internal application which uses Analysis Services and Reporting Services. You use the application on the basis of SQL Server 2008. According to the requirement of company security policy, the surface area for all the deployed components of SQL Server 2008 should be configured. You have to implement the security policy and devise a method to evaluate the security policy against other database servers. What should you do?()  A、You should create policies based on the appropriate facets. Apply the policies against a server group. The server group includes the database servers that need to be configured B、You should create a Transact-SQL script based on the sp_configure stored procedure. Use a configuration server to run the script against a server group that includes the database servers that need to be configured C、You should edit the RSReportServer.config configuration file. Distribute the file to all database servers that need to be configured D、You should analyze your database servers by using the SQL Server Best Practices Analyzer (BPA). Implement the recommendations of the BPA

You need to design a Windows Server Update Services (WSUS) infrastructure that meets the  following requirements:   èThe updates must be distributed from a central location.   èAll computers must continue to receive updates in the event that a server fails. What should you include in your design?()A、Configure two WSUS servers in a Microsoft SQL Server 2008 failover cluster. Configure each WSUS  server to use a local database.B、Configure a single WSUS server to use multiple downstream servers. Configure each WSUS server touse a RAID 1 mirror and a local database.C、Configure a single WSUS server to use multiple downstream servers. Configure each WSUS server to  use a RAID 5 array and a local database.D、Configure a Microsoft SQL Server 2008 failover cluster. Configure two WSUS servers in a Network Load Balancing cluster. Configure WSUS to use the remote SQL Server 2008 database instance.

You have an Exchange Server 2010 organization that contains 20 Mailbox servers.You plan to create 10 mailbox databases on each Mailbox server. You need to create a naming convention for all mailbox databases.  What should you include in your naming convention()?  A、For each mailbox database, provide a database name that is unique within the organization.B、For each mailbox database, provide a database name that is unique within the Mailbox server.C、For each mailbox database file, provide a file name that is unique within the organization.D、For each mailbox database file, provide a file name that is unique within the Mailbox server.

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 foldersB、Create a public folder database on a server in the new site.Run the Set-DatabaseAvailabilityGroup cmdlet from a server in the new siteC、Configure clustered continuous replication (CCR) on two servers in the new site. Modify the replication settings for all public folder databasesD、Configure standby continuous replication (SCR) on a server in the new site. Run the Enable-StorageGroupCopy cmdlet from a server in the new site

Your company has a single Active Directory domain. You have 30 database servers that run Windows Server 2008 R2.   The computer accounts for the database servers are stored in an organizational unit (OU) named Data.   The user accounts for the database administrators are stored in an OU named Admin. The database administrators are members of a global group named D_Admins.   You must allow the database administrators to perform administrative tasks on the database servers. You must prevent the database administrators from performing administrative tasks on other servers. What should you do?()A、Deploy a Group Policy to the Data OU.B、Deploy a Group Policy to the Admin OU.C、Add D_Admins to the Domain Admins global group.D、Add D_Admins to the Server Operators built-in local group.

You are the administrator of a Microsoft Windows Server 2003 computer named Server1. SQL Server 2005 is installed on Server1 to host a database named MedDB. The MedDB database serves as the backend database for a new client/server application named MedDATA. Installation of the MedDATA application creates the database schema, application roles, and administrative accounts. It also sets all of the default permissions. You need to establish a permissions baseline for all objects in the MedDB database.  What should you do?()A、Use the SQL Server 2005 Management Studio to review the permissions of the default database objects.B、Query the sys.server_permissions table on Server1.C、Execute the sp_helplogins system stored procedure for each of the default users that the MedDATA application creates.D、Query the sys.database_permissions and sys.database_principals tables in the MedDB database.

You are the network administrator for TestKing. The network consists of a single Active Directory domain named testking.com. All domain controller run Windows Server 2003. employes three database administrators who administer seven databases servers that run Windows Server 2003. The database administrators occasionally restore a database server after a disaster. To restore a server, database administrators need the rights required to perform the following tasks: 1. Back up files and folders 2. Restore files and folders. 3. Restore the System State data. You need to assign the database administrators the rights that they require to perform the specified tasks. For security reasons, you must not assign the administrators more rights than they require to perform the tasks. What should you do?()A、Add the database administrators' user accounts to the Administrators group on each of the database servers.B、Add the database administrators' user accounts to the Power Users group on each of the database servers.C、Add the database administrators' user accounts to the Backup Operators group on each of the database servers.D、Add the database administrators' user accounts to the Backup Operators group on one of the domain controllers.E、Add the database administrators' user accounts to the Server Operators group on one of the domain controllers.

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 single Database Mail profile. Reports are sent to all the company employees by using the Mail profile. During office hours, a large volume of reports are sent by the sp_send_dbmail stored procedure. Now you notice that it takes a long time for the reports to be sent to the company manager. As the technical support, you have to speed up the delivery. So what action should you perform to achieve this goal?()  A、Another SMTP account should be added to the existing Database Mail profile B、When you send the reports to the manager, you should use the @importance = high parameter. C、You should change the Account Retry Attempts option of the Database Mail system properties D、You should configure a new Database Mail profile. The new one will be used for sending the reports to the manager.

单选题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?()ADatabase ControlBManagement ServerCManagement RepositoryDApplication Server ControlEOracle Management Agent

单选题You have an Exchange Server 2010 organization.The organization contains two Mailbox servers named Server1 and Server2.Both servers are members of a database availability group (DAG) named DAG1.Server1 and Server2 have a copy of a mailbox database named DB1.You need to remove the copy of DB1 from Server1.What should you do?()AFrom the Exchange Management Shell, run Clean-MailboxDatabase -Identity DB1.BFrom the Exchange Management Shell, run Remove-MailboxDatabase -Identity DB1/Server1.CFrom the Exchange Management Console (EMC), right-click the database copy and select Remove.DFrom the Exchange Management Console (EMC), right-click DAG1 and select Manage Database Availability Group Membership.Remove Server1 from the list and click Manage.

单选题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?()ACreate a public folder database on a server in the new site. Modify the replication settings for all public foldersBCreate a public folder database on a server in the new site.Run the Set-DatabaseAvailabilityGroup cmdlet from a server in the new siteCConfigure clustered continuous replication (CCR) on two servers in the new site. Modify the replication settings for all public folder databasesDConfigure standby continuous replication (SCR) on a server in the new site. Run the Enable-StorageGroupCopy cmdlet from a server in the new site

单选题You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employeeinformation and the database in the SACCT server maintains the accounts payable information. The employeessubmit the expense reports to the accounts payable department. A user of the accounts payable databasewants to extract the employee information from the database in the SEMP server for cross-verification.  Whichschema object enables the user to access the information from the remote database()AClusterBDatabase linkCMapping tableDMaterialized view

单选题You are the administrator of a Microsoft Windows Server 2003 computer named Server1. SQL Server 2005 is installed on Server1 to host a database named MedDB. The MedDB database serves as the backend database for a new client/server application named MedDATA. Installation of the MedDATA application creates the database schema, application roles, and administrative accounts. It also sets all of the default permissions. You need to establish a permissions baseline for all objects in the MedDB database.  What should you do?()AUse the SQL Server 2005 Management Studio to review the permissions of the default database objects.BQuery the sys.server_permissions table on Server1.CExecute the sp_helplogins system stored procedure for each of the default users that the MedDATA application creates.DQuery the sys.database_permissions and sys.database_principals tables in the MedDB database.

单选题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 single Database Mail profile. Reports are sent to all the company employees by using the Mail profile. During office hours, a large volume of reports are sent by the sp_send_dbmail stored procedure. Now you notice that it takes a long time for the reports to be sent to the company manager. As the technical support, you have to speed up the delivery. So what action should you perform to achieve this goal?()AAnother SMTP account should be added to the existing Database Mail profile BWhen you send the reports to the manager, you should use the @importance = high parameter. CYou should change the Account Retry Attempts option of the Database Mail system properties DYou should configure a new Database Mail profile. The new one will be used for sending the reports to the manager.

单选题Your company has a single Active Directory domain. You have 30 database servers that run Windows Server 2008 R2.   The computer accounts for the database servers are stored in an organizational unit (OU) named Data.   The user accounts for the database administrators are stored in an OU named Admin. The database administrators are members of a global group named D_Admins.   You must allow the database administrators to perform administrative tasks on the database servers. You must prevent the database administrators from performing administrative tasks on other servers. What should you do?()ADeploy a Group Policy to the Data OU.BDeploy a Group Policy to the Admin OU.CAdd D_Admins to the Domain Admins global group.DAdd D_Admins to the Server Operators built-in local group.

单选题You need to design a Windows Server Update Services (WSUS) infrastructure that meets the  following requirements:   èThe updates must be distributed from a central location.   èAll computers must continue to receive updates in the event that a server fails. What should you include in your design?()AConfigure two WSUS servers in a Microsoft SQL Server 2008 failover cluster. Configure each WSUS  server to use a local database.BConfigure a single WSUS server to use multiple downstream servers. Configure each WSUS server touse a RAID 1 mirror and a local database.CConfigure a single WSUS server to use multiple downstream servers. Configure each WSUS server to  use a RAID 5 array and a local database.DConfigure a Microsoft SQL Server 2008 failover cluster. Configure two WSUS servers in a Network Load Balancing cluster. Configure WSUS to use the remote SQL Server 2008 database instance.

单选题You are the network administrator for TestKing. The network consists of a single Active Directory domain named testking.com. All domain controller run Windows Server 2003. employes three database administrators who administer seven databases servers that run Windows Server 2003. The database administrators occasionally restore a database server after a disaster. To restore a server, database administrators need the rights required to perform the following tasks: 1. Back up files and folders 2. Restore files and folders. 3. Restore the System State data. You need to assign the database administrators the rights that they require to perform the specified tasks. For security reasons, you must not assign the administrators more rights than they require to perform the tasks. What should you do?()AAdd the database administrators' user accounts to the Administrators group on each of the database servers.BAdd the database administrators' user accounts to the Power Users group on each of the database servers.CAdd the database administrators' user accounts to the Backup Operators group on each of the database servers.DAdd the database administrators' user accounts to the Backup Operators group on one of the domain controllers.EAdd the database administrators' user accounts to the Server Operators group on one of the domain controllers.

单选题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 an internal application which uses Analysis Services and Reporting Services. You use the application on the basis of SQL Server 2008. According to the requirement of company security policy, the surface area for all the deployed components of SQL Server 2008 should be configured. You have to implement the security policy and devise a method to evaluate the security policy against other database servers. What should you do?()AYou should create policies based on the appropriate facets. Apply the policies against a server group. The server group includes the database servers that need to be configured BYou should create a Transact-SQL script based on the sp_configure stored procedure. Use a configuration server to run the script against a server group that includes the database servers that need to be configured CYou should edit the RSReportServer.config configuration file. Distribute the file to all database servers that need to be configured DYou should analyze your database servers by using the SQL Server Best Practices Analyzer (BPA). Implement the recommendations of the BPA

单选题You have an Exchange Server 2010 organization that contains 20 Mailbox servers.You plan to create 10 mailbox databases on each Mailbox server. You need to create a naming convention for all mailbox databases.  What should you include in your naming convention()?AFor each mailbox database, provide a database name that is unique within the organization.BFor each mailbox database, provide a database name that is unique within the Mailbox server.CFor each mailbox database file, provide a file name that is unique within the organization.DFor each mailbox database file, provide a file name that is unique within the Mailbox server.