网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
In your datawarehousing application， you generate reports frequently. The data is static in the tables being used to generate reports. You are currently using joins， resulting in a large performance overhead. What kind of database structure would you use to reduce the response time of the query？（）
A
hash clusters
B
index clusters
C
partitioned tables
D
index-organized table （IOT）
参考答案
参考解析
解析：
暂无解析
更多 “单选题In your datawarehousing application， you generate reports frequently. The data is static in the tables being used to generate reports. You are currently using joins， resulting in a large performance overhead. What kind of database structure would you use to reduce the response time of the query？（）A hash clustersB index clustersC partitioned tablesD index-organized table （IOT）” 相关考题
考题
单选题Your database operates in ARCHIVELOGmode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence， 230， is not archived and it contained information from 10：35 a.m. onwards. The current time is 11：00 a.m. Because of a disk crash， you executed the following command to perform an incomplete recovery： RMAN RUN { 2 SET UNTIL SEQUENCE 230 THREAD 1； 3 ALTER DATABASE MOUNT； 4 RESTORE DATABASE； 5 RECOVER DATABASE； 6 ALTER DATABASE OPEN RESETLOGS； 7 }； With reference to this scenario， which statement is true？（）A
RMAN recovers up to log sequence 230， but not including 230.B
RMAN returns an error because the log sequence number mentioned in the command should be 229.C
RMAN returns an error because the log sequence number mentioned in the command may never be missing.D
RMAN recovers up to and including log sequence 229 but then returns an error because log sequence 230 is missing.
考题
单选题You have created a locally managed tablespace by issuing the following command： CREATE TABLESPACE data1 DATAFILE ’data1_file1.dbf’ SIZE 10M AUTOEXTEND ON MAXSIZE UNLIMITED； For the DATA1 tablespace， you have set the warning level alert limit to 70 percent. In which situation will a warning level alert be generated？（）A
when 700 KB is usedB
when 700 KB is left as free spaceC
when 7MB is usedD
when 7MB is left as free spaceE
no alert will be generated because an autoextensible datafile is included in the tablespace
考题
多选题When performing a backup using Recovery Manager （RMAN）， which four types of files can be backed up with the RMAN BACKUP command？（）Adata fileBpassword fileCarchivelog fileDtemporary fileEonline redo log fileFthe current control fileGthe tnsnames.ora fileHcurrent server parameter file
考题
单选题The warning and critical threshold values have been set to 85% and 97%， respectively， for one of the tablespaces. The current tablespace space usage is 54%. You modify the warning threshold to be 50% and critical threshold to be 53% in Database Control. Which statement is true？（）A
The new setting would be applied but no alerts would be raised immediately.B
The new setting would be applied and an alert would be raised immediately.C
The new setting would be ignored because the tablespace space usage is more than the specified threshold value.D
The new setting would cause an error because the tablespace space usage is more than the specified threshold value.
考题
单选题You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）A
loss of one of the tablespacesB
loss of a system data fileC
loss of one of the control filesD
loss of a tempfileE
loss of the only member of an unarchived redo log groupF
loss of a member from each redo log group
考题
单选题Which component does the SQL Tuning Advisor NOT analyze for the SQL statements？（）A
ADDMB
AWRC
Cursor CacheD
SQL Tuning SetsE
Flash Recovery Area
热门标签
最新试卷