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

  • 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 #21
Which two are true about unused columns? (Choose two.)
  1. A
    A query can return data from unused columns, but no DML is possible on those columns.
  2. B
    Unused columns retain their data until they are dropped.
  3. C
    Once a column has been set to unused, a new column with the same name can be added to the table.
  4. D
    The DESCRIBE command displays unused columns.
  5. E
    A primary key column cannot be set to unused.
  6. F
    A foreign key column cannot be set to unused.

Correct Answer:
BC
Reference:
https://decipherinfosys.wordpress.com/2007/11/15/back-to-the-basics-dropping-unused-columns-in-oracle/

Question #22
Which two are true about the precedence of operators and conditions? (Choose two.)
  1. A
    || has a higher order of precedence than + (addition).
  2. B
    + (addition) has a higher order of precedence than * (multiplication).
  3. C
    NOT has a higher order of precedence than AND and OR in a condition.
  4. D
    AND and OR have the same order of precedence in a condition.
  5. E
    Operators are evaluated before conditions.

Correct Answer:
CE
chatbot-img GPT-4o - Answer
When examining operator precedence in SQL, it's crucial to grasp that operators indeed have precedence over conditions during expression evaluation. Specifically, the NOT operator holds priority over AND and OR, effectively clarifying logical evaluation in statements. Maintaining awareness of this structure ensures the correct interpretation and intended outcomes of complex SQL queries. This knowledge is fundamental for writing precise and efficient SQL code, aligning with SQL best practices.

Question #23
In your session, the NLS_DATE_FORMAT is DD-MM-YYYY.
There are 86400 seconds in a day.
Examine this result:

DATE -
-----------
02-JAN-2020
Which statement returns this?
  1. A
    SELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '4' DAY - INTERVAL '120' SECOND, 'DD-MON-YYYY') AS "date" FROM DUAL;
  2. B
    SELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '3' MONTH + INTERVAL '7' DAY - INTERVAL '360' SECOND, 'DD-MON-YYYY') AS "date" FROM DUAL;
  3. C
    SELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '5' DAY - INTERVAL '120' SECOND, 'DD-MON-YYYY') AS "date" FROM DUAL;
  4. D
    SELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '5' DAY - INTERVAL '86410' SECOND, 'DD-MON- YYYY') AS "date" FROM DUAL;
  5. E
    SELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '6' DAY - INTERVAL '120' SECOND, 'DD-MON-YYYY') AS "date" FROM DUAL;

Correct Answer:
C
chatbot-img GPT-4o - Answer
Option C precisely achieves the desired result of giving the date '02-JAN-2020'. The process begins by converting '29-10-2019' to a date using TO_DATE. Adding '2' months jumps to '29-12-2019', and a further addition of '5' days results in '03-01-2020'. Subtracting '120' seconds (equivalent to two minutes) pulls the date back to just before midnight on '02-01-2020', hence producing the accurate result when formatted with 'DD-MON-YYYY'. It's a good example of manipulating date intervals and formats in SQL, which is essential for handling time-sensitive data correctly.

Question #24
Examine the data in the INVOICES table:

Examine the data in the CURRENCIES table:

Which query returns the currencies in CURRENCIES that are not present in INVOICES?
A.

B.

C.

D.


Correct Answer:
C

Question #25
The SALES table has columns PROD_ID and QUANTITY_SOLD of data type NUMBER.
Which two queries execute successfully? (Choose two.)
  1. A
    SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*) > 10 GROUP BY COUNT(*) > 10;
  2. B
    SELECT prod_id FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id HAVING COUNT(*) > 10;
  3. C
    SELECT COUNT(prod_id) FROM sales GROUP BY prod_id WHERE quantity_sold > 55000;
  4. D
    SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*) > 10 GROUP BY prod_id HAVING COUNT(*) > 10;
  5. E
    SELECT COUNT(prod_id) FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id;

Correct Answer:
BE
chatbot-img GPT-4o - Answer
The correct query options B and E utilize fundamental SQL syntax appropriately. Option B effectively filters individual records with the WHERE clause before applying the GROUP BY clause, which organizes the results by prod_id, and then uses the HAVING clause, which is correctly used to filter groups formed by GROUP BY based on the aggregate function, COUNT(*). Similarly, option E employs the WHERE clause to initially filter the rows, followed by performing an aggregate function, COUNT(prod_id), on the grouped data by prod_id. This demonstrates standard SQL practices for grouping and filtering data.

Previous Questions Next Questions

All Pages