Oracle Database Administration I practice questions

1. Question 1 of 25

   Select 3

   Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)

   • Awriting inbound request to the common request queue from all shared server connections
   • Bchecking for outbound shared server responses on the common outbound response queue
   • Creceiving inbound requests from processes using shared server connections
   • Dsending each connection input request to the appropriate shared server input queue
   • Ebroadcasting shared server session responses back to requesters on all connections
   • Fsending shared server session responses back to requesters on the appropriate connection

   Show answer

   Correct answer: A, C, F

   How others answered

   • ACF100%

   Explanation

   A is correct. All dispatchers are required to write incoming requests to a common response queue, which the (idle) shared server processes will monitor and pick up. B is wrong. Each dispatcher has it's own response queue. C is correct. This is the main purpose of dispatchers in a shared server architecture. D is wrong. Connection input requests are handled by the listener and, shared server processes do not have their own input queues, they monitor the common input queue. E is wrong. Shared server responses cannot be broadcasted to all connections. F is correct. Shared server responses must be sent back to the requester on it's own connection. Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/application-and-networking-architecture.html#GUID-EC8F8778-02B7-4CF9-9E6F-A5D88C777235

   Adapted from community discussion by Franky_T · 2023-04-12 · 7 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   View community discussion4

   Candidate context

   Question 1 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-082 or CertExamHQ.

   1. F

      Franky_T

      2023-04-12

      Selected A, C, F7 upvotes

      A is correct. All dispatchers are required to write incoming requests to a common response queue, which the (idle) shared server processes will monitor and pick up. B is wrong. Each dispatcher has it's own response queue. C is correct. This is the main purpose of dispatchers in a shared server architecture. D is wrong. Connection input requests are handled by the listener and, shared server processes do not have their own input queues, they monitor the common input queue. E is wrong. Shared server responses cannot be broadcasted to all connections. F is correct. Shared server responses must be sent back to the requester on it's own connection. Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/application-and-networking-architecture.html#GUID-EC8F8778-02B7-4CF9-9E6F-A5D88C777235

   2. N

      nautil2

      2024-09-13

      Selected A, C, F5 upvotes

      see https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-processes.html#GUID-A522BFBF-5452-4038-92DB-C5116A0B1B50 A - TRUE; All dispatchers are required to write incoming requests to a common response queue, which the (idle) shared server processes will monitor and pick up. B - FALSE; Each dispatcher has its own response queue. C - TRUE; This is the main purpose of dispatchers in a shared server architecture. D - FALSE; Connection input requests are handled by the listener and, shared server processes do not have their own input queues, they monitor the common input queue. E - FALSE; Shared server responses cannot be broadcasted to all connections. F - TRUE; Shared server responses must be sent back to the requester on its own connection.

   3. N

      NiciMilo

      2021-08-09

      8 upvotes

      i think A, C and F D is wrong Ref: https://docs.oracle.com/cd/B28359_01/server.111/b28310/manproc001.htm#ADMIN11168 An ***idle shared server process picks up*** the virtual circuit from the common queue

   4. G

      Guhborges

      2024-03-25

      1 upvote

      C,D,F In a shared server configuration, dispatchers are responsible for managing incoming requests and outgoing responses. When a user connects to the database using a shared server configuration, the dispatcher receives the user's request and places it in the common request queue. The dispatcher then selects an available shared server and assigns the request to it by placing it in the appropriate shared server input queue. The shared server then processes the request and generates a response, which is placed in the appropriate outbound response queue. The dispatcher checks for outbound shared server responses on the common outbound response queue and sends the response back to the requester on the appropriate connection.

2. Question 2 of 25

   Select 3

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

   • AAn index block can contain row data.
   • BA data block header is of a fixed length.
   • CRow data is stored starting at the end of the block.
   • DA table block must always contain row data.
   • EA block header contains a row directory pointing to all rows in the block.

   Show answer

   Correct answer: A, C, E

   How others answered

   • ACE67%
   • BCE33%

   Only 67% agreed on this answer — treat it as contested rather than settled.

   Explanation

   A. An index block can contain row data. --> True. ref: https://docs.oracle.com/cd/A57673_01/DOC/server/doc/SCN73/ch3.htm B. A data block header is of a fixed length. --> False. ref: https://www.dba-oracle.com/t_data_block_format.htm C. Row data is stored starting at the end of the block. --> True. ref: https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/logical-storage-structures.html D. A table block must always contain row data. --> False. ref: https://richardfoote.wordpress.com/category/block-dumps/ E. A block header contains a row directory pointing to all rows in the block. --> True. ref: https://medium.com/geekculture/explain-about-oracle-database-data-block-interview-a-be137c52fe4d

   Adapted from community discussion by auwia · 2024-07-13 · 6 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Oracle documentation
   • Oracle documentation

   View community discussion4

   Candidate context

   Question 2 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-082 or CertExamHQ.

   1. A

      auwia

      2024-07-13

      Selected A, C, E6 upvotes

      A. An index block can contain row data. --> True. ref: https://docs.oracle.com/cd/A57673_01/DOC/server/doc/SCN73/ch3.htm B. A data block header is of a fixed length. --> False. ref: https://www.dba-oracle.com/t_data_block_format.htm C. Row data is stored starting at the end of the block. --> True. ref: https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/logical-storage-structures.html D. A table block must always contain row data. --> False. ref: https://richardfoote.wordpress.com/category/block-dumps/ E. A block header contains a row directory pointing to all rows in the block. --> True. ref: https://medium.com/geekculture/explain-about-oracle-database-data-block-interview-a-be137c52fe4d

   2. A

      auwia

      2024-07-13

      1 upvote

      A. An index block can contain row data. --> True, "Row Data" portion : This portion of the block contains table or index data. B. A data block header is of a fixed length. --> False, the header of a data block has two areas a "common" area and a "variable" area. In the common area you have a fixed-size block header. ==> But it's different to say, I guess. C. Row data is stored starting at the end of the block. --> True, "Space Management in Data Blocks" -> As the database fills a data block from the bottom up, the amount of free space between the row data and the block header decreases. D. A table block must always contain row data. --> False, it also contains info about tab and col: If we look at a partial block dump of one of the table blocks. E. A block header contains a row directory pointing to all rows in the block. --> True, a block header includes the information about block type information, whether it is a row block or an index block, and the information of tables that have the rows in it, and the row directory, means the addresses of each row in this block.

   3. Z

      zouve

      2024-08-22

      2 upvotes

      Header (Common and Variable) The header contains general block information, such as the block address and the type of segment; for example, data, index, or rollback. While some block overhead is fixed in size, the total block overhead size is variable. On average, the fixed and variable portions of data block overhead total 84 to 107 bytes.

   4. A

      auwia

      2024-07-13

      1 upvote

      I'm sorry I was wrong. please remove this full comment with vote.

3. Question 3 of 25

   Select 3

   Which three statements are true about indexes and their administration in an Oracle database? (Choose three.)

   • AAn index can be created as part of a CREATE TABLE statement.
   • BIf a query filters on an indexed column, then it will always be used during execution of the query.
   • CA descending index is a type of function-based index.
   • DA DROP INDEX statement always prevents updates to the table during the drop operation.
   • EA UNIQUE and non-unique index can be created on the same table column.
   • FAn INVINSIBLE INDEX is not maintained when Data Manipulation Language (DML) is performed on its underlying table.

   Show answer

   Correct answer: A, C, E

   How others answered

   • ACE83%
   • ABC17%

   Explanation

   A- CREATE TABLE Books( ID NUMBER PRIMARY KEY USING INDEX (CREATE INDEX idx_custom_books_id ON books (ID)), Title VARCHAR2(100) NOT NULL, Author VARCHAR2(100) NOT NULL, PublishYear NUMBER NOT NULL ); C- "Oracle Database treats descending indexes as if they were function-based indexes" https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-INDEX.html#GUID-1F89BBC0-825F-4215-AF71-7588E31D8BFE__GUID-92F4F0FB-499A-4ED7-8630-B219F8A50B90 E- "When you have multiple indexes on the same set of columns, only one of these indexes can be visible at a time, and any other indexes must be invisible." "You can create multiple indexes on the same set of columns when at least one of the following index characteristics is different: The indexes have different uniqueness properties. You can create both a unique and a non-unique index on the same set of columns." https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-indexes.html#GUID-B4B30CF4-2B95-44D6-8596-EC2A378251EF Correct is ACE, according the above evidences.

   Adapted from community discussion by piontk · 2023-08-07 · 2 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Oracle documentation
   • Oracle documentation

   View community discussion4

   Candidate context

   Question 3 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-082 or CertExamHQ.

   1. P

      piontk

      2023-08-07

      Selected A, C, E2 upvotes

      A- CREATE TABLE Books( ID NUMBER PRIMARY KEY USING INDEX (CREATE INDEX idx_custom_books_id ON books (ID)), Title VARCHAR2(100) NOT NULL, Author VARCHAR2(100) NOT NULL, PublishYear NUMBER NOT NULL ); C- "Oracle Database treats descending indexes as if they were function-based indexes" https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-INDEX.html#GUID-1F89BBC0-825F-4215-AF71-7588E31D8BFE__GUID-92F4F0FB-499A-4ED7-8630-B219F8A50B90 E- "When you have multiple indexes on the same set of columns, only one of these indexes can be visible at a time, and any other indexes must be invisible." "You can create multiple indexes on the same set of columns when at least one of the following index characteristics is different: The indexes have different uniqueness properties. You can create both a unique and a non-unique index on the same set of columns." https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-indexes.html#GUID-B4B30CF4-2B95-44D6-8596-EC2A378251EF Correct is ACE, according the above evidences.

   2. I

      ivanadj

      2023-02-20

      Selected A, C, E2 upvotes

      https://www.examtopics.com/discussions/oracle/view/9439-exam-1z0-071-topic-1-question-300-discussion/

   3. A

      auwia

      2023-07-06

      1 upvote

      E is false: -- Create table CREATE TABLE test_table ( id NUMBER, value VARCHAR2(255) ); -- Populate the table INSERT INTO test_table (id, value) VALUES (1, 'One'); INSERT INTO test_table (id, value) VALUES (2, 'Two'); COMMIT; -- Create a unique index CREATE UNIQUE INDEX test_table_uniq_idx ON test_table(id); -- Create a non-unique index CREATE INDEX test_table_idx ON test_table(id); ORA-01408: such column list already indexed

   4. S

      sobrinho

      2024-04-23

      1 upvote

      C is correct: SQL> create table t1 (col1 number, col2 varchar2(10), col3 varchar2(10)); Table created. Elapsed: 00:00:00.03 SQL> create unique index ix1 on t1(col1); Index created. Elapsed: 00:00:00.02 SQL> create index ix2 on t1(col1, col2); Index created. Elapsed: 00:00:00.01 SQL> create unique index ix3 on t1(col1, col2, col3); Index created. Elapsed: 00:00:00.02 SQL>

