多项选择题
Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. .. statement are correct？（）
A.This clause is not valid for a temporary or undo tablespace.
B.If the tablespace is in the NOLOGGING mode， no operation on the tablespace will generate redo.
C.The tablespace will be in the NOLOGGING mode by default， if not specified while creating a tablespace.
D.The tablespacelevel logging attribute can be overridden by logging specifications at the table， index， materialized view， materialized view log， and partition levels.
相关考题
-
多项选择题
InyourOracle10gdatabase，youhavescheduledajobtoupdatetheoptimizerstatisticsat05：00pmeveryFriday.Thejobhassuccessfullycompleted.Whichthreepiecesofinformationwouldyouchecktoconfirmthatthestatisticshavebeencollected？（）
A.average row size
B.last analyzed date
C.size of table in bytes
D.size of table in database blocks
E.number of free blocks in the free list
F.number of extents present in the table -
多项选择题
The following are the details of your database： Instance name：test Host name：tech1.us.oracle.com IP address：145.33.230.186 Enterprise Manager Console HTTP Port number：5500 You started the database instance and you want to manage your database remotely with Enterprise Manager through a Web browser. Which two URLs would you use to access the Database Control？（）
A.http：//145.33.230.186：5500/em
B.http：//www.145.33.230.186：5500/em
C.http：//tech1.us.oracle.com：5500/em
D.http：//test.145.33.230.186：5500/em
E.http：//test.tech1.us.oracle.com：5500
F.http：//www.tech1.us.oracle.com：5500/em
G.http：//test.tech1.us.oracle.com：5500/em -
单项选择题
Youfindtoday’sperformanceofyourproductiondatabasetobethebestever.Therefore，youwanttobenotifiedinthefuturewhenevertheperformancedegradesby10%oftoday’sperformance.Whatisthefirststepthatyouwouldtaketoensurethis？（）
A.create baseline metrics for today’s performance
B.write the current database metrics to a database table and create a trigger to compare with future database statistics
C.write the current database metrics to a flat file and create an operating script to compare with future database statistics
D.write the current database metrics to a database table and create a procedure to compare with future database statistics
E.write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics
