Oracle 1Z0-052 Online Practice Questions and Exam Preparation

Oracle 1Z0-052 Online Questions & Answers

• Question 161:

  Which three statements are true about logical structures of the Oracle database? (Choose three.)

  A. Each segment contains one or more extents.
  B. Multiple tablespaces can share a single data file.
  C. A data block is the smallest unit of input/output (I/O) in data files.
  D. It is possible to have tablespaces of different block sizes in a database.
  E. Each data block in the database always corresponds to one operating system block.
  A. Each segment contains one or more extents.
  C. A data block is the smallest unit of input/output (I/O) in data files.
  D. It is possible to have tablespaces of different block sizes in a database.

• Question 162:

  A database user SMITH tries to query the V$SESSION view and fails to access it as follows:

  

  Which are the two possible solutions to enable SMITH to query the data in V$SESSION? (Choose two.)

  A. granting SELECT privilege to SMITH on V$SESSION
  B. granting SELECT privilege to SMITH on V_$SESSION
  C. asking the user SMITH to run the catalog.sql script
  D. granting SELECT privilege to SMITH on V$FIXED_TABLES
  E. setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE
  F. creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created
  B. granting SELECT privilege to SMITH on V_$SESSION
  F. creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created

• Question 163:

  A database user SMITH tries to query the V$SESSION view and fails to access it as follows:

  

  Which solution will enable SMITH to query the data in V$SESSION?

  A. granting SELECT privilege to SMITH on V$SESSION
  B. granting SELECT privilege to SMITH on V_$SESSION
  C. asking the user SMITH to run the catalog.sql script
  D. granting SELECT privilege to SMITH on V$FIXED_TABLES
  E. setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE
  B. granting SELECT privilege to SMITH on V_$SESSION

• Question 164:

  Which statement is true about loading data using the conventional path of SQL*Loader?

  A. Redo is not generated while performing conventional path loads
  B. Only PRIMARY KEY, UNIQUE KEY and NOT NULL constraints are checked
  C. No exclusive locks are acquired when the conventional path loads are performed
  D. Instead of performing transactions, SQL*Loader directly writes data blocks to the data files
  E. INSERT triggers are disabled before the conventional path load and reenabled at the end of the load
  C. No exclusive locks are acquired when the conventional path loads are performed

• Question 165:

  Which two statements describe good practices for an application developer to reduce locking conflicts in Oracle database? (Choose two.)

  A. Avoid coding unnecessary longrunning transactions.
  B. Allow the database to handle locks in default locking mode.
  C. Always explicitly code the locks as per the requirement of the application.
  D. Allow escalation of row locks to block locks if too many row locks cause problem.
  A. Avoid coding unnecessary longrunning transactions.
  B. Allow the database to handle locks in default locking mode.

• Question 166:

  Which two are true about roles? (Choose two.)

  A. A secure application role can be set only by its associated PL/SQL package.
  B. A role can be granted a combination of system and object privileges and other roles.
  C. Roles are owned by SYSTEM.
  D. The CONNECT role is granted automatically to a user when it is created.
  E. The RESOURCE role is granted the CREATE SESSION privilege.
  A. A secure application role can be set only by its associated PL/SQL package.
  B. A role can be granted a combination of system and object privileges and other roles.

• Question 167:

  Which two statements correctly describe the relation between a data file and the logical database structures? (Choose two)

  A. An extent cannot spread across data files.
  B. A segment cannot spread across data files.
  C. A data file can belong to only one tablespace.
  D. A data file can have only one segment created in it.
  E. A data block can spread across multiple data files as it can consist of multiple operating system (OS) blocks.
  A. An extent cannot spread across data files.
  C. A data file can belong to only one tablespace.

• Question 168:

  You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance, you plan to move the data from the flat files to clustered tables in an Oracle database. While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into the Oracle database?

  A. Use the external table population.
  B. Use the Oracle Data Pump export and import utility.
  C. Use the conventional path data load of the SQL*Loader utility.
  D. Use the INSERT INTO...SELECT command to load the data.
  C. Use the conventional path data load of the SQL*Loader utility.

• Question 169:

  View the Exhibit and examine the command used to create the ZONEDATA table. The table contains a million rows for zonewise analysis in the DSS system. DML operations are performed very rarely on the table. You decide to prepare an

  index on the ZONE column to enhance the performance of the queries on the ZONE column.

  Which type of index would you select in this scenario?

  Exhibit:

  

  A. Bitmap index
  B. Reverse key index
  C. Normal BTree index
  D. Functionbased index
  A. Bitmap index

• Question 170:

  View the Exhibit and note the files available in the $ORACLE_HOME/dbs folder. The ASM instance is already running. You used the following steps to start the database instance and open the database:

  

  Which file is used to start the instance in this case? Exhibit:

  

  A. init.ora
  B. spfile.ora
  C. initorcl.ora
  D. spfile+ASM.ora
  B. spfile.ora