Oracle 1z0-032: Oracle 9i Database Fundamentals-II #5

QUESTION NO: 21

Which two statements are true regarding the use of UTF-16 encoding? (Choose two)

A. Enables easier loading of multinational data.
B. Uses a fixed-width Multibyte encoding sequence.
C. Asian characters are represented in three characters.
D. Used a variable-width Multibyte encoding sequence.
E. European characters are represented on one or two bytes.

Answer: A, B

Explanation:

AL16UTF16 is a 2-byte, fixed-width Unicode character set, which is also referred to as UTF16 or UCS2. The ASCII English character set is assigned the first 128 values from 0 (0X00) through 127 (oX7F) in Unicode, which translates to 1 byte. Even though AL16UTF16 uses one more byte than UTF8 for ASCII character representation, it is still faster because it uses fixed-width encoding as opposed to UTF8, which uses variable-width encoding. UTF-16 encoding enables easier loading of multinational data. It uses a fixed-width multibyte encoding sequence.

Incorrect Answers

C: Asian characters are represented in two characters because UTF16 is a 2-byte, fixed-width Unicode character set.
D: It uses a fixed-width multibyte encoding sequence.
E: European characters are represented in two bytes because UTF16 is a 2-byte, fixed-width Unicode character set.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 266-278
Chapter 5: Language Enhancements
Oracle 9i New Features, Robert Freeman, p. 139-146
Chapter 5: Miscellaneous Oracle9i Features and Enhancements

QUESTION NO: 22

The Oracle Shared Server architecture reduces memory usage by reducing the number of server processes required. To process a request for a server process, the following tasks are performed:
1. A shared server picks up the request from the request queue and processes the request.
2. The dispatcher retrieves the response from the response queue.
3. A user sends a request to its dispatcher.
4. The dispatcher returns the response to the user.
5. The shared sever places the response on the calling dispatcher’s response queue.
6. The dispatcher places the request into the request queue in the SGA.

Put the above task in the order in which they are performed.

A. 3, 1, 6, 2, 5, 4
B. 3, 6, 1, 5, 2, 4
C. 3, 1, 2, 3, 4, 5
D. 6, 1, 3, 5, 2, 4
E. 6, 3, 1, 2, 4, 5
F. 6, 3, 1, 2, 5, 4

Answer: B

Explanation:

When the user process arrives, the listener examines the request and determines whether the user process can use a shared server process. If so, the listener returns the address of the dispatcher process that is currently handling the least number of requests. Then the user process connects to the dispatcher directly. The dispatcher process then directs multiple client requests to a common queue. The idle shared server processes pick up the virtual circuit from the common request queue on a first-in-first-out (FIFO) basis and make all necessary calls to the database to complete that request. When the server process completes the request, it places the response on the calling dispatcher response queue. The dispatcher then returns the completed request to the appropriate user process.

Incorrect Answers

A: The dispatcher places the request into the request queue in the SGA before a shared server picks up the request from the request queue and processes the request..
C: After user sent a request to its dispatcher the dispatcher places the request into the request queue in the SGA.
D: A user sends a request to its dispatcher. This is first step of the procedure.
E: A user sends a request to its dispatcher. This is first step of the procedure.
F: A user sends a request to its dispatcher. This is first step of the procedure.

OCP Oracle9i Database: Fundamentals II Exam Guide, Rama Velpuri, p. 100-102
Chapter 5: Usage and Configuration of the Oracle Shared Server

QUESTION NO: 23

You issue this RMAN command:
RMAN> create script Level0Backup {
backup
incremental level 0
format ‘/u01/db01/backup/%d_%_Sp’
fileperset 5
(database include current controlfile);
sql ‘alter database archive log current’;
}

Which three statements are true about the Level0 Backup script you just created?
(Choose three)

A. The script is stored only in the control file.
B. The script is stored only in the recover catalog.
C. The script can be executed only by using the RMAN RUN command.
D. The commands of the script can be displayed with the LIST command.
E. The commands of the script can be displayed with the PRINT command.
F. The commands of the script can be displayed with the REPORT command.

Answer: B, C, E

Explanation:

A stored script is a sequence of RMAN commands stored within the recovery catalog repository. To execute a stored script, you must use the EXECUTE SCRIPT command in a RUN block, as shown in the following code. The commands of the script can be displayed with the PRINT command.

Incorrect Answers

A: The script is stored only in the recover catalog, not in the control file.
D: The LIST command queries the repository and generates a list of all the backup sets and image copies recorded in the RMAN’s metadata that are specific to a database.
F: The REPORT command performs detailed analysis of the information stored in the repository and displays detailed outputs on backup sets or image copies.

OCP Oracle9i Database: Fundamentals II Exam Guide, Rama Velpuri, p. 400-407
Chapter 17: Recovery Catalog Creation and Maintenance

QUESTION NO: 24

Which RMAN command do you use to verify that the RMAN repository information is synchronized with the actual files that exist on disk?

A. LIST
B. CHANGE
C. CATALOG
D. CROSSCHECK

Answer: D

Explanation:

RMAN command CROSSCHECK enables you to crosscheck the availability of the backup sets by verifying the information stored in its repository with the backup sets that are physically available in the designated storage medium.

Incorrect Answers

A: The LIST command queries the repository and generates a list of all the backup sets and image copies recorded in the RMAN’s metadata that are specific to a database.
B: The CHANGE command can be used with UNCATALOG clause: it removes the records of the specified backup sets and image copies from the catalog and updates the control file records status as DELETED. Also it can be run with AVAILABLE or UNAVAILABLE clauses: RMAN would then update the repository to reflect the respective backup files as either available or unavailable.
C: The copies of files generated using O/S commands and utilities are similar to RMAN image copies. But these are not recognized by RMAN until you catalog the file copies by executing the RMAN CATALOG command.

OCP Oracle9i Database: Fundamentals II Exam Guide, Rama Velpuri, p. 269-270
Chapter 11: RMAN Backups

QUESTION NO: 25

A web browser can connect directly to an Oracle server using which two? (Choose two)

A. HTTP
B. IIOP
C. TCP/IP
D. Named Pipes
E. TCP/IP with SSL

Answer: A, B

Explanation:

The clients forward the requests using HTTP, which provides the language that enables Web browsers and application Web servers to communicate. Also web clients can access the Oracle database directly – for example, by using a Java applet. In addition to regular
connections, the database can be configured to accept HTTP and Internet Inter-ORB Protocol (IIOP) connections.

Incorrect Answers

C: A web browser can connect directly to an Oracle server just using TCP/IP.
D: Names Pipes are not used to connect a web browser directly to an Oracle server.
E: TCP/IP with SSL is not used to connect a web browser directly to an Oracle server.

OCP Oracle9i Database: Fundamentals II Exam Guide, Rama Velpuri, p. 34-36
Chapter 2: Basic Oracle Net Architecture