C the database is closed but the instance is still

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: d redo buffers are not written to the disk. E. The database undergoes automatic media recovery during the next startup. Answer: B,D QUESTION 177: Exhibit: View the Exhibit. Your Oracle 10g database has 6 tablespaces in which: -TEMP is the default temporary tablespace -UNDOTBS1 is the default undo tablespace -USERS is the default permanent tablespace In this database, which two tablespaces can be made read only? (Choose two.) Actualtests.com - The Power of Knowing 1Z0-042 A. TEMP B. PROD C. USERS D. SYSAUX E. SYSTEM F. UNDOTBS1 Answer: B,C QUESTION 178: View the Exhibit. The DBA creates a new user as follows: SQL> CREATE USER manfus IDENTIFIED BY manfus TEMPORARY TABLESPACE temp; User manfus creates a table as follows: SQL> CREATE TABLE material(id NUMBER(3)); In which tablespace will the material table be created? Actualtests.com - The Power of Knowing 1Z0-042 A. SYSTEM B. USERS C. PROD D. SYSAUX E. TEMP Answer: B QUESTION 179: You want to set up the Oracle Database 10g installation to follow the French language, with France as the territory, and the date to be displayed in French for all users' sessions. Which environmental variable would you set to achieve this objective? A. NLSLANG B. NLSLENGTHSEMANTICS C. NLSTERRITORY D. NLSLANGUAGE E. NLSCHARACTERSET F. NLSDATELANGUAGE G. NLSNCHARCHARACTERSET Answer: A QUESTION 180: Identify the two tablespaces whose data files are so critical that only a closed recovery is possible. (Choose two.) A. SYSAUX B. TOOLS C. UNDO D. INDEX E. SYSTEM F. USERS G. TEMP Answer: C,E QUESTION 181: View the Exhibit to see the output of queries on DATABASEPROPERTIES and DBAUSERS. Actualtests.com - The Power of Knowing 1Z0-042 You observe that the current default permanent tablespace of the database is running out of space and you decide to change it to NEWDEFTBSP. You create a new user, USER04, after changing the default permanent tablespace of the database. What would be the new user's default tablespace? A. DEFTBSP B. SYSTEM C. NEWDEFTBSP D. USERS and NEWDEFTBSP both E. USERS Answer: C QUESTION 182: You connected to the database using the following connection string: CONNECT hr/hr@test.us.oracle.com:1521/mydb Which three statements are correct regarding the connection string? (Choose three.) A. mydb is a service name. B. test.us.oracle.com is a database name. C. 1521 is the listener port number. D. mydb is a host name. E. test.us.oracle.com is a net service name. F. hr is a username. G. test.us.oracle.com is an instance name. Answer: A,C,F Actualtests.com - The Power of Knowing...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online