The instance abnormally terminates because of a power outage.
Which statement is true about redo log files during instance recovery?
Answer : C
Which two statements correctly describe the relation between a data file and the logical database structures? (Choose two)
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?
Exhibit:
Answer : A
Which two statements are true regarding the usage of the SQL*LOADER utility? (Choose two.)
Answer : A,B
SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;
What is the effect of this command?
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.)
Answer : B,E
Which two operations can be performed on an external table? (Choose two.)
Answer : A,C
View the Exhibit to examine the details for an incident.
Answer : D
You have an ORDERS table with the following structure:
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?
Exhibit:
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?
Answer : B
Explanation:
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?
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):
Answer : B,C
You have executed this command to change the size of the database buffer cache:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582;
System altered.
To verify the change in size, you executed this command:
Answer : A
Explanation:
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?
Answer : A