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: https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/1Z0-082/page_5_img_1.jpg Which statement is true?

The LREG process registers services dynamically with the LISTENER_1 listener

Dynamic service registration cannot be used for this database instance

The LREG process registers services dynamically with the LISTENER_1 listener

LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration

There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances

The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration

Examine the description of the PROMOTIONS table: https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/1Z0-082/page_23_img_1.jpg You want to display the unique promotion costs in each promotion category. Which two queries can be used? (Choose two.)

SELECT DISTINCT promo_category || ‘ has ‘ || promo_cost AS COSTS FROM promotions ORDER BY 1;

SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

SELECT promo_cost, promo_category FROM promotions ORDER BY by 1;

SELECT DISTINCT promo_cost || ’ in ‘ || DISTINCT promo_category FROM promotions ORDER BY 1;

SELECT DISTINCT promo_category || ‘ has ‘ || promo_cost AS COSTS FROM promotions ORDER BY 1;

SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;

SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

View 1Z0-082 Exam Questions

Q: 1

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?

Options

Q: 2

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

Options

Q: 3

In one of your databases, the user HR has the password HRMGR. You want to connect to a database instance whose listener listens on port 1531 by using this statement: CONNECT HR/HRMGR@orcl No name server is used. Which statement is true about ORCL?

Options

Q: 4

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE. You want to display the date of the first Monday after the completion of six months since hiring. The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day on the week. Which query can be used?

Options

Q: 5

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

Options

Q: 6

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

Options

Q: 7

In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespaces are smallfile tablespaces. SALES_Q1 is a permanent user-defined tablespace in the SALES database. Examine this command which is about to be issued by a DBA logged in to the SALES database: ALTER TABLESPACE sales_q1 ADD DATAFILE; Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)

Options

Q: 8

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

Options

Q: 9

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.)

Options

Q: 10

Which two statements are true about single row functions? (Choose two.)

Options

Question 1 of 20 · Page 1 / 2

Premium Access Includes

✓ Quiz Simulator
✓ Exam Mode
✓ Progress Tracking
✓ Question Saving
✓ Flash Cards
✓ Drag & Drops
✓ 3 Months Access
✓ PDF Downloads

Get Premium Access

Premium Access Includes

FLASH OFFER

avail 10% DISCOUNT on YOUR PURCHASE