1Z0-062 Oracle Admin Exam

Pregunta 1 de 14

1

Which statement is true about the Log Writer process?

Selecciona una de las siguientes respuestas posibles:

A. It writes when it receives a signal from the checkpoint process (CKPT).
B. It writes concurrently to all members of multiplexed redo log groups.
C. It writes after the Database Writer process writes dirty buffers to disk.
D. It writes when a user commits a transaction.

Explicación

Pregunta 2 de 14

1

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

Selecciona una o más de las siguientes respuestas posibles:

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

Explicación

Pregunta 3 de 14

1

Which action takes place when a file checkpoint occurs?

Selecciona una de las siguientes respuestas posibles:

A. The checkpoint position is advanced in the checkpoint queue.
B. All buffers for a checkpointed file that were modified before a specific SCN are written to disk by DBWn and the SCN is stored in the control file.
C. The Database Writer process (DBWn) writes all dirty buffers in the buffer cache to data files.
D. The Log Writer process (LGWR) writes all redo entries in the log buffer to online redo log files.

Explicación

Pregunta 4 de 14

1

Examine the query and its output:

What might have caused three of the alerts to disappear?

Selecciona una de las siguientes respuestas posibles:

A. The threshold alerts were cleared and transferred to DBA_ALERT_HISTORY.
B. An Automatic Workload Repository (AWR) snapshot was taken before the execution of the second query.
C. An Automatic Database Diagnostic Monitor (ADOM) report was generated before the execution of the second query.
D. The database instance was restarted before the execution of the second query.

Explicación

Pregunta 5 de 14

1

Examine the current value for the following parameters in your database instance:

SGA_MAX_SIZE = 1024M -

SGA_TARGET = 700M -

DB_8K_CACHE_SIZE = 124M -

LOG_BUFFER = 200M -
You issue the following command to increase the value of DB_8K_CACHE_SIZE:
SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;
Which statement is true?

Selecciona una de las siguientes respuestas posibles:

A. It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.
B. It succeeds only if memory is available from the autotuned components if SGA.
C. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.
D. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.

Explicación

Pregunta 6 de 14

1

Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges? (Choose three.)

Selecciona una o más de las siguientes respuestas posibles:

A. Bind Variable Peeking
B. SQL Plan Baselines
C. Adaptive Cursor Sharing
D. Bind variable used in a SQL statement
E. Literals in a SQL statement

Explicación

Pregunta 7 de 14

1

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.
Which method or feature should you use?

Selecciona una de las siguientes respuestas posibles:

A. Compare Period ADDM report
B. AWR Compare Period report
C. Active Session History (ASH) report
D. Taking a new snapshot and comparing it with a preserved snapshot

Explicación

Pregunta 8 de 14

1

Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.)

Selecciona una o más de las siguientes respuestas posibles:

A. All AWR tables belong to the SYSTEM schema.
B. The AWR data is stored in memory and in the database.
C. The snapshots collected by AWR are used by the self-tuning components in the database
D. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.
E. AWR contains system wide tracing and logging information.

Explicación

Pregunta 9 de 14

1

Examine the contents of SQL loader control file:

Which three statements are true regarding the SQL* Loader operation performed using the control file? (Choose three.)

Selecciona una o más de las siguientes respuestas posibles:

A. An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.
B. The SQL* Loader data file myfile1.dat has the column names for the EMP table.
C. The SQL* Loader operation fails because no record terminators are specified.
D. Field names should be the first line in the both the SQL* Loader data files.
E. The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.

Explicación

Pregunta 10 de 14

1

In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # #
A_ADMIN in root and all PDBs. You execute the following command from the root container:
SQL > REVOKE create table FROM C # # A_ADMIN;
What is the result?

Selecciona una de las siguientes respuestas posibles:

A. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.
B. It fails and reports an error because the CONTAINER=ALL clause is not used.
C. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.
D. It fails and reports an error because the CONTAINER=CURRENT clause is not used.
E. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.

Explicación

Pregunta 11 de 14

1

You are administering a database and you receive a requirement to apply the following
restrictions:
1. A connection must be terminated after four unsuccessful login attempts by user.
2. A user should not be able to create more than four simultaneous sessions.
3. User session must be terminated after 15 minutes of inactivity.
4. Users must be prompted to change their passwords every 15 days.
How would you accomplish these requirements?

Selecciona una de las siguientes respuestas posibles:

A. by granting a secure application role to the users
B. by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to FALSE
C. By creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4
D. By Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE.
E. By implementing the database resource Manager plan and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.

Explicación

Pregunta 12 de 14

1

Which four actions are possible during an Online Data file Move operation? (Choose four.)

Selecciona una o más de las siguientes respuestas posibles:

A. Creating and dropping tables in the data file being moved
B. Performing file shrink of the data file being moved
C. Querying tables in the data file being moved
D. Performing Block Media Recovery for a data block in the data file being moved
E. Flashing back the database
F. Executing DML statements on objects stored in the data file being moved

Explicación

Pregunta 13 de 14

1

Which two statements are true when row archival management is enabled? (Choose two.)

Selecciona una o más de las siguientes respuestas posibles:

A. The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.
B. The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.
C. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
D. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.
E. The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer

Explicación

Pregunta 14 de 14

1

Which two are prerequisites for performing a flashback transaction? (Choose two.)

Selecciona una o más de las siguientes respuestas posibles:

A. Flashback Database must be enabled.
B. Undo retention guarantee for the database must be configured.
C. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
D. Supplemental logging must be enabled.
E. Recycle bin must be enabled for the database.
F. Block change tracking must be enabled tor the database.

	Creado por Abdullah Albyati hace alrededor de 4 años

This question set is used for the confusing, stupid questions that the Oracle DBA exam has. I mean seriously this test is stupid DON'T BECOME ORACLE DBA

1Z0-062 Oracle Admin Exam

Pregunta 1 de 14

Which statement is true about the Log Writer process?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 2 de 14

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

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 3 de 14

Which action takes place when a file checkpoint occurs?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 4 de 14

Examine the query and its output: What might have caused three of the alerts to disappear?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 5 de 14

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 6 de 14

Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges? (Choose three.)

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 7 de 14

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 8 de 14

Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.)

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 9 de 14

Examine the contents of SQL loader control file: Which three statements are true regarding the SQL* Loader operation performed using the control file? (Choose three.)

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 10 de 14

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 11 de 14

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 12 de 14

Which four actions are possible during an Online Data file Move operation? (Choose four.)

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 13 de 14

Which two statements are true when row archival management is enabled? (Choose two.)

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 14 de 14

Which two are prerequisites for performing a flashback transaction? (Choose two.)

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Examine the query and its output:

What might have caused three of the alerts to disappear?

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.
Which method or feature should you use?

Examine the contents of SQL loader control file:

Which three statements are true regarding the SQL* Loader operation performed using the control file? (Choose three.)