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 f

第1题：

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

第2题：

Which of the following defines memory interleaving?（）

• A、The distribution of data written across all the memory DIMMs and the L1 cache
• B、The distribution of data written across all the memory DIMMs in one bank
• C、The distribution of data written across all the memory DIMMs and the processor
• D、The distribution of data written across all the memory DIMMs and the L2 cache

第3题：

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.

第4题：

Which 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

第5题：

The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover？（）

• A、Restore the data file and perform incomplete recovery.
• B、Restore the data file and perform point-in-time recover.
• C、Drop the tablespace and lose all data in the tablespace.
• D、Restore the database and lose all data since the last backup.

第6题：

Which two statements are true about simple views？（）

• A、Views can be created as read only.
• B、Views are data segments like tables.
• C、Views can be created on the basis of more than one table.
• D、Data manipulation language （DML） operations cannot be performed on views.

第7题：

When performing an incomplete recover of the whole database， which data files must you restore？ （）

• A、Only the damaged or lost data files.
• B、All of the data files of the database.
• C、Only the data files belonging to the SYSTEM tablespace.
• D、The data files belonging to the SYSTEM tablespace and the damaged or lost data files.

第8题：

Which three statements are true regarding the data types in Oracle Database 10g/11g?（）

• A、Only one LONG column can be used per table 
• B、A TIMESTAMP data type column stores only time values with fractional seconds 
• C、The BLOB data type column is used to store binary data in an operating system file 
• D、The minimum column width that can be specified for a VARCHAR2 data type column is one 
• E、The value for a CHAR data type column is blank-padded to the maximum defined column width

第9题：

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.

第10题：

第11题：

第12题：

第13题：

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

第14题：

You are creating a locally managed tablespace to meet the following requirements： All the extents should be of the same size.  The data should be spread across two data files.  A bitmap should be used to record the free space within the allocated extents. Which three options would you choose？（）

• A、set PCTFREE and PCTUSED to 50
• B、specify extent allocation as Uniform
• C、specify extent allocation as Automatic
• D、create the tablespace as bigfile tablespace
• E、create the tablespace as smallfile tablespace
• F、set segment space management to Automatic
• G、use the RESIZE clause while creating the tablespace

第15题：

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.

第16题：

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.

第17题：

The data file belonging to the SYSTEM tablespace is 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 the SYSTEM auto 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.

第18题：

Which two statements are true regarding transactions in an Oracle database（）

• A、Multiple transactions can use the same undo segment.
• B、A transaction is assigned an undo segment when it is started.
• C、More than one transaction cannot share the same extent in the undo tablespace.
• D、The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.

第19题：

Which two statements are true regarding the usage of the SQL*Loader utility（）

• A、You can load data into multiple tables during the same load session.
• B、You can load data from multiple files to a table during the same load session.
• C、You cannot perform selective data loading based on the values available in the records.
• D、You can use an export file generated by the EXPDP utility as an input data file to load the data.
• E、You can load data only if the input file is available on the disk and tape but not in a named pipes.

第20题：

View this parameter setting in your database：   DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’  You created a tablespace by using this command：   CREATE TABLESPACE USERS；  Which two statements are true about the USERS tablespace？（）

• A、The tablespace has two data files.
• B、An error is reported and tablespace creation fails.
• C、Data files are created with names generated by the instance.
• D、The tablespace can be extended without specifying the data file.
• E、Data files belonging to the USERS tablespace cannot be renamed.

第21题：

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.

第22题：

第23题：