1Z0-030 Oracle - Braindumps.com.ua: question list for "Oracle 9i: New Features For Administrators", page: 11

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2461)

Network Appliance (2)

Authorization

Login:
Password:
remember me:

Contacts
Certification links
Links

Authorized user can see question and answers.
Please log in or sign up.

Exam question list:
Show all comments

Oracle 1Z0-030: Oracle 9i: New Features For Administrators

#101. The Performance Manager, part of Oracle9i Enterprise Manager, can monitor the performance of which three Oracle Shared Server components? (Choose three.)

#102. Examine this statement, which creates a Cartesian product of the COUNTRIES and REGION tables:

 SQL> SELECT c.country_name, 
 2> r.region name 
 3> FROM countries c, region r;

Oracle9i SQL: 1999 syntax supports the same functionality with which join type?

#103. To assist you in migrating your existing LONG columns to LOB data types, the ALTER TABLE syntax has been enhanced to support LONG to CLOB migration and LONG RAW to BLOB migration.
During this migration, if redo logging is enabled for the table or for the LOB being created, the ALTER TABLE ... MODIFY command temporarily _______ the space requirements.

#104. Which two data types can be converted to LOBs using an ALTER TABLE...MODIFY command? (Choose two.)

#105. In order to speed foreign key creation, Oracle9i will cache the first _________ primary key values only where there are multirow DML statements.

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

#107. What is the meaning of using "character semantics" to create a table?

#108. The new time and date data types support greater precision for capturing fractional seconds and time zone information. This gives the Oracle9i database greater flexibility in supporting locality preferences.
What is the default degree of precision of fractional seconds when specifying the TIMESTAMP data type?

#109. What does the Character Set Scanner command line utility do?

#110. What is required for the Character Set Scanner to operate?

[1] ... [11] [12] [13]

gen. 0.378

Server date 10:35 22-11-2008

Oracle 1Z0-030

Forum

Start online exam simulation

Master braindump

User braindumps