You want a record of all queries that are not using indexes. How would you achieve this?()
A: By enabling the Slow Query Log because all queries that are not using indexes will be logged automatically
B: By enabling the Error Log because not using indexes is an error
C: By enabling the Slow Query Log and using the – log-queries-not-using-indexes option
D: By enabling the Error Log and using the – log-queries-not-using-indexes optio
A: By enabling the Slow Query Log because all queries that are not using indexes will be logged automatically
B: By enabling the Error Log because not using indexes is an error
C: By enabling the Slow Query Log and using the – log-queries-not-using-indexes option
D: By enabling the Error Log and using the – log-queries-not-using-indexes optio
举一反三
- You can find information using Web-based ____. A: indexes B: lists of links C: links provided on the pages of wikis D: all of the above
- 4.下列关于结果记录文件的命令语句书写正确的有: A: log using filename.log B: log use filename C: log on D: log off
- When shrinking a table segment, you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use?() A: A INCLUDING DEPENDENCIES B: B INCLUDING DEPENDENCIES CASCADE C: C COMPACT D: D CASCADE E: E None of the above
- You are using Recovery wizard for performing incomplete recovery. Which of the following object types is NOT available in the Perform Recovery :Type screen?() A: Whole database B: Tablespaces C: Datafiles D: Archive logs E: Redo log
- 选择下列函数运行后的输出NestList[Log,10,3] A: {Log[10],Log[Log[10]],Log[Log[Log[10]]]} B: {10,Log[10],Log[Log[10]],10+Log[Log[Log[10]]]} C: {Log[10],Log[Log[10]],Log[Log[Log[Log[10]]]]} D: {10,Log[10],Log[Log[10]],Log[Log[Log[10]]]}