4. Question 4 of 25

   Select 2

   DATADIR1 and DATATDIR2 are database directory objects. Examine this command:

   

   Which two statements are true about the expdp operation? (Choose two.)

   • AIt fails if the total size of the dump file is more than 2GB.
   • BIt starts only when four worker processes are available.
   • CIt creates a master table to store details of the export operation.
   • DIt creates dump files for the entire database.
   • EIt creates dump files only for objects in the SYSTEM schema.

   Show answer

   Correct answer: C, D

   How others answered

   • CD75%
   • BC25%

   Explanation

   D is correct: "You can use Data Pump to carry out a full database export by using the FULL parameter. In a full database export, the ENTIRE DATABASE is unloaded. This mode requires that you have the DATAPUMP_EXP_FULL_DATABASE role." https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/oracle-data-pump- export-utility.html#GUID-079769D8-40F4-432F-88AD-E7264D7A2E2D

   Adapted from community discussion by sobrinho · 2024-04-24 · 2 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   View community discussion4

   Candidate context

   Question 4 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-082 or CertExamHQ.

   1. I

      it6567306

      2024-05-06

      1 upvote

      Example 2-6 Parallel Full Export > expdp hr FULL=YES DUMPFILE=dpump_dir1:full1%U.dmp, dpump_dir2:full2%U.dmp FILESIZE=2G PARALLEL=3 LOGFILE=dpump_dir1:expfull.log JOB_NAME=expfull -- Because this is a full database export, all data and metadata in the database is exported. Dump files named full101.dmp, full201.dmp, full102.dmp, and so on are created in a round-robin fashion in the directories pointed to by the dpump_dir1 and dpump_dir2 directory objects. For best performance, Oracle recommends that you place dump files on separate I/O channels. Each file is up to 2 gigabytes in size. Initially, up to three files are created. More files are created as needed. The job and master table have a name of expfull. The log file is written to expfull.log in the dpump_dir1 directory.

   2. I

      it6567306

      2024-05-06

      1 upvote

      Reason for determining that option B is incorrect: The PARALLEL=4 option specifies the parallel processing setting used in the Data Pump Export utility (expdp). This option sets the maximum number of active execution processes used for the export job. In the command provided in the question, PARALLEL=4 is specified. This instructs Data Pump to attempt to use a maximum of 4 parallel processes (a combination of worker processes and parallel I/O server processes) to perform the export. However, this does not guarantee that 4 processes will be used. The actual number of processes used depends on available system resources and other constraints.

   3. S

      sobrinho

      2024-04-24

      2 upvotes

      D is correct: "You can use Data Pump to carry out a full database export by using the FULL parameter. In a full database export, the ENTIRE DATABASE is unloaded. This mode requires that you have the DATAPUMP_EXP_FULL_DATABASE role." https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/oracle-data-pump- export-utility.html#GUID-079769D8-40F4-432F-88AD-E7264D7A2E2D

   4. I

      it6567306

      2024-05-06

      1 upvote

      According to the Oracle official reference, when PARALLEL=4 is specified, the behavior is as follows: 1. Data Pump attempts to use a maximum of 4 parallel processes (worker processes and parallel I/O server processes) to perform the export. 2. The actual number of processes used depends on system resources and other constraints. 3. Even if 4 processes are not available, the job starts with the number of processes that are available. 4. During job execution, the value of PARALLEL can be increased or decreased using interactive mode commands.

5. Question 5 of 25

   Select 4

   Which four account management capabilities can be configured using Oracle profiles? (Choose four.)

   • Athe number of hours for which an account is locked after the configured number of login attempts has been reached
   • Bthe number of days for which an account may be inactive before it is locked
   • Cthe maximum amount of CPU time allowed for a user's sessions before their account is locked
   • Dthe ability to prevent a password from ever being reused
   • Ethe number of password changes required within a period of time before a password can be reused
   • Fthe number of days for which an account is locked after the configured number of login attempts has been reached
   • Gthe maximum number of sessions permitted for a user before the account is locked

   Show answer

   Correct answer: B, D, E, F

   How others answered

   • BDEF56%
   • ABDE25%

   Only 56% agreed on this answer — treat it as contested rather than settled.

   Explanation

   A D E F A. the number of hours for which an account is locked after the configured number of login attempts has been reached -- [it accepts in days,you can enter fraction of days to achieve hours]. B. the number of days for which an account may be inactive before it is locked [Inactive is not a state for an account] C. the maximum amount of CPU time allowed for a user's sessions before their account is locked [account never get locked in such settings] D. the ability to prevent a password from ever being reused [PASSWORD_REUSE_MAX] E. the number of password changes required within a period of time before a password can be reused [PASSWORD_REUSE_TIME] F. the number of days for which an account is locked after the configured number of login attempts has been reached [PASSWORD_LOCK_TIME] G. the maximum number of sessions permitted for a user before the account is locked [account never get locked in such settings]

   Adapted from community discussion by avanand · 2020-08-22 · 12 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   View community discussion4

   Candidate context

   Question 5 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-082 or CertExamHQ.

   1. N

      NowOrNever

      2020-09-23

      14 upvotes

      Correct Answer: ABEF Wrong Answer: CDG A: 1/24 is one hour, 1/96 is 15 minutes B: INACTIVE_ACCOUNT_TIME C: the account will not be locked, it can not exceed this limit D: not possible so far E: PASSWORD_REUSE_MAX - defines the number of changes required before a password can be reused PASSWORD_REUSE_TIME - Sets the number of days before which a password cannot be reused. F: PASSWORD_LOCK_TIME G: the account will not be locked, it can not exceed this limit

   2. A

      avanand

      2020-08-22

      12 upvotes

      A D E F A. the number of hours for which an account is locked after the configured number of login attempts has been reached -- [it accepts in days,you can enter fraction of days to achieve hours]. B. the number of days for which an account may be inactive before it is locked [Inactive is not a state for an account] C. the maximum amount of CPU time allowed for a user's sessions before their account is locked [account never get locked in such settings] D. the ability to prevent a password from ever being reused [PASSWORD_REUSE_MAX] E. the number of password changes required within a period of time before a password can be reused [PASSWORD_REUSE_TIME] F. the number of days for which an account is locked after the configured number of login attempts has been reached [PASSWORD_LOCK_TIME] G. the maximum number of sessions permitted for a user before the account is locked [account never get locked in such settings]

   3. S

      SimoneF

      2020-12-09

      8 upvotes

      I would say instead that E is wrong, since it doesn't define "the number of password changes required within a period of time" but the time that has to pass before reusing the same password. For this and what you all said before, I would go with A-B-D-F

   4. S

      SimoneF

      2020-12-09

      5 upvotes

      But for D, there is this, speaking about PASSWORD_REUSE_MAX and PASSWORD_REUSE_TIME: "If you specify a value for either of these parameters and specify UNLIMITED for the other, then the user can never reuse a password." source: https://docs.oracle.com/database/121/SQLRF/statements_6012.htm#SQLRF01310

6. Question 6 of 25

   You want to use table compression suitable for OLTP that will: 1. Compress rows for all DML statements on that table 2. Minimize the overheads associated with compression Which compression option is best suited for this?

   • ACOLUMN STORE COMPRESS FOR QUERY LOW
   • BROW STORE COMPRESS BASIC
   • CCOLUMN STORE COMPRESS FOR ARCHIVE LOW
   • DCOLUMN STORE COMPRESS FOR ARCHIVE HIGH
   • EROW STORE COMPRESS ADVANCED

   Show answer

   Correct answer: E

   How others answered

   • E100%

   Explanation

   https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-TABLE.html#GUID-F9CE0CC3-13AE-4744-A43C-EAC7A71AAAB6 When you enable table compression by specifying ROW STORE COMPRESS ADVANCED, you enable Advanced Row Compression. Oracle Database compresses data during all DML operations on the table. This form of compression is recommended for OLTP environments.

   Adapted from community discussion by nautil2 · 2023-09-19 · 2 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Oracle documentation
   • Oracle documentation

   View community discussion4

   Candidate context

   Question 6 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-082 or CertExamHQ.

   1. A

      avanand

      2020-08-22

      11 upvotes

      E is correct https://docs.oracle.com/database/121/ADMIN/tables.htm#ADMIN-GUID-34D15DD1-0925-4C9A-BE8A-3EE91671E526

   2. N

      nautil2

      2023-09-19

      Selected E2 upvotes

      https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-TABLE.html#GUID-F9CE0CC3-13AE-4744-A43C-EAC7A71AAAB6 When you enable table compression by specifying ROW STORE COMPRESS ADVANCED, you enable Advanced Row Compression. Oracle Database compresses data during all DML operations on the table. This form of compression is recommended for OLTP environments.

   3. C

      cseko76

      2024-10-27

      1 upvote

      my answer: E -> compress rows for all DML statementsc+ lower overheads than Hybrid Columnar Compression the others: B. ROW STORE COMPRESS BASIC: false, not works for all DML statements, e.g. updated rows are not compressed A, C, D: false due to higher overheads

   4. V

      valiantvimal

      2024-04-26

      1 upvote

      E option is right: “ROW STORE COMPRESS ADVANCED”. See the example below: CREATE TABLE emp (emp_id NUMBER, first_name VARCHAR2(128), last_name VARCHAR2(128)) ROW STORE COMPRESS ADVANCED;

