Free Dec-2023 1Z0-082 Certification Sample Questions certification Exam [Q81-Q105]

Free Dec-2023 1Z0-082 Certification Sample Questions certification Exam

Certification Topics of 1Z0-082 Exam PDF Recently Updated Questions

Oracle 1Z0-082 is a certification exam that focuses on database administration. 1Z0-082 exam is designed to test a candidate's knowledge and skills in managing and maintaining an Oracle database system. Passing 1Z0-082 exam is a crucial step towards becoming an Oracle Certified Associate (OCA) in database administration.

Oracle 1Z1-082 is a certification exam that evaluates the skills and knowledge of professionals in the field of Oracle database administration. 1Z0-082 exam is designed to assess the candidate's understanding of the Oracle Database architecture, installation, configuration, and management. Passing 1Z0-082 exam is a prerequisite for professionals seeking to become Oracle Certified Associates (OCA) in Oracle Database 19c.

Oracle 1Z0-082 exam is a part of the Oracle Database 19c certification path. Oracle Database Administration I certification is highly respected in the industry and is recognized worldwide. It is an essential certification for anyone who wants to advance their career as a database administrator. Oracle Database Administration I certification shows that the candidate has the knowledge and skills required to manage and maintain Oracle databases and related infrastructure.

 

NEW QUESTION # 81
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?

• A. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
• B. The LREG process registers services dynamically with the LISTENER_1 listener
• C. Dynamic service registration cannot be used for this database instance
• D. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration
• E. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration

Answer: B

Explanation:
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
https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG292

NEW QUESTION # 82
Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)

• A. INTERSECT returns rows common to both sides of the compound query
• B. INTERSECT ignores NULLs
• C. The number of columns in each SELECT in the compound query can be different
• D. Column names in each SELECT in the compound query can be different
• E. Reversing the order of the intersected tables can sometimes affect the output

Answer: B,D

NEW QUESTION # 83
Which two statements are true about the SET VERIFY ON command? (Choose two.)

• A. It displays values for variables used only in the WHERE clause of a query
• B. It displays values for variables created by the DEFINE command
• C. It can be used only in SQL*Plus
• D. It can be used in SQL Developer and SQL*Plus
• E. It displays values for variables prefixed with &&

Answer: D,E

NEW QUESTION # 84
Which three statements are true about using SQL*Plus?

• A. It has both command-line and graphical user interfaces (GUI).
• B. It must be downloaded from the Oracle Technology Network (OTN).
• C. It has its own commands that are separate from any SQL statements.
• D. It can run scripts entered at the SQL prompt.
• E. It can run Recovery Manager (RMAN) commands.
• F. It can run scripts passed to it by a shell script.

Answer: B,C,D

NEW QUESTION # 85
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?

• A. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
• B. The LREG process registers services dynamically with the LISTENER_1 listener
• C. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
• D. Dynamic service registration cannot be used for this database instance
• E. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration

Answer: A

NEW QUESTION # 86
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?

• A. Unset REMOTE_LOGIN_PASSWORDFILE
• B. Alter user KING to be IDENTIFIED EXTERNALLY
• C. Set OS_AUTHEN_PREFIX to OPS$
• D. Have the OS administrator add KING to the OSDBA group
• E. Grant DBA to KING

Answer: A

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

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

Answer: B,C,E

NEW QUESTION # 88
The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE.
NLS_DATE_FORMAT is set to DD-MON-RR.
Which two are true about data type conversions involving these columns in query expressions? (Choose two.)

• A. qty_sold = '0554982' uses implicit conversion
• B. qty_sold BETWEEN '101' AND '110' : uses implicit conversion
• C. invoie_date > '01-02-2019' : uses implicit conversion
• D. CONCAT (qty_sold, invoice_date) : requires explicit conversion
• E. invoice_date = '15-march-2019' : uses implicit conversion

Answer: B,E

NEW QUESTION # 89
Which two statements are true about the DUAL table? (Choose two.)

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

Answer: B,E

NEW QUESTION # 90
The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully? (Choose two.)

