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

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

#141. You are creating a locally managed table space to meet the following requirements:
All the extents should be of the same size.
The data should be spread across two data files.
A bitmap should be used to record the free space within the allocated extents.
Which three options would you choose? (Choose three.)

#142. Exhibit:

View the Exhibit to see the data in the emp table. You created a PRIMARY KEY constraint on the empno column of the emp table, and the constraint is not deferred. Which two statements are true in this scenario? (Choose two.)

#143. You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your database.
Which type of script does the backup scheduler generate?

#144. You have three databases, FINDB, PAYDB and ADMINDB, located in Sydney, Tokyo and Singapore respectively. You want to perform administrative tasks which include starting up and shutting down the databases, creating and managing tablespaces and database users, and taking regular backups, for all of the three databases from London.
Which component must be enabled and running on each host machine to achieve your objective?

#145. Exhibit:

View the Exhibit to see the structure of EMPLOYEES, DEPARTMENTS and EMP_DEP tables. User A wants to insert rows from EMPLOYEES and DEPARTMENTS table into EMP_DEP table by using following insert command.

 INSERT INTO EMP_DEP (emp_id,name,salary,dep_name,mgr_id) 
 SELECT e.employee_id, 
 e.first_name ||' '|| e.last_name, 
 e.salary, 
 d.department_name, 
 e.manager_id 
 FROM employees e, 
 departments d 
 WHERE e.department_id = d.department_id;

While user A executes the command, it errors out, displaying the following error message:

 INSERT INTO EMP_DEP (emp_id,name,salary,dep_name,mgr_id)

*
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?

#146. You decided to increase the value for the SHARED_SERVERS parameter by using the following command:

 SQL> ALTER SYSTEM SET SHARED_SERVERS=3 SCOPE=?;

Which three values can be specified for the SCOPE clause? (Choose three.)

#147. Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member, which is not a member of the current group. How would you recover from the loss of the redo log member?

#148. Your application demands frequent connection and disconnection from the database. You have three listener processes that are listening for the database PROD. While setting up the connect string using Oracle Enterprise Manager 10g Database Control, which two options would you select to balance the connection load across all the listener processes? (Choose two.)

#149. You find today's performance of your production database to be the best ever. Therefore, you want to be notified in the future whenever the performance degrades by 10% of today's performance. What is the first step that you would take to ensure this?

#150. The following are the details of your database:
Instance name : test
Host name : tech1.us.oracle.com
IP address : 145.33.230.186
Enterprise Manager Console HTTP Port number : 5500
You started the database instance and you want to manage your database remotely with Enterprise Manager through a Web browser.
Which two URLs would you use to access the Database Control? (Choose two.)

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

gen. 0.165

Server date 02:17 10-01-2009

Oracle 1z0-042

Forum

Start online exam simulation

Master braindump

User braindumps