7. Question 7 of 25

   Select 3

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

   • AConnect Time Failover requires the use of Transparent Application Failover (TAF)
   • BSource Routing requires the use of a name server
   • CSource Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall
   • DLoad Balancing can balance the number of connections to dispatchers when using a Shared Server configuration
   • ELoad Balancing requires the use of a name server
   • FConnect Time Failover requires the connect string to have two or more listener addresses configured

   Show answer

   Correct answer: C, D, F

   How others answered

   • CDF100%

   Explanation

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

   Adapted from community discussion by auwia · 2023-07-04 · 2 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Oracle documentation
   • Oracle documentation

   View community discussion4

   Candidate context

   Question 7 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-082 or CertExamHQ.

   1. A

      ama

      2020-07-15

      6 upvotes

      A is wrong… Connect-Time Failover is a feature of local naming method, and can be easily set up by adding a tns entry into tnsnames. ora file on the client machine, then the client can connect to the second database (listener) if the first database (listener) cannot be connected

   2. A

      auwia

      2023-07-04

      Selected C, D, F2 upvotes

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

   3. D

      dinati7315

      2024-07-15

      1 upvote

      A. Connect Time Failover requires the use of Transparent Application Failover (TAF): Connect Time Failover allows Oracle Net to automatically fail over to another Oracle Database instance if the initial connection attempt fails. TAF enhances this feature by preserving the client-side session state during a failover. D. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration: Load Balancing in Oracle Net distributes connection requests across multiple dispatchers to optimize resource utilization in a Shared Server (or MTS) configuration. F. Connect Time Failover requires the connect string to have two or more listener addresses configured: Connect Time Failover requires multiple listener addresses specified in the connect string to provide failover capability. If one listener is unavailable, Oracle Net attempts to connect to the next listener in the list. https://bitly.cx/ExamsTopics

   4. A

      ama

      2020-07-15

      3 upvotes

      D seems a legit answer.. 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

8. Question 8 of 25

   Select 2

   You execute this command:

   

   During the export operation, you detach from the job by using CTRL+C and then execute this command: Export> STOP_JOB=immediate - Are you sure you wish to stop the job ([yes]/no): yes Which two statements are true about the job? (Choose two.)

   • AYou can no longer monitor it
   • BYou can reattach to it and monitor it
   • CIt is paused and can be resumed
   • DIt continues to run in the background
   • EIt terminates

   Show answer

   Correct answer: B, C

   How others answered

   • BC71%
   • AE29%

   Only 71% agreed on this answer — treat it as contested rather than settled.

   Explanation

   A. You can no longer monitor it -- Semi-wrong, can be monitored if reattached. B. You can reattach to it and monitor it -- Correct, STOP_JOB can be reattached and monitored C. It is paused and can be resumed -- Correct, As per doc it can be resumed but some tasks may have to restarted. D. It continues to run in the background -- Wrong, The job is stopped E. It terminates -- Wrong, Terminates with KILL_JOB not STOP_JOB B and C seems to be the most correct https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/oracle-data-pump-export-utility.html#GUID-1A2BF459-680D-4D2B-B35F-9A3F4EE72530

   Adapted from community discussion by musafir · 2023-07-22 · 2 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Oracle documentation
   • Oracle documentation

   View community discussion4

   Candidate context

   Question 8 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-082 or CertExamHQ.

   1. Y

      you1234

      2020-07-18

      9 upvotes

      B & C is correct. see the example which is done on 12c version B. You can reattach to it and monitor it C. It is paused and can be resumed

   2. N

      nautil2

      2023-10-02

      Selected B, C1 upvote

      A - FALSE; the job can be attached and restarted at a later time with the START_JOB command. A KILL_JOB command performs non-reversible termination of the job. B - TRUE; see A C - TRUE; see A D - FALSE; it is completely stopped E - FALSE; it is stopped, but not terminated. A KILL_JOB command terminates the job. Release 19, Utilities; Part I Oracle Data Pump; 2.5.11 STOP_JOB; If the Data Pump control job table and dump file set are not disturbed when or after the STOP_JOB command is issued, then the job can be attached to and restarted at a later time with the START_JOB command. To perform an immediate shutdown, specify STOP_JOB=IMMEDIATE. A warning requiring confirmation will be issued. All attached clients, including the one issuing the STOP_JOB command, receive a warning that the job is being stopped by the current user and they will be detached. After all clients are detached, the process structure of the job is immediately run down. That is, the Data Pump control job process will not wait for the child processes to finish their current tasks.

   3. M

      musafir

      2023-07-22

      Selected B, C2 upvotes

      A. You can no longer monitor it -- Semi-wrong, can be monitored if reattached. B. You can reattach to it and monitor it -- Correct, STOP_JOB can be reattached and monitored C. It is paused and can be resumed -- Correct, As per doc it can be resumed but some tasks may have to restarted. D. It continues to run in the background -- Wrong, The job is stopped E. It terminates -- Wrong, Terminates with KILL_JOB not STOP_JOB B and C seems to be the most correct https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/oracle-data-pump-export-utility.html#GUID-1A2BF459-680D-4D2B-B35F-9A3F4EE72530

   4. Y

      you1234

      2020-07-24

      3 upvotes

      A is wrong because you can still be monitor & see the status of Job via attach= correct is B & C.

9. Question 9 of 25

   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?

   • Aas SCOTT in DALLAS_DB
   • Bas SCOTT in BOSTON_DB
   • Cas SCOTT in BOSTON_DB and SYS in DALLAS_DB
   • Das SYS in both the databases
   • Eas SCOTT in both the databases

   Show answer

   Correct answer: B

   How others answered

   • B100%

   Explanation

   B https://docs.oracle.com/cd/B28359_01/server.111/b28310/ds_concepts002.htm#ADMIN12085 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

   Adapted from community discussion by NowOrNever · 2021-07-25 · 15 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Oracle documentation
   • Oracle documentation

   View community discussion4

   Candidate context

   Question 9 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-082 or CertExamHQ.

   1. N

      NowOrNever

      2021-07-25

      15 upvotes

      B https://docs.oracle.com/cd/B28359_01/server.111/b28310/ds_concepts002.htm#ADMIN12085 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

   2. F

      Franky_T

      2023-04-22

      Selected B2 upvotes

      Firstly, there is no reference to Scott's permissions, so we have to assume that Scott has the ability to create the DB Link. A is wrong. DALLAS_DB is the target, so the link has to be created from the source which is BOSTON_DB. B is correct. Source and target is correct and this has to be a private link only accessible to Scott. C is wrong. This link is one-directional and only needs to be done from BOSTON_DB. D is wrong. DB Links created by SYS becomes publicly available, we only want Scott to access this link. E is wrong. Just silly, we don't need a DB Link from a database to itself.

   3. N

      nautil2

      2024-10-05

      Selected B1 upvote

      A - FALSE; source database is BOSTON_DB, in that db the database link must be created B - TRUE; source database is BOSTON_DB and owner is SCOTT => private database link is created C - FALSE; correct private dblink is created, but also SYS in DALLAS_DB can access to SCOTT schema D - FALSE; both db links are accessible only to SYS users in both databases E - FALSE; both SCOTT in BOSTON_DB and SCOTT in DALLAS_DB can access SCOTT schema in DALLAS_DB

   4. S

      SimoneF

      2021-12-13

      2 upvotes

      But if you create the DBLINK as SYS schema, SCOTT cannot access it. I think the question is not about the privileges of the schema, which is more in a hypothetical situation where the privilege is there, while rather on the functioning of dblinks.

10. Question 10 of 25

    Select 3

    Which three are types of segments in an Oracle Database? (Choose three.)

    • Aundo
    • Bindex
    • Cstored procedures
    • Dsequences
    • Etables
    • Fclusters

    Show answer

    Correct answer: A, B, E

    How others answered

    • ABE57%
    • BEF43%

    Only 57% agreed on this answer — treat it as contested rather than settled.

    Explanation

    1.User Segments -Table, table partition, or table cluster -LOB or LOB partition -Index or index partition 2.Temporary Segments 3.Undo Segments Ref: https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/logical-storage-structures.html#GUID-7DA83E64-9FF1-45A7-A9AC-D4997DDE0866 A B E F should be correct??

    Adapted from community discussion by ogdru · 2021-03-16 · 12 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 10 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-082 or CertExamHQ.

    1. O

       ogdru

       2021-03-16

       12 upvotes

       1.User Segments -Table, table partition, or table cluster -LOB or LOB partition -Index or index partition 2.Temporary Segments 3.Undo Segments Ref: https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/logical-storage-structures.html#GUID-7DA83E64-9FF1-45A7-A9AC-D4997DDE0866 A B E F should be correct??

    2. N

       NowOrNever

       2020-09-24

       7 upvotes

       BEF https://docs.oracle.com/en/database/oracle/oracle-database/18/refrn/DBA_SEGMENTS.html#GUID-7BF4F8C7-1917-4532-B048-C044E17A1754

    3. F

       Franky_T

       2022-04-24

       4 upvotes

       Again a question with four possible answers and not three. select the distinct segment_type from dba_segments to get a list of all the segment types. A is correct. B is correct. C is wrong. D is wrong. E is correct. F is correct. https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/DBA_SEGMENTS.html#GUID-7BF4F8C7-1917-4532-B048-C044E17A1754

    4. A

       adoptc94

       2020-08-31

       4 upvotes

       A is also correct Taken from the Oracle Administrators Workshop Study Guide: The different types of segments include: - Table and cluster - Index - Undo - Temporary

