A it terminates all user sessions b it prevents users

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: n to the database remotely. C. It halts the server until all user transactions are completed. D. The server hangs, so users will receive an error asking them to login again. E. Connected users would get an error with the message "End of communication Actualtests.com - The Power of Knowing 1Z0-042 channel". Answer: B QUESTION 129: You have a listener process, L1, currently listening for the connections to the PROD and ADMIN databases. You create a new database, PAY, using CREATE DATABASE.. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA file manually to include PAY database for L1 listener process. Which command of Listener control utility (LSNRCTL) would you use to enable L1 process to start listening for the connections to the PAY database without disrupting any existing database communications? A. START B. RELOAD C. RESTART D. REFRESH E. START L1 F. RELOAD L1 G. RESTART L1 H. REFRESH L1 Answer: F QUESTION 130: You need to rename a data file of a tablespace. How would you perform this? A. bring the database to the NOMOUNT state, rename the data file using the operating system, and then execute the ALTER TABLESPACE...RENAME DATAFILE .. statement B. take the tablespace that contains the data file offline, rename the data file using the operating system, execute the ALTER DATABASE...RENAME DATAFILE .. statement, and bring the tablespace online C. take the tablespace that contains the data file offline, rename the data file using the operating system, execute the ALTER TABLESPACE...RENAME DATAFILE .. statement, and bring the tablespace online D. make the tablespace that contains the data file read only, rename the data file using the operating system, execute the ALTERTABLESPACE... RENAME DATAFILE .. statement to rename the data file, and make the tablespace read/write Answer: C Actualtests.com - The Power of Knowing 1Z0-042 QUESTION 131: When you try to start the Database Control by using the emctl start dbconsole command the following error is displayed: TZ set to America/New_york OC4J Configuration issue. /u01/app/oracle/product/10.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_orc...
View Full Document

Ask a homework question - tutors are online