單項(xiàng)選擇題

You have created an Oracle 10g database named SALES， which will be used by an application named SalesOrders. Users of the SalesOrders application complain that application response time is slow when they generate reports. The SalesOrders application accesses a table that contains 10 million rows. You decide to create an index on this table using the NOLOGGING option so that the index creation process is completed in the least amount of time. Which of the following is NOT true about an index created with the NOLOGGING option？（）

A. The index can be changed from NOLOGGING to LOGGING
B. The index cannot be recovered even in the ARCHIVELOG mode.
C. The index can only be created if the base table is created with the NOLOGGING option.
D. The index can be recovered if you perform a backup after the CREATE INDEX statement.

你可能感興趣的試題

單項(xiàng)選擇題

Your database contains two temporary tablespaces named TEMP and TEMP1. The TEMP tablespace is the default temporary tablespace for the database， and the TEMP1 tablespace was created at database creation. You want to increase the size of the tempfile for the TEMP tablespace and drop the TEMP1 tablespace from the database. The database is not using Oracle-Managed Files （OMF）. Which statement must you use to ensure that when you drop the TEMP1 tablespace from the database， its corresponding operating system file is also deleted？（）

A. DROP TABLESPACE temp1；
B. DROP TABLESPACE temp1 INCLUDING CONTENTS；
C. DROP TABLESPACE temp1 INCLUDING CONTENTS AND DATAFILES；
D. DROP TABLESPACE temp1 INCLUDING CONTENTS CASCADE CONSTRAINTS；

單項(xiàng)選擇題

Your database is in NOARCHIVELOG mode. The database has three online redo log groups， and each group contains three online redo log members. The online redo log members are stored across three hard disks， E， F， and G， respectively. Hard disk G crashed while the LGWR background process was writing redo information to the online redo log files. What effect will this crash have on the database？（）

A. The database will operate normally without generating any redo.
B. The database will hang， and you must shut down and restart the instance.
C. The database will crash， and you must recover the database from the point of failure.
D. The database will operate normally and will generate minimal redo for the tables created with the NOLOGGING clause.

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

你可能感興趣的試題

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线