CMS专题
单选题Your Oracle10g database contains a table with a TIMESTAMP TO LOCAL TIME ZONE column. There are about two hundred column values for the column. You issued the following statement： SQL> ALTER DATABASE SET TIME_ZONE =’Europe/London’； What will be the
题目
The statement will be executed successfully， and a new time zone will be set for the database.
The statement will be executed successfully， but a new time zone will not be set for the database.
The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.
The statement will not be executed successfully because the ALTER DATABASE SET TIME_ZONE statement is used only when the database contains no table with the TIMESTAMP TO LOCAL TIME ZONE column.
相似问题和答案
第1题：
B.Excel table]
C.Database]
D.Data dictionary
第2题：
You plan to execute the following command to perform a Flashback Database operation in your database： SQL> FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）； Which two statements are true about this？（）
- A、 The database must have multiplexed redo log files
- B、 The database must be in the MOUNT state to execute the command
- C、 The database must be in the NOMOUNT state to execute the command
- D、 The database must be opened in RESTRICTED mode before this operation
- E、 The database must be opened with the RESETLOGS option after the flashback operation
正确答案:B,E
第3题：
Note the following statements that use flashback technology:1. FLASHBACK TABLE <table> TO SCN <scn>;2. SELECT * FROM <table> AS OF SCN 123456;3. FLASHBACK TABLE <table> TO BEFORE DROP;4. FLASHBACK DATABASE TO TIMESTAMP <timestamp>;5. SELECT * FROM <table> VERSIONS AS OF SCN 123456 AND 123999;Which of these statements will be dependent on the availability of relevant undo data in the undo segment?（）
A. 1, 2, and 5
B. 1, 3, and 4
C. 2, 3, 4, and 5
D. 1, 2, 3, 4, and 5
第4题：
You work as a database administrator for Certkiller .com. According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）
- A、The backup is similar to image copy.
- B、The backup contains all used data blocks.
- C、The backup contains only unused data blocks.
- D、The backup contains all data blocks changed since the last incremental level 1 backup.
正确答案:B
第5题：
Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees； Table created. Further， you executed the following command to drop the table： SQL> DROP TABLE emp；Table dropped. What happens in this scenario？（）
- A、The table is moved to the SYSAUX tablespace.
- B、The table is moved to the SYSTEM tablespace.
- C、The table is removed from the database permanently.
- D、The table is renamed and remains in the TBSFD tablespace.
正确答案:D
第6题：
Which statement is true about a forwarding table?（）
- A、It stores a subset of information from the routing table.
- B、It contains routes learned from all protocols to a destination.
- C、It provides a database for routes selected and placed into the routing table.
- D、Every routing protocol maintains its own forwarding table.
正确答案:A
第7题：
You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this？（）
- A、 The index tablespace contains bitmap indexes.
- B、 The index tablespace contains more than one data file.
- C、 The index tablespace supports only complete recovery.
- D、 The index tablespace is not a dictionary-managed tablespace.
- E、 There is a dependency relationship between a table and its indexes.
正确答案:E
第8题：
A.It stores a subset of information from the routing table.
B.It contains routes learned from all protocols to a destination.
C.It provides a database for routes selected and placed into the routing table.
D.Every routing protocol maintains its own forwarding table.
第9题：
You create a table in your database that contains 50，000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes？（）
- A、SQL Access Advisor
- B、 Memory Advisor
- C、SQL Tuning Advisor
- D、 Segment Advisor
正确答案:A
第10题：
Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）
- A、 V$DATABASE
- B、 V$UNDOSTAT
- C、 V$FLASHBACK_DATABASE_LOG
- D、 V$FLASHBACK_DATABASE_STAT
正确答案:C