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

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

#331. You are looking for the following information:
1 Time stamp of database creation
2 Tablespace names -Current online redo log file sequence number
3 When the last checkpoint occured
Where can you find this information?

#332. Which three statements are true regarding the default temporary tablespace? (Choose three.)

#333. View the Exhibit and examine the output.

Examine the list of steps to add a data file, SALES2.DBF, to the SALES tablespace in your database. The steps are arranged in random order.

 1. ALTER TASLESPACE SALES ONLINE; 
 2. ALTER TABLESPACE SALES READ WRITE; 
 3. ALTER TABLESPACE SALES ADD DATAFILE ‘/ORADATAJSALES2.DBF’ SIZE 50M;

What is the correct order for the steps?

#334. You decide to grant the SYSDBA privilege to SCOTT and execute the following command:

 SQL> GRANT SYSDBA TO SCOTT; 
 GRANT SYSDBA TO SCOTT

*
ERROR at line 1:
ORA-01994: GRANT failed: cannot add users to public password file
What could be the reason for this error?

#335. You executed the following command to increase the quota for a database user USER01:

 SQL> ALTER USER user01 
 QUOTA 1000M 
 ON users;

While executing the command, you realize that the quota specified is more than the size of the data file that belongs to the USERS tablespace. AUTOEXTEND of the data file is set to OFF. What is the result of this situation?

#336. You execute the following command for the ADMIN_ROLE role in your database:

 SQL> ALTER ROLE admin_role NOTIDENTIFIED;

What is the implication of this command on the users that were granted this role?

#337. Which of the following files defines the characteristics of an Oracle instance?

#338. The data in the EMPLOYEE_NAME column of the EMPLOYEES table is stored in mixed case. Currently, there is no index on the column. You want to create an index on the column to support non-case-sensitive queries and faster retrieval of data by using the index. Which type of index would you create on the column?

#339. Which two object privileges can be granted on columns of a table or view? (Choose two.)

#340. Which three statements are true regarding the dropping of a column from a table? (Choose three.)

[1] ... [31] [32] [33] [34] [35] [36] [37]

gen. 0.09

Server date 09:04 08-01-2009

Oracle 1Z0-031

Forum

Start online exam simulation

Master braindump

User braindumps