Latest Oracle 1Z1-060 Actual Free Exam Questions & Community Discussion, Page 1

Question #1

Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column?

A. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.

B. All the components may be moved from the SYSAUX tablespace.

C. All the components may be moved into SYSAUX tablespace.

D. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.

Discussion 0

Correct Answer: A,D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #2

You database is running an ARCHIVELOG mode.
The following parameter are set in your database instance:
LOG_ARCHIVE_FORMAT = arch+%t_%r.arc
LOG_ARCHIVE_DEST_1 = `LOCATION = /disk1/archive'
DB_RECOVERY_FILE_DEST_SIZE = 50G
DB_RECOVERY_FILE = `/u01/oradata'
Which statement is true about the archived redo log files?

A. They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.

B. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.

C. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.

D. They are created only in the Fast Recovery Area.

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #3

Examine the following query output:

You issue the following command to import tables into the hr schema:
$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr
TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y
Which statement is true?

A. None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.

B. All database operations performed by the impdp command are logged.

C. Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.

D. Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #4

Which two are true concerning a multitenant container database with three pluggable databases?

A. Pluggable databases can make database consolidation easier

B. All administration tasks must be done to each pluggable database.

C. Pluggable databases in the same container database (CDB) each have their own buffer cache

D. Pluggable databases are patched together

E. Pluggable databases increase patching time.

Discussion 0

Correct Answer: A,D Vote an answer

Question #5

Examine the following command;
ALTER SYSTEM SET enable_ddl_logging = TRUE;
Which statement is true?

A. Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.

B. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.

C. Only DDL commands that resulted in the creation of new segments are logged.

D. All DDL commands are logged in a different log file that contains DDL statements and their execution dates.

E. All DDL commands are logged in the alert log file.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #6

The tnsnames.ora file has an entry for the service alias ORCL as follows:

The TNSPING command executes successfully when tested with ORCL; however, from the same OS user session, you are not able to connect to the database instance with the following command:
SQL > CONNECT scott/tiger@orcl
What could be the reason for this?

A. The listener is running on a different port.

B. The orcl.oracle.com database service is not registered with the listener.

C. The listener is not running on the database node.

D. The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.

E. The TNS_ADMIN environment variable is set to the wrong value.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #7

Examine the memory-related parameters of an Oracle database instance:

Which statement is true?

A. PGA size can grow automatically beyond 500 MB.

B. The value of the memory_target parameter cannot be changed dynamically.

C. Memory is dynamically re-allocated between SGA and PGA as needed.

D. Only the components of SGA are managed automatically.

Discussion 0

Correct Answer: A Vote an answer

Question #8

You performed an incremental level 0 backup of a database:
RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE;
To enable block change tracking after the incremental level 0 backup, you issued this command:
SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
` /mydir/rman_change_track.f';
To perform an incremental level 1 cumulative backup, you issued this command:
RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
Which three statements are true?

A. More than one database block may be read by an incremental backup for a change made to a single block.

B. Block change tracking will always reduce I/O performed during cumulative incremental backups.

C. Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.

D. The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.

E. The change tracking file must always be backed up when you perform a full database backup.

Discussion 0

Correct Answer: A,C,D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #9

In your database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20.
Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?

A. Setting the target tablespace to read-only after the segments are moved

B. Taking the target tablespace offline after the segments are moved

C. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

D. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

E. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

Discussion 0

Correct Answer: A,E Vote an answer

Question #10

You issue the following command to alter the country column in the departments table:

Which statement is true?

A. It executes successfully. The modification to add the default value takes effect only from subsequent insertions to the table.

B. It produces an error because column definitions cannot be altered to add default values.

C. It produces an error because the data type for the column is not specified.

D. It executes successfully and all the rows that have a null value for the country column will be updated with the value 'USA'.

Discussion 0

Correct Answer: D Vote an answer

Oracle 1Z1-060 Actual Free Exam Questions & Community Discussion

Download Free Oracle 1Z1-060 Demo