• A. SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;
• B. SELECT TO_CHAR(NVL(cust_credit_limit * .15, `Not Available')) FROM customers;
• C. SELECT NVL2(cust_credit_limit * .15, `Not Available') FROM customers;
• D. SELECT NVL(TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;
• E. SELECT NVL(cust_credit_limit * .15, `Not Available') FROM customers;

Answer: C,D

NEW QUESTION # 91
Examine this command:

Which two statements are true? (Choose two.)

• A. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
• B. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
• C. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
• D. DML may be performed on tables with one or more extents in this data file during the execution of this command.
• E. The file is renamed and stored in the same location

Answer: B,D

NEW QUESTION # 92
Examine the description of the CUSTOMERS table:

For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?

• A. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
  FROM customers
  WHERE cust_income_level != NULL
  AND cust_credit_level !=NULL;
• B. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
  FROM customers
  WHERE cust_income_level IS NOT NULL
  AND cust_credit_limit IS NOT NULL;
• C. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
  FROM customers
  WHERE cust_income_level != NULL
  AND due_amount != NULL;
• D. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
  FROM customers
  WHERE cust_income_level IS NOT NULL
  AND due_amount IS NOT NULL;
• E. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
  FROM customers
  WHERE cust_income_level <> NULL
  AND due_amount <> NULL;

Answer: B

NEW QUESTION # 93
Which is true about security rules on a compute node?

• A. New security rules can be defined to use only the TCP protocol but multiple port numbers.
• B. The port used for HTTPS connections is enabled by default based on a predefined security rule.
• C. A compute node port can be enabled only if it is associated with an existing security rule.
• D. A security rule can restrict IP addresses that can connect to a database instance on a compute node.
• E. A new database deployment on a compute node automatically enables a set of predefined security rules.

Answer: E

NEW QUESTION # 94
Which two are true about the roles? (Choose two.)

• A. A role must be disabled before it can be revoked from a user.
• B. The SET ROLE statement enables as well as disables roles in a session.
• C. The SET ROLE statement can be used once per session.
• D. All privileges and roles granted to a user are enabled by default when the user logs in.
• E. The ALTER USER statement must be used to set specific default roles for a user.

Answer: B,D

NEW QUESTION # 95
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.)

• A. SYSDATE can be used in expressions only if the default date format is DD-MON-RR
• B. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
• C. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server
• D. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE
• E. SYSDATE can be queried only from the DUAL table
• F. CURRENT_DATE returns the current date and time as per the session time zone

Answer: E,F

NEW QUESTION # 96
Examine the description of the PROMOTIONS table:

You want to display the unique promotion costs in each promotion category.
Which two queries can be used? (Choose two.)

• A. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;
• B. SELECT DISTINCT promo_category || ` has ` || promo_cost AS COSTS FROM promotions ORDER BY 1;
• C. SELECT DISTINCT promo_cost || ' in ` || DISTINCT promo_category FROM promotions ORDER BY 1;
• D. SELECT promo_cost, promo_category FROM promotions ORDER BY by 1;
• E. SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;

Answer: A,E

NEW QUESTION # 97
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?

• A. Unset REMOTE_LOGIN_PASSWORDFILE
• B. Alter user KING to be IDENTIFIED EXTERNALLY
• C. Set OS_AUTHENT_PREFIX to OPS$
• D. Have the OS administrator add KING to the OSDBA group
• E. Grant DBA to KING

Answer: C

Explanation:
https://oracle-base.com/articles/misc/os-authentication

NEW QUESTION # 98
What two are benefits of Data Pump? (Choose two.)

• A. It makes use of client system resources.
• B. It represents database metadata information as DDL statements in the dump file.
• C. It can restart failed export jobs.
• D. It can export data into sequential media, such as tapes.
• E. It can execute in parallel.

Answer: C,E

NEW QUESTION # 99
Examine these SQL statements which execute successfully:

Which two statements are true after execution?

• A. The foreign key constraint will be enabled and immediate.
• B. The foreign key constraint will be enabled and deferred.
• C. The primary key constraint will be enabled and deferred.
• D. The foreign key constraint will be disabled.
• E. The primary key constraint will be enabled and immediate.

Answer: D

NEW QUESTION # 100
The sales table has columns prod_id and quantity_sold of data type number In two queries execute successfully? x

• A. SELECT prod_id FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id HAVING COUNT(-) > 10;
• B. SELECT COUNT|prod_id> FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id;
• C. SELECT prod_id FROM sales WHERE quantity_sold > 5S000 AND COUNT(-) > 10 GROUP BY prod_id HAVING COUNT(-) > 10;
• D. SELECT prod_id FROM sales WHERE quantity_scld > 55000 AND COUNT(-) > 10 GROUP BY COUNT(-) > 10;
• E. SELECT COUNTlprod_id> FROM sales GROUP BY prod_id WHERE quantity_Sold > 55000;

Answer: A,B

NEW QUESTION # 101
Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.
Only the EMPLOYEE_ID column is indexed.
Rows exist for employees 100 and 200.
Examine this statement:

Which two statements are true? (Choose two.)

• A. Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100
• B. Employees 100 and 200 will have the same JOB_ID as before the update command
• C. Employee 100 will have SALARY set to the same value as the SALARY of employee 200
• D. Employees 100 and 200 will have the same SALARY as before the update command
• E. Employee 200 will have SALARY set to the same value as the SALARY of employee 100
• F. Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200

Answer: A,C

NEW QUESTION # 102
Which two statements are true about the DUAL table? (Choose two.)

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

Answer: B,F

NEW QUESTION # 103
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.)

• A. analysis of all privileges used by all users including administrative users in the database
• B. analysis of all privileges used by all users but excluding administrative users in the database
• C. analysis of privileges granted directly to a role that are then used by a user who has been granted that role
• D. analysis of privileges that a user has on their own schema objects that they did not use
• E. analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role
• F. analysis of privileges that a user has on their own schema objects that they did use

Answer: B,C,E

Explanation:
https://docs.oracle.com/en/database/oracle/oracle-database/19/dbseg/performing-privilege-analysis-find-privilege-use.html#GUID-AD683DDB-D345-4702-B1F4-37B79F276B66

NEW QUESTION # 104
You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
1. Be stored in a format supporting date arithmetic without using conversion functions
2. Store a loan period of up to 10 years
3. Be used for calculating interest for the number of days the loan remains unpaid Which data type should you use?

• A. INTERVAL YEAR TO MONTH
• B. TIMESTAMP WITH LOCAL TIMEZONE
• C. TIMESTAMP
• D. TIMESTAMP WITH TIMEZONE
• E. INTERVAL DAY TO SECOND

Answer: E

NEW QUESTION # 105
......

2023 New Preparation Guide of Oracle 1Z0-082 Exam: https://www.actual4exams.com/1Z0-082-valid-dump.html

1Z0-082 Exam Prep Guide: Prep guide for the 1Z0-082 Exam: https://drive.google.com/open?id=13QvNgwRqb5hx13Ml1LrVTB37BqRHjU6j