Incorrect answers b you cannot do this with a cancel

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: ant tablespace set from the master definition site to the new master site to perform this step. Incorrect Answers B: You cannot do this with a cancel-based recovery on the new master site. C: You cannot do this with a time-based recovery on the new master site. Actualtests.com - The Power of Knowing 1Z0-030 E: You will not be able to instantiate the database at the new master site by performing an export using the FLASHBACK_SCN option on the master definition site and then import the dump file to the new master database. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 83-93 Chapter 2: Availability Enhancements Oracle 9i New Features, Robert Freeman, p. 147 Chapter 5: Miscellaneous Oracle9i Features and Enhancements QUESTION 113: What is the meaning of using "character semantics" to create a table? A. You use only use CHAR data types. B. All columns are a single character wide. C. You use single letter names of all columns. D. You specify the width of a column in characters, not in bytes. E. You use only character type data types (CHAR, NCHAR, VARCHAR2, NVARCHAR2, CLOB, NCLOB). Answer: D Explanation: You specify the width of a column in characters, not in bytes to create a table. You can specify byte or character semantics with the NLS_LENGTH_SEMANTICS initialization parameter. With a single-byte system, it does not matter whether you set the semantics to character or to byte, because one byte corresponds to one character in the system. When you specify character semantics, the database will reserve the number of bytes needed to store the characters when using multi-byte system. With byte semantics, you must calculate the bytes needed and specify how many. Thus, character semantics make it easier for you to work with multi-byte systems. Incorrect Answers A: It does not mean that you can use only CHAR data types. It just simplifies your work with multi-byte systems. B: It does not require that all columns are a single character wide. C: This statement is incorrect: character semantics does not limit you with single letter names for columns. E: You can use various types. It means only that the database will reserve the number of bytes needed to store the characters when using multi-byte system. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 275-276 Chapter 5: Language Enhancements Oracle 9i New Features, Robert Freeman, p. 139-141 Chapter 5: Miscellaneous Oracle9i Features and Enhancements QUESTION 114: Your database has tablespaces with different block sizes. What must you do to back Actualtests.com - The Power of Knowing 1Z0-030 these up with RMAN? A. You need to issue a separate RMAN BACKUP command to group tablespaces with the same block size. B. You need to use RMAN BACKUP BLOCKSIZE=nK to select tablespaces that are not the same size as the standard block size. C. You can simply issue the RMAN BACKUP command, because a backup set can contain tablespaces of different block sizes. D. You must allow for the fact that...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online