网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
A database administrator wants to design a multi-partition database that can take advantage of both intra-partition parallelism and inter-partition parallelism. Which configuration will allow the use of these types of parallelism while using the least number of hardware components (servers, processors)? （）
A
one server having at least two processors
B
two servers having one processor and one logical database partition
C
one server having four processors and two logical database partitions
D
two servers each having four processors and two logical database partitions
参考答案
参考解析
解析：
暂无解析
更多 “单选题A database administrator wants to design a multi-partition database that can take advantage of both intra-partition parallelism and inter-partition parallelism. Which configuration will allow the use of these types of parallelism while using the least number of hardware components (servers, processors)? （）A one server having at least two processors B two servers having one processor and one logical database partition C one server having four processors and two logical database partitions D two servers each having four processors and two logical database partitions” 相关考题
考题
Which of the following is not responsibility of DBA(Data Base Administrator)?A．Database management system designB．Database schema definitionC．Database schema modificationD．Integrity constraint specification
考题
Well, the design manager is()by your CV and he wants you to be in his team.A、 impressB、 impressedC、 impressing
考题
The administrator wants to verify the current state of the OSPF database loading process. Which show command should the administrator use?()
A. show ip ospf [process - id] interfaceB. show ip ospf neighborC. show ip ospf [process - id]D. show ip ospf [process - id area - id] database
考题
The administrator wants to verify the current state of the OSPF database loading process. Which show command should the administrator use?（）A、show ip ospf [process - id] interfaceB、show ip ospf neighborC、show ip ospf [process - id]D、show ip ospf [process - id area - id] database
考题
A database administrator wants a unique IP address for each of three instances of a database. Normally，all instances run on a large production node，but they may fallover to different standby nodes according to the dynamic node priority configuration. What is the best way to obtain unique addresses for each of the three database instances？（）A、 There is no way since this cannot be configured with HACMPB、 Use IP Replacement address takeover and define all service addresses on the same NICC、 Use IP Aliasing for address takeover and define each alias in a separate resource groupD、 Use EtherChannel to map the three alias IP addresses to the common service address defined to HACMP
考题
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
考题
An administrator wants to proactively collect information on attackers and their attempted methods of gaining access to the internal network. Which of the following would allow the administrator to do this？（）A、NIPSB、HoneypotC、DMZD、NIDS
考题
A database administrator wants to design a multi-partition database that can take advantage of both intra-partition parallelism and inter-partition parallelism. Which configuration will allow the use of these types of parallelism while using the least number of hardware components (servers, processors)? （）A、one server having at least two processors B、two servers having one processor and one logical database partition C、one server having four processors and two logical database partitions D、two servers each having four processors and two logical database partitions
考题
A system administrator wants to configure a system so that all new users will be put into the database group by default. How would this be accomplished？（）A、remove all other groups from the systemB、run the command mkuser -default "GROUP=database"C、change the default group in /usr/lib/security/mkuser.defaultD、edit /etc/security/group to move all users to the database stanza
考题
which one of the following database elements is not updated when the design task is run?（）A、formsB、viewsC、rolesD、agents
考题
tony wants to create a duplicate of the video application. He wants to keep a version of the data on the same server as the production application but does not want any new documents or documents modifications to be replicated into his new database once he creates it. Which one of the following should tony do to create his archive?（）A、create a new copy of the databaseB、create a replica of the databaseC、Use the windows explorer to create a copy of the database file.D、Create a replica copy of the database and disable replication on the database file.
考题
shirin plans to change the form and views of a production database. she will make the changes locally and then update the application’s design template with the changes. which one of the following server tasks does the administrator run in order for the changes to take effect?（）A、 design B、 updall C、 replica D、 fixup
考题
Marry wants to create a new application on his laptop that does not have any design elements in it. Which one of the following should he do to begin his process?（）A、 select file-Database-new and give it a filename of “blank.nsf” B、 select file-Database-new,choose local as the server,and chose the blank template C、 select file-Database-new,choose local as the server,and chose the default.ntf template D、 select file-Database-new,give it a filename of “blank.nsf”,and chose the blank template
考题
If the ADD DBPARTITIONNUM command is used to add a new database partition to an existing DB2 instance,which statement is correct? （）A、All existing databases in the instance are expanded to the new database partition but data cannot be stored on the newpartition until it has been added to a partition group. B、Database partition groups within existing databases will automatically include the new database partition and willredistribute their existing data to the new partition. C、Any single partition databases within the instance will automatically become multi-partition databases once the newpartition is added to the instance. D、A database administrator would need to modify the db2nodes.cfg file to complete the addition of the new partition tothe instance.
考题
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. A SQL Server 2005 database is utilized in your company. And a table named Inventory is contained by the database. A column named Price is included by the table. According to the company policy， you cannot reduce more than 10 percent the value in the Price column in any single database operation. Through many kinds of method， the company makes updates to the Price column. For instance， the utilization of ad hoc queries is one of the methods. Since you are the database administrator， you should confirm that this company policy takes its effect. Which action should be performed？（）A、A stored procedure should be created， and changes are disallowed by the procedure to the Price column that violates company policy.B、On the Price column， a check constraint should be created， and a specified minimum value is required by the check constraint.C、A trigger should be created， and changes are rolled back by the trigger to the Price column that violates company policy.D、On the Price column， a foreign key constraint is created to a table that valid prices are included.
考题
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. A user database named Products is included by your SQL Server 2005 computer. SQL Server Integration Services （SSIS） packages are utilized to export data from the Products database to a text file. You deliver the text file to your company’s trading partners by utilizing FTP. You are required to make sure that your SSIS packages can be recovered from the occurrence of a disaster. Which action should be performed to finish the task？（）A、To finish the task，the Products database should be backed up.B、To finish the task，your server should be set to utilize the full recovery model.C、To finish the task，your server should be set to utilize the bulk-logged recovery model.D、To finish the task， the msdb database should be backed up.
考题
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.
考题
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. A vendor company’s application is utilized， and the application is based on a proprietary database. Data is queried from the application database and the data is imported into a SQL Server 2005 database. A new OLE DB driver is offered by the application vendor， and the new OLE DB driver will be utilized when the application database is queried. According the company requirements， the connections between the SQL Server database and the application database is prohibited， except when this data is queried. You should think out a method to have data queried from the application database. Which action should be performed to achieve the goal？（）A、To achieve the goal， a Linked Server connection should be configured to the application database.B、To achieve the goal， a query should be written， and an OPENQUERY command is utilized by the query.C、To achieve the goal， a Remote Server connection to the application database should be configured.D、To achieve the goal， a query should be written， and an OPENDATASOURCE command is utilized by the query.
考题
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 the administrator of a SQL Server 2005 computer， and the computer is called SQL1. There are two databases on the SQL1， and the two databases are respectively named Production and DW. A new database named Staging is created. When the data are moving from the Production database into the DW database， the Staging database is utilized temporarily to store and manipulate data. Since you are the database administrator， you are required to make sure the points listed below. First， the tables should not be removed from the Staging database. Second， any attempts to have tables migrated should be logged. Third， your solution should not impact on other databases. Which action should be performed to achieve the goal？（）A、To achieve the goal， a DML trigger on each table should be created to prevent deletion of data.B、To achieve the goal， a DDL trigger should be created， and that the ON DATABASE parameter is utilized by DDL trigger for the Staging database.C、To achieve the goal， an event notification should be created to fire when the TRUNCATE TABLE Transact-SQL statement is submitted to the Staging database.D、To achieve the goal， a DDL trigger should be created， and the ON ALL SERVER parameter is utilized by the DDL trigger.
考题
单选题A system administrator wants to configure a system so that all new users will be put into the database group by default. How would this be accomplished？（）A
remove all other groups from the systemB
run the command mkuser -default GROUP=databaseC
change the default group in /usr/lib/security/mkuser.defaultD
edit /etc/security/group to move all users to the database stanza
考题
单选题If the ADD DBPARTITIONNUM command is used to add a new database partition to an existing DB2 instance,which statement is correct? （）A
All existing databases in the instance are expanded to the new database partition but data cannot be stored on the newpartition until it has been added to a partition group. B
Database partition groups within existing databases will automatically include the new database partition and willredistribute their existing data to the new partition. C
Any single partition databases within the instance will automatically become multi-partition databases once the newpartition is added to the instance. D
A database administrator would need to modify the db2nodes.cfg file to complete the addition of the new partition tothe instance.
考题
单选题shirin plans to change the form and views of a production database. she will make the changes locally and then update the application’s design template with the changes. which one of the following server tasks does the administrator run in order for the changes to take effect?（）A
design B
updall C
replica D
fixup
考题
单选题tony wants to create a duplicate of the video application. He wants to keep a version of the data on the same server as the production application but does not want any new documents or documents modifications to be replicated into his new database once he creates it. Which one of the following should tony do to create his archive?（）A
create a new copy of the databaseB
create a replica of the databaseC
Use the windows explorer to create a copy of the database file.D
Create a replica copy of the database and disable replication on the database file.
考题
单选题The administrator wants to verify the current state of the OSPF database loading process. Which show command should the administrator use?（）A
show ip ospf [process - id] interfaceB
show ip ospf neighborC
show ip ospf [process - id]D
show ip ospf [process - id area - id] database
考题
单选题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. A vendor company’s application is utilized， and the application is based on a proprietary database. Data is queried from the application database and the data is imported into a SQL Server 2005 database. A new OLE DB driver is offered by the application vendor， and the new OLE DB driver will be utilized when the application database is queried. According the company requirements， the connections between the SQL Server database and the application database is prohibited， except when this data is queried. You should think out a method to have data queried from the application database. Which action should be performed to achieve the goal？（）A
To achieve the goal， a Linked Server connection should be configured to the application database.B
To achieve the goal， a query should be written， and an OPENQUERY command is utilized by the query.C
To achieve the goal， a Remote Server connection to the application database should be configured.D
To achieve the goal， a query should be written， and an OPENDATASOURCE command is utilized by the query.
考题
单选题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 the administrator of a SQL Server 2005 computer， and the computer is called SQL1. There are two databases on the SQL1， and the two databases are respectively named Production and DW. A new database named Staging is created. When the data are moving from the Production database into the DW database， the Staging database is utilized temporarily to store and manipulate data. Since you are the database administrator， you are required to make sure the points listed below. First， the tables should not be removed from the Staging database. Second， any attempts to have tables migrated should be logged. Third， your solution should not impact on other databases. Which action should be performed to achieve the goal？（）A
To achieve the goal， a DML trigger on each table should be created to prevent deletion of data.B
To achieve the goal， a DDL trigger should be created， and that the ON DATABASE parameter is utilized by DDL trigger for the Staging database.C
To achieve the goal， an event notification should be created to fire when the TRUNCATE TABLE Transact-SQL statement is submitted to the Staging database.D
To achieve the goal， a DDL trigger should be created， and the ON ALL SERVER parameter is utilized by the DDL trigger.
考题
单选题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.
热门标签
最新试卷
