itgle.com

单选题A database administrator would like to examine repartitioning options for a partitioned database named PRODDB. A workload has been captured on the system (Windows) and is stored in a file named WORKLOAD.SQL. What is the proper command to run the Design

题目
单选题
A database administrator would like to examine repartitioning options for a partitioned database named PRODDB. A workload has been captured on the system (Windows) and is stored in a file named WORKLOAD.SQL. What is the proper command to run the Design Advisor so that it will evaluate the information stored in the file and give advice on re-partitioning?（）
A

db2advis -d proddb -i workload.sql -P  

B

db2advis -d proddb -i workload.sql -partitioning  

C

db2advis -d proddb -i workload.sql -m P  

D

db2advis -d proddb -i workload.sql -m ALL 

相似考题

1.In the ORACLE system, sets of SQL statements and control flow statements that have been named, compiled ,and stored in database are referred to as storedA．batchesB．proceduresC．triggersD．transactions

2. In your database， the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command：   SQL>SELECT /*+ RESULT_CACHE */ sale_category， sum（sale_amt） FROM sales  GROUP BY sale_category；   Where would the result of this query be stored（）？  A、 database buffer cacheB、 shared poolC、 PGAD、 large pool

3.An administrator has added a new device to a system and wants to determine if it has been correctly added to the ODM database. Which command would the system administrator use？（）A、odmgetB、odmaddC、odmshowD、odmcreate

4.You are the administrator of a SQL Server 2000 computer. The server contains database named Sales. Users report that they cannot add new data to the database. You examine the properties of the database. The database is configured as shown in the Sales Properties exhibit.You examine drive E. The hard disk is configured as shown in the Local Disk Properties exhibit.You want the users to be able to add data, and you want to minimize administrative overhead. What should you do?A．Increase the maximum file size of Sales_Data to 1,500MB.B．Use the DBCC SHRINKDATABASE statement.C．Set automatic file growth to 10 percent.D．Create another data file named Sales_Data2 in a new SECONDARY filegroup.

