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

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

#191. Which graphical DBA administration tool would you use to tune an Oracle database?

#192. Examine the syntax below, which creates a DEPARTMENTS table:

 CREATE TABLE hr.departments( 
 Department_id NUMBER(4), 
 department_name VARCNAR2(30), 
 manager_id NUMBER(6), 
 location_id NUMBER(4)) 
 STORAGE(INITIAL 200K NEXT 200K 
 PCTINCREASE 50 MINEXTENTS 1 MAXEXTENTS 5) 
 TABLESPACE data;

What is the size defined for the fifth extent?

#193. In which two situations does the Log Writer (LGWR) process write the redo entries from the redo log buffer to the current online redo log group? (Choose two.)

#194. You check the alert log for your database and discover that there are many lines that say "Checkpoint Not Complete". What are two ways to solve this problem? (Choose two.)

#195. Which four statements are true about profiles? (Choose four.)

#196. Which are considered types of segments?

#197. The control file defines the current state of the physical database. Which three dynamic performance views obtain information from the control file? (Choose three.)

#198. As SYSDBA you created the PAYCLERK role and granted the role to Bob. Bob in turn attempts to modify the authentication method of the PAYCLERK role from SALARY to NOT IDENTIFIED, but when doing so he receives the insufficient privilege error shown below.
SQL> connect bob/crusader
Connected.
SQL> alter role payclerk not identified;
alter role payclerk not identifie
d ERROR at line 1:
ORA-01031: insufficient privileges
Which privilege does Bob require to modify the authentication method of the PAYCLERK role?

#199. You decided to use Oracle Managed Files (OMF) for the control files in your database. Which initialization parameter do you need to set to specify the default location for control files if you want to multiplex the files in different directories?

#200. Your database is currently configured with the database character set to WEBIS08859P1 and national character set to AL16UTF16. Business requirements dictate the need to expand language requirements beyond the current character set, for Asian and additional Western European languages, in the form of customer names and addresses. Which solution saves space storing Asian characters and maintains consistent character manipulation performance?

[1] ... [11] [12] [13] [14] [15] [16] [17] [18] [19] [20] [21] ... [37]

gen. 0.063

Server date 08:50 08-01-2009

Oracle 1Z0-031

Forum

Start online exam simulation

Master braindump

User braindumps