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

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

#71. Exhibit :

You work as a database administrator for Company.com. While executing the command line to create a table, the user gets the following error message and the CREATE TABLE... command fails.
ERROR at line 1:
ORA-01950: no privileges on tablespace
What could be the possible reason for this error message?

#72. You work as a database administrator for Company.com. You are using Recovery Manager (RMAN) for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace.
Which statement is true in this scenario?

#73. You work as a database administrator for Company.com. your listener process, l1, is currently listening to three databases: company b04, db05 and db06. using database configuration assistant (dbca) you create one more database, db07, and enable dynamic registration.
which two commands of listener control utility (lsnrct1) would you use to determine whether the dynamic registration occurred for the database, db07, with the l1 listener process? choose two

#74. Your boss at Company.com wants you to clarify Oracle 10g. Which statement is true about the analysis of the Automatic Database Diagnostic Monitor (ADDM)?

#75. Exhibit, list of privileges.

You work as a database administrator for Company.com. the database user, user07, has the connect role assigned. you want this user to be able to:
A) connect to the database when the database is in restricted mode
AND
B) query the tables created by other users.
Which minimal set of privileges and roles would you select from the list in the exhibit to grant to the user?

#76. Exhibit :

Your database is not configured for session failover. Your tnsnames.ora file contains the details shown in the exhibit.
Which feature is enabled in this case?

#77. You work as a database administrator for Company.com. One of the user sessions was terminated abnormally in the middle of a transaction.
What does Oracle database do to recover it?

#78. You work as a database administrator for Company.com. You suspect that in one of your applications the customer table is being accessed by some unauthorized users.
Which option would you use to monitor the queries being executed on the customer table?

#79. Exhibit:

View the Exhibit. Your Oracle 10g database has 6 tablespaces in which:
-TEMP is the default temporary tablespace
-UNDOTBS1 is the default undo tablespace
-USERS is the default permanent tablespace
In this database, which two tablespaces can be made read only? (Choose two.)

#80. You work as a database administrator for Company.com. Client connection requests are failing because the listener is not responding. You want to forward client connect requests to another listener if one listener is not responding.
How do you achieve this?

[1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] ... [19]

gen. 0.053

Server date 06:50 02-12-2008

Oracle 1z0-042

Forum

Start online exam simulation

Master braindump

User braindumps