多項(xiàng)選擇題

Which three statements are true regarding the logical structure of the Oracle database？（）

A.Each segment contains one or more extents.
B.Multiple tablespaces can share single data file.
C.A data block is the smallest unit of I/O for data files.
D.It is possible to have tablespaces of different block sizes in a database.
E.Each data block in the database always corresponds to one OS block.

你可能感興趣的試題

多項(xiàng)選擇題

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.

多項(xiàng)選擇題

In your Oracle 10g database ， you have scheduled a job to update the optimizer statistics at 05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）

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

无码高清视频|成人自拍视频|欧美成人午夜无码A片秀色直播|草美女视频网站|美女被操网站在线观看

Which three statements are true regarding the logical structure of the Oracle database？（）

你可能感興趣的試題

Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. .. statement are correct？（）

In your Oracle 10g database ， you have scheduled a job to update the optimizer statistics at 05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）

Which three statements are true regarding the logical structure of the Oracle database？（）

Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. .. statement are correct？（）

In your Oracle 10g database ， you have scheduled a job to update the optimizer statistics at 05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）