单项选择题

Identify the logical structure that will never have more than one data segment created for it.（）

A.external table
B.partitioned table
C.partitioned index
D.nonclustered table
E.global temporary table

点击查看答案&解析

上一题目录下一题

相关考题

多项选择题

Which three statements are true about logical structures of the Oracle database（）

A.Each segment contains one or more extents.
B.Multiple tablespaces can share a single data file.
C.A data block is the smallest unit of input/output （I/O） in 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 operating system block.

单项选择题

You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows： Warning （%）： 90
Critical （%）： 95
Which background process is responsible for issuing alerts when the threshold is crossed（）

A.System monitor （SMON）
B.Process monitor （PMON）
C.Memory manager process （MMAN）
D.Manageability Monitor process （MMON）

多项选择题

Which two statements about the background process of thedatabase writerare true（）

A.It is possible to have multiple database writers in an Oracle instance.
B.It writes dirty buffers， if any， to data files whenever a checkpoint occurs.
C.It writes dirty buffers， if any， to data files whenever a transaction commits.
D.It writes dirty buffers， if any， to data files before the log writer （LGWR） writes.