更多“单选题A database administrator would like to examine repartitioning options for a partitioned database named PRODDB. A workload has been captured on the system (Windows) and is stored in a file named WORKLOAD.SQL. What is the proper command to run the Design”相关问题

  • 第1题：

    What is the proper way to ensure that updates to the /etc/aliases file are seen by sendmail？（）

    • A、Refresh the named daemon
    • B、Run the alias command
    • C、Refresh the snmpd daemon
    • D、Run the sendmail -bi command

    正确答案:D

  • 第2题：

    A customer has a combination of fifteen Windows file servers with direct attached storage and three Power Systems with AIX database servers SAN attached to a DS4700. They would like to upgrade and plan for 40 TB capacity. The customer needs to move to a more scalable storage system to include all servers. Which of the following would be most appropriate to ask first？（）

    • A、What are Disaster Recoveryplans
    • B、What are plans for datamigration
    • C、What storage system space isavailable
    • D、DoesiSCSI meet the needs

    正确答案:B

  • 第3题：

    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 utility
    • B、 by using the STATUS L1 command of the Listener control utility
    • C、 by using the SHOW RULES command of the Listener control utility
    • D、 by using the SET PASSWORD command of the Listener control utility
    • E、 by searching for the PASSWORD_LISTENER entry in the listener.ora file

    正确答案:B

  • 第4题：

    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 Dworks in the instance. The Dworks database has a table named Orderthings. According to the company requirement, you have to export all data from the Orderthings table to a file. During the export, you must make sure that the data export process is saved for reuse and a Microsoft Office Open XML document format is used. What should you do?（）  

    • A、You should run the bulk copy program utility along with an output file and no format file
    • B、You should run the SQLCmd utility and save the output to a file
    • C、You should run the SQL Import and Export Data Wizard and save the output to a file.
    • D、You should run the bulk copy program utility along with a format file and an output file.

    正确答案:C

  • 第5题：

    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.

    正确答案:A

  • 第6题：

    Your network contains an Exchange Server 2010 Mailbox server.The server has one mailbox database.A user named User1 reports that he has multiple corrupted e-mail messages in his mailbox.You need to recover User1ˉs -mail messages.The solution must not delete any other e-mail messages in the mailbox database.What should you do？（）

    • A、Create a new Mailbox Recovery Database， restore a backup of the database file， and then run the Export-Mailbox cmdlet.
    • B、Create a new Mailbox Recovery Database， restore a backup of the database file， and then run the Restore-Mailbox cmdlet.
    • C、Create a database availability group （DAG）， restore a backup of the mailbox database file， and then run the Restore-Mailbox cmdlet.
    • D、Create a database availability group （DAG）， restore a backup of the mailbox database file， and then run the Export-Mailbox cmdlet.

    正确答案:B

  • 第7题：

    单选题
    You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files： % rman target / What would be the effect of this command？（）
    A

     RMAN would use the current operating system location to place the backup.

    B

     RMAN would use the control file of the target database to maintain the backup.

    C

     RMAN would use the recovery catalog of the target database to maintain the backup.

    D

     RMAN would use the control file of the target database to maintain the backup metadata.

    E

     RMAN would use the recovery catalog of the target database to maintain the backup metadata.


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

  • 第8题：

    单选题
    While installing an application， the administrator is instructed to perform two final tasks prior to starting the application：   1.Set the ownership of a file named ’control_file’ to be owned by the user ’database’ and the group ’appsrvr’.   2.Change the permissions of ’control_file’ to 0766.   After these two tasks have been completed， what will the file permissions look like when ’ls -l control_file’ is executed？（）
    A

    -rwxrw-rw- 1 database appsrvr 4913 Mar 17 08：24 control_file

    B

    -rw-r--r-- 1 appsrvr database 4913 Mar 17 08：24 control_file

    C

    -rw-r--r-- 1 database appsrvr 4913 Mar 17 08：24 control_file

    D

    -rwxrw-rw- 1 appsrvr database 4913 Mar 17 08：24 control_file


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

  • 第9题：

    单选题
    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 Service in the instance. There is a database user who is named ServiceGreatUser. A SQL Server login named ServiceGreatLogin maps to ServiceGreatUser in the Service database. According to the requirement of the company CIO, the database user can only perform the two tasks below: the database user executes all stored procedures that currently exist in the Sales database and executes all stored procedures that will be created in the Sales database. So what should you do to ensure this? （）
    A

    ServiceGreatUser should be added to the appropriate fixed database roles. 

    B

    You should assign the appropriate object-level permissions to ServiceGreatUser 

    C

    You should assign the appropriate server-level permissions to ServiceGreatLogin 

    D

    You should assign the appropriate database-level permissions to ServiceGreatUser


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

  • 第10题：

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


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

  • 第11题：

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

    B

    by using the STATUS L1 command of the Listener control utility

    C

    by using the SHOW RULES command of the Listener control utility

    D

    by using the SET PASSWORD command of the Listener control utility

    E

    by searching for the PASSWORD_LISTENER entry in the listener.ora file


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

  • 第12题：

    单选题
    An administrator has added a new device to a system and wants to determine if it has been correctly added to the ODM database. Which command would the system administrator use？（）
    A

    odmget

    B

    odmadd

    C

    odmshow

    D

    odmcreate


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

  • 第13题：

    A database administrator would like to examine repartitioning options for a partitioned database named PRODDB. A workload has been captured on the system (Windows) and is stored in a file named WORKLOAD.SQL. What is the proper command to run the Design Advisor so that it will evaluate the information stored in the file and give advice on re-partitioning?（）

    • A、db2advis -d proddb -i workload.sql -P  
    • B、db2advis -d proddb -i workload.sql -partitioning  
    • C、db2advis -d proddb -i workload.sql -m P  
    • D、db2advis -d proddb -i workload.sql -m ALL 

    正确答案:C

  • 第14题：

    You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database.  Which method would you use to recover the data file？（）

    • A、Restore all the data files and open the database
    • B、Create the data file and performtablespacerecovery
    • C、No need to restore any file， just recover the database
    • D、Restore only the system data file and recover the database
    • E、Restore only lost date file and performtablespacerecovery

    正确答案:A

  • 第15题：

    You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files：  $ rman target /  What would be the effect of this command？（）

    • A、RMAN would use the current operating system location to place the backup.
    • B、RMAN would use the control file of the target database to maintain the backup.
    • C、RMAN would use the recovery catalog of the target database to maintain the backup.
    • D、RMAN would use the control file of the target database to maintain the backup metadata. 
    • E、RMAN would use the recovery catalog of the target database to maintain the backup metadata.

    正确答案:D

  • 第16题：

    You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. You utilize the SP：Recompile event class to run SQL Server Profiler. You find that a great amount of recompiles occurring. The possible causes of the large number of recompiles should be identified.  From the flowing four options， which one is the most possible cause of the problem？（）

    • A、The sp_executesql batches are not being recovered from the procedure cache.
    • B、A database administrator executed UPDATE STATISTICS statements on all tables， and the most common stored procedures reference all the tables.
    • C、One new stored procedure is created by a database administrator.
    • D、Ad hoc batches are not being recovered from the procedure cache.

    正确答案:B

  • 第17题：

    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.

    正确答案:D

  • 第18题：

    单选题
    You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files：  $ rman target /  What would be the effect of this command？（）
    A

    RMAN would use the current operating system location to place the backup.

    B

    RMAN would use the control file of the target database to maintain the backup.

    C

    RMAN would use the recovery catalog of the target database to maintain the backup.

    D

    RMAN would use the control file of the target database to maintain the backup metadata. 

    E

    RMAN would use the recovery catalog of the target database to maintain the backup metadata.


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

  • 第19题：

    单选题
    A database administrator would like to examine repartitioning options for a partitioned database named PRODDB. A workload has been captured on the system (Windows) and is stored in a file named WORKLOAD.SQL. What is the proper command to run the Design Advisor so that it will evaluate the information stored in the file and give advice on re-partitioning?（）
    A

    db2advis -d proddb -i workload.sql -P  

    B

    db2advis -d proddb -i workload.sql -partitioning  

    C

    db2advis -d proddb -i workload.sql -m P  

    D

    db2advis -d proddb -i workload.sql -m ALL 


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

  • 第20题：

    单选题
    You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）
    A

    Restore all the data files and open the database

    B

    Create the data file and perform tablespace recovery

    C

    No need to restore any file， just recover the database

    D

    Restore only the system data file and recover the database

    E

    Restore only lost date file and performtablespacerecovery


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

  • 第21题：

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


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

  • 第22题：

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


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

  • 第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. There is a database named Dworks in the instance. The Dworks database has a table named Orderthings. According to the company requirement, you have to export all data from the Orderthings table to a file. During the export, you must make sure that the data export process is saved for reuse and a Microsoft Office Open XML document format is used. What should you do?（）
    A

    You should run the bulk copy program utility along with an output file and no format file

    B

    You should run the SQLCmd utility and save the output to a file

    C

    You should run the SQL Import and Export Data Wizard and save the output to a file.

    D

    You should run the bulk copy program utility along with a format file and an output file.


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

  • 第24题：

    单选题
    Your network contains an Exchange Server 2010 Mailbox server.The server has one mailbox database.A user named User1 reports that he has multiple corrupted e-mail messages in his mailbox.You need to recover User1ˉs -mail messages.The solution must not delete any other e-mail messages in the mailbox database.What should you do？（）
    A

    Create a new Mailbox Recovery Database， restore a backup of the database file， and then run the Export-Mailbox cmdlet.

    B

    Create a new Mailbox Recovery Database， restore a backup of the database file， and then run the Restore-Mailbox cmdlet.

    C

    Create a database availability group （DAG）， restore a backup of the mailbox database file， and then run the Restore-Mailbox cmdlet.

    D

    Create a database availability group （DAG）， restore a backup of the mailbox database file， and then run the Export-Mailbox cmdlet.


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

相关内容