网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
Which two statements are true regarding a tablespace（）
A
It can span multiple databases.
B
It can consist of multiple data files.
C
It can contain blocks of different sizes.
D
It can contain segments of different sizes.
E
It can contain a part of a nonpartitioned segment.
参考答案
参考解析
解析：
暂无解析
更多 “多选题Which two statements are true regarding a tablespace（）AIt can span multiple databases.BIt can consist of multiple data files.CIt can contain blocks of different sizes.DIt can contain segments of different sizes.EIt can contain a part of a nonpartitioned segment.” 相关考题
考题
You issued the following command:An index is then created on the ADMIN_WORK_AREA temporary table. Which two statements are true regarding the TBS_T1 tablespace in the above command? ()
A. It stores only the temporary table but not its indexes.B. It stores both the temporary table as well as its indexes.C. It must be a nondefault temporary tablespace for the database.D. It can be a default or nondefault temporary tablespace for the database.E. It must be the default temporary tablespace of the user who issues the command.
考题
Which two statements are true about the use of the procedures listed in the vsysaux_occupants.move_procedure column?()
A. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.B. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.C. All the components may be moved into SYSAUX tablespace.D. All the components may be moved from the SYSAUX tablespace.
考题
Which two statements are true regarding L2TP? ()(Choose two.)
A. Tunnels are initiated by the LACB. Tunnels are initiated by the LNSC. By default, subscriber authentication occurs on the LNSD. By default, subscriber authentication occurs on the LAC
考题
Which two statements are true regarding high-availability chassis clustering？（）A、A chassis cluster consists of two devices.B、A chassis cluster consists of two or more devices.C、Devices participating in a chassis cluster can be different models.D、Devices participating in a chassis cluster must be the same models
考题
Which two statements are true regarding L2TP? （）(Choose two.)A、Tunnels are initiated by the LACB、Tunnels are initiated by the LNSC、By default, subscriber authentication occurs on the LNSD、By default, subscriber authentication occurs on the LAC
考题
Which two statements are true regarding undo tablespaces（）A、The database can have more than one undo tablespace.B、The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.C、Undo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.D、An undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.
考题
Which statements are true regarding a tablespace（）A、It can span multiple databases.B、It can consist of multiple data files.C、It can contain blocks of different sizes.D、It can contain segments of different sizes.E、It can contain a part of a nonpartitioned segment
考题
Which two statements about bigfile tablespaces are true？ （）A、The bigfile tablespace have only one data file.B、The segment space management is automatic.C、The extent management is dictionary managed.D、The database can have only one bigfile tablespace.E、The bigfile tablespace can be converted to a smallfile tablespace.
考题
Which two statements are TRUE regarding Coherence Indexes ？ （）A、 indexes are maintained by cache entry ownesB、 an application should not suggest an index that another aplication had suggestedC、 indexes cannot be sortedD、 each application using Coherence may suggest the same set of indexes when it starts
考题
Which two statements are true regarding subqueries? （）A、A subquery can retrieve zero or more rows B、Only two subqueries can be placed atone level C、A subquery can be used only in SQL query statements D、A subquery can appear on either side of a comparison operator E、There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement
考题
Which two statements are true regarding transactions in an Oracle database（）A、Multiple transactions can use the same undo segment.B、A transaction is assigned an undo segment when it is started.C、More than one transaction cannot share the same extent in the undo tablespace.D、The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.
考题
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.
考题
Which of the following statements are true regarding the Recycle Bin？（）A、 The Recycle Bin is a physical storage area for dropped objects.B、 The Recycle Bin is a logical container for dropped objects.C、 The Recycle Bin stores the results of a Flashback Drop operation.D、 The objects in the Recycle Bin are stored in the tablespace in which they were created.
考题
View this parameter setting in your database： DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’ You created a tablespace by using this command： CREATE TABLESPACE USERS； Which two statements are true about the USERS tablespace？（）A、The tablespace has two data files.B、An error is reported and tablespace creation fails.C、Data files are created with names generated by the instance.D、The tablespace can be extended without specifying the data file.E、Data files belonging to the USERS tablespace cannot be renamed.
考题
Which two statements are true regarding a tablespace（）A、It can span multiple databases.B、It can consist of multiple data files.C、It can contain blocks of different sizes.D、It can contain segments of different sizes.E、It can contain a part of a nonpartitioned segment.
考题
多选题Which two statements are true regarding transactions in an Oracle database（）AMultiple transactions can use the same undo segment.BA transaction is assigned an undo segment when it is started.CMore than one transaction cannot share the same extent in the undo tablespace.DThe transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.
考题
多选题Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. .. statement are correct？（）AThis clause is not valid for a temporary or undo tablespace.BIf the tablespace is in the NOLOGGING mode， no operation on the tablespace will generate redo.CThe tablespace will be in the NOLOGGING mode by default， if not specified while creating a tablespace.DThe tablespacelevel logging attribute can be overridden by logging specifications at the table， index， materialized view， materialized view log， and partition levels.
考题
多选题Which statements are true regarding a tablespace（）AIt can span multiple databases.BIt can consist of multiple data files.CIt can contain blocks of different sizes.DIt can contain segments of different sizes.EIt can contain a part of a nonpartitioned segment
考题
多选题Which of the following statements are true regarding the Recycle Bin？（）AThe Recycle Bin is a physical storage area for dropped objects.BThe Recycle Bin is a logical container for dropped objects.CThe Recycle Bin stores the results of a Flashback Drop operation.DThe objects in the Recycle Bin are stored in the tablespace in which they were created.
考题
多选题Which two statements are true regarding L2TP? （）(Choose two.)ATunnels are initiated by the LACBTunnels are initiated by the LNSCBy default, subscriber authentication occurs on the LNSDBy default, subscriber authentication occurs on the LAC
考题
多选题Which two statements are true regarding undo tablespaces（）AThe database can have more than one undo tablespace.BThe UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.CUndo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.DAn undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.
考题
多选题Which two statements are true regarding the MRKT tablespace（）ANo more data files can be added to the tablespace.BSegment space is managed by free lists in the tablespace.CA user created without being assigned a default tablespace uses this tablespace.DThe tablespace can be dropped with the current setting with segments present in it.
考题
多选题Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correct？（）AThis clause is not valid for a temporary or undo tablespace.BIf the tablespace is in the NOLOGGING mode，no operation on the tablespace will generate redo.CThe tablespace will be in the NOLOGGING mode by default，if not specified while creating a tablespace.DThe tablespace-level logging attribute can be overridden by logging specifications at the table，index， materialized view，materialized view log，and partition levels.
考题
多选题View this parameter setting in your database： DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’ You created a tablespace by using this command： CREATE TABLESPACE USERS； Which two statements are true about the USERS tablespace？（）AThe tablespace has two data files.BAn error is reported and tablespace creation fails.CData files are created with names generated by the instance.DThe tablespace can be extended without specifying the data file.EData files belonging to the USERS tablespace cannot be renamed.
考题
多选题You issued the following command： CREATE GLOBAL TEMPORARY TABLE admin_work_area （startdate DATE， enddate DATE， class CHAR（20）） ON COMMIT DELETE ROWS TABLESPACE tbs_t1； An index is then created on the ADMIN_WORK_AREA temporary table. Which two statements are true regarding the TBS_T1 tablespace in the above command？（）AIt stores only the temporary table but not its indexes.BIt stores both the temporary table as well as its indexes.CIt must be a nondefault temporary tablespace for the database.DIt can be a default or nondefault temporary tablespace for the database.EIt must be the default temporary tablespace of the user who issues the command.
考题
多选题Which two statements are true regarding high-availability chassis clustering？（）AA chassis cluster consists of two devices.BA chassis cluster consists of two or more devices.CDevices participating in a chassis cluster can be different models.DDevices participating in a chassis cluster must be the same models
考题
多选题Which two statements about bigfile tablespaces are true？ （）AThe bigfile tablespace have only one data file.BThe segment space management is automatic.CThe extent management is dictionary managed.DThe database can have only one bigfile tablespace.EThe bigfile tablespace can be converted to a smallfile tablespace.
热门标签
最新试卷
