Journal
Task Center
Control Center
Activity Monitor
第1题:
第2题:
Which of the following OSPF messages contains entire complete LSAs used during the database exchange process?()
第3题:
Which of the following tools can be used prior to installing Windows Vista to find hardware compatibility issues?()
第4题:
Which of the following tools for DB2 V9 allows a user to create and debug a SQL stored procedure?()
第5题:
Which of the following tools can be used to schedule a backup operation that is to be run every Sunday evening?()
第6题:
Which tasks are run automatically as part of the Automated Maintenance Task by default?()
第7题:
You need to ensure that database schema changes in branch offices result in the proper notifications. What should you do?()
第8题:
Segment Advisor
SQL Access Advisor
Optimizer statistics gathering
Automatic SQL Tuning Advisor
Automatic Database Diagnostics Monitor
第9题:
Segment Advisor
SQL Access Advisor
Optimizer statistics gathering
Automatic SQL Tuning Advisor
Automatic Database Diagnostics Monitor
第10题:
Oracle Net Manager
Listener Control Utility
Oracle Net Control Utility
Oracle Net Configuration Assistant
第11题:
SYS.SOURCE$
SYS.AUD$
DBA_SOURCE
DBA_AUDIT_TRAIL
第12题:
V$CONTROLFILE
V$DATABASE
init.ora
DBA FILES
第13题:
Which of the following can be used to kill a running process?()
第14题:
After Microsoft Windows boots, a message appears stating that a service failed to start. Which of the following can be used to find more information about this error?()
第15题:
Which of the following tools should be used to report in-depth information about file fragments?()
第16题:
Which of the following tools is used to view historical information about tasks, database changes, messages, and notifications?()
第17题:
A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests. For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING. What should you do to accomplish this task?()
第18题:
You are adatabase developer. You develop atask management application that connect stoa SQLServer 2008 database named TaskDB.Users logon to the application by using a SQLServer login. The application contains amodule named Task that assigns tasks tousers. Information about the setasks is stored in the Tasks table of the TaskDB data base. The Tasks table contains multiple columns. These include the Close Dateand Estimated Timecolumns. The application must meet the following security requirements: Users assigned toad atabase role named User 1 canupd ate all task information columns except the Close Date and the Estimated Time columns in the Tasks table. Administrative users assigned toad atabase role named Task_Admin canupd ateall task information in the Tasks table.You needto design a strategy to meet the security requirements. Which two actions should you perform?()
第19题:
he DBA is about to enable auditing on the Oracle database in an attempt to discover some suspicious activity. Audit trail information is stored in which of the following database object names?()
第20题:
Execute the query and view Active Session History (ASH) for information about the query.
Enable SQL trace for the query.
Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.
Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.
第21题:
Journal
Task Center
Control Center
Activity Monitor
第22题:
Install Notification Services on all branch office servers, and configure Notification Services to use a local notifications database.
Specify that all SQL Server log files must be archived and sent by e-mail to the main office.
Implement DML triggers that use Database Mail to send an e-mail message about the DML activity.
Implement DDL triggers that use Database Mail to send an e-mail message about the DDL activity.
第23题:
defragfs
istat
filemon
fileplace
第24题:
LSR
LSAck
LSU
DD
Hello