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

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

#21. The database currently has one control file. You decide that three control files will provide better protection against a single point of failure. To accomplish this, you modify the SPFILE to point to the locations of the three control files. The message "system altered" was received after execution of the statement.
You shut down the database and copy the control file to the new names and locations. On startup you receive the error ORA-00205: error in identifying control file. You look in the alert log and determine that you specified the incorrect path for the for control file.
Which steps are required to resolve the problem and start the database?

Show comments for this question (1)
Add comments
Link to this question

#22. Which two methods enforce resource limits? (Choose two.)

Show comments for this question (1)
Add comments
Link to this question

#23. Which type of index does this syntax create?

 CREATE INDEX hr.employees_last_name_idx 
 ON hr.employees(last_name) 
 PCTFREE 30 
 STORAGE(INITIAL 200K NEXT 200K 
 PCTINCREASE 0 MAXEXTENTS 50) 
 TABLESPACE indx;

Show comments for this question (1)
Add comments
Link to this question

#24. There are three ways to specify National Language Support parameters:
1. initialization parameters
2. environment variables
3. ALTER SESSION parameters
Match each of these with their appropriate definitions.

Show comments for this question (1)
Add comments
Link to this question

#25. More stringent user access requirements have been issued. You need to do these tasks for the user pward:
1. Change user authentication to external authentication.
2. Revoke the user's ability to create objects in the TEST TS tablespace.
3. Add a new default and temporary tablespace and set a quota of unlimited.
4. Assign the user to the CLERK profile.
Which statement meets the requirements?

Show comments for this question (1)
Add comments
Link to this question

#26. A new user, psmith, has just joined the organization. You need to create psmith as a valid user in the database. You have the following requirements:
1. Create a user who is authenticated externally.
2. Make sure the user has CONNECT and RESOURCE privileges.
3. Make sure the user does NOT have DROP TABLE and CREATE USER privileges.
4. Set a quota of 100 MB on the default tablespace and 500 K on the temporary tablespace.
5. Assign the user to the DATA_TS default tablespace and the TEMP_TS temporary tablespace.
Which statement would you use to create the user?

Show comments for this question (1)
Add comments
Link to this question

#27. You issue these queries to obtain information about the REGIONS table:

 SQL> SELECT segment_name, tablespace_name 
 2> FROM user_segments 
 3> WHERE segment_name = 'REGIONS';

 SEGMENT_NAME     TABLESPACE_NAME 
 REGIONS          SAMPLE

 SQL> SELECT constraint_name, constraint_type 
 2> FROM USER CONSTRAINTS 
 3> WHERE table_name = ‘REGIONS’;

 CONSTRAINT_NAME     C 
 REGION_ID_NN        C 
 REG_ID              P

 SQL> SELECT index_named 
 2> FROM USER indexes 
 3> WHERE table_name = ‘REGIONS’;

INDEX_NAME
REG_ID_PK
You then issue this command to move the REGIONS table:

 ALTER TABLE regions 
 MOVE TABLESPACE user_data;

What else must you do to complete the move of the REGIONS table?

Show comments for this question (1)
Add comments
Link to this question

#28. You need to create an index on the CUSTOMER_ID column of the CUSTOMERS table. The index has these requirements:
1. The index will be called CUST_PK.
2. The index should be sorted in ascending order.
3. The index should be created in the INDEX01 tablespace, which is a dictionary
4. All extents of the index should be 1 MB in size.
5. The index should be unique.
6. No redo information should be generated when the index is created.
7. 20% of each data block should be left free for future index entries.
Which command creates the index and meets all the requirements?