최신Oracle Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP - 1z1-067무료샘플문제

A. Drop the temp01.dbf file, and then re-create the temp file.

B. Shut down the database instance, start up the database instance in mount state, create a new temporary tablespace, and then open the database.

C. Create a new temporary tablespace and assign it as the default to the user.

D. Take the temporary tablespace offline, recover the missing temp file, and then bring the temporary tablespace online.

E. Add a new temp file to the temporary tablespace and drop the temp01.dbf file.

A. LOCATION

B. DEFAULT DIRECTORY

C. TYPE

D. PARALLEL

E. ORGANIZATION EXTERNAL

A. It succeeds only if the target database is in MOUNT state

B. It fails because no parallel channels are allocated for the auxiliary database

C. It succeeds and creates multisection backup sets that are used for active database duplication

D. It fails because there is no connection to a recovery catalog

A. The row archival visibility session parameter defaults to all rows.

B. Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter.

C. The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active.

D. The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.

E. The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered active.

A. Performance improves because no redo and undo are generated for the temporary tables

B. Performance improves because less redo is written to the redo log

C. Performance improves because data manipulation language (DML) operations performed on temporary tables do not use the buffer cache

D. Temporary undo reduces the amount of undo stored in undo tablespaces

A. Only the data files belonging to pdb2_ are backed up.

B. All data files belonging to pdb2_1 are backed up along with the archive log files.

C. All data files belonging to pdb2_1 are backed up and all archive log files are deleted.

D. This command gives an error because archive log files can be backed up only when RMAN is connected to the root database.

A. SQL statement restructure recommendations

B. creation of materialized views to improve query performance

C. statistics recommendations

D. SQL profile recommendations

A. It fails and reports an error because the container=all clause is not used.

B. It executes successfully and the c##role1 role is revoked from the c##a_admin user only in the root container.

C. It executes successfully and the c##rocl1 role is revoked from the c##a_admin user in the root database and all the PDBs.

D. It fails and reports an error because the comtainer=current clause is not used.

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

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

C. It can be used to create views.

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.

A. Start up the database instance by using the STARTUP UPGRADE command by using the server parameter file.

B. Start up the database instance by using the new location of the server parameter file and run the catctl.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 new location of the server parameter file and run the catuppst.sql script to generate informational messages and log files during the upgrade.

D. Start up the database instance by using the new location of the server parameter file and run the catupgrd.sql script from the new ORACLE_HOME to use parallel upgrade options that reduce down time.

A. when recovering data that was lost after a DDL operation modified the structure of a table

B. when recovering a table that has been logically corrupted

C. when recovering a table to a point in time

D. when recovering the data of a table to the desired point in time, which is more recent than the oldest available undo.

E. when recovering dropped tables that are present in the recyclebin

A. It succeeds with default settings if the employees table exists in the hr schema.

B. It succeeds and creates the employees table in the HR schema.

C. It fails if the hr user does not have the create any directory privilege.

D. It fails because no SQL*Loader control file location is specified.

E. It fails because no SQL*Loader data file location is specified.

A. impdp will create two users called hr1 and oe1 and import only the tables owned by hr and oe schemas to ht1 and oe1 schemas, respectively.

B. expdp will succeed but impdp will fail because the users do not exist.

C. expdp will fail because no path has been defined for the dumpfile.

D. inpdp will create two users called hr1 and oe1 and import all objects to the new schemas.

A. The ADR base is shared across multiple instances.

B. The ADR can be used for problem diagnosis even when the database instance is down.

C. The ADR base keeps all diagnostic information in binary format.

D. The ADR can be used to store statspack snapshots to diagnose database performance issues.

E. The ADR is used to store Automatic Workload Repository (AWR) snapshots.