testking oracle 9i 1z0-031
Visited 1453 times, 1 so far today
Exam 1z0-031: Oracle9i Database: Fundamentals I
Exam Number: 1Z0-031
Associated Certifications: Oracle9i DBA OCA
Exam Price: $125.00 USD
Exam Registration: Register
Duration: 120 minutes
Number of Questions: 60
Passing Score: 73%
Recommended Training and Preparation
The exam is based on Oracle9i Release 2
Oracle9i Database: Fundamentals I
Oracle9i DBA Fundamentals I Self-Study CD Course (NETg Oracle)
Self-Study CD-ROMs are an excellent tool to help you prepare for your exam. SSCDs reinforce the course material and allow you to focus on sections that you need to review. Note: the SSCDs do not count towards your course requirements for certification and should be used as a study aid only.
Additional Information & Resources
Practice Exams
Oracle authorized practice exam from Self Test Software. 1Z0-031 Oracle9i: DBA Fundamentals I
Oracle authorized practice exam from Transcender: Cert-1Z0-031 : DBCert: 9i Database: Fundamentals I
Oracle9i DBA Certification Exam Candidate Guide
Exam Retake Policy
Sample Questions
Exam Topics
Oracle Architectural Components
[ ] Describe the Oracle architecture and its main components
[ ] Describe the structures involved in connecting a user to an Oracle instance
Getting Started With the Oracle Server
[ ] Identify common database administrative tools available to a DBA
[ ] Identify the features of the Oracle Universal Installer
[ ] Explain the benefits of Optimal Flexible Architecture
[ ] Set up password file authentication
[ ] List the main components of the Oracle Enterprise Manager and their uses
Maintaining the Control File
[ ] Explain the uses of the control file
[ ] Describe the contents of the control file
[ ] Multiplex and manage the control file
[ ] Manage the control file with Oracle Managed Files
[ ] Obtain control file information
Managing Tablespaces and Data files
[ ] Describe the logical structure of tablespaces within the database
[ ] Create tablespaces
[ ] Change the size of the tablespace
[ ] Allocate space for temporary segments
[ ] Change the status of tablespaces
[ ] Change the storage settings of tablespaces
[ ] Implement Oracle Managed Files
Managing Tables
[ ] Identify the various methods of storing data
[ ] Describe Oracle data types
[ ] Distinguish between an extended versus a restricted ROWID
[ ] Describe the structure of a row
[ ] Create regular and temporary tables
[ ] Manage storage structures within a table
[ ] Reorganize, truncate, drop a table
[ ] Drop a column within a table
Managing an Oracle Instance
[ ] Create and manage initialization parameter files
[ ] Configure OMF
[ ] Start up and shut down an instance
[ ] Monitor the use of diagnostic files
Creating a Database
[ ] Describe the prerequisites necessary for database creation
[ ] Create a database using Oracle Database Configuration Assistant
[ ] Create a database manually
Maintaining Redo Log Files
[ ] Explain the purpose of online redo log files
[ ] Describe the structure of online redo log files
[ ] Control log switches and checkpoints
[ ] Multiplex and maintain online redo log files
[ ] Manage online redo log files with OMF
Storage Structure and Relationships
[ ] Describe the logical structure of segments within the database
[ ] Describe the segment types and their uses
[ ] List the keywords that control block space usage
[ ] Obtain information about storage structures from the data dictionary
Managing Undo Data
[ ] Describe the purpose of undo data
[ ] Implement Automatic Undo Management
Managing Indexes
[ ] Describe the different types of indexes and their uses
[ ] Create various types of indexes
[ ] Reorganize indexes
[ ] Drop indexes
[ ] Get index information from the data dictionary
[ ] Monitor the usage of an index
Data Dictionary Content and Usage
[ ] Identify key data dictionary components
[ ] Identify the contents and uses of the data dictionary
[ ] Query the data dictionary
Managing Password Security and Resources
[ ] Manage passwords using profiles
[ ] Administer profiles
[ ] Control use of resources using profiles
[ ] Obtain information about profiles, password management and resources
Managing Users
[ ] Create new database users
[ ] Alter and drop existing database users
[ ] Monitor information about existing users
Managing Privileges
[ ] Identify system and object privileges
[ ] Grant and revoke privileges
[ ] Identify auditing capabilities
Managing Roles
[ ] Create and modify roles
[ ] Control availability of roles
[ ] Remove roles
[ ] Use predefined roles
[ ] Display role information from the data dictionary
Maintaining Data Integrity
[ ] Implement data integrity constraints
[ ] Maintain integrity constraints
[ ] Obtain constraint information from the data dictionary
Using Globalization Support
[ ] Choose database character set and national character set for a database
[ ] Specify the language- dependent behavior using initialization parameters, environment variables and the ALTER SESSION command
[ ] Use the different types of National Language Support (NLS) parameters
[ ] Explain the influence on language-dependent application behavior
[ ] Obtain information about Globalization Support usage
Oracle Certification Program Fraudulent Activity Policy
Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.
If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate’s Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate’s employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle’s authorized vendors, and may be required to pay additional fees for services rendered.
View the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.
Recommended Training about 1z0-031 exam PDF
The following courses are the recommended training for 1z0-031 exam PDF.
1z0-031 Q & A with Explanations
1z0-031 Audio Exam
1z0-031 Study Guide
1z0-031 Preparation Lab
1z0-031 Exam: Freetestking’s orcacle9i database:fundamentals i PDF
The orcacle9i database:fundamentals i PDF for preparing for the 1z0-031 exam – Freetestking’s orcacle9i database:fundamentals i. Freetestking is your premier source for practice tests, and true testing environment. Nothing will prepare you for your next exam like a Freetestking. You find it all here at certbible.org.
QUESTION 1:
You executed the following command to change the default temporary tablespace in your database:
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP2;
Which view helps you to confirm that the TEMP2 tablespace is being used as the default temporary tablespace?
A. DATABASE_PROPERTIES B. V$DATABASE
C. DBA_TEMP_FILES
D. DBA_TABLESPACES Answer: A
QUESTION 2:
You have set up password file authentication in your database. You accidentally lost the password file. What would be the effect of this loss on the functional database?
A. The database will be functional and none of the users will have problems in connecting.
B. The database will be functional but none of the users will be able to connect as
SYSDBA.
C. The database fails and it needs recovery.
D. The database shuts down and the password file will be created automatically at the next startup.
Answer: B
QUESTION 3:
Consider the following facts about your database:
-The database operates in NOARCHIVELOG mode.
-The database has three redo log groups.
-All the groups have one member each.
-Redo log group 3 is the CURRENT group. You executed the following command:
SQL> ALTER DATABASE DROP LOGFILE MEMBER
2 ‘D:\\ORACLE\\ORADATA\\MYDB\\REDO03.LOG’;
The command fails to drop the member. What is the reason displayed for the failure
of the command?
A. You cannot drop a member from a group as the database is in NOARCHIVELOG
mode.
TK
1Z0-031
B. You cannot drop the last member in a group.
C. You cannot drop a member when the database is open. D. You cannot drop a member until checkpoint completes.
Answer: B
QUESTION 4:
Which view would you query to identify the space utilization settings for tables owned by the APPS user?
A. DBA_SEGMENTS B. DBA_EXTENTS
C. DBA_OBJECT_TABLES D. DBA_OBJECTS
Answer: A
QUESTION 5:
View the Exhibit and identify the component labeled as a question mark.
A. system monitor (SMON) B. archiver (ARCn)
C. checkpoint (CKPT)
D. process monitor (PMON)
TK
1Z0-031
Answer: C
QUESTION 6:
Examine the following statement:
SQL> SELECT * FROM V$CONTROLFILE;
In which two situations will the execution of this query return one or more rows?
(Choose two.)
A. when the database is in the OPEN state
B. when the database is in the NOMOUNT state
C. only if the Oracle Managed Files (OMF) feature is used
D. when the database is in the MOUNT state
Answer: A,D
QUESTION 7:
You created the password file in your database server as follows:
$ orapwd file=$ORACLE_HOME/dbs/orapwdb password=dba entries=2
Further, you granted the SYSDBA privilege to the user SCOTT who has TIGER as the password. What effect would the assigning of this privilege have on Scott’s password?
A. The password will be DBA when he connects as SYSDBA, and he can use either
TIGER or DBA when connecting as a normal user.
B. The password will not be affected and remain as TIGER. C. The password will change from TIGER to DBA.
D. The password will be DBA when SCOTT connects as SYSDBA, and TIGER when connecting as a normal user.
Answer: B
QUESTION 8:
In your database, you observe that a database user is executing a lot of
CPU-intensive queries, thereby causing the database performance to degrade. You want to restrict the resource utilization of that user without affecting other database users. Which two options can you use? (Choose two.)
A. create a database trigger to monitor user queries and to terminate the user session if the CPU usage exceeds a threshold value
B. start the database in QUIESCED mode
C. create a profile with resource restriction and assign it to the user
D. use the Database Resource Manager to prioritize CPU usage
TK
1Z0-031
E. grant the RESTRICTED SESSION system privilege to the user
Answer: C,D
QUESTION 9:
Which two statements are true regarding extent management in a tablespace?
(Choose two.)
A. The extents are allocated immediately after the tablespace is created.
B. In a dictionary-managed tablespace, the information on free extents is maintained inside the tablespace.
C. In a locally managed tablespace free extents are managed by bitmap.
D. Coalescing of freespace is not required in a locally managed tablespace. Answer: C,D
QUESTION 10:
Which two statements are true regarding the temporary tablespace? (Choose two.) A. Used for sort operations
B. Can contain permanent objects
C. Cannot be created with nonstandard block size specification
D. Cannot be shared by multiple users
Answer: A,C
QUESTION 11:
Querying which two dynamic performance views would retrieve information from the control file? (Choose two.)
A. V$SGA
B. V$INSTANCE C. V$DATABASE D. V$TEMPFILE
E. V$PARAMETER Answer: C,D
QUESTION 12:
Which three statements identify the properties of a temporary table? (Choose three.)
Interactive Testing 1z0-031 Engine Included!
389 Questions
Updated : 09/18/2008
Price : $87.99 $79.99
Exam Number/Code:1z0-031
Exam Name: orcacle9i database:fundamentals i
Testking 1z0-031 Exam will provide you with exam simulation questions and actual answers that reflect the actual exam
Preparing for the Testking 1z0-031 exam?Searching 1z0-031 Test Questions,
1z0-031 Practice Exam,1z0-031 Braindumps ? 1z0-031 practice exam covers all the practice test objectives to pass 1z0-031 exam.
Pass your exam at first attempt with our Testking 1z0-031 study guide,1z0-031 Braindumps, As well Audio exam, Realistic Practice Labs, and Interactive Testing Engine.
Our Testking practice test covers the information associated with each 1z0-031 exam topics in details and includes information found in no other practice test sites on the web.
Our challenging questions with Correct Answers built to simulate the actual exam. Unlimited, FREE auto-updates so you’re never behind on any topic. The whole package comes as an automatic download so there’s no waiting or shipping. Our most questions and answers along with explanations. Our practice test will determine you to take your 1z0-031 certification exam and pass the official exam on your first try, guaranteed
Now guaranteed Testking 1z0-031 exam training is available in various formats to best suit your needs and learning style. Whether you are a hands-on tactile learner, visually or even a textbook training veteran, Real-Exams has the 1z0-031 pdf vce format resources that will enable you to pass your 1z0-031 test with flying colors.
Comprehensive questions with complete explanations about actualtests 1z0-031 exam
download 1z0-031 exam questions accompanied by exhibits
Verified Answers Researched by Industry Experts and almost 100% correct
1z0-031 exam questions updated on regular basis
Oracle 1z0-031 Transcender Torrent
Oracle 1z0-031 P4S
Oracle 1z0-031 Study Guide
Oracle 1z0-031 Exams
Oracle 1z0-031 Braindumps
Oracle 1z0-031 Pass4sure
Oracle 1z0-031 Real Exams
Oracle 1z0-031 Exam
Oracle 1z0-031 Actual Tests
Oracle 1z0-031 Pdf
1z0-031 also gives new editions of Real Exams 1z0-031 for enhancing professional skills and knowledge. These Testking Real Practice Questions 000-710 are useful for understanding 1z0-031 exam terminologies and these brain dumps also very useful for enhancing people brain power. These Testking Real Practice Questions 1z0-031 are prepare by highly qualified and 1z0-031 professionals. 1z0-031 Certification experts’ teams always try to give you real exam environment in these 4shared training materials links.
QUESTION 1:
You executed the following command to change the default temporary tablespace in
your database:
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP2;
Which view helps you to confirm that the TEMP2 tablespace is being used as the
default temporary tablespace?
A. DATABASE_PROPERTIES
B. V$DATABASE
C. DBA_TEMP_FILES
D. DBA_TABLESPACES
Answer: A
QUESTION 2:
You have set up password file authentication in your database. You accidentally lost
the password file. What would be the effect of this loss on the functional database?
A. The database will be functional and none of the users will have problems in
connecting.
B. The database will be functional but none of the users will be able to connect as
SYSDBA.
C. The database fails and it needs recovery.
D. The database shuts down and the password file will be created automatically at the
next startup.
Answer: B
QUESTION 3:
Consider the following facts about your database:
-The database operates in NOARCHIVELOG mode.
-The database has three redo log groups.
-All the groups have one member each.
-Redo log group 3 is the CURRENT group.
You executed the following command:
SQL> ALTER DATABASE DROP LOGFILE MEMBER
2 ‘D:\\ORACLE\\ORADATA\\MYDB\\REDO03.LOG’;
The command fails to drop the member. What is the reason displayed for the failure
of the command?
A. You cannot drop a member from a group as the database is in NOARCHIVELOG
mode.
B. You cannot drop the last member in a group.
C. You cannot drop a member when the database is open.
D. You cannot drop a member until checkpoint completes.
Answer: B
QUESTION 4:
Which view would you query to identify the space utilization settings for tables
owned by the APPS user?
A. DBA_SEGMENTS
B. DBA_EXTENTS
C. DBA_OBJECT_TABLES
D. DBA_OBJECTS
Answer: A
QUESTION 5:
View the Exhibit and identify the component labeled as a question mark.
A. system monitor (SMON)
B. archiver (ARCn)
C. checkpoint (CKPT)
D. process monitor (PMON)
Answer: C
QUESTION 6:
Examine the following statement:
SQL> SELECT * FROM V$CONTROLFILE;
In which two situations will the execution of this query return one or more rows?
(Choose two.)
A. when the database is in the OPEN state
B. when the database is in the NOMOUNT state
C. only if the Oracle Managed Files (OMF) feature is used
D. when the database is in the MOUNT state
Answer: A,D
QUESTION 7:
You created the password file in your database server as follows:
$ orapwd file=$ORACLE_HOME/dbs/orapwdb password=dba entries=2
Further, you granted the SYSDBA privilege to the user SCOTT who has TIGER as
the password. What effect would the assigning of this privilege have on Scott’s
password?
A. The password will be DBA when he connects as SYSDBA, and he can use either
TIGER or DBA when connecting as a normal user.
B. The password will not be affected and remain as TIGER.
C. The password will change from TIGER to DBA.
D. The password will be DBA when SCOTT connects as SYSDBA, and TIGER when
connecting as a normal user.
Answer: B
QUESTION 8:
In your database, you observe that a database user is executing a lot of
CPU-intensive queries, thereby causing the database performance to degrade. You
want to restrict the resource utilization of that user without affecting other database
users. Which two options can you use? (Choose two.)
A. create a database trigger to monitor user queries and to terminate the user session if
the CPU usage exceeds a threshold value
B. start the database in QUIESCED mode
C. create a profile with resource restriction and assign it to the user
D. use the Database Resource Manager to prioritize CPU usage
E. grant the RESTRICTED SESSION system privilege to the user
Answer: C,D
QUESTION 9:
Which two statements are true regarding extent management in a tablespace?
(Choose two.)
A. The extents are allocated immediately after the tablespace is created.
B. In a dictionary-managed tablespace, the information on free extents is maintained
inside the tablespace.
C. In a locally managed tablespace free extents are managed by bitmap.
D. Coalescing of freespace is not required in a locally managed tablespace.
Answer: C,D
QUESTION 10:
Which two statements are true regarding the temporary tablespace? (Choose two.)
A. Used for sort operations
B. Can contain permanent objects
C. Cannot be created with nonstandard block size specification
D. Cannot be shared by multiple users
Answer: A,C
QUESTION 11:
Querying which two dynamic performance views would retrieve information from
the control file? (Choose two.)
A. V$SGA
B. V$INSTANCE
C. V$DATABASE
D. V$TEMPFILE
E. V$PARAMETER
Answer: C,D
Testking 1z0-031
TK Questions&Answers(Q & As with Expert Explanations): 464 Q&A
Update: 14/11/2008
Free Down: Testking 1z0-031
Free Down: Pass4sure 1z0-031
Dowload PassGuide Practice Test Questions
7 Comments on “testking oracle 9i 1z0-031”