Vendor: Oracle
Certifications: Oracle Certifications
Exam Name: Oracle Database 12cR2 Administration
Exam Code: 1Z0-072
Total Questions: 87 Q&As ( View Details)
Last Updated: Mar 15, 2025
Note: Product instant download. Please sign in and click My account to download your product.
VCE
Oracle 1Z0-072 Last Month Results
1Z0-072 Q&A's Detail
Exam Code: | 1Z0-072 |
Total Questions: | 87 |
Single & Multiple Choice | 87 |
CertBus Has the Latest 1Z0-072 Exam Dumps in Both PDF and VCE Format
1Z0-072 Online Practice Questions and Answers
The ORCL database has DEFERRED_SEGMENT_CREATION set to TRUE.
UNDOTBS2 is the active undo tablespace.
Examine these commands:
USER1 executes DML, which generates more than 2 MB of UNDO.
What is the result and why?
A. It suspends the transaction, which can be resumed by increasing the size of UNDOTBS2.
B. It returns an error because UNDOTBS2 is fixed size and has RETENTION GUARANTEE.
C. It suspends the transaction, which can be resumed by increasing USER1's quota on UNDOTBS2.
D. It returns an error because UNDOTBS2 has RETENTION GUARANTEE.
E. It suspends the transaction, which can be resumed by setting UNDOTBS1 as the active undo tablespace.
F. It returns an error because UNDOTBS2 is fixed size.
Which two are true about the roles? (Choose two.)
A. All privileges and roles granted to a user are enabled by default when the user logs in.
B. The SET ROLE statement can be used once per session.
C. The SET ROLE statement enables as well as disables roles in a session.
D. A role must be disabled before it can be revoked from a user.
E. The ALTER USER statement must be used to set specific default roles for a user.
In the ORCL database, UNDOTBS1 is the active undo tablespace with a fixed size of 70 MB and RETENTION GUARANTEE.
UNDO_RETENTION is set to 15 minutes and the tablespace does not have AUTOEXTEND on.
Which statement is true about a transaction if UNDOTBS1 fills with uncommitted undo within 10 minutes of the transaction's first update?
A. It succeeds and the generated undo is stored in SYSAUX.
B. It succeeds and the generated undo is stored in TEMP.
C. It fails and returns the error message "Snapshot too old".
D. It succeeds and the generated undo is stored in SYSTEM.
E. It fails and returns the error message "ORA=30036": unable to extend segment by 8 in undo tablespace `UNDOTBS1'".
F. It succeeds and the least recently used undo block UNDOTBS1 is overwritten by the generated undo.
Which is true about revoking roles?
A. Only users who are granted the DBA role can revoke a role.
B. Only users who are granted SYSDBA can revoke a role.
C. Users who have the GRANT ANY ROLE privilege can revoke any role.
D. Users who are granted a role with ADMIN OPTION can revoke that role only from users to whom they have granted the role.
E. Users can revoke a role that is granted to them through other roles.
Which two can you use to recover a dropped table? (Choose two.)
A. FLASHBACK QUERY
B. FLASHBACK DATABASE
C. FLASHBACK TRANSACTION
D. FLASHBACK TABLE TO SCN
E. FLASHBACK DROP
Add Comments
I love this dumps. It really helpful and convenient. Recommend strongly.
I signed up for the exam and ordered dumps from this site. I never attended any bootcamp or classes geared to exam or material preparation. However, I was shocked to find all the time, money and energy people spent preparing to take this test. Honestly, it started to make me nervous, however, it was too late to turn back. I just bought this and read it in 6-days, and I took the exam on the 7th day. That was enough. Just go through the dumps and take the test.
HIGHLY recommend. Each question is centered around something that must be known for the 1Z0-072 exam. Each answer is clear, concise, and contains all needed steps in a manner pertinent to the subjects. One thing need to be improved is there are no explanations for each question. Only explanations for some questions. It would be better if you give explanations to every question.
Three new questions. Just easy questions so you do not need to worry. I joined the training courses for about 2 weeks and then use these dumps to practice the questions. The questions are valid. No incorrect answers like someone said in the forum. You can trust on this. Questions may change in the real exam so you need to read that carefully. Be sure to pay attention to the sequence of the options. May change in the actual exam, too.
I studied this 1Z0-072 material carefully and took every question seriously. At last, I passed the exam with high score. Prepare well and study much more.
This dumps is very very valid. I passed this week with a satisfied score. ALL questions were from this file.
One new question in the exam. 100% valid dumps. Passed my exam with full score. Thanks so much for your valid questions and accurate answers. I will recommend this to all my friends. One suggestion: it will be greater if you can send the unlocked version earlier. Anyway, you've done a great job. Thanks again.
I have studied every question and answer and I suggest you to go through each question, too. So when you seated for exam, you will be more confident. It will increase the chance to pass your exam. I passed the exam with high score without doubt. If you want to pass the exam like me, just try their dumps.
Already passed my 1Z0-072 exam. Valid dumps. Good site. Thanks, guys.
The dumps is great, they contain a very good knowledge about the exam. However, most of the materials are the same from the previous version. There are some new questions, and the organization of the pattern is much better than the older one. I'd say this dumps may contain 15-20 percent new materials, the rest is almost identical to the old one.