1z0-023 Oracle - Braindumps.com.ua: question list for "Developer/2000: Build Reports", page: 1

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

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-023: Developer/2000: Build Reports

#1. What is one reason for using the package DBMS_TTS?
DATA01 has

#2. Which export option will generate code to create an initial extent that is equal to the sum of the sizes of all the extents currently allocated to an object?

#3. What are two reasons for changing user quotas on a tablespace? (Choose two)

#4. A DBA performs the query:

 SELECT tablespace_name, max_blocks 
 FROM dba_tablespace_quotas 
 WHERE username= ''SCOTT;

That returns the result:

What does -1 indicate?

#5. Consider the following command to create the user 'peter'.

 CREATE USER peter 
 IDENTIFIED BY pan 
 TEMPORARY TABLESPACE temp 
 PASSWORD EXPIRE;

Since no default tablespace was specified, what will happen if this command executed?

#6. An oracle user receives the following error:
ORA-01555 SNAPSHOP TOO OLD
What are two possible solutions? (Choose two)

#7. When creating rollback segments, what is the recommended value for MINEXTENT minimize dynamic extension?

#8. MINEXTENT must be at least _____ when a rollback segment is created.

#9. You are creating a database with a character set other than US7ACII. Which operating system environmental variable needs to be set to specify the directory location of the NLS support files?

#10. Given the statement:

 CREATE DATABASE orc1 
 LOGFILE GROUP 1 'u01/oracle/dba/logla.rdo' SIZE 1M, 
 GROUP 2 'u01/oracle/dba/log2a.rdo' SIZE 1M 
 DATAFILE 'u01/oracle/dbs/sys_01.dbf' REUSE;

Which statement is true?

[1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] ... [15]

gen. 0.057

Server date 11:36 08-01-2009

Oracle 1z0-023

Forum

Start online exam simulation

Master braindump

User braindumps