Testking Oracle 11i 1z0-235
Visited 374 times, 2 so far today
Oracle 11i Applications DBA:Fundamentals I : 1z0-235 Exam
Exam Number: 1Z0-235
Associated Certifications: Oracle 11i Applications DBA
Exam Price: $195 USD
Exam Registration: Register
Duration: 120 minutes
Number of Questions: 68
Passing Score: 70%
Recommended Training and Preparation
Oracle9i Database Administration Fundamentals I
Oracle9i Database Administration Fundamentals II
Additional Information & Resources
Oracle 11i Application Developer DBA Candidate Guide
Exam Retake policies
Exam Topics
Oracle Architectural Components
[ ]
Describe the Oracle architecture and its main components
[ ]
List (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
Managing an Oracle Instance
[ ]
Create and manage initialization parameter files
[ ]
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 manually
Data Dictionary Content and Usage
[ ]
Identify key data dictionary components
[ ]
Identify the contents and uses of the data dictionary
[ ]
Query the data dictionary
Maintaining the Control File
[ ]
Explain the uses of the control file
[ ]
Mulitplex and manage the control file
[ ]
Obtain control file information
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
[ ]
Mulitplex and maintain online redo log files
Managing Tablespaces and Data files
[ ]
Describe the logical structure of tablespaces within the database
[ ]
Create tablespaces
[ ]
Allocate space for temporary segments
[ ]
Change the status of tablespaces
[ ]
Change the storage settings of tablespaces
Storage Structure and Relationships
[ ]
List 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 Tables
[ ]
Identify the various methods of storing data
[ ]
Create regular and temporary tables
[ ]
Reorganize, truncate, drop a table
[ ]
Drop a column within a table
Managing Indexes
[ ]
List the different types of indexes and their uses
[ ]
Reorganize indexes
[ ]
Monitor the usage of an index
Maintaining Data Integrity
[ ]
Describe the Types of Data Integrity Constraints
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
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
Basic Oracle Net Architecture
[ ]
Explain the key components of the Oracle Net layered architecture
[ ]
Explain Oracle Net Services role in client server connections
[ ]
Describe how web client connections are established through Oracle networking products
Basic Net Server-Side Configuration
[ ]
Identify how the listener responds to incoming connections
[ ]
Configure the listener using Oracle Net Manager
[ ]
Control the listener using the Listener Control Utility (lsnrctl)
[ ]
Describe Dynamic Service Registration
Basic Oracle Net Services Client-Side Configuration
[ ]
Describe the difference between host naming and local service name resolution
[ ]
Use Oracle Net Configuration Assistant to configure: Host Naming, Local naming method, Net service names
[ ]
Perform simple connection troubleshooting
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-235 exam PDF
The following courses are the recommended training for 1z0-235 exam PDF.
1z0-235 Q & A with Explanations
1z0-235 Audio Exam
1z0-235 Study Guide
1z0-235 Preparation Lab
1z0-235 Exam: Freetestking’s Oracle 11i Applications DBA:Fundamentals I PDF
The Oracle 11i Applications DBA:Fundamentals I PDF for preparing for the 1z0-235 exam – Freetestking’s Oracle 11i Applications DBA: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 receive the following error while connecting to an Oracle9i database instance: ORA-12523
TNS:listener could not find instance appropriate for the client connection Which action would be appropriate in the context of investigating the cause of error?
A. checking the listener.ora file to verify that the protocol specified in ADDRESS is supported by the database server
B. checking the sqlnet.ora file to verify that the NAMES.DIRECTORY_PATH =
(TNSNAMES,HOSTNAME)parameter is set
C. executing the lsnrctl services command to verify that the instances are registered with the listener, and have the READY status.
D. checking the tnsnames.ora file to verify that the net service name specified in your connect string is mapped to a connect descriptor
Answer: C Question: 2
You are using rollback segments in your database. To ease transaction management, you want
to implement automatic undo management by using the following steps:
1. creating an undo tablespace
2. setting the UNDO_MANAGEMENT parameter to AUTO in the parameter file
3. changing the tablespace that has the rollback segments to an undo tablespace by using the
ALTER TABLESPACE command
4. setting the UNDO_TABLESPACE parameter to the tablespace that has the rollback segments
5. dropping the rollback segments and create undo segments in the same tablespace that has the rollback segments
Which option would you use? A. 3 only
B. 1 and 2 only
C. 2 and 3 only D. 3 and 5 only E. 2 and 5 only
Answer: B Question: 3
You specified extent management as local for a tablespace. How will this affect space
management in the tablespace?
A. Bitmap will be used to record free and allocated extents.
B. Free extents will be managed by the data dictionary tables.
C. The tablespace can have extents containing blocks of different sizes.
D. The tablespace will be system managed and the users cannot specify the extent size.
Answer: A Question: 4
Which statement regarding the KEEP buffer pool is true assuming that it is sized correctly?
A. The buffer pool can be used for data blocks of standard size only.
B. The buffer pool can be used for data blocks of both standard and nonstandard sizes.
C. The buffer pool eliminates data blocks from memory when they are no longer needed.
Page 1 of 31
TK
Exam Name: Oracle 11i Applications DBA: Fundamentals I
Exam Type Oracle
Exam Code: 1z0-235 Total Questions: 108
D. The buffer pool holds data blocks from schema objects that are not assigned to any buffer
pool.
Answer: A Question: 5
Which two statements are true regarding object privileges? (Choose two.)
A. The privileges cannot be granted to a user in the form of a role.
B. The object owner can grant the privileges to any other user in the database.
C. Any user that has the GRANT ANY OBJECT PRIVILEGE can grant the privileges on behalf of the object owner.
D. The grantee of the privileges with WITH GRANT OPTION can revoke the same privileges from any other user irrespective of its grantor.
Answer: B, C Question: 6
Which two statements are true regarding the temporary tablespace? (Choose two.)
A. Used for sort operations
B. Can contain permanent objects
C. Cannot be shared by multiple users
D. Cannot be created with nonstandard block size specification
Answer: A, D Question: 7
You want to reuse all the existing data files, control files, and redo log files to re-create your test database. You execute the following command to create the database:
CREATE DATABASE testdb
DATAFILE
‘/u01/oradata/testdb/system01.dbf’ SIZE 100M REUSE
LOGFILE
GROUP 1 (’/u01/oradata/testdb/log1a.rdo’,
‘/u02/oradata/testdb/log1b.rdo’) SIZE 50K REUSE,
GROUP 2 (’/u01/oradata/testdb/log2a.rdo’,
‘/u02/oradata/testdb/log2b.rdo’) SIZE 50K REUSE MAXLOGFILES 5
MAXLOGHISTORY 100
MAXDATAFILES 10;
The command fails to create the database successfully. What could be the reason?
A. You have set MAXLOGFILES to a very low value. B. You cannot reuse the online redo log files.
C. You have omitted the CONTROLFILE REUSE clause.
D. You cannot reuse the data file belonging to the SYSTEM tablespace.
Answer: C Question: 8
Which three statements are correct regarding the listener process? (Choose three.)
Page 2 of 31
TK
Exam Name: Oracle 11i Applications DBA: Fundamentals I
Exam Type Oracle
Exam Code: 1z0-235 Total Questions: 108
A. A listener can be configured to listen for multiple protocols.
B. Multiple listeners cannot listen on behalf of a single database. C. The name of the listener should be unique per listener.ora file.
D. A listener can listen for a single database only and not multiple databases.
E. The listener transfers the connection request to a dispatcher in a Shared Server configuration.
F. The listener transfers the connection request to the Connection Manager in a Dedicated Server configuration.
Answer: A, C, E Question: 9
Examine the value set for the NAMES.DIRECTORY_PATH parameter in the sqlnet.ora file.
You are working in a TCP/IP network environment. What will happen when you try to connect to the database from a remote client?
A. The local naming method will be used first to resolve a connect identifier. B. It will result in an error because two values cannot be specified for the
NAMES.DIRECTORY_PATH parameter.
C. If the local naming method is unable to resolve the connect identifier, then Oracle Names server will be used to resolve the connect identifier.
D. If the host naming method is unable to resolve the connect identifier, then the net service
name stored in a centralized LDAP-compliant directory server is used to resolve the connect identifier.
Answer: A Question: 10
You are working in a dedicated server environment. You require the PMON process to register
with a local listener, lsnr1, which does not use TCP/IP, port 1521. The protocol address of lsnr1 is available in the listener.ora file. What would you do?
A. configure the LOCAL_LISTENER parameter in the initialization parameter file
B. configure the SID_LIST_LSNR1 parameter in the listener.ora file
C. execute the lsnrctl set command with the appropriate parameter to set the correct instance names
D. no explicit action required because the protocol address of the listener is available in the listener.ora file
Page 3 of 31
TK
Exam Name: Oracle 11i Applications DBA: Fundamentals I
Exam Type Oracle
Exam Code: 1z0-235 Total Questions: 108
Answer: A
Question: 11
You executed the following command to grant the CONNECT role to the USER01 user:
SQL> GRANT connect to USER01 WITH ADMIN OPTION; Which statement is true?
A. The user can grant the role to any database user but cannot revoke it. B. The user can grant or revoke the role to or from any database user.
C. The user can revoke the role from any database user but cannot grant it.
D. The statement fails because the CONNECT role cannot be granted with WITH ADMIN OPTION.
E. The user can grant or revoke the role to or from any database user except the SYS and
SYSTEM users.
Answer: B Question: 12
Which Oracle data type should you use to store data in a database that uses multiple languages
to store data?
A. LONG B. CHAR
C. VARCHAR D. VARCHAR2
E. NVARCHAR2
Answer: E Question: 13
You executed the following command to create an index on CUSTOMER_ID and ITEMS_ID
columns in the ORDERS table:
SQL> CREATE INDEX orders_prim_indx
ON orders (customer_id, items_id);
In which two conditions would a query use this index? (Choose two.)
A. when both the columns are used in the WHERE clause of the query
B. when both the columns are used in the SELECT clause of the query
C. when the CUSTOMER_ID column is used in the WHERE clause of the query
D. when the ITEMS_ID column is used with a single row function in the WHERE clause of the query
Answer: A, C Question: 14
When is the control file opened?
A. after the data files are opened
B. after the parameter file is opened
C. after the redo log files are opened
D. after the parameter file, data files, and redo log files are opened
E. before the parameter file, data files, and redo log files are opened
Product Description
Exam Number/Code: 1z0-235
Exam Name: Oracle 11i Applications DBA:Fundamentals I
“Oracle 11i Applications DBA:Fundamentals I”, also known as 1z0-235 exam, is a Oracle certification.
Preparing for the 1z0-235 exam? Searching 1z0-235 Test Questions, 1z0-235 Practice Exam, 1z0-235 Dumps?
With the complete collection of questions and answers, Pass4sure has assembled to take you through 136 Q&As to your 1z0-235 Exam preparation. In the 1z0-235 exam resources, you will cover every field and category in Oracle 11i helping to ready you for your successful Oracle Certification.
Exam Number/Code:1z0-235
Exam Name: Oracle 11i Applications DBA:Fundamentals I
Testking 1z0-235 Exam will provide you with exam simulation questions and actual answers that reflect the actual exam
Preparing for the Testking 1z0-235 exam?Searching 1z0-235 Test Questions,
1z0-235 Practice Exam,1z0-235 Braindumps ? 1z0-235 practice exam covers all the practice test objectives to pass 1z0-235 exam.
Pass your exam at first attempt with our Testking 1z0-235 study guide,1z0-235 Braindumps, As well Audio exam, Realistic Practice Labs, and Interactive Testing Engine.
Our Testking practice test covers the information associated with each 1z0-235 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-235 certification exam and pass the official exam on your first try, guaranteed
Now guaranteed Testking 1z0-235 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-235 pdf vce format resources that will enable you to pass your 1z0-235 test with flying colors.
Comprehensive questions with complete explanations about actualtests 1z0-235 exam
download 1z0-235 exam questions accompanied by exhibits
Verified Answers Researched by Industry Experts and almost 100% correct
1z0-235 exam questions updated on regular basis
Oracle 1z0-235 Transcender Torrent
Oracle 1z0-235 P4S
Oracle 1z0-235 Study Guide
Oracle 1z0-235 Exams
Oracle 1z0-235 Braindumps
Oracle 1z0-235 Pass4sure
Oracle 1z0-235 Real Exams
Oracle 1z0-235 Exam
Oracle 1z0-235 Actual Tests
Oracle 1z0-235 Pdf
1z0-235 also gives new editions of Real Exams 1z0-235 for enhancing professional skills and knowledge. These Testking Real Practice Questions 000-710 are useful for understanding 1z0-235 exam terminologies and these brain dumps also very useful for enhancing people brain power. These Testking Real Practice Questions 1z0-235 are prepare by highly qualified and 1z0-235 professionals. 1z0-235 Certification experts’ teams always try to give you real exam environment in these 4shared training materials links.
Question: 1
You receive the following error while connecting to an Oracle9i database instance: ORA-12523
TNS:listener could not find instance appropriate for the client connection Which action would be
appropriate in the context of investigating the cause of error?
A. checking the listener.ora file to verify that the protocol specified in ADDRESS is supported by
the database server
B. checking the sqlnet.ora file to verify that the NAMES.DIRECTORY_PATH =
(TNSNAMES,HOSTNAME)parameter is set
C. executing the lsnrctl services command to verify that the instances are registered with the
listener, and have the READY status.
D. checking the tnsnames.ora file to verify that the net service name specified in your connect
string is mapped to a connect descriptor
Answer: C
Question: 2
You are using rollback segments in your database. To ease transaction management, you want
to implement automatic undo management by using the following steps:
1. creating an undo tablespace
2. setting the UNDO_MANAGEMENT parameter to AUTO in the parameter file
3. changing the tablespace that has the rollback segments to an undo tablespace by using the
ALTER TABLESPACE command
4. setting the UNDO_TABLESPACE parameter to the tablespace that has the rollback segments
5. dropping the rollback segments and create undo segments in the same tablespace that has the
rollback segments
Which option would you use?
A. 3 only
B. 1 and 2 only
C. 2 and 3 only
D. 3 and 5 only
E. 2 and 5 only
Answer: B
Question: 3
You specified extent management as local for a tablespace. How will this affect space
management in the tablespace?
A. Bitmap will be used to record free and allocated extents.
B. Free extents will be managed by the data dictionary tables.
C. The tablespace can have extents containing blocks of different sizes.
D. The tablespace will be system managed and the users cannot specify the extent size.
Answer: A
Question: 4
Which statement regarding the KEEP buffer pool is true assuming that it is sized correctly?
A. The buffer pool can be used for data blocks of standard size only.
B. The buffer pool can be used for data blocks of both standard and nonstandard sizes.
C. The buffer pool eliminates data blocks from memory when they are no longer needed.
D. The buffer pool holds data blocks from schema objects that are not assigned to any buffer
pool.
Answer: A
Question: 5
Which two statements are true regarding object privileges? (Choose two.)
A. The privileges cannot be granted to a user in the form of a role.
B. The object owner can grant the privileges to any other user in the database.
C. Any user that has the GRANT ANY OBJECT PRIVILEGE can grant the privileges on behalf of
the object owner.
D. The grantee of the privileges with WITH GRANT OPTION can revoke the same privileges from
any other user irrespective of its grantor.
Answer: B, C
Question: 6
Which two statements are true regarding the temporary tablespace? (Choose two.)
A. Used for sort operations
B. Can contain permanent objects
C. Cannot be shared by multiple users
D. Cannot be created with nonstandard block size specification
Answer: A, D
Question: 7
You want to reuse all the existing data files, control files, and redo log files to re-create your test
database. You execute the following command to create the database:
CREATE DATABASE testdb
DATAFILE
‘/u01/oradata/testdb/system01.dbf’
SIZE 100M REUSE
LOGFILE
GROUP 1 (’/u01/oradata/testdb/log1a.rdo’,
‘/u02/oradata/testdb/log1b.rdo’)
SIZE 50K REUSE,
GROUP 2 (’/u01/oradata/testdb/log2a.rdo’,
‘/u02/oradata/testdb/log2b.rdo’)
SIZE 50K REUSE
MAXLOGFILES 5
MAXLOGHISTORY 100
MAXDATAFILES 10;
The command fails to create the database successfully. What could be the reason?
A. You have set MAXLOGFILES to a very low value.
B. You cannot reuse the online redo log files.
C. You have omitted the CONTROLFILE REUSE clause.
D. You cannot reuse the data file belonging to the SYSTEM tablespace.
Answer: C
Question: 8
A. A listener can be configured to listen for multiple protocols.
B. Multiple listeners cannot listen on behalf of a single database.
C. The name of the listener should be unique per listener.ora file.
D. A listener can listen for a single database only and not multiple databases.
E. The listener transfers the connection request to a dispatcher in a Shared Server configuration.
F. The listener transfers the connection request to the Connection Manager in a Dedicated Server
configuration.
Answer: A, C, E
Question: 9
Examine the value set for the NAMES.DIRECTORY_PATH parameter in the sqlnet.ora file.
You are working in a TCP/IP network environment. What will happen when you try to connect to
the database from a remote client?
A. The local naming method will be used first to resolve a connect identifier.
B. It will result in an error because two values cannot be specified for the
NAMES.DIRECTORY_PATH parameter.
C. If the local naming method is unable to resolve the connect identifier, then Oracle Names
server will be used to resolve the connect identifier.
D. If the host naming method is unable to resolve the connect identifier, then the net service
name stored in a centralized LDAP-compliant directory server is used to resolve the connect
identifier.
Answer: A
Question: 10
You are working in a dedicated server environment. You require the PMON process to register
with a local listener, lsnr1, which does not use TCP/IP, port 1521. The protocol address of lsnr1 is
available in the listener.ora file. What would you do?
A. configure the LOCAL_LISTENER parameter in the initialization parameter file
B. configure the SID_LIST_LSNR1 parameter in the listener.ora file
C. execute the lsnrctl set command with the appropriate parameter to set the correct instance
names
D. no explicit action required because the protocol address of the listener is available in the
listener.ora file
Answer: A
Question: 11
You executed the following command to grant the CONNECT role to the USER01 user:
SQL> GRANT connect to USER01 WITH ADMIN OPTION;
Which statement is true?
A. The user can grant the role to any database user but cannot revoke it.
B. The user can grant or revoke the role to or from any database user.
C. The user can revoke the role from any database user but cannot grant it.
D. The statement fails because the CONNECT role cannot be granted with WITH ADMIN
OPTION.
E. The user can grant or revoke the role to or from any database user except the SYS and
SYSTEM users.
Answer: B
Question: 12
Which Oracle data type should you use to store data in a database that uses multiple languages
to store data?
A. LONG
B. CHAR
C. VARCHAR
D. VARCHAR2
E. NVARCHAR2
Answer: E
Question: 13
You executed the following command to create an index on CUSTOMER_ID and ITEMS_ID
columns in the ORDERS table:
SQL> CREATE INDEX orders_prim_indx
ON orders (customer_id, items_id);
In which two conditions would a query use this index? (Choose two.)
A. when both the columns are used in the WHERE clause of the query
B. when both the columns are used in the SELECT clause of the query
C. when the CUSTOMER_ID column is used in the WHERE clause of the query
D. when the ITEMS_ID column is used with a single row function in the WHERE clause of the
query
Answer: A, C
Testking 1z0-235
TK Questions&Answers(Q & As with Expert Explanations): 108 Q&A
Update: 28/06/2008
Free Down: Testking 1z0-235
Free Down: Pass4sure 1z0-235
Dowload PassGuide Practice Test Questions
5 Comments on “Testking Oracle 11i 1z0-235”