Oracle 1Z0-052 Online Practice Questions and Exam Preparation

Oracle 1Z0-052 Online Questions & Answers

• Question 201:

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

• Question 202:

  You want to audit update statements that refer to USER1.DEPT.DNAME. Which type of auditing must you use?

  A. standard auditing
  B. mandatory auditing
  C. value-based auditing
  D. fine-grained auditing
  C. value-based auditing

• Question 203:

  Your database instance is started using the server parameter file (SPFILE). You executed a command to change the value of the LOG_BUFFER initialization parameter:

  ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH;

  What would be the outcome of this command?

  A. The command succeeds only if Automatic Memory Management is not enabled.
  B. The command succeeds, but you need to restart the database for changes to take effect.
  C. The command returns an error because the size of the redo log buffer cannot be changed dynamically.
  D. The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area (SGA).
  C. The command returns an error because the size of the redo log buffer cannot be changed dynamically.

• Question 204:

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

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

• Question 205:

  You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue? (Choose two.)

  A. Disable automatic checkpoint tuning
  B. Check the size of the redo log file size and increase the size if it is small
  C. Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor
  D. Decrease the number of redo log members if there are more than one redo log members available in each redo log group
  B. Check the size of the redo log file size and increase the size if it is small
  C. Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor

• Question 206:

  Which two are true about the Inventory directory? (Choose two.)

  A. It should be created before installing Oracle software for the first time on a server
  B. It is shared by all Oracle software installations on a single server
  C. It is required only for Oracle Grid Infrastructure and Oracle Database software installations
  D. It is owned by the oinstall group, which must be created before installing Oracle software for the first time on a server
  E. It can be created only if the ORACLE_BASE environment variable is set
  B. It is shared by all Oracle software installations on a single server
  D. It is owned by the oinstall group, which must be created before installing Oracle software for the first time on a server

• Question 207:

  User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives the following error after the INSERT statement is issued and few rows are inserted:

  INSERT INTO EMP_DEP (emp_id,name,salary,dep_name,mgr_id)

  *

  ERROR at line 1:

  ORA-01653: unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS

  Identify two actions either of which will help you resolve this problem. (Choose two.)

  A. Grant the RESOURCE role to SCOTT.
  B. Add data files to the USERS tablespace.
  C. Grant the CREATE ANY TABLE privilege to SCOTT.
  D. Increase the space for SCOTT on the USERS tablespace.
  E. Increase the size of the data file associated with the USERS tablespace.
  B. Add data files to the USERS tablespace.
  E. Increase the size of the data file associated with the USERS tablespace.

• Question 208:

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

  A. All AWR tables belong to the SYSTEM schema
  B. The AWR contains systemwide tracing and logging information
  C. The snapshots collected by the AWR are accessible through data dictionary views
  D. The snapshots collected by the AWR are used by self-tuning components in the database
  C. The snapshots collected by the AWR are accessible through data dictionary views
  D. The snapshots collected by the AWR are used by self-tuning components in the database

• Question 209:

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

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

• Question 210:

  Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener by using the command: LSNRCTL> STOP What happens to the sessions that are presently connected to the database instance?

  A. The sessions are able to perform only queries
  B. The sessions are not affected and continue to function normally
  C. The sessions are terminated and the active transactions are rolled back
  D. The sessions are not allowed to perform any operations till the listener is started
  B. The sessions are not affected and continue to function normally