11. Question 11 of 25

    Select 2

    Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)

    • ACURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
    • BSYSDATE can be queried only from the DUAL table
    • CCURRENT_DATE returns the current date and time as per the session time zone
    • DSYSDATE can be used in expressions only if the default date format is DD-MON-RR
    • ESYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server
    • FCURRENT_TIMESTAMP returns the same date as CURRENT_DATE

    Show answer

    Correct answer: C, F

    How others answered

    • CF100%

    Explanation

    I think A and C are correct. SQL> ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS'; SQL> select sysdate,current_date,current_timestamp from dual; SYSDATE CURRENT_DATE CURRENT_TIMESTAMP -------------------- -------------------- --------------------------------------------------------------------------- 28-SEP-2021 14:32:48 28-SEP-2021 14:32:48 28-SEP-21 02.32.48.201457 PM +03:00 https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions172.htm https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions036.htm https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions037.htm

    Adapted from community discussion by eyildiz · 2021-09-28 · 3 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 11 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-082 or CertExamHQ.

    1. N

       nautil2

       2024-09-20

       Selected C, F2 upvotes

       A - false; it is the same only in case database server operating system uses the same time zone as the operating system of the database client (session time zone) B - false; can be queried in any table, e.g. SELECT emp_no,ename,salary,mgr_no,sysdate FROM emp; C - true; SQL> select sys_extract_utc(systimestamp) from dual; SYS_EXTRACT_UTC(SYSTIMESTAMP) --------------------------------------------------------------------------- 11.09.23 13:58:24,316896 SQL> SELECT SESSIONTIMEZONE FROM DUAL; SESSIONTIMEZONE --------------------------------------------------------------------------- +02:00 SQL> SELECT current_date FROM dual; CURRENT_DATE -------------------- 11-SEP-2023 15:58:41 D - false; sysdate can be used independently of the setting of the NLS_DATE_FORMAT E - false; sydate returns date and time of the operating system of the database server, current_date returns date and time in the session time zone (i.e. in the time zone of the client) F - true; both variables returns current time and date set in the session time zone

    2. C

       chandanchoudhary

       2023-05-30

       3 upvotes

       C & F are correct SQL> SQL> SELECT sessiontimezone FROM DUAL; SESSIONTIMEZONE --------------------------------------------------------------------------- +10:00 SQL> select current_date from dual; CURRENT_DATE ----------------------------- 31-MAY-2023 02:24:46 SQL> select CURRENT_TIMESTAMP from dual; CURRENT_TIMESTAMP --------------------------------------------------------------------------- 31-MAY-23 02.25.10.789980 AM +10:00 SQL> select SYSDATE from dual; SYSDATE ----------------------------- 30-MAY-2023 22:25:23 SQL> select CURRENT_DATE from dual; CURRENT_DATE ----------------------------- 31-MAY-2023 02:25:41 SQL> select CURRENT_TIMESTAMP from dual; CURRENT_TIMESTAMP --------------------------------------------------------------------------- 31-MAY-23 02.25.58.563965 AM +10:00 SQL> select sysdate from v$database; SYSDATE ----------------------------- 30-MAY-2023 22:26:58 SQL>

    3. E

       eyildiz

       2021-09-28

       3 upvotes

       I think A and C are correct. SQL> ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS'; SQL> select sysdate,current_date,current_timestamp from dual; SYSDATE CURRENT_DATE CURRENT_TIMESTAMP -------------------- -------------------- --------------------------------------------------------------------------- 28-SEP-2021 14:32:48 28-SEP-2021 14:32:48 28-SEP-21 02.32.48.201457 PM +03:00 https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions172.htm https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions036.htm https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions037.htm

    4. A

       Aramazd

       2022-04-06

       1 upvote

       F cannot be correct: [oracle@localhost ~]$ cat date_format.sql alter session set NLS_DATE_FORMAT is set to 'DD-MON-YYYY HH24:MI:SS' ; select current_timestamp from dual ; select current_date from dual ; [oracle@localhost ~]$ sqlplus system/oracle @date_format.sql SQL*Plus: Release 19.0.0.0.0 - Production on Wed Apr 6 04:39:17 2022 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Last Successful login time: Wed Apr 06 2022 04:38:02 -04:00 Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 alter session set NLS_DATE_FORMAT is set to 'DD-MON-YYYY HH24:MI:SS' * ERROR at line 1: ORA-00927: missing equal sign CURRENT_TIMESTAMP --------------------------------------------------------------------------- 06-APR-22 04.39.18.153607 AM -04:00 CURRENT_D --------- 06-APR-22

12. Question 12 of 25

    Select 3

    Which three statements are true about the Oracle Data Dictionary? (Choose three.)

    • AData dictionary views are created by joins of dictionary base tables and DBA-defined tables
    • BThe data dictionary is created and maintained by the database administrator
    • CViews with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary
    • DBase tables can be queried directly
    • EIt is owned by the SYSTEM user
    • FUsernames of all users including database administrators are stored in the data dictionary

    Show answer

    Correct answer: C, D, F

    How others answered

    • CDF100%

    Explanation

    A is wrong. "DBA_defined tables" does not fit here. Dictionary views are based on system base tables only. B is wrong. Internally created and managed by the Oracle server. C is correct. They all have to reference the same base tables, they only display filtered rowsets from these tables. D is correct. You can query these tables, however not recommended as data is stored in a cryptic format. Consider logging in as the SYS user, since you "own" the tables you can select from them. And as DBA you can grant select on any table in any schema to any user. This is a permission (ownership) issue and not a data format issue. E is wrong. Owned by the SYS user, stored in the SYSTEM tablespace. F is correct. All user's usernames are stored in the dictionary and are queries via DBA_USERS.

    Adapted from community discussion by Franky_T · 2023-04-25 · 3 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 12 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-082 or CertExamHQ.

    1. N

       NowOrNever

       2021-09-24

       11 upvotes

       CDF - correct https://docs.oracle.com/cd/B28359_01/server.111/b28318/datadict.htm#CNCPT1210 SYS, Owner of the Data Dictionary

    2. F

       Franky_T

       2023-04-25

       Selected C, D, F3 upvotes

       A is wrong. "DBA_defined tables" does not fit here. Dictionary views are based on system base tables only. B is wrong. Internally created and managed by the Oracle server. C is correct. They all have to reference the same base tables, they only display filtered rowsets from these tables. D is correct. You can query these tables, however not recommended as data is stored in a cryptic format. Consider logging in as the SYS user, since you "own" the tables you can select from them. And as DBA you can grant select on any table in any schema to any user. This is a permission (ownership) issue and not a data format issue. E is wrong. Owned by the SYS user, stored in the SYSTEM tablespace. F is correct. All user's usernames are stored in the dictionary and are queries via DBA_USERS.

    3. N

       nautil2

       2024-10-13

       Selected C, D, F1 upvote

       A - false; data dictionary views are based only on dictionary base tables, not on DBA-defined tables B - false; data dictionary is created and maintained by the Oracle database server C - true; Oracle Database Workshop: "Generally, each view is a subset of the higher-privileged view set, row-wise and column wise." D - true; SELECT * FROM dual; or SELECT * FROM ts$; E - false; owner is SYS, tablespace is SYSTEM F - true; usernames are stored in USER$ base table, they are accessible typically with DBA_USERS dictionary view

    4. G

       Guhborges

       2022-09-30

       1 upvote

       GUYS, the correcly answer are ACDF A- User-Accessible Views The views that summarize and display the information stored in the base tables of the data dictionary. These views decode the base table data into useful information, such as user or table names, using joins and WHERE clauses to simplify the information. Most users are given access to the views rather than the base tables. https://docs.oracle.com/cd/B19306_01/server.102/b14220/datadict.htm

13. Question 13 of 25

    In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties: 1. A size of 100 MB 2. AUTOEXTEND is off 3. UNDO_RETENTION is set to 15 minutes 4. It has RETENTION GUARANTEE UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens. What will happen when the next update is attempted by any transaction?

    • AIt succeeds and the generated undo is stored in SYSTEM.
    • BIt fails and returns the error message ג€ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'ג€.
    • CIt succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.
    • DIt succeeds and the generated undo is stored in SYSAUX.
    • EIt succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.

    Show answer

    Correct answer: B

    How others answered

    • B100%

    Explanation

    Its a tricky question. To me answer should be C. The undo_retention parameter is ignored for a fixed size undo tablespace. The database may overwrite unexpired undo information when tablespace space becomes low. Go to this link and search this: "The following points explain the exact impact of the UNDO_RETENTION parameter on undo retention" https://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm

    Adapted from community discussion by avanand · 2020-08-22 · 6 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 13 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-082 or CertExamHQ.

    1. F

       fgdgdfg

       2020-08-12

       7 upvotes

       B. To guarantee the success of long-running queries or Oracle Flashback operations, you can enable retention guarantee. If retention guarantee is enabled, the specified minimum undo retention is guaranteed; the database never overwrites unexpired undo data even if it means that transactions fail due to lack of space in the undo tablespace. If retention guarantee is not enabled, the database can overwrite unexpired undo when space is low, thus lowering the undo retention for the system. This option is disabled by default.

    2. A

       avanand

       2020-08-22

       6 upvotes

       Its a tricky question. To me answer should be C. The undo_retention parameter is ignored for a fixed size undo tablespace. The database may overwrite unexpired undo information when tablespace space becomes low. Go to this link and search this: "The following points explain the exact impact of the UNDO_RETENTION parameter on undo retention" https://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm

    3. A

       adoptc94

       2020-09-01

       4 upvotes

       Please ignore my previous comment, I was just confused at that time Answer C is 100% wrong! While it is true, that the undo retention will be ignored for fixed size undo tablespaces, it won't be ignored if retention guarantee is enabled! Source: https://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams222.htm#REFRN10225 For fixed- size undo tablespaces, the system automatically tunes for the maximum possible undo retention period, based on undo tablespace size and usage history, and ignores UNDO_RETENTION !!!unless retention guarantee is enabled.!!! So the correct answer for this question is B!

    4. F

       Franky_T

       2022-04-25

       Selected B2 upvotes

       Tricky question indeed. The documentation clearly shows that: "The UNDO_RETENTION parameter is ignored for a fixed size undo tablespace. The database always tunes the undo retention period for the best possible retention, based on system activity and undo tablespace size." This shows that Unexpired segments will be overwritten by new transactional data. However, the issue here is with the part of the question that states "UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens". This implies that all segments have an ACTIVE state. ASKTOM states: "We will not reuse space (wrap the rollback segment back around over itself) while there is an active transaction there." With this in mind the answer has to be B.

