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

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

#151. Your database is running in the ARCHIVELOG mode. You placed a tablespace, tbs_1, offline with the immediate option. Which statement is correct in this scenario?

#152. In your database, you may be forced to perform a recovery using the RESETLOGS option during which the redo logs would be reset to sequence number 1. You want to avoid the overwriting of old log files. Which archived log file name format ensures this?

#153. You manually create an additional listener process, L1, for databases PROD, PAYDB and FINDB. While starting up the listener process, you get the following error message:
LSNRCTL> start l1
Starting /u01/app/oracle/product/10.1.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.1.0.2.0 - Production
System parameter file is /u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.1.0/db_1/network/log/l1.log
Error listening on: (ADDRESS=(PROTOCOL=TCP)(HOST=144.23.230.185)(port=8899))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
Linux Error: 98: Address already in use
Listener failed to start. See the error message(s) above...
What action would you take to overcome this error without disrupting any existing database communications?

#154. The customer and order tables are often used in joins, thereby resulting in complex queries. You created views to simplify the writing of queries. These views are stored in _____.

#155. Users in your PROD database complain about the slow response of the transactions. While investigating the reason, you find that the transactions are waiting for the undo segments to be available, and undo retention has been set to zero. What would you do to overcome this problem?

#156. In the instance of the PROD database, the checkpoint (CKPT) process runs after every minute. A database user updates the rows of the ORDERS table. Because of the configuration, the CKPT process gets initiated before the user commits the transaction.
What would happen to the modified blocks when the CKPT process is started?

#157. You are working on a very large database. You had performed a binary backup of the control file a month ago. After this you added a few tablespaces, and dropped a couple of table spaces. This morning, due to hardware failure, you lost all your control files.
How would you recover the database from this situation?

#158. You are using the following command to clear the log file group:

 ALTER DATABASE CLEAR LOGFILE GROUP 2;

In which case would the command be successful?

#159. Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk. Which command would you execute to proceed further?

#160. You execute the following set of commands to create a database user and to grant the system privileges in your production environment.

 SQL> CREATE USER user01 
 IDENTIFIED BY oracle 
 DEFAULT TABLESPACE tbs1 
 TEMPORARY TABLESPACE temp 
 PROFILE DEFAULT

SQL> GRANT create session, create table TO user01;
While executing the command 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?

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

gen. 0.108

Server date 02:23 10-01-2009

Oracle 1z0-042

Forum

Start online exam simulation

Master braindump

User braindumps