Online Access Free 1Z0-052 Exam Questions

You executed this command to create a temporary table:
SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (
startdate DATE,
enddate DATE,
class CHAR(20)
) ON COMMIT PRESERVE ROWS;
Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction?

• A.The rows stay in the table only until the next transaction starts on the table
• B.The rows stay available for subsequent sessions after the transaction is committed
• C.The rows stay in the table only until session termination
• D.The rows are visible to all current sessions after the transaction in committed

Which is true about the Database Configuration Assistant (DBCA)?

• A.It can register a database with Cloud Control and configure Database Control for the same database.
• B.It can create new database templates only from existing templates or databases.
• C.It can use Oracle ASM for storing database files only if Oracle Managed Files (OMF) is configured.
• D.It can change the server mode from dedicated to shared and vice versa for an existing database.

Automatic Shared Memory Management (ASMM) has been enabled for your database instance. The initialization parameters for the components that are managed by ASMM are not set. After observing the effects of ASMM, you executed the following command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;
Which statement is true in this scenario?

• A.The maximum memory size that can be obtained by the database buffer cache during ASMM is set to 100 MB.
• B.The minimum memory size allocated for a server process in the database buffer cache in dedicated mode is set to 100 MB.
• C.The maximum memory size from the database buffer cache that can be released for dynamic distribution during ASMM is set to 100 MB.
• D.The minimum memory size for the database buffer cache is set to 100 MB.

The database instance is currently using SPFILE. View the Exhibit and examine the error that you received while running the DB Structure Integrity check. Given below are the steps to recover from the error in random order:
1 . Shut down the instance, if not already done.
2 . Copy one of the remaining control files to a new location.
3 . Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of the control files.
4. Start up the database instance to the NOMOUNT stage.
5. Recover the database to the point of failure of the control file.
6. Open the database.
Identify the correct sequence of steps?
Exhibit:

• A.1, 2, 4, 3, 5, 6
• B.4, 5, 6, 2, 3; 1 not required
• C.2, 4, 3, 5, 6; 1 not required
• D.5, 2, 3, 4; 1 and 6 not required

You want to create a role to meet these requirements:
1. The role is to be protected from unauthorized usage.
2. The password of the role is not to be embedded in the application source code or stored in a table.
Which method would you use to restrict enabling of such roles?

• A.Create the role as a secure application role.
• B.Create a role and use Fine-Grained Access Control (FGAC) to secure the role.
• C.Create the role with external authentication.
• D.Create the role as a password-protected role.