An extent cannot spread across data files.
A segment cannot spread across data files.
A data file can belong to only one tablespace.
A data file can have only one segment created in it.
A data block can spread across multiple data files as it can consist of multiple operating system (OS)blocks
第1题:
Which two statements about bigfile tablespaces are true? ()
第2题:
Which statements are true about logical structures of the Oracle database()
第3题:
A data file become corrupted in your database due to bad sectors on the disk. Because of corruption, you lost all the important tables in that data file. Which method would you use for recovery?()
第4题:
Which two statements are true regarding transactions in an Oracle database()
第5题:
Which three statements are true regarding the data types in Oracle Database 10g/11g?()
第6题:
Which three statements are true regarding the logical structure of the Oracle database?()
第7题:
Restore the data file and perform incomplete recovery.
Restore the data file and perform point-in-time recover.
Drop the tablespace and lose all data in the tablespace.
Restore the database and lose all data since the last backup.
第8题:
You cannot export data from a remote database.
You can rename tables during an import operation.
You can overwrite existing dump files during an export operation.
You can compress the data during export but not the metadata because it is not supported.
第9题:
Creating and dropping tables in the data file being moved
Performing file shrink of the data file being moved
Querying tables in the data file being moved
Performing Block Media Recovery for a data block in the data file being moved
Flashing back the database
Executing DML statements on objects stored in the data file being moved
第10题:
An extent cannot spread across data files.
A segment cannot spread across data files.
A data file can belong to only one tablespace.
A data file can have only one segment created in it.
A data block can spread across multiple data files as it can consist of multiple operating system (OS) blocks.
第11题:
You can load data into multiple tables during the same load session.
You can load data from multiple files to a table during the same load session.
You cannot perform selective data loading based on the values available in the records.
You can use an export file generated by the EXPDP utility as an input data file to load the data.
You can load data only if the input file is available on the disk and tape but not in a named pipes.
第12题:
The bigfile tablespace have only one data file.
The segment space management is automatic.
The extent management is dictionary managed.
The database can have only one bigfile tablespace.
The bigfile tablespace can be converted to a smallfile tablespace.
第13题:
The data file belonging to theSYSTEMtablespaceis corrupted and no backup of the file is available. How do you recover the data file?()
第14题:
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups, and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file?()
第15题:
Which two statements are true about simple views?()
第16题:
Which two statements are true regarding the usage of the SQL*Loader utility()
第17题:
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?()
第18题:
Which three statements are true about logical structures of the Oracle database()
第19题:
Each segment contains one or more extents.
Multiple tablespaces can share single data file.
A data block is the smallest unit of I/O for data files.
It is possible to have tablespaces of different block sizes in a database.
Each data block in the database always corresponds to one OS block.
第20题:
Each segment contains one or more extents.
Multiple tablespaces can share a single data file.
A data block is the smallest unit of input/output (I/O) in data files.
It is possible to have tablespaces of different block sizes in a database.
Each data block in the database always corresponds to one operating system block.
第21题:
Multiple transactions can use the same undo segment.
A transaction is assigned an undo segment when it is started.
More than one transaction cannot share the same extent in the undo tablespace.
The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.
第22题:
Flash back all the tables in the data file, one by one.
Restore the data file to a new location and perform a media recovery.
Flash back the database, there is no need to restore the data file.
Restore the data file from the most recent backup and flash the database.
第23题:
Each segment contains one or more extents.
Multiple tablespaces can share a single data file
A data block is the smallest unit of input/output (I/O) in data files.
It is possible to have tablespaces of different block sizes in a database.
Each data block in the database always corresponds to one operating system block
第24题:
An extent cannot spread across data files.
A segment cannot spread across data files.
A data file can belong to only one tablespace.
A data file can have only one segment created in it.
A data block can spread across multiple data files as it can consist of multiple operating system (OS)blocks