Questions21-30
QUESTION 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.
QUESTION 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.
Actualtests.com - The Power of Knowing
1Z0-032
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.
QUESTION 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 Level0Backup 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.
Printing a Script to a File: Example
/tmp/backup_db.rman':PRINT SCRIPT backup_db TO FILE '/tmp/backup_db.rman';
Printing a Script to the Screen: Example
RMAN> PRINT SCRIPT 'backup_db'; printing stored script: backup_db { ALLOCATE CHANNEL c1 DEVICE TYPE sbt BACKUP DATABASE;}
QUESTION 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.
QUESTION 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.
QUESTION 26:
What is true regarding direct-load insert?
A. A direct-load insert can be invoked by suing the APPEND hint.
B. Inserting using the NOLOGGING option is the default for direct-load inserts.
C. All data loaded using direct-load insert is loaded below the high-water mark.
D. An object that is modifies using parallel direct-load can be queried within the same
transaction.
Answer: A
Explanation:
Conventionally when we insert data is first loaded in Instance and then in to database via DBWR.but in direct-load insert data is directly loaded into data files of database.Its fast but uses more memory.
It inserts data in only those segments which are above the high-water mark.Data is appended to the table. Existing free space is not re-used. So, if you direct load insert a bunch of rows, then delete them, and insert them again, the space made by the delete will not be re-used.
QUESTION 27:
In which three cases does a checkpoint occur? (Choose three)
A. Every three minutes.
B. When a log switch occurs.
C. When forces by an administrator.
D. When a tablespace is taken offline normal.
E. When the redo buffer is one-third full.
Answer: B, C, D
Explanation:
Checkpoints, at the database or data file level, occur automatically when the database
encounters the following conditions:
1>when a log switch occurs, when configured through the
database initialization parameters LOG_CHECKPOINT_INTERVAL and
LOG_CHECKPOINT_TIMEOUT,
2>when an online database backup begins, when a
tablespace is taken offline NORMAL,
3>when the ALTER SYSTEM CHECKPOINT command
is issued, when the database is closed gracefully or when the redo buffer is one-third full.
QUESTION 28:
Which two roles or privileges must you have to export tables owned by another user?
(Choose two)
A. CREATE USER
B. CREATE SESSION
C. CREATE ANY TABLE
D. IMP_FULL_DATABASE
E. EXP_FULL_DATABASE
Answer: B, E
Explanation:
1>To connect to the database you need the CREATE SESSION privilege.
2>To do a full export or an export tables owned by another user you need the EXP_FULL_DATABASE privilege.
QUESTION 29:
When you are performing media recover, and an archived log is lost or corrupt, which
type of recover must you perform?
A. Until SCN
B. Until time
C. Until cancel
D. Recover using backup control file.
Answer: C
Explanation:
You must use the cancel-based recovery to perform an incomplete media recovery if a current
redo log is damaged and is not available to perform recovery. Another reason for using
cancel-based recovery is when an archived redo log file needed for recovery is unavailable
either due to the loss of the file or corruption. Archiving to multiple destinations or backing
up the files more frequently can avoid such errors.
QUESTION 30:
Which three features are provided by Oracle Net Services? (Choose three)
A. Data encryption.
B. User authentication.
C. Transparent data conversion
D. Configuration and administration mechanisms.
E. Support for multiple network transport protocols.
Answer: C, D, E
Explanation:
Two Task Common layer of Oracle Net Services provide transparent data conversion,
configuration and administration
mechanisms, support for multiple network transport protocols(if client is using http and server is using Tcp/Ip).
Post a Comment