1Z0-031 Oracle - Braindumps.com.ua: question list for "Oracle9i: Database Fundamentals I", page: 9

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-031: Oracle9i: Database Fundamentals I

#81. When is the SGA created in an Oracle database environment?

#82. You have a database with the DB_NAME set to PROD and ORACLE_SID set to PROD. These files are in the default location for the initialization files:
• init.ora
• initPROD.ora
• spfile.ora
• spfilePROD.ora
The database is started with this command:
SQL> startup
Which initialization files does the Oracle Server attempt to read, and in which order?

#83. Which type of table is usually created to enable the building of scalable applications, and is useful for large tables that can be queried or manipulated using several processes concurrently?

#84. Based on the following profile limits, if a user attempts to log in and fails after five tries, how long must the user wait before attempting to log in again?

 ALTER PROFILE DEFAULT LIMIT 
 PASSWORD_LIFE_TIME 60 
 PASSWORD_GRACE_TIME 10 
 PASSWORD_REUSE_TIME 1800 
 PASSWORD_REUSE_MAX UNLIMITED 
 FAILED_LOGIN_ATTEMPTS 5 
 PASSWORD_LOCK_TIME 1/1440 
 PASSWORD_VERIFY_FUNCTION verify_function;

#85. Which steps should you take to gather information about checkpoints?

#86. The DBA can structure an Oracle database to maintain copies of online redo log files to avoid losing database information. Which three are true regarding the structure of online redo log files? (Choose three.)

#87. Which is true when considering the number of indexes to create on a table?

#88. You need to drop two columns from a table. Which sequence of SQL statements should be used to drop the columns and limit the number of times the rows are updated?

#89. You just issued the STARTUP command. Which file is checked to determine the state of the database?

#90. John has issued the following SQL statement to create a new user account:

 CREATE USER john 
 IDENTIFIED BY john 
 TEMPORARY TABLESPACE temp_tbs 
 QUOTA 1M ON SYSTEM 
 QUOTA UNLIMITED ON data_tbs 
 PROFILE apps_profile 
 PASSWORD EXPIRE 
 DEFAULT ROLE apps_dev_role;

Why does the above statement return an error?

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

gen. 0.334

Server date 09:05 22-11-2008

Oracle 1Z0-031

Forum

Start online exam simulation

Master braindump

User braindumps