Write the current database metrics to a flat file and

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: script to compare with future database statistics D. write the current database metrics to a database table and create a procedure to compare with future database statistics E. write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics Answer: A QUESTION 150: The following are the details of your database: Instance name : test Host name : tech1.us.oracle.com Actualtests.com - The Power of Knowing 1Z0-042 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.) A. http://145.33.230.186:5500/em B. http://www.145.33.230.186:5500/em C. http://tech1.us.oracle.com:5500/em D. http://test.145.33.230.186:5500/em E. http://test.tech1.us.oracle.com:5500 F. http://www.tech1.us.oracle.com:5500/em G. http://test.tech1.us.oracle.com:5500/em Answer: A,C QUESTION 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? A. The operation would fail if tbs_1 were a read-only tablespace. B. The operation would fail if tbs_1 were a read/write tablespace. C. The operation would fail if tbs_1 were the default tablespace for the database. D. If the above operation were successful, media recovery would be required to bring the tablespace online. E. If the above operation were successful, instance recovery would be required to bring the tablespace online. Answer: D QUESTION 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? A. %t_%s.dbf B. arch_%t.arc C. arch_%d.arc D. arch_%t_%d.arc E. arch_%d_%s...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online