14. Question 14 of 25

    Select 2

    Which two statements are true about the rules of precedence for operators? (Choose two.)

    • AThe concatenation operator | | is always evaluated before addition and subtraction in an expression
    • BNULLS influence the precedence of operators in an expression
    • CThe + binary operator has the highest precedence in an expression in a SQL statement
    • DArithmetic operators with equal precedence are evaluated from left to right within an expression
    • EMultiple parentheses can be used to override the default precedence of operators in an expression

    Show answer

    Correct answer: D, E

    How others answered

    • DE100%

    Explanation

    DE are correct. Precedence Precedence is the order in which Oracle evaluates different operators in the same expression. When evaluating an expression containing multiple operators, Oracle evaluates operators with higher precedence before evaluating those with lower precedence. Oracle evaluates operators with equal precedence from left to right within an expression. https://docs.oracle.com/cd/A87860_01/doc/server.817/a85397/operator.htm

    Adapted from community discussion by Trowa · 2021-08-09 · 6 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 14 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-082 or CertExamHQ.

    1. T

       Trowa

       2021-08-09

       6 upvotes

       DE are correct. Precedence Precedence is the order in which Oracle evaluates different operators in the same expression. When evaluating an expression containing multiple operators, Oracle evaluates operators with higher precedence before evaluating those with lower precedence. Oracle evaluates operators with equal precedence from left to right within an expression. https://docs.oracle.com/cd/A87860_01/doc/server.817/a85397/operator.htm

    2. S

       SimoneF

       2021-12-19

       4 upvotes

       D and E are obviously correct BUT, since this was too strange of a mistake to be true, I went and review the precedence rules, finding out something I honestly forgot or ignored altogether: "+" IS, actually, the operator with the highest precedence, together with "-", yet only when they're used a unary operators "identity" and "negation". For example, in a simple operation +X*Y, the "+" is the first operator evaluated. As a binary operator it still comes, obviously, after multiplication and division, I've just been thinking that in a similar question where they could state "unary", I could have easily been tricked overlooking that simple detail. https://docs.oracle.com/cd/A87860_01/doc/server.817/a85397/operator.htm#997667

    3. N

       nautil2

       2024-10-17

       Selected D, E2 upvotes

       A - false; concatenation, addition and subtraction has the same precedence, in that case it is evaluated from left to right within an expression. B - false; precedence does not change, result is NULL except of concatenation C - false; only unary +, unary -, PRIOR, CONNECT_BY_ROOT and COLLATE have the highest precedence D - true; see A E - true; You can use parentheses in an expression to override operator precedence. Oracle evaluates expressions inside parentheses before evaluating those outside. Source: Oracle documentation: Release 19, SQL Language Reference, 4 Operators, About SQL Operators

    4. A

       auwia

       2024-07-11

       2 upvotes

       Rules of precedence: 1. arithmetic operators 2. concatenation operator 3. comparison conditions 4. is (NOT) NULL, LIKE (NOT) IN 5. (NOT) Between 6. NOT equal to 7. NOT logical operatror 8. AND logical operatror 9. OR logical operatror

15. Question 15 of 25

    In one of your databases, user KING is: 1. Not a DBA user 2. An operating system (OS) user Examine this command and its output:

    

    What must you do so that KING is authenticated by the OS when connecting to the database instance?

    • ASet OS_AUTHENT_PREFIX to OPS$
    • BHave the OS administrator add KING to the OSDBA group
    • CGrant DBA to KING
    • DUnset REMOTE_LOGIN_PASSWORDFILE
    • EAlter user KING to be IDENTIFIED EXTERNALLY

    Show answer

    Correct answer: E

    How others answered

    • E100%

    Explanation

    E is the correct one: https://docs.oracle.com/cd/B19306_01/network.102/b14266/admnauth.htm#i1006459 Creating a User Who Is Authenticated Externally The following statement creates a user who is identified by Oracle and authenticated by the operating system or a network service. This example assumes that OS_AUTHENT_PREFIX = "". CREATE USER scott IDENTIFIED EXTERNALLY; Using CREATE USER ... IDENTIFIED EXTERNALLY, you create database accounts that must be authenticated by the operating system or network service. Oracle will then rely on this external login authentication when it provides that specific operating system user with access to the database resources of a specific user.

    Adapted from community discussion by eddkzew · 2022-01-04 · 2 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 15 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-082 or CertExamHQ.

    1. M

       Muhab

       2021-08-04

       5 upvotes

       The Answer should be A . Ref : https://oracle-base.com/articles/misc/os-authentication

    2. N

       NowOrNever

       2021-09-24

       5 upvotes

       A - ist wrong a prefix can be empty, it is not necessary to set it back to default OPS$

    3. A

       avanand

       2021-08-23

       4 upvotes

       I think answer should be A. Because unless you set OS_AUTHENT_PREFIX you can't have this user created on database which can identified externally. And when you have OS_AUTHENT_PREFIX set to OPS$ (eg) , you need to alter OPS$KING to identified externally not to KING.

    4. E

       eddkzew

       2022-01-04

       2 upvotes

       E is the correct one: https://docs.oracle.com/cd/B19306_01/network.102/b14266/admnauth.htm#i1006459 Creating a User Who Is Authenticated Externally The following statement creates a user who is identified by Oracle and authenticated by the operating system or a network service. This example assumes that OS_AUTHENT_PREFIX = "". CREATE USER scott IDENTIFIED EXTERNALLY; Using CREATE USER ... IDENTIFIED EXTERNALLY, you create database accounts that must be authenticated by the operating system or network service. Oracle will then rely on this external login authentication when it provides that specific operating system user with access to the database resources of a specific user.

16. Question 16 of 25

    Select 2

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

    • AIt can be accessed only by the SYS user
    • BIt consists of a single row and single column of VARCHAR2 data type
    • CIt can display multiple rows but only a single column
    • DIt can be used to display only constants or pseudo columns
    • EIt can be accessed by any user who has the SELECT privilege in any schema
    • FIt can display multiple rows and columns

    Show answer

    Correct answer: B, F

    How others answered

    • BF50%
    • BE33%
    • EF17%

    Only 50% agreed on this answer — treat it as contested rather than settled.

    Explanation

    B and F are correct answers. F is correct : 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.

    Adapted from community discussion by Sharif1 · 2021-02-06 · 19 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 16 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-082 or CertExamHQ.

    1. S

       Sharif1

       2021-02-06

       19 upvotes

       B and F are correct answers. F is correct : 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.

    2. D

       danito

       2020-11-28

       12 upvotes

       B E https://docs.oracle.com/cd/B19306_01/server.102/b14200/queries009.htm

    3. N

       nautil2

       2024-04-24

       Selected B, F1 upvote

       A - false; DUAL is a table automatically created by Oracle Database along with the data dictionary. DUAL is in the schema of the user SYS but is accessible by the name DUAL to all users. Source: Oracle documentation - Oracle Database, Release 19, SQL Language Reference, 9 SQL Queries and Subqueries, Selecting from the DUAL Table B - true; single column DUMMY with datatype VARCHAR2(1) and value 'X' C - false; query SELECT sysdate, sysdate FROM dual; D - false; Alternatively, you can select a constant, pseudocolumn, or expression from any table, but the value will be returned as many times as there are rows in the table. Source: same as mentioned in answer A E - false; GRANT SELECT any table is not necessary to query DUAL table. Newly created user is not granted with any SELECT privilege, however he/she can query any own object and table DUAL. F - true; example SELECT with multiple row and column output is SELECT sysdate,sysdate+1 FROM dual CONNECT BY LEVEL <= 5;

    4. M

       Muhab

       2021-02-04

       5 upvotes

       The Answer BE ref https://docs.oracle.com/cd/B19306_01/server.102/b14200/queries009.htm

