题目
The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?()
A. Create two custom ADDM tasks.
B. Modify the AWR snapshot time interval to two hours.
C. Create a new scheduler window for a time period of two hours.
D. Modify the Automatic Workload Repository (AWR) snapshot retention period to two hours.
第1题
使用SQL语言修改数据库,正确的命令是()
A. CREATE DATABASE
B. MODIFY DATABASE
C. ALTER DATABASE
D. CHANGE DATABASE
第2题
在Visual FoxPro中,打开一个名为GRADE的数据库,应使用命令
A.CREATE DATABASE GRADE
B.OPEN DATABASE GRADE
C.CREATE GRADE
D.OPEN GRADE
第3题
DBMS will" manage "the stored data items and assemble the needed items from the(72) database in response to the queries of those who aren't programmers.
A.particular
B.the same
C.common
D.extention
第4题
要将数据库“考生库”文件及其所包含的数据库表文件直接物理删除,下列命令正确的是
A.DELETE DATABASE考生库
B.DELETE DATABASE考生库RECYCLE
C.DELETE DATABASE考生库DELETETABLES
D.DELETE DATABASE考生库DELETETABLES RECYCLE
第5题
You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?()
A.Every SQL statement in the STS is considered only once for execution
B.The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics
C.The execution plan and execution statistics are computed for each SQL statement in the STS
D.The effects of DDL and DML are considered to produce the execution plan and execution statistics
第6题
在SQL Server 2000中,要对数据库GoodsDB进行一次差异备份,将其备份到设备Backup 1上(该设备已建立好),并要求该次备份操作清除Backupl中己有的备份内容。下列能实现该备份要求的语句是
A.BACKUP DATABASE GoodsDB TO Backupl DIFFERENTIAL,WITH NOINIT
B.BACKUP DATABASE GoodsDB TO Backupl WITH DIFFERENTIAL,NOINIT
C.BACKUP DATABASE GoodsDB TO Backupl DIFFERENTIAL,WITHINIT
D.BACKUP DATABA息E GoodsDB TO Backupl WITH DIFFERENTIAL,INIT
第7题
A.Automatic Intelligence
B.Automatic Information
C.Artifical Intelligence
D.Automatic Intelligence
第9题
A.Databasemustberunninginarchivelogmode.
B.Automaticundomanagementmustbeenabled.
C.Undoretentionguaranteemustbeenabled.
D.ThetablespaceonwhichtheFlashbackDataArchiveiscreatedmustbemanaged with Automatic Segment SpaceManagement(ASSM).
第10题
A.Automatic Intelligence
B.Automatic Information
C.Artifical Intelligence
D.Automatic Intelligence
为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!