Oracle Database 12c: Installation and Administration - 1z1-062 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

As part of a manual upgrade of your database to Oracle Database 12c, you plan to issue the command:
SQL> STARTUP UPGRADE
Which three statements are true about the upgrade process? (Choose three.)

A. The COMPATIBLE parameter must be set to at least 12.1.0 before issuing the command. B. All job queues remain active during the upgrade process. C. All system triggers are disabled during the upgrade process. D. Only queries on fixed views execute without errors until you run the catctl.pl script. E. Only connections AS SYSDBA are allowed during the upgrade process.

Discussion 0

Correct Answer: B,C,E Vote an answer

Question 2

You want to reduce fragmentation and reclaim unused space for the SALES table but not its dependent objects. During this operation, you want to ensure the following:
i. Long-running queries are not affected.
ii. No extra space is used.
iii. Data manipulation language (DML) operations on the table succeed at all times throughout the process.
iv. Unused space is reclaimed both above and below the high water mark.
Which ALTER TABLE option would you recommend?

A. DEALLOCATE UNUSED B. SHRINK SPACE CASCADE C. SHRINK SPACE COMPACT D. ROW STORE COMPRESS BASIC

Discussion 0

Correct Answer: C Vote an answer

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

Question 3

Which three statements are true about space usage alerts? (Choose three.)

A. Alerts are not issued for locally managed tablespaces that are offline or in read-only mode. B. Alerts are issued only when the critical threshold for space available in a tablespace is breached. C. Database alerts can provide warnings about low space availability at both tablespace and segment levels. D. A newly created locally managed tablespace is automatically assigned the default threshold values defined for a database. E. The sum of active extents and allocated user quotas is considered to compute space usage for an undo tablespace.

Discussion 0

Correct Answer: A,B,D Vote an answer

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

Question 4

You execute the commands:

Which two statements are true? (Choose two.)

A. The user Sidney can connect to the database instance but requires relevant privileges to create objects in the users tablespace. B. The create user command fails if any role with the name Sidney exists in the database. C. The user Sidney is created and authenticated by the operating system. D. The user Sidney is created but cannot connect to the database instance because no profile is default. E. The user Sidney can connect to the database instance but cannot perform sort operations because no space quota is specified for the temp tablespace.

Discussion 0

Correct Answer: A,B Vote an answer

Question 5

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

A. All the components may be moved from the SYSAUX tablespace. B. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace. C. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace. D. All the components may be moved into SYSAUX tablespace.

Discussion 0

Correct Answer: B,C Vote an answer

Question 6

You execute the following commands to audit database activities:
SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE;
SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the audit record that generated when auditing after instance restarts?

A. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements. B. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used. C. One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used. D. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements. E. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.

Discussion 0

Correct Answer: E Vote an answer

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

Question 7

Examine the command:
SQL> CONNECT hr/hr@orcl
Which two configurations allow this command to execute successfully? (Choose two.)

A. The TNS_ADMIN environment variable should be set to orcl on the client. B. The orcl TNS alias should be defined in the tnsnames.ora file on both the client and the database host. C. In the tnsnames.ora file, the SERVICE_NAME value of CONNECT_DATA should be explicitly suffixed with the domain name. D. The orcl TNS alias should be defined such that it is resolvable by a client running on the database host. E. The SERVICE_NAMES initialization parameter should contain the name orcl in the database host.

Discussion 0

Correct Answer: D,E Vote an answer

Question 8

Which two tasks can be performed on an external table? (Choose two.)

A. creating a public synonym B. creating a view C. partitioning the table D. updating the table by using an UPDATE statement E. creating an invisible index

Discussion 0

Correct Answer: A,B Vote an answer

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

Question 9

Which two statements are true about a server parameter file (SPFILE)? (Choose two.)

A. An SPFILE contains only those dynamic parameters that can be changed without having to restart the database instance. B. An SPFILE must reside in the ORACLE_HOME/dbs directory. C. An SPFILE can be created only before a database instance is started. D. A PFILE can be used to start up a database instance even if an SPFILE exists. E. An SPFILE can be created from a PFILE or from memory.

Discussion 0

Correct Answer: D,E Vote an answer

Question 10

Which two categories of segments are analyzed by the Automatic Segment Advisor? (Choose two.)

A. segments in tablespaces that have exceeded a critical or warning space threshold B. segments that have unusable indexes C. segments that are sparsely populated and have more than 10% of free space below the high water mark. D. segments that have the highest growth rate in a database E. segments for tables created using ADVANCED ROW COMPRESSION

Discussion 0

Correct Answer: A,D Vote an answer

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

Question 11

Your database is open in read/write mode and multiple users are connected to the database instance.
You execute the following command:
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
What would be the effect on current sessions?

A. They are not affected. B. They are not terminated but may only issue queries. C. They are terminated after completing the transaction. D. They are terminated immediately.

Discussion 0

Correct Answer: A Vote an answer