1z0-042 Oracle - Braindumps.com.ua: question list for "Oracle Database 10g: Administration I", page: 18

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-042: Oracle Database 10g: Administration I

#171. While running the Oracle Universal Installer on a Unix platform to install Oracle Database 10g software, you are prompted to run orainstRoot.sh script. What does this script accomplish?

#172. Exhibit:

View the Exhibit to see the information on existing tablespaces of the PROD database. You observe that a large volume of INSERTs and DELETEs are happening on the TRANS table residing in the USERS tablespace, and you suspect that the TRANS table is fragmented. Which advisory component would you refer to, in order to find the information about table fragmentation?

#173. In your database, UNDO_RETENTION has been set to 600 sec and UNDO tablespace is configured for RETENTION GUARANTEE. Which statement regarding RETENTION GUARANTEE is true?

#174. You want to migrate your application from the development environment to the production environment. While doing the task, you want the database objects owned by the user DEVUSER in the development environment to be moved to the user APPS in the production environment. Which option of Oracle Data Pump Import would you use to achieve this objective?

#175. Data files of which three tablespaces can be recovered by performing an open recovery?(Choose three.)

#176. View the Exhibit.

The DBA creates a new user as follows:

 SQL> CREATE USER manfus IDENTIFIED BY manfus TEMPORARY TABLESPACE temp;

User manfus creates a table as follows :

 SQL> CREATE TABLE material(id NUMBER(3));

In which tablespace will the material table be created?

#177. You executed the following command to back up your control file:

 ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

Which initialization parameter is used to specify the location of the trace file?

#178. Exhibit:

View the Exhibit to see the output of queries on DATABASE_PROPERTIES and DBA_USERS. You observe that the current default permanent tablespace of the database is running out of space and you decide to change it to NEW_DEF_TBSP. You create a new user, USERO4, after changing the default permanent tablespace of the database. What would be the new user’s default tablespace?

#179. Identity the two tablespaces whose data tiles are so critical that only a closed recovery is possible. (Choose two.)

#180. You connected to the database using the following connection string:
CONNECT hr/hr@test.us.oracle.com: 1521/mydb
Which three statements are correct regarding the connection string? (Choose three.)

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

gen. 0.194

Server date 01:04 10-01-2009

Oracle 1z0-042

Forum

Start online exam simulation

Master braindump

User braindumps