多选题Which two statements correctly describe the relation between a data file and the logical databasestructures（）AAn extent cannot spread across data files.BA segment cannot spread across data files.CA data file can belong to only one tablespace.DA data fi

第1题：

第2题：

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.

第3题：

第4题：

The data file belonging to theSYSTEMtablespaceis corrupted and no backup of the file is available. How do you recover the data file？（）

• A、The data file cannot be recovered.
• B、The date file can be restored from theSYSTEMauto backup.
• C、Take thetablespaceoffline，drop，kand re-create it.
• D、Recovery Manager （RMAN） is used to recover the data file.
• E、The ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.

第5题：

A PC on a network segment sends data to another PC on a different segment.Which of the following correctly describe the correct order of how this data will be encapsulated?（）

• A、Data, Frame, Packet, Segment, Bit
• B、Data, Frame, Segment, Packet, Bit
• C、Data, Packet, Frame, Segment, Bit
• D、Data, Packet, Segment, Frame, Bit
• E、Data, Segment, Frame, Packet, Bit
• F、Data, Segment, Packet, Frame, Bit

第6题：

Which file characteristic cannot be used in the Cisco IronPort Data Security policies？（） 

• A、 file type
• B、 file size
• C、 file age
• D、 file  name

第7题：

Which four actions are possible during an Online Data file Move operation?（）

• A、Creating and dropping tables in the data file being moved
• B、Performing file shrink of the data file being moved
• C、Querying tables in the data file being moved
• D、Performing Block Media Recovery for a data block in the data file being moved
• E、Flashing back the database
• F、Executing DML statements on objects stored in the data file being moved

第8题：

第9题：

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.

第10题：

Which two statements about subqueries are true?（）

• A、A single row subquery can retrieve data from only one table.
• B、A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.
• C、A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.
• D、A single row subquery can retrieve data from more than one table.
• E、A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.
• F、A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.