Ause the create database command to create the

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: he database with Oracle-managed files. B.Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. 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 Processing template. E.Use the CREATE DATABASE... command to create the database with Automatic Storage Management (ASM) file system. Answer: D QUESTION 64: You work as a database administrator for Certkiller .com. You determine that - 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? A.USER_DUMP_DEST B.CORE_DUMP_DEST C.ALERT_LOG_DEST D.ALERT_DUMP_DEST E.TRACE_DUMP_DEST F.BACKGROUND_DUMP_DEST Answer: F QUESTION 65: 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 files. Answer: B QUESTION 66: 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

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online