Oracle Database 11g: Administration I v9.1 (1z0-052)

Page:    1 / 14   
Total 214 questions

The instance abnormally terminates because of a power outage.
Which statement is true about redo log files during instance recovery?

  • A. Inactive and current redo log files are required to accomplish recovery
  • B. Online and archived redo files are required to accomplish instance recovery
  • C. All redo log entries after the last checkpoint are applied from redo log files to data files
  • D. All redo log entries recorded in the current log file until the checkpoint position are applied to data files

Answer : C

Which two statements correctly describe the relation between a data file and the logical database structures? (Choose two)

  • 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 file can have only one segment created in it.
  • E. A data block can spread across multiple data files as it can consist of multiple operating system (OS) blocks.

Answer : A,C

View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour that performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives the following error:
ORA-01555: snapshot too old What could be the reason for this error?

  • A. The query is unable to get a read-consistent image.
  • B. There is not enough space in Flash Recovery Area.
  • C. There is not enough free space in the flashback archive.
  • D. The query is unable to place data blocks in undo tablespace.

Answer : A

Which two statements are true regarding the usage of the SQL*LOADER utility? (Choose two.)

  • 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 a named pipes

Answer : A,B

What is the effect of this command?

  • A. One audit record is created for every successful DROP TABLE command executed in the session of SCOTT
  • B. One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users
  • C. One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session
  • D. One audit record is created for every session of any other user in which a table owned by SCOTT is dropped successfully
  • E. One audit record is created for every successful DROP TABLE command executed by any user to drop tables owned by SCOTT

Answer : C

Which two files in the database can be configured for automatic backups by using the autobackup feature in Recovery Manager (RMAN)? (Choose two.)

  • A. Data Files
  • B. Control Files
  • C. Parameter Files
  • D. Online Redo Log Files
  • E. Server Parameter File

Answer : B,E

Which two operations can be performed on an external table? (Choose two.)

  • A. Create a view on the table
  • B. Create an index on the table
  • C. Create a synonym on the table
  • D. Add a virtual column to the table
  • E. Update the table using the UPDATE statement
  • F. Delete rows in the table using the DELETE command

Answer : A,C

View the Exhibit to examine the details for an incident.

Which statement is true regarding the status of the incident?

  • A. The DBA is working on the incident and prefers that the incident be kept in the ADR
  • B. The incident is now in the Done state and the ADR can select the incident to be purged
  • C. The incident has been newly created and is in the process of collecting diagnostic information
  • D. The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support

Answer : D

You have an ORDERS table with the following structure:

The table has data in the ODATE column for all rows. Many orders are placed in a single day. You need to ensure that the ODATE column must contain data for every order in future.
Which method would serve the purpose?

  • A. Modify the column using the ALTER TABLE ... MODIFY command.
  • B. Add a UNIQUE constraint to the column using the ALTER TABLE ... ADD CONSTRAINT command.
  • C. Add a NOT NULL constraint to the column using the ALTER TABLE ... ADD CONSTRAINT command.
  • D. Add a PRIMARY KEY constraint to the column using the ALTER TABLE ... ADD CONSTRAINT command.

Answer : A

View the Exhibit and examine the parameters. User A executes the following command to update the TRANS table:
SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code='C005';
Before user A issues a COMMIT or ROLLBACK command, user B executes the following command on the TRANS table:
SQL> ALTER TABLE trans MODIFY (tr_type VARCHAR2(3));
What would happen in this scenario?

A. The ALTER TABLE command modifies the column successfully
B. The DDL operation gets higher priority and transaction for user A is rolled back
C. The ALETER TABLE command waits indefinitely until user A ends the transaction
D. The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy

Answer : D Topic 2, Volume B

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?

  • A. Host naming method
  • B. Local naming method
  • C. External naming method
  • D. Directory naming method

Answer : B


Database Configuration Options -
Your installation process continues:
5. Navigate through the OUI pages and specify your database configuration options. OUI displays a summary of your installation choices.
6. 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.

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:
1. Configure the database to operate in shared server mode.
2. Disable automatic maintenance tasks such as optimizer statistics collection.
3. Configure a naming method to help the remote user connect to the database instance.
4. Use Automatic Storage Management (ASM) for storing the database files.
5. Configure daily database backup to flash recovery area.
6. Configure Enterprise Manager Database Control to manage the database.
Which of these requirements can be met while creating the database?

  • A. 4 and 6
  • B. 2, 3, 4, and 6
  • C. 1, 2, 4, 5, and 6
  • D. 1, 2, 3, 4, 5, and 6

Answer : C

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):

Exhibit2 (exhibit):

  • A. The user is authenticated by the operating system.
  • B. The objects created by the user are placed in the USERS tablespace.
  • C. The user does not require quota on the TEMP tablespace to perform sort operations.
  • D. The user is forced to change the password at the first login to the database instance.
  • E. The objects created by the user in future are unlocked to be accessed by all the users in the database by default.

Answer : B,C

You have executed this command to change the size of the database buffer cache:
System altered.
To verify the change in size, you executed this command:

Why is the value set to 4194304 and not to 2516582?

  • A. Because 4194304 is the granule size
  • B. Because 4194304 is the standard block size
  • C. Because 4194304 is the largest nonstandard block size defined in the database
  • D. Because 4194304 is the total size of data already available in the database buffer cache

Answer : A

Regardless of whether you are using automatic or manual memory management, you'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:

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?

  • A. Using the MERGE command
  • B. Using the SQL*Loader utility
  • C. Using the correlated UPDATE command
  • D. Using the INSERT command to perform bulk operation

Answer : A

Page:    1 / 14   
Total 214 questions