Oracle 1z0-071 Exam Practice Questions (P. 4)
- 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 #16
Which two statements are true about Oracle synonyms? (Choose two.)
- AAny user can create a PUBLIC synonym.
- BA synonym has an object number.
- CAll private synonym names must be unique in the database.
- DA synonym can be created on an object in a package.
- EA synonym can have a synonym.
Correct Answer:
BE
BE
GPT-4o - Answer
Each synonym maintains its own object number, evidencing its individual identity within the Oracle database. Moreover, synonyms demonstrate flexibility in accessing database objects; a synonym can indeed point to another synonym, allowing layered referencing which simplifies SQL operations in more complex environments. Remember, this capacity emphasizes the abstraction and encapsulation possibilities inherent in Oracle's SQL environment. For clarity on the creation of synonyms on package components, while technically you can create a synonym targeting a component of a PL/SQL package, it won’t be functional or active.
Question #17
Which is true about the ROUND, TRUNC and MOD functions?
- ATRUNC(MOD(25,3),-1) is invalid.
- BROUND(MOD(25,3),-1) is invalid.
- CROUND(MOD(25,3),-1) and TRUNC(MOD(25,3),-1) are both valid and give the same result.
- DROUND(MOD(25,3),-1) and TRUNC(MOD(25,3),-1) are both valid but give different results.
Correct Answer:
C
C
GPT-4o - Answer
The ROUND and TRUNC functions in SQL can be paired with the MOD function efficiently. Both expressions in option C, ROUND(MOD(25,3),-1) and TRUNC(MOD(25,3),-1), function correctly and produce identical results since MOD(25,3) results in 1, and both ROUND and TRUNC, rounding or truncating to the nearest 10 (denoted by -1), will give a result of 0. Therefore, this demonstrates how these functions can interact seamlessly and equivalently when used in this manner.
Question #18
Which two are true about transactions in the Oracle Database? (Choose two.)
- ADML statements always start new transactions.
- BDDL statements automatically commit only data dictionary updates caused by executing the DDL.
- CA session can see uncommitted updates made by the same user in a different session.
- DA DDL statement issued by a session with an uncommitted transaction automatically commits that transaction.
- EAn uncommitted transaction is automatically committed when the user exits SQL*Plus.
Correct Answer:
DE
DE
GPT-4o - Answer
When a DDL statement is issued in a session that has uncommitted transactions, those transactions are automatically committed. This is an important feature to remember, as it ensures transactional consistency before schema changes take effect. Additionally, when exiting SQL*Plus, any uncommitted transactions are also automatically committed. This behavior underscores the importance of understanding the automatic commit triggers to effectively manage transactional integrity in Oracle Database.
Question #19
Examine the description of the MEMBERS table:
Examine the partial query:
SELECT city, last_name AS lname FROM members ...;
You want to display all cities that contain the string AN. The cities must be returned in ascending order, with the last names further sorted in descending order.
Which two clauses must you add to the query? (Choose two.)
Examine the partial query:
SELECT city, last_name AS lname FROM members ...;
You want to display all cities that contain the string AN. The cities must be returned in ascending order, with the last names further sorted in descending order.
Which two clauses must you add to the query? (Choose two.)
Question #20
Examine this partial command:
Which two clauses are required for this command to execute successfully? (Choose two.)
Which two clauses are required for this command to execute successfully? (Choose two.)
All Pages