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

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

#61. You used the password file utility to create a password file as follows:
$orapwd file=$ORACLE_HOME/dbs/orapwDB01
password=orapass entries=5
You created a user and granted only the SYSDBA privilege to that user as follows:

 CREATE USER dba_user 
 IDENTIFIED BY dba_pass; 
 GRANT sysdba TO dba_user;

The user attempts to connect to the database as follows:

 CONNECT dba_user/orapass AS sysdba;

Why does the connection fail?

#62. You are creating a new database. You do NOT want users to use the SYSTEM tablespace for sorting operations. What should you do when you issue the CREATE DATABASE statement to prevent this?

#63. An INSERT statement failed and is rolled back. What does this demonstrate?

#64. Select the memory structure(s) that would be used to store the parse information and actual value of the bind variable id for the following set of commands:

 VARIABLE id NUMBER; 
 BEGIN 
 :id:=1; 
 END;

#65. Which constraint state prevents new data that violates the constraint from being entered, but allows invalid data to exist in the table?

#66. What determines the initial size of a tablespace?

#67. Which background process performs a checkpoint in the database by writing modified blocks from the database buffer cache in the SGA to the data files?

#68. A table can be dropped if it is no longer needed, or if it will be reorganized. Which three statements are true about dropping a table? (Choose three.)

#69. A network error unexpectedly terminated a user's database session. Which two events occur in this scenario? (Choose two.)

#70. Which is a complete list of the logical components of the Oracle database?

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

gen. 0.105

Server date 06:35 22-11-2008

Oracle 1Z0-031

Forum

Start online exam simulation

Master braindump

User braindumps