Oracle 1z0-071 Exam Practice Questions (P. 1)
- 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
Question #1
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.)

You want to display the unique promotion costs in each promotion category.
Which two queries can be used? (Choose two.)
- ASELECT DISTINCT promo_category || ' has ' || promo_cost AS COSTS FROM promotions ORDER BY 1;Most Voted
- BSELECT DISTINCT promo_cost || ' in ' || DISTINCT promo_category FROM promotions ORDER BY 1;
- CSELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;Most Voted
- DSELECT promo_category DISTINCT promo_cost, FROM promotions ORDER BY 2;
- ESELECT promo_cost, promo_category FROM promotions ORDER BY 1;
Correct Answer:
AC
AC
send
light_mode
delete
Question #2
Examine the description of the PRODUCTS table:

Which three queries use valid expressions? (Choose three.)

Which three queries use valid expressions? (Choose three.)
- ASELECT product_id, unit_price, S "Discount", unit_price + surcharge - discount FROM products;
- BSELECT product_id, (unit_price * 0.15 / (4.75 + 552.25)) FROM products;Most Voted
- CSELECT product_id, (expiry_date - delivery_date) * 2 FROM products;Most Voted
- DSELECT product_id, unit_price || 5 "Discount", unit_price + surcharge - discount FROM products;
- ESELECT product_id, expiry_date * 2 FROM products;
- FSELECT product_id, unit_price, unit_price + surcharge FROM products;Most Voted
Correct Answer:
BCF
BCF
send
light_mode
delete
Question #3
What is true about non-equijoin statement performance? (Choose two.)
- AThe BETWEEN condition always performs less well than using the >= and <= conditions.
- BThe BETWEEN condition always performs better than using the >= and <= conditions.
- CThe Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.
- DTable aliases can improve performance.Most Voted
- EThe join syntax used makes no difference to performance.Most Voted
Correct Answer:
DE
DE

Table aliases do indeed enhance the performance of SQL queries, primarily by simplifying the query parsing process. When aliases are used, the SQL parser can more efficiently identify which columns belong to which tables, especially in complex queries with multiple tables. This optimization reduces the workload on the parser and can lead to quicker execution times. Additionally, the choice of join syntax (Oracle's versus ANSI's) generally does not impact performance, as the database's optimizer evaluates the best execution path regardless of syntax style. Both of these points are crucial for optimizing SQL query performance in Oracle.
send
light_mode
delete
Question #4
Which two are true? (Choose two.)
- AADD_MONTHS adds a number of calendar months to a date.Most Voted
- BCEIL requires an argument which is a numeric data type.
- CCEIL returns the largest integer less than or equal to a specified number.
- DLAST_DAY returns the date of the last day of the current month only.
- ELAST_DAY returns the date of the last day of the month for the date argument passed to the function.Most Voted
- FLAST_DAY returns the date of the last day of the previous month only.
Correct Answer:
AC
Reference:
https://docs.oracle.com/database/121/SQLRF/functions025.htm
https://docs.oracle.com/cd/B28359_01/server.111/b28286/functions004.htm
AC
Reference:
https://docs.oracle.com/database/121/SQLRF/functions025.htm
https://docs.oracle.com/cd/B28359_01/server.111/b28286/functions004.htm
send
light_mode
delete
Question #5
Which three statements are true about Oracle synonyms? (Choose three.)
- AA synonym cannot be created for a PL/SQL package.
- BA synonym can be available to all users.Most Voted
- CA SEQUENCE can have a synonym.Most Voted
- DAny user can drop a PUBLIC synonym.
- EA synonym created by one user can refer to an object belonging to another user.Most Voted
Correct Answer:
BCE
BCE

Correct understanding of Oracle synonyms is pivotal. A synonym allows users to access objects with different names which is useful to mask the real names and simplify SQL commands. Particularly, a public synonym, as option B indicates, is accessible by all users in the database, which is a point of convenience and efficiency. Options C and E are also correct, with C highlighting that even sequences can have synonyms, expanding versatility, and E demonstrating that synonyms can allow a user to access objects from different schemas, enhancing cross-user functionality without multiple permissions.
send
light_mode
delete
All Pages