1Z0-031

Today I passed database Fundamental I exam. I studied hard for it. I had some practical experience too. Finally I got the stuff from www.exams.ws . 98% questions were from it. I strongly recommend it to save expensive exam fee.

Question 1:

Examine the SQL statement:

CREATE TABLESPACE user_data

DATAFILE '/u01/oradata/user_data_0l.dbf' SIZE 100M

LOCALLY MANAGED UNIFORM SIZE 1M

AUTOMATIC SEGMENT SPACE MANAGEMENT;

Which part of the table space will be of a uniform size of 1 MB?

1. Extent

2. Segment

3. Oracle block

4. Operating system block

Answer: I

Question 2:

The ORDERS table has a constant transaction load 24 hours a day, so down time is not allowed. The indexes become fragmented.

Which statement is true?

1. The index needs to be dropped, and then re-created.

2. The resolution of index fragmentation depends on the type of index.

3. The index can be rebuilt while users continue working on the table.

4. The index can be rebuilt, but users will not have access to the index during this time.

5. The fragmentation can be ignored because Oracle resolves index fragmentation by means of a free list.

Answer: III

Question 3:

When preparing to create a database, you should be sure that you have sufficient disk space for your database files. When calculating the space requirements you need to consider that some of the files may be multiplexed. Which two types of files should you plan to multiplex? (Choose two.)

1. Data files

2. Control file

3. Password file

4. Online redo log files

5. Initialization parameter file

Answer: II, IV

Question 4:

You want to limit the number of transactions that can simultaneously make changes to data in a block, and increase the frequency with which Oracle returns a block back on the free list. Which parameters should you set?

1. INITRANS and PCTUSED

2. MAXTRANS and PCTFREE

3. INITRANS and PCTFREE

4. MAXTRANS and PCTUSED

Answer: IV

Question 5:

Which structure provides for statement-level read consistency?

1. Undo segments

2. Redo log files.

3. Data dictionary tables

4. Archived redo log files

Answer: I

Question 6:

You can use the Database Configuration Assistant to create a template using an existing database structure. Which three will be included in this template? (Choose three.)

1. Data files

2. Table spaces

3. User defined schemas

4. User defined schema data

5. Initialization parameters

Answer: I, II, V

Question 7:

You are going to create a new database. You will NOT use operating system authentication. Which two files do you need to create before creating the database? (Choose two.)

1. Control file

2. Password file

3. Redo log file

4. Alert log file

5. Initialization parameter file

Answer: II, V

Question 8:

You omit the UNDO table space clause in your CREATE DATABASE statement. The UNDO_MANAGEMENT parameter is set to AUTO. What is the result of your CREATE DATABASE statement?

1. The Oracle server creates no undo table spaces.

2. The Oracle server creates an undo segment in the SYSTEM table space.

3. The Oracle server creates one undo table space with the name SYS_UNDOTBS.

4. Database creation fails because you did not specify an undo table space on the CREATE DATABASE statement.

Answer: III

Question 9:

What provides for recovery of data that has not been written to the data files prior to a failure?

1. Redo log

2. Undo segment

3. Rollback segment

4. System table space

Answer: I

Question 10:

In order to enable remote administration of users and table spaces on an Oracle database, which of the following types of files must exist in the database?

1. Password file

2. Initialization file

3. Data file

4. Control file

5. Nothing - SYSDBA privileges are not required for these actions.

Answer: V