Oracle 19c OCP 1Z0-082认证考试题库（19-23）

19.Which three statements are true about Deferred Segment Creation in Oracle databases? A.It is the default behavior for tables and indexes.B.It is supported for sys-owned tables contained in locally managed tablespacesC.Sessions may dynamically switch back and forth from DEFERRED to IMMEDIATE segment creation.D.Indexes inherit the DEFERRED or IMMEDIATE segment creation attribute from their parent tableE.It is supported for Index Organized Tables(IOTs) contained in locally managed tablespaces.答案：ACD延迟段创建不支持的表类型包括：索引组织表用户SYS、SYSTEM、PUBLIC、OUTLN和XDB下的表不支持延迟段创建。20.Which two Oracle database space management features require the use of locally managed Table spaces?A.Oracle Managed Files(OMF).B.Server-generated tablespace space alerts C.Online segment shrinkD.Free space management with bitmaps E.Automatic data file extension (AUTOEXTEND)答案：CD21.Which three statements are true about data block storage in an Oracle Database? A.An index block can contain row dataB.A data block header is of a fixed lengthC.A table block must always contain row dataD.A block header contains a row directory pointing to all rows in the block.E.Row data is stored starting at the end of the block答案：ADE22.Which two are true about a SQL statement using SET operators such as UNION?A.The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first queryB.The number, but not names, of columns must be identical for all SELECT statements in the queryC.The names and number of columns must be identical for all SELECT statements in the query D.The data type of each column returned by the second query is automatically converted to the datatype of the corresponding column returned by the first queryE.The data type group of each column returned by the second query must match the data type group of the corresponding column returned by the first query答案：BE23.Which two are benefits of external tables?A.They support UPDATES which transparently updates records in the file system as if they were tableB.They can be queried while the database is in the MOUNT state like dynamic performance views C.They support DELETEs which transparently deletes records in the file system as if they were table rowsD.The results of a complex join or aggregating function or both can be unloaded to a file for transportation to another databaseE.They can be queried, transformed, and joined with other tables without having to load the data first答案：DE外部表可以做任何的查询操作，好处是不需要加载到数据库中，但是不支持任何的 dml操作。