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

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

#351. During the process of disk space management, the alert log file that belongs to your database is accidentally deleted. The database is currently functional. Which statement regarding this situation is true?

#352. You executed the following command in your database:

 SQL> ALTER DATABASE ADD LOGFILE (‘/DISK3/log3a.rdo’, 
 ’/DISK4/log3b.rdo’) SIZE 1M;

What would this command do?

#353. Which two statements regarding segments are true? (Choose two.)

#354. You execute the following command to create a table in your database:

 SQL> CREATE TABLE oe.orders 
 (ord_id NUMBER(4), 
 ord _date DATE, 
 cust_id NUMBER(4), 
 ord_tot NUMBER(11,2)) 
 PCTUSED 40 PCTFREE 30 
 INITRANS 5 MAXTRANS 10 STORAGE (INITIAL 32K NEXT 32K 
 PCTINCREASE 50 
 MINEXTENTS 5 MAXEXTENTS 100) 
 TABLESPACE users;

The Oracle block size is 8K. Identify three properties that would be set for the table, (Choose three.)

#355. Your database instance is running in dedicated server mode. To restrict resource utilizations in your database, you created a profile, PROF1, by executing the following command:

 SQL> CREATE PROFILE prof 1 
 LIMIT 
 SESSIONS_PER_USER 10 
 IDLE_TIME 5 
 PRIVATE_SGA 2MB 
 CONNECT_TIME 10;

After creating the profile, you assigned it to the users of the administration department. Which three statements are true regarding the usage of the profile? (Choose three.)

#356. Which two statements are true regarding extent management in a tablespace? (Choose two.)

#357. Your database operates in NOARCHIVELOG mode. You have shut down the database and made the necessary parameter settings to operate it in ARCHIVELOG mode. Which STARTUP command would you execute to enable archiving?

#358. Which two are true about the data dictionary views with prefix USER_? (Choose two.)

#359. You are connected to the SCOTT schema in your database.
The 07_DICTIONARY_ACCESSIBILITY parameter is set to FALSE. You execute the following query:

 SQL> SELECT * FROM DICT;

What would be the output of this query?

#360. You created seven roles, ROLE1, ROLE2, ROLES, ROLE4, ROLE5, ROLES, and ROLE7 with different sets of privileges.
You granted:
- ROLES and ROLE4 to ROLE 1.
- ROLE5 and ROLES to ROLE2.
- ROLE 1 and ROLE2 to ROLE7.
- ROLE7 to the user USER01.
Next, you executed the following command to set the default role for the user, USER01:

 SQL> ALTER USER user01 DEFAULT ROLE role7;

What is the result of this command?

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

gen. 0.098

Server date 08:23 08-01-2009

Oracle 1Z0-031

Forum

Start online exam simulation

Master braindump

User braindumps