多项选择题
Which two statements correctly describe the relation between a data file and the logical databasestructures()
A.An extent cannot spread across data files.
B.A segment cannot spread across data files.
C.A data file can belong to only one tablespace.
D.A data file can have only one segment created in it.
E.A data block can spread across multiple data files as it can consist of multiple operating system (OS) blocks.
相关考题
-
单项选择题
ote the following structures in your database server: 1:Extents 2:OS Blocks 3:Tablespace 4:Segments 5:Oracle Data Block Which option has the correct arrangement of these structures from the smallest to the largest()
A.2, 5, 1, 4, 3
B.1, 2, 3, 4, 5
C.5, 2, 1, 3, 4
D.2, 1, 5, 4, 3 -
单项选择题
Identifythelogicalstructurethatwillneverhavemorethanonedatasegmentcreatedforit.()
A.external table
B.partitioned table
C.partitioned index
D.nonclustered table
E.global temporary table -
多项选择题
WhichthreestatementsaretrueaboutlogicalstructuresoftheOracledatabase()
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.
