CMS专题
单选题You discover that the schema changes that were recently made to your SQL Server 2005 database have caused your Web site to stop functioning. It is unclear who made the changes. TestKing.com now mandates that all changes to the database schema be tracke
题目
Implement a stored procedure that writes data about schema changes to a log table.
Implement DDL AFTER triggers that write user and schema information to a log table.
Implement a DML INSTEAD OF trigger that writes data about schema changes to a log table.
Implement a DML AFTER trigger that writes data about schema changes to a log table.
相似问题和答案
第1题：
A. point-in-time recovery
B. execute the ROLLBACK command with transaction number
C. flashback the database to before the transaction was committed
D. determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
第2题：
题库
1. What extracurricular activities were you involved in? What made you choose those? Which of them did you most enjoy, and why?
第3题：
The reason for all the changes being made ( ) to us.
A、explained
B、had explained
C、was explained
D、were explained
解析：主语“the reason”是单数
第4题：
An administrator has made several topology and resource group changes on one node in a running cluster.During verification and synchronization， using the "Emulate" option， many errors are reported. Theadministrator decided the best course of action was to roll back the changes. Prior to the changes beingmade， a cluster snapshot was taken. Which of the following actions will roll back the changes with the least disruption？（）
- A、Perform a synchronization from a node without the changes.
- B、Apply the cluster snapshot on both nodes while the cluster is running.
- C、"Restore HACMP Configuration Database from Active Configuration" on the node where the changes weremade
- D、Stop the cluster using the option "Unmanage Resource Groups" and apply the cluster snapshot on thenode where the changes were made
正确答案:C
第5题：
—David has made great progress recently. —_______， and _______. A. So he has；so you have B. So he has；so have you C. So he has；so do you D. So has he；so you have
第6题：
Your database supports an online transaction processing (OLTP) application.The application is undergoing some major schema changes, such as addition of new indexes and materialized views.You want to check the impact of these changes on workload performance.What should you use to achieve this?（）
A. Database replay
B. SQL Tuning Advisor
C. SQL Access Advisor
D. SQL Performance Analyzer
E. Automatic Workload Repository compare reports
第7题：
You are the network administrator for TestKing. The network contains a Windows
Server 2003 computer named testking1, which hosts a critical business application
named Salesapp. Testking1 has one disk that contains a single NTFS volume.
Five days ago, the System State of testking1 was backed up, and an Automated
System Recovery (ASR) backup was created. No additional backups were
performed. Subsequently, many changes were made to the Salesapp data files.
You apply an update to the application, which requires you to restart testking1.
Windows startup terminates with a Stop error. You restart the computer and boot
to a floppy disk. A utility on this disk gives you read-only access to the NTFS file
system. You discover that one of the .dll files for the Salesapp application is
corrupted. The corrupted file is stored in the C.\Windows\System32 folder.
You need to restore the corrupted file. You need to avoid losing any changes made
to the data files on testking1.
What should you do onTestKing1?（）
第8题：
A、have made
B、has made
C、were made
D、is made
第9题：
In your Cisco EIGRP network，you notice that the neighbor relationship between two of your routers was recently restarted. Which two of these choices could have made this occur？（）
- A、An update packet with init flag set from a known， already established neighbor relationship was received by one of the routers.
- B、The ARP cache was cleared.
- C、The counters were cleared.
- D、The IP EIGRP neighbor relationship was cleared manually.
正确答案:A,D
第10题：
You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）
- A、 V$FLASHBACK_DATABASE_LOG
- B、 V$FLASHBACK_DATABASE_STAT
- C、 V$DATABASE
- D、 V$UNDOSTAT
正确答案:A