1Z1-052 by Oracle Actual Free Exam Q&As

Question 1

Which three statements are correct about temporary tables? (Choose three.)

A. Both the data and the structure of temporary tables can be exported. B. The data inserted into a temporary table in a session is available to other sessions. C. Temporary tables are always created in a user's temporary tablespace. D. Data manipulation language (DML) locks are never acquired on the data of temporary tables. E. Indexes and views can be created on temporary tables.

Discussion 0

Correct Answer: C,D,E Vote an answer

Question 2

In a system, large online transaction processing (OLTP) jobs run during the daytime that require a large database buffer cache. In the night, the system supports batch jobs that require a higher value to be set for the large pool. You must simultaneously configure the memory components to accommodate the peak requirement.
What would you do to automate this configuration for the memory components with change in mode of working?

A. Set the SGA_TARGET initialization parameter to a nonzero value. B. Set the MEMORY_MAX_TARGET initialization parameter to zero. C. Set the SGA_TARGET initialization parameter to zero. D. Set the PRE_PAGE_SGA initialization parameter to TRUE.

Discussion 0

Correct Answer: A Vote an answer

Question 3

Your database instance is running with full workload after database creation. You have decided to use a fixedsize undo tablespace. You want to use the undo Advisor to estimate the capacity of the undo tablespace.
Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undo tablespace? (Choose two.)

A. The retention period to support flashback B. The number of undo tablespaces in the database C. The size of the Flash Recovery Area for the database instance D. The expected length of the longest-running query

Discussion 0

Correct Answer: A,D Vote an answer

Question 4

USER1.EMP has a referential integrity constraint defined on EMP.DNO that references USER1.DEPT.DNO.
USER1 executes these commands:

What will be the outcome and why?

A. It will fail because there is an uncommitted transaction on USER1.DEPT B. It will execute successfully and drop DEPT.DNO C. It will fail because there is an uncommitted transaction on USER1.EMP D. It will execute successfully and drop the DEPT.DNO and EMP.DNO columns E. It will fail because a referential integrity constraint is defined on USER1.EMP

Discussion 0

Correct Answer: B Vote an answer

Question 5

What function is performed by the System Monitor (SMON) background process in a database instance?

A. It monitors memory space allocation only within the System Global Area (SGA). B. It performs instance recovery when failed database instance is restarted. C. It monitors memory space allocation within the SGA and the Program Global Area (PGA). D. It performs recovery when a user process fails.

Discussion 0

Correct Answer: B Vote an answer

Question 6

Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a remote machine?

A. Host naming method B. Directory naming method C. Local naming method D. External naming method

Discussion 0

Correct Answer: C Vote an answer

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

Question 7

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

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

Discussion 0

Correct Answer: B Vote an answer

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

Question 8

The database instance has the following parameter setting:
OS_AUTHENT_PREFIX = OPS$
OS_ROLES = FALSE
REMOTE_OS_AUTHENT = FALSE
REMOTE_OS_ROLES = FALSE
TIMED_OS_STATISTICS = 0
You have a local operating system user SKD. You create a database user OPS$SKD, and then assign external authentication. The user OPS$SKD has the CREATE SESSION privilege.
What would you achieve by the above process?

A. The authentication detail for the database user OPS$SKD is recorded in the password file. B. The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance. C. The local operating system user SKD will be able to access the database instance without specifying the username and password. D. The database user OPS$SKD will be able to administer the database.

Discussion 0

Correct Answer: C Vote an answer

Question 9

The database is running in ARCHIVELOG mode. Examine the initialization parameters and their values set to enable archiving on your database server:

Which statement is true regarding the archived redo log files?

A. It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and location specified by the DB_RECOVERY_FILE_DEST parameter. B. It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the default location $ORACLE_HOME/dbs. C. It will be created only in the flash recovery area (fast recovery area). D. It will be created on the local file system in the location specified LOG_ARCHIVE_DEST_1 parameter.

Discussion 0

Correct Answer: D Vote an answer

Question 10

You plan to install Oracle Grid Infrastructure and Oracle Database
Which two mandatory tasks must be completed before you perform these installations?
(Choose two.)

A. creating the oper and asmdba operating system groups B. creating the Oracle Inventory and OSDBA groups in the operating system C. setting the ORACLE_SID environment variable D. creating an operating system user to be the owner of the Oracle installation E. setting the ORACLE_BASE environment variable to an existing directory

Discussion 0

Correct Answer: B,D Vote an answer

Oracle Database 11g: Administration I - 1Z1-052 Exam Practice Test