052 (c)

11.

 One. Which statements is true about GKFX SQL area andPrivate SQL area? (Choose.) A. Shared SQL area would be allocatedinchThe shared Pool B. Shared SQL area would be allocated whena session starts C. GKFX SQL area would be allocatedinchThe large pool always D. The whole ofPrivate SQL area would be allocatedinchThe program Global area (PGA) always E. Shared SQL area andPrivate SQL area would be allocatedinchThe PGAorLarge Pool F. the Number  ofPrivate SQL Area Allocations isDependent onThe open_cursors parameter Answer:af

The SQL information stored in the private SQL area is only unique to the session where the SQL statement was executed, and other sessions cannot share this part of the information.

12.

 A. Which three statements is correct aboutTemporarytables? (Choose three.) A. Indexes andViews can be created on Temporarytables B. Both the Data andStructure of Temporarytables can be exported C.TemporaryTables is always createdinchAUser's temporary tablespace D. The data inserted into a temporary table in a session was available to other sessions E. Data manipulation Language (DML) L Ocks is never acquired on the data of temporary tables Answer:ace

The Oracle staging table is divided into session-level temporary tables and transaction-level temporary tables
A DML lock is not required for temporary tables. When a session ends (the user exits gracefully when the user quits abnormally) or the end of a transaction, Oracle executes the TRUNCATE statement on the table of the session to empty the temporary table data. The data in the other session staging table is not emptied.
You can index temporary tables and build views on temporary tables. Similarly, indexes built on temporary tables are temporary and valid only for the current session or transaction
Temporary tables are typically created in the user's temporary table space, and different users can have their own separate temporary table spaces
Temporary table structure can be exported, but content cannot be exported
Different sessions can not access each other's temporary table data

13.

 -. which kinds offailures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose.) A. Failure whenNo standbyDatabase  isconfigured B. Failure because a datafile  isrenamed accidentally C. Failure that requires no archive logs toBe applied forrecovery D. Failure due toLoss ofConnectivity- forExample, an unpluggedDiskCable ANSWER:BD

DRA is a new feature of Oracle 11g

Data failure information is automatically collected when an error is encountered. In addition, it is capable of pre-checking for faults. In this mode, it detects and analyzes data failures before the database process discovers corruption and sends error messages

14.

 -. Which statements correctly describe the relationbetweenA datafile  andThe logicalDatabasestructures? (Choose) A. An extent cannot spread across data files. B. A segment cannot spread across data files. C. A DatafileCan belong to  onlyOne tablespace. D. A DatafileCan has onlyOne segment createdinchit. E. A data block can spread across multiple data files asIt can consist ofmultiple operating system (OS) blocks. Answer:ac

The logical database space above the data block is the data extension (extent). A data extension is a contiguous set of blocks of data that is allocated for storing data.
The logical database storage structure on top of the data extension is segment (segment). A segment consists of a set of data extensions (extent) that reside in the same table space (tablespace) for storing various logical data structures.

A segment (segment) and all data extensions (extent) that belong to her must be included in the same table space (tablespace). However, within a table space, data extensions that belong to the same segment can be distributed across multiple data files (datafile), where segments can be stored over files. However, each data extension can only be included in the same data file.

15.

 of containsof contains  of nonpartitioned segment ANSWER:BD

The allocation units of the database space are data blocks, data extensions (Extent), and segments (Segment)

Create a table space you can add a parameter: blocksize This parameter can set the size of an nonstandard block. If you want to set this parameter, you must set db_block_size, at least one db_nk_block_size, and the value of the declared integer must be equal to db_nk_block_size.

052 (c)