Online Access Free 1Z0-035 Practice Test

You need to add a column to a table that holds updateable image data. Which data type should you use for this column?

• A.CLOB
• B.BFILE
• C.BLOB
• D.LOBFILE

You want to benefit from a partial partition-wise join for two tables. What is required?

• A.You need to equipartition both tables on their join keys.
• B.You need to partition one of the tables on their join keys.
• C.You need to hash-partitioned both tables on their join keys.
• D.You must define a foreign key constraint.

For the best performance, what should be done with blocks transferred using the Cache Fusion algorithm in a Real Application Clusters database?

• A.They should be granted, by the Global Cache Service, an exclusive mode resource for each instance involved.
• B.They should be transferred through the cache area of the Global Resource Directory on the instance where the block is mastered.
• C.They should be transferred across a high-speed cluster interconnect.
• D.They should be written to disk by the sending instance and read from disk by the receiving instance.

Examine the statement:
DROP TABLESPACE IND2 INCLUDING CONTENTS AND DATAFILES;
What is the result of the statement?

• A.The statement will only succeed if the IND2 tablespace was built using Oracle-Managed Files (OMF) data files.
• B.The statement will only succeed if the data files belonging to the IND2 tablespace are Oracle-Managed Files (OMF) or if the database was created using OMF.
• C.The contents and data files belonging to the IND2 tablespace are dropped.
• D.The contents of the tablespace are dropped along with all its data files except those identified with the Oracle-Managed Files (OMF) naming convention.

The database was started up using a text parameter file.
What will be the default scope of changes made by using the SET clause of the ALTER SYSTEM statement?

• A.Only MEMORY is updated.
• B.Only init<SID>.ora parameters are updated.
• C.Both init<SID>.ora parameters and SPFILE values are updated.
• D.Both SPFILE and MEMORY memory values are updated.
• E.Only SPFILE values are updated.