Oracle 1Z0-082 Online Practice Questions and Exam Preparation

Oracle 1Z0-082 Online Questions & Answers

• Question 121:

  Which three statements are true about connection strings and service names used to connect to an Oracle database instance?

  A. A single database instance can support connections for multiple service names.
  B. A service name is created by a listener.
  C. A single connection string can refer to multiple database instances.
  D. A connection string including a service name must be defined in the cnsnames.ora file.
  E. A connection string must include the SID of a database Instance.
  F. Different connection strings in the same tnsnames.ora file can contain the same service name, host and port parameters.
  A. A single database instance can support connections for multiple service names.
  C. A single connection string can refer to multiple database instances.
  F. Different connection strings in the same tnsnames.ora file can contain the same service name, host and port parameters.

• Question 122:

  The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations.

  Each database has a tnsnames.ora file defining DALLAS_DB as a service name.

  Examine this command:

  CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING `dallas_db';

  How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?

  A. as SCOTT in DALLAS_DB
  B. as SCOTT in BOSTON_DB
  C. as SCOTT in BOSTON_DB and SYS in DALLAS_DB
  D. as SYS in both the databases
  E. as SCOTT in both the databases
  B. as SCOTT in BOSTON_DB

  ---

  Explanation/Reference:

  https://docs.oracle.com/cd/B28359_01/server.111/b28310/ds_concepts002.htm#ADMIN12 Database links are either private or public. If they are private, then only the user who created the link has access; if they are public, then all database users have access. https://docs.oracle.com/database/121/SQLRF/statements_5006.htm#SQLRF01205

• Question 123:

  Which two statements are true about Enterprise Manager (EM) Express?

  A. You can use a single instance of EM Express to manage multiple database running on the same server.
  B. EM Express uses a separate repository database to store target database metadata.
  C. By default, EM express is available for a database after database creation using DBCA.
  D. You can shut down a database instance using EM Express.
  E. You cannot start up a database instance using EM Express.
  C. By default, EM express is available for a database after database creation using DBCA.
  E. You cannot start up a database instance using EM Express.

• Question 124:

  Which three statements are true about Resumable Space Allocation in Oracle databases? (Choose three.)

  A. A user's session may be suspended and resumed multiple times.
  B. The AFTER SUSPEND event trigger can itself be suspended due to space conditions.
  C. All sessions must have the same timeout value when waiting for resumable space allocations.
  D. Resumable space allocation is only possible with locally managed tablespaces.
  E. A user's session may be suspended even if the user has the UNLTMTTED TABLESPACE system privilege.
  F. Resumable space allocation may be enabled for some sessions and not others.
  A. A user's session may be suspended and resumed multiple times.
  E. A user's session may be suspended even if the user has the UNLTMTTED TABLESPACE system privilege.
  F. Resumable space allocation may be enabled for some sessions and not others.

  ---

  Explanation/Reference:

• Question 125:

  Which two statements are true about constraints? (Choose two.)

  A. A UNIQUE constraint can use a pre-existing index on the constrained column or columns
  B. A FOREIGN KEY column can contain NULLs.
  C. A PRIMARY KEY constraint can only be added to an empty table.
  D. A column can have only one CHECK constraint.
  E. A CHECK constraint can refer to values in other rows.
  A. A UNIQUE constraint can use a pre-existing index on the constrained column or columns
  B. A FOREIGN KEY column can contain NULLs.

• Question 126:

  Which two statements are true about UNDO and UNDO tablespaces? (Choose two.)

  A. There can be only one UNDO tablespace created in a database.
  B. An instance will crash if the active undo tablespace is lost.
  C. An UNDO tablespace may be owned by only one instance.
  D. UNDO segments are owned by SYSTEM.
  E. UNDO segments are owned by SYSBACKUP.
  B. An instance will crash if the active undo tablespace is lost.
  C. An UNDO tablespace may be owned by only one instance.

  ---

  Explanation/Reference:

• Question 127:

  Examine these commands:

  

  Which two statements are true about the sqlldr execution? (Choose two.)

  A. It overwrites data in EMP with data in EMP.DAT
  B. It uses the database buffer cache to load data
  C. It generates a log that contains control file entries, which can be used with normal SQL*Loader operations
  D. It generates a sql script that it uses to load data from EMP.DAT to EMP
  E. It appends data from EMP.DAT to EMP
  C. It generates a log that contains control file entries, which can be used with normal SQL*Loader operations
  E. It appends data from EMP.DAT to EMP

  ---

  Explanation/Reference:

  C and E are correct - ..."SQL*Loader express mode generates a log file that includes a SQL*Loader control file. The log file also contains SQL scripts for creating the external table and performing the load using a SQL INSERT AS SELECT statement. Neither the control file nor the SQL scripts are used by SQL*Loader express mode. They are made available to you in case you want to use them as a starting point to perform operations using regular SQL*Loader or standalone external tables; the control file is for use with SQL*Loader, whereas the SQL scripts are for use with standalone external tables operations."

• Question 128:

  Which three statements are true about the DESCRIBE command? (Choose three.)

  A. It displays the PRIMARY KEY constraint for any column or columns that have that constraint
  B. It can be used from SQL Developer
  C. It displays the NOT NULL constraint for any columns that have that constraint
  D. It can be used to display the structure of an existing view
  E. It displays all constraints that are defined for each column
  F. It can be used only from SQL*Plus
  B. It can be used from SQL Developer
  C. It displays the NOT NULL constraint for any columns that have that constraint
  D. It can be used to display the structure of an existing view

• Question 129:

  Which three statements are true about data block storage in an Oracle Database?

  A. A block header contains a row directory pointing to all rows in the block.
  B. An index block can contain row data.
  C. Row data is stored starting at the end of the block.
  D. A data block header is of a fixed length.
  E. A table block must always contain row data.
  A. A block header contains a row directory pointing to all rows in the block.
  B. An index block can contain row data.
  C. Row data is stored starting at the end of the block.

  ---

  Explanation/Reference:

• Question 130:

  Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)

  A. External table files can be used for other external tables in a different database
  B. The ORACLE_LOADER access driver can be used to unload data from a database into an external table
  C. The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table
  D. They cannot be partitioned
  E. The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table
  F. They support UPDATEs but not INSERTs and DELETEs
  A. External table files can be used for other external tables in a different database
  C. The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table
  E. The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table

  ---

  Explanation/Reference:

  https://docs.oracle.com/cd/B19306_01/server.102/b14215/et_concepts.htm B - Incorrect The ORACLE_LOADER access driver is the default. It can perform only data loads, and the data must come from text datafiles C and E - Correct The ORACLE_DATAPUMP access driver can perform both loads and unloads. F - Incorrect https://docs.oracle.com/en/database/oracle/oracle-database/18/admin/managing-tables.html#GUID-697B86CC-875C-4F68-AF80-49B41F33AE45 You can, for example, select, join, or sort external table data. You can also create views and synonyms for external tables. However, no DML operations (UPDATE, INSERT, or DELETE) are possible, and no indexes can be created, on external tables. D - Incorrect Partitioned external tables were introduced in Oracle Database 12c Release 2 (12.2), allowing external tables to benefit from partition pruning and partition-wise. https://oracle-base.com/articles/12c/partitioned-external-tables12cr2#:~:text=Partitioned%20external%20tables%20were%20introduced,are%20supported%20with%20some%20restrictions.