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

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

#81. You work as a database administrator for Company.com. You added a tablespace to your database.
Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure.
How would you proceed to recover the database?

#82. You work as a database administrator for Company.com. You received the following error while working on your database:
ORA-01555: snapshot too old
In which situation would you receive such an error?

#83. Exhibit #1, structure

Exhibit #2, insert command

You work as a database administrator for Company.com. Use exhibit #1 to see the structure of the EMPLOYEES, DEPARTMENTS and EMP_DEP tables.
User Company C wants to insert rows from EMPLOYEES and DEPARTMENTS table into EMP_DEP table by using the code in exhibit #2.
While user CompanyC executes the command, it errors out, displaying the following error message:
ERROR at line 1:
ORA-01653: unable to allocate extent table A.EMP_DEP by 8 in tablespace USERS
What would have caused the error?

#84. Exhibit :

You work as a database administrator for Company.com. Use the exhibit to see details about existing table spaces in the Oracle 10g database. You want to add a new table space to your database. Which three statements regarding a new table space are true? Choose three.

#85. Exhibit :

You work as a database administrator for Company.com. While trying to access Enterprise Manager Database Control by using a browser, you get an error. See exhibit. On further investigation, you find that the Oracle database 10g installation has just finished and your colleague, Company who installed the software, has not noted down all the port numbers. How do you determine the port number of the HTTP listener that is being used by Enterprise Manager Database Control?

#86. Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?

#87. Consider the following scenario: You have a directory, data, under the disk group tdgroupA. You want to create an alias for one of the data files and you execute the following command:

 ALTER DISKGROUP tdgroupA 
 ADD ALIAS '+tdgroupA/data/datafile.dbf' 
 FOR '+tdgroupA.231.45678';

Which task would be accomplished by the command?

#88. Exhibit :

One the evening of April 22, you are working on a database created using Oracle Database 10g. This database operates in the ARCHIVELOG mode. You discover that you need crucial data that was dropped from the database at 8:00 a.m. No full backup has been taken after April 15. What would you do?

#89. You are unable to move the Unified Job Scheduler occupant from the SYSAUX table space to the USERS table space. What could be the reason?

#90. You want to enforce a company's business policy on several objects by using a single policy function.
Which two types of policies can be assigned to the policy_type argument in the dbms_rls.add_policy procedure to achieve the above objective? (Choose two.)

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

gen. 0.075

Server date 06:09 02-12-2008

Oracle 1z0-042

Forum

Start online exam simulation

Master braindump

User braindumps