1Z0-035 무료 덤프문제 온라인 액세스

When executing parallel DELETE statements, what is the maximum degree of parallelism allowed on a table?

• A.the table default degree of parallelism
• B.limited by the system
• C.10
• D.limited to the number of partitions

Which two factors can influence the time taken for instance recovery? (Choose two)

• A.the number of archived redo logs that have to be read
• B.size of the redo log buffer
• C.value of FAST_START_IO_TARGET
• D.the number of tables stored in the database buffer cache at the moment of failure
• E.value of RECOVERY_PARALLELISM
• F.size of the system tablespace

What are three advantages of index-organized tables? (Choose three.)

• A.Fewer I/O operations are needed to retrieve data.
• B.The table needs to be analyzed less frequently.
• C.Data is stored in primary key sequence.
• D.Less physical storage space is needed for the data.

Which three features are provided by Recovery Manager and NOT provided by user-managed backup and recovery? (Choose three.)

• A.online backups
• B.partial database backups
• C.incremental block-level backup
• D.skipping unused blocks
• E.detection of corrupted blocks during backup

Consider the following statement:
SQL> EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS (2> ownname => 'OE', 3> estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, 4> method_opt => 'for all columns size AUTO');
What is the effect of 'for all columns size AUTO' of the METHOD_OPT option?

• A.The Oracle server creates a histogram based on data distribution and application usage of the column/s for all table, column, and index statistics for the OE schema.
• B.The Oracle server creates a new histogram based on existing histogram definitions for all table, column, and index statistics for the OE schema.
• C.The Oracle server creates a histogram based on application usage, regardless of data distribution, for all table, column, and index statistics for the OE schema.
• D.The Oracle server creates a histogram based on data distribution regardless of how the application uses the column/s for all table, column, and index statistics for the OE schema.