This preview shows page 1. Sign up to view the full content.
Unformatted text preview: he database with
B.Use the Database Configuration Assistant (DBCA) to create the database with
C.Use the Enterprise Manager to create a new database with the Online Transaction
Processing (OLTP) option.
D.Use Database Configuration Assistant (DBCA) to create the database with Transaction
E.Use the CREATE DATABASE... command to create the database with Automatic
Storage Management (ASM) file system.
You work as a database administrator for Certkiller .com. You determine that
Actualtests.com - The Power of Knowing 1Z0-042
archiving was not successful in one of thedestinators. You want to check the alert
log file for more information on this.
Which initialization parameter gives you the location of the alert log file?
Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement
regarding the usage of redo log files during instance recovery is true?
A.Transactions are rolled back using redo log files.
B.Transactions are rolled forward using redo log files.
C.Transactions are rolled back using redo log files and archived log files.
D.Transactions are rolled forward using redo log files and rolled back using redo log
You execute the following command in your Certkiller .com production database to
change the width of the CUST_NAME column of the CUSTOMERS table:
ALTER TABLE customers
MODIFY (cust_nameVARCHAR2 (40))
When you execute the command, it displays the following error message:
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified
What could be the reason for the error message?
A.The database instance is not available.
B.The ALTER TABLE command does not have WAIT option
C.The table or a row in the table is currently locked by another user session.
D.The database instance is busy processing other...
View Full Document
- Fall '09