Free preview mode

Enjoy the free questions and consider upgrading to gain full access!

1z0-082Free trialFree trial

By oracle
Aug, 2025

Verified

25Q per page

Question 26

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

  • A: An index can be created as part of a CREATE TABLE statement.
  • B: If a query filters on an indexed column, then it will always be used during execution of the query.
  • C: A descending index is a type of function-based index.
  • D: A DROP INDEX statement always prevents updates to the table during the drop operation.
  • E: A UNIQUE and non-unique index can be created on the same table column.
  • F: An INVINSIBLE INDEX is not maintained when Data Manipulation Language (DML) is performed on its underlying table.
—

Question 27

Which three actions are ways to apply the principle of least privilege? (Choose three.)

  • A: setting the O7_DICTIONARY_ACCESSIBILITY parameter to true
  • B: setting the REMOTE_OS_AUTHENT parameter to true
  • C: revoking execute privilege on UTL_SMTP, UTL_TCP, UTL_HTTP, and UTL_FILE from the SYSTEM user
  • D: enabling Unified Auditing
  • E: using Access Control Lists (ACLs)
  • F: revoking execute privilege on UTL_SMTP, UTL_TCP, UTL_HTTP, and UTL_FILE from the public user
—

Question 28

The STORES table has a column START_DATE of data type DATE, containing the date the row was inserted.

You only want to display details of rows where START_DATE is within the last 25 months.

Which WHERE clause can be used?

  • A: WHERE ADD_MONTHS(start_date, 25) <= SYSDATE
  • B: WHERE MONTHS_BETWEEN(start_date, SYSDATE) <= 25
  • C: WHERE MONTHS_BETWEEN(SYSDATE, start_date) <=25
  • D: WHERE TO_NUMBER(start date - SYSDATE) <= 25
—

Question 29

Examine the description of the BOOKS_TRANSACTIONS table:

Image 1

Examine this partial SQL statement:

SELECT * FROM books_transactions

Which two WHERE conditions give the same result? (Choose two.)

  • A: WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM' AND member_id = 'A101' OR member_id = 'A102');
  • B: WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' OR member_id IN ('A101', 'A102');
  • C: WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM' AND (member_id = 'A101' OR member_id = 'A102'));
  • D: WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM' OR menber_id IN ('A101', 'A102'));
  • E: WHERE (borrowed_date = SYSDATE AND transaction_type - 'RM') OR member_id IN ('A101', VA102');
—

Question 30

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

  • A: The WITH CHECK clause prevents certain rows from being updated or inserted in the underlying table through the view.
  • B: The WITH CHECK clause prevents certain rows from being displayed when querying the view.
  • C: Views can be updated without the need to re-grant privileges on the view.
  • D: A view must only refer to tables in its defining query.
  • E: Views can be indexed.
—

Question 31

Which compression method is recommended for Direct-Path Insert operations?

  • A: ROW STORE COMPRESS BASIC
  • B: ROW STORE COMPRESS ADVANCED
  • C: COLUMN STORE COMPRESS ADVANCED
  • D: COLUMN STORE COMPRESS BASIC
—

Question 32

Which three statements are true about Deferred Segment Creation in Oracle databases? (Choose three.)

  • A: It is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces.
  • B: It is the default behavior for tables and indexes.
  • C: Sessions may dynamically switch back and forth from DEFERRED to IMMEDIATE segment creation.
  • D: Indexes inherit the DEFERRED to IMMEDIATE segment creation attribute from their parent table
  • E: It is supported for SYS-owned tables contained in locally managed tablespaces.
—

Question 33

Examine these statements executed in a single Oracle session:

Image 1

Which three statements are true? (Choose three.)

  • A: The code for pen is 10.
  • B: There is no row containing fountain pen.
  • C: There is no row containing pen.
  • D: The code for fountain pen is 3.
  • E: The code for pen is l.
  • F: There is no row containing pencil.
—

Question 34

Examine the description of the SALES1 table:

Image 1

SALES2 is a table with the same description as SALES1.

Some sales data is contained erroneously in both tables.

You must display rows from SALES1 and SALES2 and wish to see the duplicates too.

Which set operator generates the required output?

  • A: UNION ALL
  • B: SUBTRACT
  • C: MINUS
  • D: UNION
  • E: INTERSECT
—

Question 35

You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed.
The variables used in your query are never undefined in your session.
Which query can be used?

  • A: SELECT &&col1, &&col2 FROM &table WHERE &&condition = &&cond;
  • B: SELECT &col1, &col2 FROM &&table WHERE &condition;
  • C: SELECT &col1, &col2 FROM ג€&tableג€ WHERE &condition;
  • D: SELECT '&&col1', '&&col2' FROM &table WHERE '&&condition' = '&cond';
  • E: SELECT &&col1, &&col2 FROM &table WHERE &&condition;
—

That’s the end of your free questions

You’ve reached the preview limit for 1z0-082

Consider upgrading to gain full access!

Page 2 of 7 • Questions 26-50 of 173
←
12345
→

Free preview mode

Enjoy the free questions and consider upgrading to gain full access!