Oracle Database 11g: Administration I
Question No: 71 – (Topic 2)
Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a remote machine?
Host naming method
Local naming method
External naming method
Directory naming method
Answer: B Explanation:
Database Configuration Options Your installation process continues:
Navigate through the OUI pages and specify your database configuration options. OUI displays a summary of your installation choices.
Click Install to begin your installation of the Oracle software.
If you chose to create a starter database as part of the installation, OUI invokes all of these configuration assistants:
Oracle Net Configuration Assistant: This configures basic network components during installation including:
Listener names and protocol addresses
Naming methods that the client will use to resolve connect identifiers to connect descriptors
Net service names in a tnsnames.ora file
Directory server usage
Oracle Database Configuration Assistant (DBCA): This creates the starter database that you selected. When this configuration assistant finishes, you can unlock accounts and change passwords.
Question No: 72 – (Topic 2)
You are working on a new Oracle Database 11g server, where only the software is installed and no database is created. You plan to create a database on this server using the Database Configuration Assistant (DBCA).
Some of the requirements set for your database creation task are:
Configure the database to operate in shared server mode.
Disable automatic maintenance tasks such as optimizer statistics collection.
Configure a naming method to help the remote user connect to the database instance.
Use Automatic Storage Management (ASM) for storing the database files.
Configure daily database backup to flash recovery area.
Configure Enterprise Manager Database Control to manage the database. Which of these requirements can be met while creating the database?
4 and 6
B. 2, 3, 4, and 6
C. 1, 2, 4, 5, and 6
D. 1, 2, 3, 4, 5, and 6
Question No: 73 – (Topic 2)
View the Exhibit1, which shows the options that are selected to create the user SL_REP. View the Exhibit2 and examine the contents of DATABASE_PROPERTIES.
Which two statements are true regarding this user? (Choose two.) Exhibit1 (exhibit):
The user is authenticated by the operating system.
The objects created by the user are placed in the USERS tablespace.
The user does not require quota on the TEMP tablespace to perform sort operations.
The user is forced to change the password at the first login to the database instance.
The objects created by the user in future are unlocked to be accessed by all the users in the database by default.
Question No: 74 – (Topic 2)
You have executed this command to change the size of the database buffer cache:
SQLgt; ALTER SYSTEM SET DB_CACHE_SIZE=2516582;
To verify the change in size, you executed this command:
Why is the value set to 4194304 and not to 2516582?
Because 4194304 is the granule size
Because 4194304 is the standard block size
Because 4194304 is the largest nonstandard block size defined in the database
Because 4194304 is the total size of data already available in the database buffer cache
Answer: A Explanation:
Regardless of whether you are using automatic or manual memory management, you#39;ll find that memory is allocated to the various pools in the SGA in units called granules. A single granule is an area of memory of 4MB, 8MB, or 16MB in size. The granule is the smallest unit of allocation, so if you ask for a lava pool of 5MB and your granule size is 4MB. Oracle will actually allocate 8MB to the lava pool (8 being the smallest number greater than or equal to 5 that is a multiple of the granule size of 4). The size of a granule is determined by the size of your SGA (this sounds recursive to a degree, as the size of the SGA is dependent on the granule size). Vim can view the granule sizes used for each pool by querying V$SGA_DYNAMIC_COMPONENTS. In fact, we can use this view to see how the total SGA size might affect the size of the granules:
Question No: 75 – (Topic 2)
The TRANS_SUMMARY table contains product-wise transaction details that get updated with every transaction in the system. Each row has cumulative transaction details of a single product and every product is identified by a product code, which is the primary key.
As part of the archival process, the company wants to transfer the rows in the TRANS_SUMMARY table to the TRANS_SUMMARY_DUP table at the end of every quarter of the year. Along with existing products, the company deals with many new products during every quarter.
Which method is best suited for this quarterly data transfer?
Using the MERGE command
Using the SQL*Loader utility
Using the correlated UPDATE command
Using the INSERT command to perform bulk operation
Question No: 76 – (Topic 2)
Which statement is true about a whole consistent database backup on a database running in
The backup will consist of used data blocks only.
The database must be shut down to accomplish the backup.
The backup can be accomplished without shutting down the database.
The backup will contain all database files that have never been backed up.
Question No: 77 – (Topic 2)
You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance, you plan to move the data from the flat files to clustered tables in an Oracle database. While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into the Oracle database?
Use the external table population.
Use the Oracle Data Pump export and import utility.
Use the conventional path data load of the SQL*Loader utility.
Use the INSERT INTO…SELECT command to load the data.
Question No: 78 – (Topic 2)
Which three operations require undo data? (Choose three.)
Committing a transaction
Flashing back a transaction
Recovering a failed transaction
Running a read-consistent query
Changing a tablespace status from READ ONLY to READ WRITE
Answer: B,C,D Explanation:
Module 10 – Managing Undo Data Objectives
These notes teach you about managing undo data including the method used to implement automatic undo data management. You will also learn to create and modify undo segments and how to query the data dictionary to retrieve undo segment information.
Beginning with Release 11 g, for a default installation, Oracle Database automatically manages undo.
There is typically no need for DBA intervention.
If your installation uses Oracle Flashback operations, you may need to perform some undo management tasks to ensure the success of these operations.
Undo records are used to:
Roll back transactions when a ROLLBACK statement is issued
Recover the database
Provide read consistency
Analyze data as of an earlier point in time by using Oracle Flashback Query
Recover from logical corruptions using Oracle Flashback features
Question No: 79 – (Topic 2)
Which two statements are true regarding undo tablespaces? (Choose two.)
The database can have more than one undo tablespace
The UNDO_TABLESPACE parameter is valid in both automatic and manual undo management
Undo segments automatically grow and shrink as needed, acting as circular storage buffer for their assigned transactions
An undo tablespace is automatically created if the UNDO_TABLESPACE parameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up
Question No: 80 – (Topic 2)
Observe the information in the columns:
Which option has the correct match between the memory areas and their contents?
A. 1-c, 2-b, 3-d, 4-a
B. 1-b, 2-c, 3-d, 4-a
C. 1-a, 2-b, 3-c, 4-d
D. 1-a, 2-b, 3-d, 4-c
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|