17. Question 17 of 25

    Select 3

    Which three statements are true about the tools used to configure Oracle Net Services? (Choose three.)

    • AThe Oracle Net Configuration Assistant is only used when running the Oracle installer
    • BOracle Net Manager can be used to centrally configure listeners on any database server target
    • CThe lsnrctl utility requires a listener.ora file to exist before it is started
    • DOracle Net Manager can be used to locally configure naming methods on a database server
    • EEnterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server
    • FEnterprise Manager Cloud Control can be used to centrally configure net service names for any database server target

    Show answer

    Correct answer: D, E, F

    How others answered

    • DEF100%

    Explanation

    Answer: D,E,F Explanation: https://docs.oracle.com/en/database/oracle/oracle-database/19/netag/introducing-oracle-net-services.html#GUID-6B1F0584-887D-4D2A-B982-40ACF15DF985 • Oracle Enterprise Manager Cloud Control combines configuration functionality across multiple file systems, along with listener administrative control to provide an integrated environment for configuring and managing Oracle Net Services. • Oracle Net Manager provides configuration functionality for an Oracle home on a local client or server host.

    Adapted from community discussion by dotruonghan · 2021-07-27 · 8 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 17 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-082 or CertExamHQ.

    1. G

       GraceYu

       2021-06-07

       15 upvotes

       DEF Oracle Net Manager to locally control and Enterprise Manager Cloud Control to centrally control.

    2. D

       dotruonghan

       2021-07-27

       8 upvotes

       Answer: D,E,F Explanation: https://docs.oracle.com/en/database/oracle/oracle-database/19/netag/introducing-oracle-net-services.html#GUID-6B1F0584-887D-4D2A-B982-40ACF15DF985 • Oracle Enterprise Manager Cloud Control combines configuration functionality across multiple file systems, along with listener administrative control to provide an integrated environment for configuring and managing Oracle Net Services. • Oracle Net Manager provides configuration functionality for an Oracle home on a local client or server host.

    3. N

       nautil2

       2024-11-27

       Selected D, E, F1 upvote

       A - false; netca can be run independently on the Oracle Installer B - false; Oracle Net Manager can be used to configure listeners on the local server or server host C - false; there need not exist the listener.ora file before lsnrctl utility is started D - true; see answer B E - true; EM Cloud Control: All the systems and services including enterprise application systems, databases, hosts, middleware application servers, listeners, and so on, are easily managed from one central location. F - true; see answer E Source: B - Oracle database documentation: "Oracle Net Manager supports configuration of connect descriptors in a local tnsnames.ora file or directory server." E - Oracle Enterprise Manager Cloud Control 13.5 documentation

    4. A

       auwia

       2024-07-14

       Selected D, E, F1 upvote

       Provided answer are wrong. ref. https://docs.oracle.com/en/database/oracle/oracle-database/21/netag/managing-oracle-net-services.html#GUID-1F145906-24CC-4A63-86FD-31776C022209

18. Question 18 of 25

    Select 2

    Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

    • AThe ADR base defaults to $ORACLE_HOME/rdbms/admin if neither DIAGNOSTIC_DEST nor ORACLE_BASE is set
    • BThe ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set
    • CIt supports diagnostics for Automatic Storage Management (ASM)
    • DIt supports diagnostics for Oracle Clusterware
    • EIt is held inside an Oracle database schema

    Show answer

    Correct answer: C, D

    How others answered

    • CD100%

    Explanation

    I think C D. The database, Oracle Automatic Storage Management (Oracle ASM), the listener, Oracle Clusterware, and other Oracle products or components store all diagnostic data in the ADR. https://docs.oracle.com/database/121/ADMIN/diag.htm#ADMIN11260

    Adapted from community discussion by elcaso34 · 2021-06-18 · 21 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 18 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-082 or CertExamHQ.

    1. E

       elcaso34

       2021-06-18

       21 upvotes

       I think C D. The database, Oracle Automatic Storage Management (Oracle ASM), the listener, Oracle Clusterware, and other Oracle products or components store all diagnostic data in the ADR. https://docs.oracle.com/database/121/ADMIN/diag.htm#ADMIN11260

    2. B

       brolem

       2022-09-24

       6 upvotes

       A, B - Wrong: The ADR root directory is known as the ADR base. Its location is set by the DIAGNOSTIC_DEST initialization parameter. If this parameter is omitted or left null, the database sets DIAGNOSTIC_DEST upon startup as follows: If environment variable ORACLE_BASE is set, DIAGNOSTIC_DEST is set to SORACLE_BASE. If environment variable ORACLE_BASE is not set, DIAGNOSTIC_DEST is set to SORACLE_HOME/log. C - Correct: For example, in an Oracle Real Application Clusters environment with Oracle ASM, each database instance, Oracle ASM instance, and listener has an ADR home. D - Correct: Oracle Clusterware uses ADR and has its own Oracle home and Oracle base. E - Wrong: The Automatic Diagnostic Repository (ADR) is a directory structure that is stored outside of the database. It is therefore available for problem diagnosis when the database is down. From

    3. A

       auwia

       2024-07-14

       Selected C, D2 upvotes

       By exclusion: A and B are wrong because the default path is ORACLE_HOME/log for this case: The ADR root directory is known as ADR base. Its location is set by the DIAGNOSTIC_DEST initialization parameter. If this parameter is omitted or left null, the database sets DIAGNOSTIC_DEST upon startup as follows: - If environment variable ORACLE_BASE is set, DIAGNOSTIC_DEST is set to the directory designated by ORACLE_BASE. - If environment variable ORACLE_BASE is not set, DIAGNOSTIC_DEST is set to ORACLE_HOME/log. E is wrong because: The Automatic Diagnostic Repository (ADR) is a directory structure that is stored outside of the database. It is therefore available for problem diagnosis when the database is down. ref. https://docs.oracle.com/en/database/oracle/oracle-database/12.2/admin/managing-diagnostic-data.html#GUID-C78CCAD4-732B-4B14-9C6B-D47AC2A99E30

    4. N

       nautil2

       2024-11-27

       Selected C, D2 upvotes

       A - false; default value for DIAGNOSTIC_DEST: If $ORACLE_BASE is not set, then derived from ORACLE_BASE as set by the Oracle Universal Installer. If ORACLE_BASE is not set, then $ORACLE_HOME/rdbms/log is used. B - false; see answer A C - true; Beginning with Oracle Database 11g and later releases, Oracle Automatic Storage Management (Oracle ASM), and other Oracle Database products or components store all diagnostic data in the ADR. D - true; Review this content to understand clusterware-specific aspects of how Oracle Clusterware uses ADR. E - false; data are not held inside an Oracle database schema Sources: A, B - Oracle documentation: 1.108 DIAGNOSTIC_DEST C - Oracle documentation: 21.2 Definitions for Oracle Database ADRC D - Oracle documentation: J Troubleshooting Oracle Clusterware

19. Question 19 of 25

    Select 3

    You want to apply the principle of Least Privilege in all your live databases. One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis. Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose three.)

    • Aanalysis of all privileges used by all users including administrative users in the database
    • Banalysis of all privileges used by all users but excluding administrative users in the database
    • Canalysis of privileges that a user has on their own schema objects that they did not use
    • Danalysis of privileges that a user has on their own schema objects that they did use
    • Eanalysis of privileges granted directly to a role that are then used by a user who has been granted that role
    • Fanalysis of privileges granted indirectly to a role that are then used by a user who has been granted that role

    Show answer

    Correct answer: C, D, F

    How others answered

    • CDF50%
    • BEF50%

    Only 50% agreed on this answer — treat it as contested rather than settled.

    Explanation

    Reference: https://docs.oracle.com/database/121/ARPLS/d_priv_prof.htm#ARPLS74328

    Adapted from community discussion by Guhborges · 2021-11-29 · 5 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 19 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-082 or CertExamHQ.

    1. G

       Guhborges

       2021-11-29

       5 upvotes

       A - E - F CORRECT!!!! A - Right - We can analyze the administrative user, the oracle just excludes the SYS user B - Wrong, oracle does not delete administrative user, like question A, only SYS user C - Wrong - We cannot analyze the permission of the scheme itself D - Wrong - We cannot analyze the privilege of our schema E - Right - we can analyze the permission that was given directly. F - Right - we can analyze the permission that was given indirectly.

    2. X

       XhostSI

       2022-02-09

       1 upvote

       A. An undo segment may be used by multiple transactions simultaneously - True B. Undo segments can wrap around to the first extent when a transaction fills the last extent of the undo segment - True (undo segment act as a circular buffer) C. Undo segments have a minimum of three extents - False (each segment has a minimum of two extents) D. Undo segments can extend when a transaction fills the last extent of the undo segment - True (Undo tablespace are locally managed with auto extent allocation ) E. A single transaction may use multiple undo segments simultaneously - False F. Undo segments must be stored in a BIGFILE tablespace - False G. Undo segments must be stored in a SMALLFILE tablespace - False (DBCA automatically creates a smallfile undo tablespece, but it can be configured as bigfile table space as well) So correct answers are: A, B, D

    3. N

       NowOrNever

       2020-07-28

       2 upvotes

       DEF - i think Database privilege analysis enables you to create a policy that records the usage of system and object privileges that have been granted to users. You then can determine the privileges that your users are using and not using. From there, you can revoke any unused privileges, thereby reducing the number of excess privilege grants for users. C- you can analize only used privileges, but then determine the unsued privileges F - When using role-based analysis for the CREATE_CAPTURE procedure, privilege use is analyzed even if the privilege is indirectly granted to the specified role.

    4. A

       ama

       2020-07-30

       3 upvotes

       we can analyze all users except SYS, i dunno but answer B saying all users except administrative Users! You cannot analyze the privileges of the SYS user. https://docs.oracle.com/en/database/oracle/oracle-database/19/dbseg/performing-privilege-analysis-find-privilege-use.html#GUID-AD683DDB-D345-4702-B1F4-37B79F276B66

