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

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

#51. You work as a database administrator for Company.com. Because of space constraints, you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows:
ERROR at Line 1:
ORA-10635: Invalid segment or tablespace type
What could be the reason?

#52. You work as a database administrator for Company.com. You want to create your database with the automatic undo management feature enable.
Which two tasks must you perform to achieve this? Choose two.

#53. You work as a database administrator for Company.com. in your organization, you have four databases, db01, db02, db03, and db04, which are located in berlin, frankfurt, rammstein, and munich respectively, and which were created using database configuration assistant (dbca). You want to perform administrative tasks on these databases that include startup and shutdown, taking regular backups, and so on, from Frankfurt using Oracle tools.
Which Oracle file would you enable to perform this task?

#54. You work as a database administrator for Company.com. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file.
How does the loss of a redo log member affect the instance of the database that is currently running?

#55. You work as a database administrator for Company.com. After being hired, you find that there is only one database that is functional and that is being access by the applications. You want to create a replicate of the database, to be used for testing purposes.
What is the best method to create a replica?

#56. Exhibit, error

You work as a database administrator for Company.com. When you try to connect to the database, you get an error (See exhibit).
What could be the possible reason for getting such an error?

#57. You work as a database administrator for Company.com. While granting a role, SELECT_CATALOG_ROLE, to a user, Company, using Oracle Enterprise Manager 10g Database Control, you have cleared the DEFAULT check box.
What will be the result?

#58. You work as a database administrator for Company.com. You are working on Oracle Database 10g. To forward client connections to an instance, the listener must know information such as the name of the instance and where the instance's ORACLE_HOME is located.
How does the listener get this information? Choose two.

#59. Exhibit, requirements

You work as a database administrator for Company.com. While setting up the database for your production environment, you want to create a user according to the requirements in the exhibit. Which three options of the CREATE USER command would you use to achieve this objective? Choose three

#60. You work as a database administrator for Company.com. You want to configure database backups to be run automatically.
Which tool or utility would you use to achieve this?

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

gen. 0.059

Server date 05:53 02-12-2008

Oracle 1z0-042

Forum

Start online exam simulation

Master braindump

User braindumps