Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-071

Oracle 1z0-071 Exam Practice Questions (P. 2)

  • Full Access (272 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #6
Which two are true? (Choose two.)
  1. A
    CONCAT joins two character strings together.
  2. B
    CONCAT joins two or more character strings together.
  3. C
    FLOOR returns the largest positive integer less than or equal to a specified number.
  4. D
    INSTR finds the offset within a character string, starting from position 0.
  5. E
    INSTR finds the offset within a string of a single character only.
  6. F
    FLOOR returns the largest integer less than or equal to a specified number.

Correct Answer:
AF
chatbot-img GPT-4o - Answer
Understanding the functionality of CONCAT and FLOOR is crucial for database operations. CONCAT specifically combines exactly two strings, which validates option A. Regarding FLOOR, the function's purpose is to return the largest integer that is less than or equal to the specified number. This includes handling both positive and negative numbers. Applying FLOOR to -1.4 results in -2, perfectly aligning with its definition and confirming option F as correct. Thus, the correct pair for the question are options A and F, supporting string operations and numeric rounding respectively in SQL.

Question #7
Examine these SQL statements which execute successfully:

Which two statements are true after execution? (Choose two.)
  1. A
    The primary key constraint will be enabled and IMMEDIATE.
  2. B
    The foreign key constraint will be enabled and DEFERRED.
  3. C
    The primary key constraint will be enabled and DEFERRED.
  4. D
    The foreign key constraint will be disabled.
  5. E
    The foreign key constraint will be enabled and IMMEDIATE.

Correct Answer:
AD

Question #8
Examine this SQL statement:

Which two are true? (Choose two.)
  1. A
    All existing rows in the ORDERS table are updated.
  2. B
    The subquery is executed before the UPDATE statement is executed.
  3. C
    The subquery is not a correlated subquery.
  4. D
    The subquery is executed for every updated row in the ORDERS table.
  5. E
    The UPDATE statement executes successfully even if the subquery selects multiple rows.

Correct Answer:
AB

Question #9
Which two statements are true about TRUNCATE and DELETE? (Choose two.)
  1. A
    DELETE can use a WHERE clause to determine which row(s) should be removed.
  2. B
    TRUNCATE can use a WHERE clause to determine which row(s) should be removed.
  3. C
    TRUNCATE leaves any indexes on the table in an UNUSABLE state.
  4. D
    The result of a TRUNCATE can be undone by issuing a ROLLBACK.
  5. E
    The result of a DELETE can be undone by issuing a ROLLBACK.

Correct Answer:
AE
chatbot-img GPT-4o - Answer
Regarding DELETE and TRUNCATE statements, it's key to recognize their fundamental differences. Firstly, DELETE allows for selective removal of rows using a WHERE clause, offering a high level of control over what gets deleted. Furthermore, since DELETE is a DML operation, its actions are logged, allowing changes to be reversed with a ROLLBACK. On the other hand, TRUNCATE is a DDL operation that quickly removes all rows from a table but doesn't log individual row deletions, thus a ROLLBACK can't undo its effect. This distinction is crucial for deciding between TRUNCATE and DELETE based on the need for precision or efficiency.

Question #10
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?
  1. A
    WHERE TO_NUMBER(start_date - SYSDATE) <= 25
  2. B
    WHERE MONTHS_BETWEEN(start_date, SYSDATE) <= 25
  3. C
    WHERE MONTHS_BETWEEN(SYSDATE, start_date) <= 25
  4. D
    WHERE ADD_MONTHS(start_date, 25) <= SYSDATE

Correct Answer:
C
chatbot-img GPT-4o - Answer
Correct use of the `MONTHS_BETWEEN` function in Oracle SQL requires understanding that it returns the number of months between two dates where the first date is later than the second. In this scenario, `MONTHS_BETWEEN(SYSDATE, start_date)` is used, ensuring it shows the number of months since the `start_date` up to the current date, `SYSDATE`. By stipulating that this result must be 25 or fewer months, we are effectively filtering the records to include only those rows where `start_date` is within the last 25 months, corroborating with the scenario where the data was added relatively recently.

Previous Questions Next Questions

All Pages