1Z0-067 Online Practice Questions and Answers

Which three statements are true about a job chain?

A. It can contain a nested chain of jobs.

B. It can be used to implement dependency-based scheduling.

C. It cannot invoke the same program or nested chain in multiple steps in the chain.

D. It cannot have more than one dependency.

E. It can be executed using event-based or time-based schedules.

Users report this error message when inserting rows into the orders table:

ERROR atline1:

ORA-01654f:unable to extend index USERS.ORDERS_IND by 8in tablespace INDEXES

You determine that the indexes tablespace is out of space and there is no free space on the filesystem

used by the Oracle database.

Which two must you do to fix this problem without affecting currently executing queries?

A. drop and re-create the index

B. coalesce the orders,,ind index

C. coalesce the indexes tablespace

D. perform an on line table rebuild using dbns_redefir.ition.

E. rebuild the index online moving it to another tablespace that has enough free space for the index

Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)?

A. A PDB opened in restricted mode allows only local users to connect.

B. When a CDB is open in restricted mode, PDBs must also be opened in restricted mode.

C. When a CDB is in mount state, PDBs are automatically placed in mount state.

D. All PDBs must be shut down before shutting down a CDB instance.

E. When a CDB instance is started, PDBs can be placed in open state by using database triggers or by executing the alter pluggable database command.

You created a tablespace with this statement:

CREATE BIGFILE TABLESPACE adtbs DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G;

The tablespace is nearly full and you need to avoid any out of space errors for the load of a 5 gig table.

Which two alter statements will achieve this?

A. ALTER TA3LESPACE adtbs RESI2E 20G;

B. ALTER TA3LESPACE adtbs ADD DATAFILE;

C. ALTER TABLESPACE adtbs AUTOEXTEND ON;

D. ALTER TA3LESPACE adtbs ADD DATAFILE '/proddb/data/adtbsl.dbf' SIZE 1QG;

E. ALTER TA3LESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf AUTOEXTEND ON;

Which two statements are true about a common user?

A. A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs.

B. A common user with the create user privilege can create other common users, as well as local users.

C. A common user can be granted only a common role.

D. A common user can have a local schema in a PDB.

E. A common user always uses the global temporary tablespace that is defined at the CDB level as the default temporary tablespace.

Which two statements are true about Flashback Version Query?

A. The result of a query can be used as part of a DML statement.

B. It can be used to create views.

C. It can be used only if Flashback Data Archive is enabled for a table.

D. It retrieves all versions of rows that exist in a time interval, including the start time and end time.

E. It can be used to retrieve the SQL that is required to undo a row change and the user responsible for the change.

Which three statements are true about compression of backup sets?

A. Compressed backups can only be written to media.

B. Binary compression creates performance overhead during a backup operation.

C. Unused blocks below the high-water mark are not backed up.

D. Compressed backups cannot have section size defined during a backup operation

E. It works only for locally managed tablespaces.

Which two statements are true about tablespaces in multitenant container databases (CDBs)?

A. Default permanent tablespaces can be shared across pluggable databases (PDBs).

B. The current container must be set to root to create or modify the default temporary tablespace or tablespace group for a CDB.

C. Each PDB can have its own default temporary tablespace.

D. The default permanent tablespace for a PDB can be changed only by a local user with the required permissions.

E. The amount of space that each PDB can use in a shared temporary tablespace must be set at the CDB level.

As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing

the new Oracle home, you shut down the existing single-instance database.

Which step should you perform next to start the upgrade of the database?

A. Start up the database instance by using the new location of the server parameter file and run the catuppst.sqi script to generate informational messages and log files during the upgrade.

B. Start up the database instance by using the new location of the server parameter file and run the cact1.pl script from the new Oracle home to use parallel upgrade options that reduce down time.

C. Start up the database instance by using the STARTUP UPGRADE command and gather fixed object statistics to minimize the time needed for recompilation.

D. Start up the database instance by using the STARTUP UPGRADE command, which opens the existing database, and then performs additional upgrade operations.

Which two statements are true about RMAN duplexed backups? (Choose two.)

A. For performing duplexed backups, the parallelism for the device must be set equal to the number of copies.

B. It is only supported for backups to tape via media management interface.

C. It is not supported for image copies.

D. Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously.

E. Duplex backups can contain only data files and control files.