This preview shows page 1. Sign up to view the full content.
Unformatted text preview: d redo buffers are not written to the disk.
E. The database undergoes automatic media recovery during the next startup.
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
View the Exhibit. The DBA creates a new user as follows:
SQL> CREATE USER manfus IDENTIFIED BY manfus TEMPORARY
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
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
Identify the two tablespaces whose data files are so critical that only a closed
recovery is possible. (Choose two.)
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?
D. USERS and NEWDEFTBSP both
You connected to the database using the following connection string:
Which three statements are correct regarding the connection string? (Choose
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.
- Fall '09