Free Oracle 1Z0-045 Exam Dumps Questions & Answers


Exam Code/Number:	1Z0-045Join the discussion
Exam Name:	Oracle database 10g:new features for Oracle8i ocps
Certification:	Oracle
Free Question Number:	156
Publish Date:	Oct 03, 2026
# of views:	2332
Rating 100%

Page: 1 / 32
Total 156 questions

Question 1

Which four tablespaces can be renamed? (Choose four.)

A.a temporarytablespace
B.an offlinetablespace
C.a read-onlytablespace
D.an undotablespace
E.the SYSTEMtablespace
F.the default permanenttablespace for the non-SYSTEM users

Question 2

Which three file types are managed by Data Pump jobs? (Choose three.)

A.alert files
B.SQL files
C.dump files
D.error files
E.out files
F.log files

Question 3

Which statement regarding the COMPATIBLE parameter is correct?

A.It can have any value between 8.0.0 and 10.1.0 in Oracle 10g database.
B.After it is set to 10.0.0 or greater and the database is opened, it cannot be set back.
C.It is a new parameter in Oracle 10g.
D.It is a dynamic parameter.
E.It is an advanced parameter.

Question 4

You have three temporary tablespace groups named G1, G2, and G3 in your database.
You are creating a new temporary tablespace as follows:
CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE GROUP '';
Which statement regarding the above command is correct?

A.It will not add thetablespace TEMP1 to any group.
B.It will create thetablespace TEMP1 in the default group.
C.It will throw an error with message 'specified group is not available'.
D.It will create a new group with a system-generated name and add thetablespace TEMP1 to it.
E.It will create thetablespace TEMP1 in group G3.
F.It will create thetablespace TEMP1 in group G1.

Question 5

On which two database objects can the VERSIONS clause of the Flashback Versions Query be used? (Choose two.)

A.heap tables
B.temporary tables
C.external tables
D.Index-Organized Tables (IOTs)
E.fixed tables
F.views