Cursor cache
Stored outline
SQL Tuning Set
Automatic Workload Repository (AWR) snapshots
第1题:
A. Flashback queries
B. Shared server requests
C. Login and logoff activities of sessions
D. Direct path load of data from external files by using utilities such as SQL *loader
E. Data definition language (DDL) and data manipulation language (DML) operations
第2题:
有SQL语句 SELECT * FROM 教师 WHERE NOT(工资>30000R工资<2000) 与如上语句等价的SQL语句是
A.SELECT * FROM 教师 WHERE 工资 BETWEEN 2000 AND 3000
B.SELECT * FROM 教师 WHERE 工资>2000 AND工资<3000
C.SELECT * FROM 教师 WHERE 工资>2000 OR工资<3000
D.SELECT * FROM 教师 WHERE 工资<=2000 AND工资>=3000
第3题:
标准SQL基本查询模块的结构是A)SELECT…FROM…ORDER BYB)SELECT…WHERE…GROUP BYC)SELECT…WHERE…HAVINGD)SELECT…FROM…WHERE
第4题:
While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences?()
第5题:
Which two statements about subqueries are true? ()
第6题:
有SQL语句:SELECT * FROM 教师 WHERE NOT(工资>3000 OR 工资<2000)与如下语句等价的SQL语句是A)SELECT*FROM 教师 WHERE 工资 BETWEEN 2000 AND 3000B) SELECT*FROM 教师 WHERE 工资>2000 AND 工资<3000C)SELECT*FROM 教师 WHERE 工资>2000 OR 工资<3000D) SELECT*FROM 教师 WHERE 工资<=2000 AND 工资>3000
第7题:
Which two statements about configuration an unconnected Catalyst Express 500 switch from setup mode using a PC are true?()
第8题:
A. Cursor cache
B. Stored outline
C. SQL Tuning Set
D. Automatic Workload Repository (AWR) snapshots
第9题:
Which three are the valid statements in relation to SQL plan baselines?()
第10题:
Which two are true regarding direct-path exports?()