20. Question 20 of 25

    Select 3

    Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance? (Choose three.)

    • AAn undo segment may be used by multiple transactions simultaneously
    • BUndo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment
    • CUndo segments have a minimum of three extents
    • DUndo segments can extend when a transaction fills the last extent of the undo segment
    • EA single transaction may use multiple undo segments simultaneously
    • FUndo segments must be stored in a BIGFILE tablespace
    • GUndo segments must be stored in a SMALLFILE tablespace

    Show answer

    Correct answer: A, B, D

    How others answered

    • ABD80%
    • ADE20%

    Explanation

    F and G are both false! While the default is smallfile you can also create a bigfile undo tablespace which means both smallfile and bigfile are possible for undo tablespaces E is also false as each transaction is assigned to only one undo segment, but an undo segment can service more than one transaction at a time -> A is right Which leaves us with B,C,D as possible answers. B and D are true -> taken from the Oracle Administrator Workshop Studyguide: Transactions and Undo Data (14 - 5): If an extent fills up and more space is needed, the transaction acquires that space from the next extent in the segment. After all extents have been consumed, the transaction either wraps around back into the first extent or requests a new extent to be allocated to the undo segment (supporting answers B and D) The right answers for this question are: A,B,D I would also say that C is false as I am pretty sure that UNDO segments have a minimum of 2 extents (and not 3 extents) to support the circular use of undo segments and this can be achieved by a minimum of 2 extents

    Adapted from community discussion by adoptc94 · 2021-02-26 · 19 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 20 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-082 or CertExamHQ.

    1. A

       adoptc94

       2021-02-26

       19 upvotes

       F and G are both false! While the default is smallfile you can also create a bigfile undo tablespace which means both smallfile and bigfile are possible for undo tablespaces E is also false as each transaction is assigned to only one undo segment, but an undo segment can service more than one transaction at a time -> A is right Which leaves us with B,C,D as possible answers. B and D are true -> taken from the Oracle Administrator Workshop Studyguide: Transactions and Undo Data (14 - 5): If an extent fills up and more space is needed, the transaction acquires that space from the next extent in the segment. After all extents have been consumed, the transaction either wraps around back into the first extent or requests a new extent to be allocated to the undo segment (supporting answers B and D) The right answers for this question are: A,B,D I would also say that C is false as I am pretty sure that UNDO segments have a minimum of 2 extents (and not 3 extents) to support the circular use of undo segments and this can be achieved by a minimum of 2 extents

    2. M

       musafir

       2024-01-28

       Selected A, B, D1 upvote

       A. An undo segment may be used by multiple transactions simultaneously Correct - "Multiple active transactions can write concurrently to the same undo segment or to different segments." B. Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment Correct - If the 1st extent is full then the next extent will be used and overwritten if it contains unactive undo. C. Undo segments have a minimum of three extents Wrong - No documentation about minimum number of extents. D. Undo segments can extend when a transaction fills the last extent of the undo segment Correct, AUTOEXTEND Option with Automatic UNDO management allows extension of UNDO. E. A single transaction may use multiple undo segments simultaneously Wrong - Documentation says a transaction may use multiple extents simultaneosly not segments. https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/logical-storage-structures.html#GUID-BB42D7D8-2C93-4F5B-B0C1-6361AEEF4B37 F. Undo segments must be stored in a BIGFILE tablespace G. Undo segments must be stored in a SMALLFILE tablespace Wrong - Can be either Bigfile or Smallfile, smallfile is the default. A B D are correct I think

    3. N

       nautil2

       2024-05-27

       Selected A, B, D2 upvotes

       A - true; query SELECT addr,xidusn,start_time FROM v$transaction ORDER BY xidusn; can return multiple ADDR (address of the transaction state object) for a single XIDUSN (undo segment number) B - true; when an extent (within a segment) is filled up, a transaction either wraps around back into the first extent, or requests a new extent to be allocated C - false; an undo segment can be formed of a single (one) extent. One extent is the total minimum. D - true; see answer B E - false; when a transaction starts, it is assigned to only one undo segment F - false; a command CREATE SMALLFILE UNFO TABLESPACE tablespace_name; is valid G - false; a command CREATE BIGFILE UNFO TABLESPACE tablespace_name; is valid Sources: F, G - Oracle Database 19c Documentation: SQL Language Reference > 15 SQL Statements: CREATE SEQUENCE to DROP CLUSTER > CREATE TABLESPACE

    4. X

       XhostSI

       2022-08-11

       2 upvotes

       A. An undo segment may be used by multiple transactions simultaneously - True B. Undo segments can wrap around to the first extent when a transaction fills the last extent of the undo segment - True (undo segment act as a circular buffer) C. Undo segments have a minimum of three extents - False (each segment has a minimum of two extents) D. Undo segments can extend when a transaction fills the last extent of the undo segment - True (Undo tablespace are locally managed with auto extent allocation ) E. A single transaction may use multiple undo segments simultaneously - False F. Undo segments must be stored in a BIGFILE tablespace - False G. Undo segments must be stored in a SMALLFILE tablespace - False (DBCA automatically creates a smallfile undo tablespece, but it can be configured as bigfile table space as well) So correct answers are: A, B, D

21. Question 21 of 25

    Select 2

    Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

    • AThe data type group of each column returned by the second query must match the data type of the corresponding column returned by the first query.
    • BThe number, but not names, of columns must be identical for all SELECT statements in the query.
    • CThe data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.
    • DThe names and number of columns must be identical for all SELECT statements in the query.
    • EThe data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.

    Show answer

    Correct answer: A, B

    How others answered

    • AB100%

    Explanation

    I would also say A and B - "...Tables must have the same number of columns presented in the same order. In addition, the data type of the corresponding column must be in the same data type group such as number or character..."

    Adapted from community discussion by Rivaldo11 · 2021-01-15 · 6 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 21 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-082 or CertExamHQ.

    1. R

       Rivaldo11

       2021-01-15

       6 upvotes

       I would also say A and B - "...Tables must have the same number of columns presented in the same order. In addition, the data type of the corresponding column must be in the same data type group such as number or character..."

    2. A

       avanand

       2021-02-23

       3 upvotes

       A and B are correct. For SET operator, Data type group should be matched. For example, a NUMBER column in first query can be UNIONed with INTERGER column in second query.

    3. S

       Shinju_dy

       2024-09-14

       1 upvote

       In queries using set operators, Oracle does not perform implicit conversion across data type groups. Therefore, if the corresponding expressions of component queries resolve to both character data and numeric data, Oracle returns an error. https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/The-UNION-ALL-INTERSECT-MINUS-Operators.html#GUID-B64FE747-586E-4513-945F-80CB197125EE

    4. M

       mamadu

       2024-01-11

       2 upvotes

       I was confused with C and A since A. mentions "data type group". i can confirm that a CHAR can be matched with VARCHAR2. ans is A B

22. Question 22 of 25

    Select 3

    Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)

    • AThe CURRENT_TIMESTAMP function returns data without time zone information
    • BA TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row
    • CA TIMESTAMP data type column contains information about year, month, and day
    • DThe DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
    • EThe SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

    Show answer

    Correct answer: C, D, E

    How others answered

    • CDE50%
    • BDE50%

    Only 50% agreed on this answer — treat it as contested rather than settled.

    Explanation

    C D E: "TIMESTAMP WITH LOCAL TIME ZONE is another variant of TIMESTAMP that is sensitive to time zone information. It differs from TIMESTAMP WITH TIME ZONE in that data stored in the database is normalized to the database time zone, and the time zone information is not stored as part of the column data. When a user retrieves the data, Oracle returns it in the user's local session time zone." So, the data is stored with the DB Timezone, even if it's retrieved with the session timezone. A is clearly wrong by example, so the rest are true. With D and E we can also have an easy sample, while for C, which is apparently the most ambiguous, I agree with whom was saying that the TIMESTAMP data type contains indeed informations about day, month and year, and in the answer is never stated that they are the only ones present. So as it's put, it's definitely right. https://docs.oracle.com/database/121/NLSPG/ch4datetime.htm#GUID-CD2954CE-45E2-4938-A599-CCB96879510F

    Adapted from community discussion by SimoneF · 2021-01-03 · 12 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 22 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-082 or CertExamHQ.

    1. S

       SimoneF

       2021-01-03

       12 upvotes

       C D E: "TIMESTAMP WITH LOCAL TIME ZONE is another variant of TIMESTAMP that is sensitive to time zone information. It differs from TIMESTAMP WITH TIME ZONE in that data stored in the database is normalized to the database time zone, and the time zone information is not stored as part of the column data. When a user retrieves the data, Oracle returns it in the user's local session time zone." So, the data is stored with the DB Timezone, even if it's retrieved with the session timezone. A is clearly wrong by example, so the rest are true. With D and E we can also have an easy sample, while for C, which is apparently the most ambiguous, I agree with whom was saying that the TIMESTAMP data type contains indeed informations about day, month and year, and in the answer is never stated that they are the only ones present. So as it's put, it's definitely right. https://docs.oracle.com/database/121/NLSPG/ch4datetime.htm#GUID-CD2954CE-45E2-4938-A599-CCB96879510F

    2. A

       adoptc94

       2020-09-02

       8 upvotes

       I don't see any issue with answer C! While it does also store hour, minute and seconds the answer doesn't state that it ONLY stores year, month and day - it does contain it which is true. I'd go with C,D,E

    3. E

       elbelgounetos

       2021-03-05

       3 upvotes

       A is wrong It's local_timezone B is wrong, it depend of the function used to insert C is not "only" it can contain more information. => true D true see documentation. SESSIONTIMEZONE returns the time zone of the current session. The return type is a time zone offset (a character type in the format '[+|-]TZH:TZM') or a time zone region name, depending on how the user specified the session time zone value in the most recent ALTER SESSION statement. E true see documentation DBTIMEZONE returns the value of the database time zone. The return type is a time zone offset (a character type in the format '[+|-]TZH:TZM') or a time zone region name, depending on how the user specified the database time zone value in the most recent CREATE DATABASE or ALTER DATABASE statement. SO C,D,E

    4. A

       ama

       2020-07-23

       4 upvotes

       A is wrong SQL> select CURRENT_TIMESTAMP from dual; CURRENT_TIMESTAMP --------------------------------------------------------------------------- 23.07.20 12:18:00,735965 +02:00

