搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单选题】

In the instance of the PROD database， the checkpoint （CKPT） process runs after every minute. A database user updates the rows of the ORDERS table. Because of the configuration， the CKPT process gets initiated before the user commits the transaction. What would happen to the modified blocks when the CKPT process is started？（）

A、The modified blocks would be written to the data files.

B、The modified blocks would be written to the temp files.

C、The modified blocks would be written to the control file.

D、The modified blocks would be written to the redo log files.

E、The modified blocks would be written to the archived redo log files.

F、The modified blocks would be retained in the database buffer cache.

查看正确答案
更多“In the instance of the PROD database， the checkpoint （CKPT） process runs after every minute. A database user updates the rows of the ORDERS table. Because of the configuration， the CKPT process gets initiated before the user commits the transaction. What would happen to the modified blocks when the CKPT process is started？（）”相关的问题
第1题
[单选题] You work as a database administrator for Certkiller .com. You want to be notified when the number of disk I/O increases by 10% of what it was yesterday. You create a baseline metric for yesterday’s disk I/O performance. How do you use the baseline metrics to achieve your objective？（）

A、Save the baseline in the database  B、Save the baseline in the Database Control Home Page  C、Create a procedure to read and apply the baseline to disk I/O metrics  D、Apply the baseline to the disk I/O metrics in the Mange Metrics page  E、Alter the disk I/O metrics to include baseline by using the ALTER METRICScommnd  

点击查看答案
第2题
[单选题] You work as a database administrator for Supportcenter.cn. You want to be notified when the number of disk I/O increases by 10% of what it was yesterday. You create a baseline metric for yesterday’s disk I/O performance. How do you use the baseline metrics to achieve your objective？（）

A、Save the baseline in the database  B、Save the baseline in the Database Control Home Page  C、Create a procedure to read and apply the baseline to disk I/O metrics  D、Apply the baseline to the disk I/O metrics in the Mange Metrics page  E、Alter the disk I/O metrics to include baseline by using the ALTER METRICScommnd  

点击查看答案
第3题
[单选题] What is the minimum number of virtual I/O server partitions needed to ensure high availability of the disks when utilizing the Virtual I/O server in a micro-partitioned solution？（）

A、1  B、2  C、3  D、4  

点击查看答案
第4题
[单选题] When considering migrating a POWER6 server with PCI-X and PCIe adapters to a Power 720, which statement is true?（）

A、PCIe adapters are supported only in I/O drawers  B、PCI-X adapters are supported in both the CEC and in I/O drawers  C、PCI-X adapters are supported in the CEC; PCIe adapters are supported in 12X I/O drawers  D、PCIe adapters are supported in the CEC; PCI-X adapters are supported in 12X I/O drawers  

点击查看答案
第5题
[单选题] When booting the p5 590 server in full system partition mode, which location is preferred for the fastest boot?（）

A、A SAN device  B、First I/O drawer  C、Any I/O drawer within the main frame  D、First I/O drawer within the expansion frame  

点击查看答案
第6题
[单选题] The only thing I have is this bill the publisher’s name and address（） 

A、with on  B、byin  C、in-on  

点击查看答案
第7题
[] You work in a Organization which is named Wiikigo Corp. The Organization uses SQL Server 2008. You are the administrator of the Organization database. Now you are in charge of a SQL Server 2008 instance. Look at the following query: SELECT s.*, i.* FROM SensitiveTbl AS s INNER JOIN InsensitiveTbl AS iON i. OrganizationName = s.OrganizationName You use the above query to join two tables on a column named OrganizationName. The following error is returned when you execute the query. "Msg 468, Level 1

A、A.ON LOWER(i.OrganizationName) = LOWER(s.OrganizationName)  B、B.ON UPPER(i.OrganizationName) = UPPER(s.OrganizationName)   C、C.ON i.OrganizationName = s.OrganizationName COLLATE SQL_Latin1_General_CP1_CS_AS   D、D.ON i.OrganizationName = s.OrganizationName COLLATE SQL_Latin1_General_CP1_CI_AS   

点击查看答案
第8题
[单选题] A customer is planning on having a single Virtual I/O Server (VIOS) configuration in a Power 750. They haveselected a 4-port 1Gb Integrated Virtual Ethernet (IVE). There will be no other network cards installed in the system. One IVE logical port will be used in the VIO Server and will be used as the physicalport in a Shared Ethernet Adapter (SEA). What is the maximum number of IVE logical ports available to use inother LPARs?（）

A、1  B、7  C、15  D、31  

点击查看答案
第9题
[单选题] Your partner company has a single domain named partner.com. The partner.com DNS zone is Active Directory-integrated. The IP addresses of the DNS servers in the partner domain will change. You need to ensure name resolution for users in contoso.com to resources in partner.com. What should you do？（）

A、Create a stub zone for partner.com on each DNS server in contoso.com.  B、Configure the Zone Replication Scope for partner.com to replicate to all DNS servers in the forest.  C、Configure an application directory partition in the contoso.com forest. Enlist all DNS servers in the contoso.com forest in the partition.  D、Configure an application directory partition in the partner forest. Enlist all DNS servers in the partner forest in the partition.  

点击查看答案
第10题
[单选题] 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   

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服