Oracle 1Z0-082 Online Practice Questions and Exam Preparation

Oracle 1Z0-082 Online Questions & Answers

• Question 51:

  In one of your databases, the user HR has the password HRMGR.

  You want to connect to a database instance whose listener listens on port 1531 by using this statement:

  CONNECT HR/HRMGR@orcl

  No name server is used.

  Which statement is true about ORCL?

  A. It must be the value of the SERVICE_NAMES parameter on the client side
  B. It must resolve to a valid connect descriptor in the server's tnsnames.ora file
  C. It must resolve to a valid connect descriptor in the client's tnsnames.ora file
  D. It must be the name of the database to whose instance HR wishes to connect
  E. It must be the name of the server running the database to whose instance HR wishes to connect
  C. It must resolve to a valid connect descriptor in the client's tnsnames.ora file

• Question 52:

  Which three statements are true about roles?

  A. All roles granted to a user are set on by default when the user logs in,
  B. Object privileges may not be granted to roles.
  C. The SET ROLE statement can disable one or more roles for a session.
  D. Roles must be password protected.
  E. Roles may be granted to roles.
  F. The SET ROLE statement can enable one or more roles for a session.
  B. Object privileges may not be granted to roles.
  C. The SET ROLE statement can disable one or more roles for a session.
  E. Roles may be granted to roles.

• Question 53:

  Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)

  A. Connect Time Failover requires the use of Transparent Application Failover (TAF)
  B. Source Routing requires the use of a name server
  C. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall
  D. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration
  E. Load Balancing requires the use of a name server
  F. Connect Time Failover requires the connect string to have two or more listener addresses configured
  C. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall
  D. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration
  F. Connect Time Failover requires the connect string to have two or more listener addresses configured

  ---

  Explanation/Reference:

  https://docs.oracle.com/en/database/oracle/oracle-database/12.2/rilin/shared-server-configuration-for-an-oracle-rac-database.html#GUID-2EFBA08D-FEEE-407F-BC42-E548DA946DF9

• Question 54:

  Which three tasks are performed by background processes in an Oracle database instance? (Choose three.)

  A. writing dirty database block images from the buffer cache
  B. reading database blocks into the buffer cache
  C. creating dedicated server connections
  D. writing redo to log files
  E. registering services with Oracle Net listeners
  A. writing dirty database block images from the buffer cache
  B. reading database blocks into the buffer cache
  D. writing redo to log files

• Question 55:

  Which three statements are true about table data storage in an Oracle Database? (Choose three.)

  A. Data block headers contain their own Data Block Address (DBA)
  B. A table row piece can be chained across several database blocks
  C. Multiple row pieces from the same row may be stored in different database blocks
  D. Multiple row pieces from the same row may be stored in the same block
  E. Data block free space is always contiguous in the middle of the block
  F. Index block free space is always contiguous in the middle of the block
  A. Data block headers contain their own Data Block Address (DBA)
  C. Multiple row pieces from the same row may be stored in different database blocks
  D. Multiple row pieces from the same row may be stored in the same block

  ---

  Explanation/Reference:

  Reference: https://books.google.com.pk/books?id=lNtVjrmbzckCandpg=PA267andlpg=PA267anddq=Multiple+row+pieces+from+the+same+row+may+be+stored+in+different+database +blocksandsource=blandots=lEIhFe2Q52andsig=ACfU3U1TETJPy194pARxfIJ5ROaQdySCMQandhl=enandsa=Xandved=2ahUKEwivveLa97_mAhWOzaQKHahYAVEQ6AEwAnoECAoQAQ#v=onepageandq=Multiple%20row%20pieces%20from%20the% 20same%20row%20may%20be%20stored%20in%20different%20database%20blocksandf=false/

• Question 56:

  Which three instance situations are possible with the Oracle Database server without multi-tenant? (Choose three.)

  A. two or more instances on separate servers all associated with one database
  B. one instance on one server associated with one database
  C. one instance on one server associated with two or more databases on the same server
  D. one instance on one server not associated with any database
  E. one instance on one server associated with two or more databases on separate servers
  A. two or more instances on separate servers all associated with one database
  B. one instance on one server associated with one database
  D. one instance on one server not associated with any database

  ---

  Explanation/Reference:

  A: RAC 2,3 or 4 nodes

  B: Single instance (standalone) with database

  C: one instance running multiple INDEPENDENT databases!!

  D: Single instance (standalone) without database

  E: absurd configuration!

• Question 57:

  Which two statements are true about the DUAL table? (Choose two.)

  A. It can be accessed only by the SYS user
  B. It consists of a single row and single column of VARCHAR2 data type
  C. It can display multiple rows but only a single column
  D. It can be used to display only constants or pseudo columns
  E. It can be accessed by any user who has the SELECT privilege in any schema
  F. It can display multiple rows and columns
  B. It consists of a single row and single column of VARCHAR2 data type
  F. It can display multiple rows and columns

  ---

  Explanation/Reference:

  SQL> SELECT level, sysdate 2 FROM dual 3 CONNECT BY 4 level <= 4;

  LEVEL SYSDATE

  1 06-AUG-20

  2 06-AUG-20

  3 06-AUG-20

  4 06-AUG-20

  It can return multple rows and columns.

  D is wrong, you just create a brand new user and do not grant any privilege but still it can select dual table.

  Reference: https://en.wikipedia.org/wiki/DUAL_table

• Question 58:

  Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)

  A. They can be written by server processes
  B. Trace files are written to the Fast Recovery Area (FRA)
  C. They can be written by background processes
  D. All trace files contain error information that require contacting Oracle Support
  E. Trace file names are based on the database name concatenated with a sequential number
  A. They can be written by server processes
  C. They can be written by background processes

  ---

  Explanation/Reference:

  Reference: https://gerardnico.com/db/oracle/trace_file https://docs.oracle.com/html/E25494_01/monitoring001.htm

  Each server and background process can write to an associated trace file. When an internal error is detected by a process, it dumps information about the error to its trace file. Some of the information written to a trace file is intended for the database administrator, and other information is for Oracle Support Services. Trace file information is also used to tune applications and instances.

• Question 59:

  Which two statements are true about the COUNT function? (Choose two.)

  A. COUNT (*) returns the number of rows in a table including duplicate rows and rows containing NULLs in any column.
  B. COUNT (DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULLs in the INV_AMT column.
  C. A SELECT statement using the COUNT function with a DISTINCT keyword cannot have a WHERE clause.
  D. It can only be used for NUMBER data types.
  E. COUNT (inv_amt) returns the number of rows in a table including rows with NULL in the INV_AMT column.
  A. COUNT (*) returns the number of rows in a table including duplicate rows and rows containing NULLs in any column.
  B. COUNT (DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULLs in the INV_AMT column.

• Question 60:

  Which three statements are true about Enterprise Manager Cloud Control? (Choose three.)

  A. It is available to manage a database only when that database is open.
  B. It provides management for Oracle-engineered systems.
  C. It uses a web-based console built into the Oracle database using XML DB.
  D. It is integrated with My Oracle Support.
  E. It provides management for Oracle middleware
  B. It provides management for Oracle-engineered systems.
  D. It is integrated with My Oracle Support.
  E. It provides management for Oracle middleware