23. Question 23 of 25

    In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

    

    Which statement is true?

    • ADynamic service registration cannot be used for this database instance
    • BThe LREG process registers services dynamically with the LISTENER_1 listener
    • CLISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
    • DThere are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
    • EThe definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration

    Show answer

    Correct answer: B

    How others answered

    • B50%
    • C45%

    Only 50% agreed on this answer — treat it as contested rather than settled.

    Explanation

    Answer is B. The listener forwards client requests to supported services. These services are dynamically registered with the listener. This dynamic registration feature is called service registration. The registration is performed by the Listener Registration (LREG) process. Dynamic service registration does not require any manual configuration in the listener.ora file. Reference: https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG292

    Adapted from community discussion by Muhab · 2020-08-04 · 9 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 23 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-082 or CertExamHQ.

    1. M

       Muhab

       2020-08-04

       9 upvotes

       Answer is B. The listener forwards client requests to supported services. These services are dynamically registered with the listener. This dynamic registration feature is called service registration. The registration is performed by the Listener Registration (LREG) process. Dynamic service registration does not require any manual configuration in the listener.ora file. Reference: https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG292

    2. N

       nautil2

       2022-12-15

       Selected B3 upvotes

       My vote is for answer B, because it's the closest to my findings. The question text does not imply the listener name is LISTENER_1. The string "LISTENER_1" is just an alias, that does not need a record in listener.ora, just a setting of LOCAL_LISTENER parameter in the database and alias explanation in tnsnames.ora as described at https://docs.oracle.com/en/database/oracle/oracle-database/19/netag/configuring-and-administering-oracle-net-listener.html#GUID-0E7C39E3-4627-403A-AE69-E9AA2C7E4C57 When reproduced a scenario on a testing instance and typing $ lsnrctl status LISTENER_1, I can see status of default LISTENER with services registered dynamicaly after database was bounced. In listener.ora there is a definition of standard LISTENER, but no mention about LISTENER_1, however dynamic service registration works fine.

    3. N

       nobody347

       2021-06-10

       6 upvotes

       Answer is C 100% I create Listener_1 in tnsnames.ora and didn't put information about it in listener.ora, when i start Listener_1 it was failed because TNS-01151 ; Missing listener name, Listener_1, in listener.ora.

    4. F

       Franky_T

       2022-04-12

       Selected B2 upvotes

       Dynamic service registration is configured in the database initialization file. It does not require any configuration in the listener.ora file. However, listener configuration must be set to listen on the ports named in the database initialization file, and must not have parameters set that prevent automatic registration, such as COST parameters. By default, the LREG process registers service information with its local listener on the default local address of TCP/IP, port 1521. If the listener configuration is synchronized with the database configuration, then LREG can register service information with a nondefault local listener or a remote listener on another node. Ref: https://docs.oracle.com/en/database/oracle/oracle-database/19/netag/configuring-and-administering-oracle-net-listener.html#GUID-A7F49477-1F13-49E7-9B23-9A50A4627862

24. Question 24 of 25

    Select 3

    Which three statements are true regarding indexes? (Choose three.)

    • AA UNIQUE index can be altered to be non-unique
    • BA SELECT statement can access one or more indices without accessing any tables
    • CA table belonging to one user can have an index that belongs to a different user
    • DAn update to a table can result in updates to any or all of the table's indexes
    • EWhen a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped
    • FAn update to a table can result in no updates to any of the table's indexes

    Show answer

    Correct answer: B, D, F

    How others answered

    • BDF60%
    • BCF40%

    Only 60% agreed on this answer — treat it as contested rather than settled.

    Explanation

    I would also suggest: BCD Especially for D Oracle says following: The database automatically maintains and uses indexes after they are created. The database also automatically reflects changes to data, such as adding, updating, and deleting rows, in all relevant indexes with no additional actions required by users. Retrieval performance of indexed data remains almost constant, even as rows are inserted. However, the presence of many indexes on a table degrades DML performance because the database must also update the indexes. Source: https://docs.oracle.com/cd/E11882_01/server.112/e40540/indexiot.htm#CNCPT1895 But F seems also like it's true, just like you mentioned if someone updates only non indexed columns in the table, there shouldn't be any changes done to the index. I am confused as to what the right answers are for sure - is it possible that out of the 6 choices 4 are right, but you only have to choose 3 of them?

    Adapted from community discussion by adoptc94 · 2021-02-21 · 4 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 24 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-082 or CertExamHQ.

    1. S

       SimoneF

       2021-07-05

       5 upvotes

       I think the biggest confusion here is given by option D. While A is false (can't change the uniqueness of an index) as E (Indexes of a dropped table are moved to the recycled bin if enabled) B is true if you select more indexed columns on different indexes and no unindexed columns. C is true for sure cause it's possible, given the right privileges, to create an index as schema X on a table owned by schema Y. F Is true cause no index may be updated, if you update a non-indexed column and the row address is unchanged D also sounds right, I think the key might be in the phrasing here: if it's intended that the update of any or all indexes are the only possible outcome of a table update, then it would in fact be false. Otherwise, as someone else noted, I also suspect that more answers may be right, even though you only have to select three.

    2. A

       adoptc94

       2021-02-21

       4 upvotes

       I would also suggest: BCD Especially for D Oracle says following: The database automatically maintains and uses indexes after they are created. The database also automatically reflects changes to data, such as adding, updating, and deleting rows, in all relevant indexes with no additional actions required by users. Retrieval performance of indexed data remains almost constant, even as rows are inserted. However, the presence of many indexes on a table degrades DML performance because the database must also update the indexes. Source: https://docs.oracle.com/cd/E11882_01/server.112/e40540/indexiot.htm#CNCPT1895 But F seems also like it's true, just like you mentioned if someone updates only non indexed columns in the table, there shouldn't be any changes done to the index. I am confused as to what the right answers are for sure - is it possible that out of the 6 choices 4 are right, but you only have to choose 3 of them?

    3. A

       auwia

       2024-01-04

       Selected B, D, F2 upvotes

       A. A UNIQUE index can be altered to be non-unique --> False B. A SELECT statement can access one or more indices without accessing any tables. True C. A table belonging to one user can have an index that belongs to a different user --> False, schema is still the owner. D. An update to a table can result in updates to any or all of the table's indexes. True, it depends if the update goes on column with index or without. E. When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped. --> False, indexes will follow the table. F. An update to a table can result in no updates to any of the table's indexes. True, you do an update on a single column that has no index.

    4. D

       danito

       2021-02-28

       3 upvotes

       Be careful with the exam. I had this question but with a small detail: one of answer was: very similar to C but "cannot" instead of "can" C A table belonging to one user can have an index that belongs to a different use (my exam) A table belonging to one user cannot have an index that belongs to a different use So you must study a lot. To study this dump is not enought

25. Question 25 of 25

    Select 3

    Which three statements are true concerning logical and physical database structures? (Choose three.)

    • AAll tablespaces may have one or more data files
    • BThe extents of a segment must always reside in the same datafile
    • CA smallfile tablespace might be bigger than a bigfile tablespace
    • DA segment can span multiple data files in some tablespaces
    • EA segment's blocks can be of different sizes
    • FA segment might have only one extent
    • GSegments can span multiple tablespaces

    Show answer

    Correct answer: C, D, F

    How others answered

    • CDF69%
    • ACF15%

    Only 69% agreed on this answer — treat it as contested rather than settled.

    Explanation

    A is wrong. Because bigfile tablespaces may have only one datafile B is wrong. Because if a tablespace has more than one datafile then the extents of the segment can be in any one or all of the data files. Remember that tablespaces are LOGICAL objects and the segment lives in the logical object, regardless of which file the extent exists on. C is correct. Smallfile tablespaces may have many datafiles that collectively exceed the the size of the datafile that is in the bigfile tablespace D is correct. The opposite of option B. A tablespace is a logical object made up of one or more datafiles. With locally managed tablespaces the server will decide where the next extent allocation should be done for a segment E is wrong. A segment must have all it's extents in the same tablespace, and block size is defined at tablespace level F is correct. If a segment has row pieces that collectively are less than or equal to the total storage requirement of one extent then the segment will have only one extent allocated to it G is wrong. A segment can reside in one tablespace only

    Adapted from community discussion by Franky_T · 2022-04-12 · 9 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 25 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-082 or CertExamHQ.

    1. F

       Franky_T

       2022-04-12

       Selected C, D, F9 upvotes

       A is wrong. Because bigfile tablespaces may have only one datafile B is wrong. Because if a tablespace has more than one datafile then the extents of the segment can be in any one or all of the data files. Remember that tablespaces are LOGICAL objects and the segment lives in the logical object, regardless of which file the extent exists on. C is correct. Smallfile tablespaces may have many datafiles that collectively exceed the the size of the datafile that is in the bigfile tablespace D is correct. The opposite of option B. A tablespace is a logical object made up of one or more datafiles. With locally managed tablespaces the server will decide where the next extent allocation should be done for a segment E is wrong. A segment must have all it's extents in the same tablespace, and block size is defined at tablespace level F is correct. If a segment has row pieces that collectively are less than or equal to the total storage requirement of one extent then the segment will have only one extent allocated to it G is wrong. A segment can reside in one tablespace only

    2. R

       Rivaldo11

       2020-07-16

       13 upvotes

       C, D and F. Answer A is wrong, it says - "All tablespaces may have one or more data files", but bigfile tablespaces can have only one datafile.

    3. S

       SimoneF

       2020-11-23

       3 upvotes

       The wording used is misleading, but I think there are some safe points: A - Wrong: not all tablespaces may have more than one datafile, since bigfile tablespaces can only have one. B - Wrong: Extents of the same segments can be on different datafiles, no doubts here. C - Right: A bigfile tablespace could very well be 100MB, and a smallfile tablespace span multiple GB datafiles. So no dobuts here either. E - Wrong: A segment resides on a single tablespace and block size is consistent across a tablespace, so no dobuts here as well. F - Mostly right: wording is ambiguous but I dare say it's possible for a segment to have only one extent. I'm inclined to think that it would have been different if it said "A segment might only have one extent". But I'm not a native English speaker, so a grain of salt here. D and G are, for me, the trickiest but, the more I read, the more I'm actually convinced that D is wrong and G means that different segments can be on different tablespace, which would clearly be true. So maybe this time, in the end, the marked answers are correct and it is CFG.

    4. A

       adoptc94

       2020-08-24

       5 upvotes

       It's just like Rivaldo11 said, not all tablespaces may have one or more data files! Bigfile tablespaces can only have ONE datafile (which can be and in most cases are much bigger in size than smallfile datafiles) - as stated in your statement. A is definitely incorrect! My picks would also be C, D and F

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

1Z0-082 practice, question 1 of 25