ORACLE certification preparation
1Z0-497 Practice Questions
Practice exam-style questions, check your answers, and review explanations and source references where they are available.
- Exam
- 1Z0-497
- Provider
- ORACLE
- Full set
- 150 questions
- Last Update Check
Which two options can you use to list Oracle Database 12c patches by using Queryable Patch
Inventory?
Question 1 discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
A DBA informs you that an Oracle instance has started. What does this imply?
Question 2 discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
You have two database servers EMP and EXP. A user of the database from the EXP server wants to
extract some information from the database in the EMP server for cross-verification. Which schema
object enables the user to access the information from the remote database?
Question 3 discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Your customer wants all email addresses from the database displayed as [hidden]@company.com.
What method of data redaction must you use?
Question 4 discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Which targets can be managed by using Enterprise Manager Cloud Control?
Question 5 discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
What happens if you execute these SQL statements?
SQL> show con_name
CON_NAME
--------------------------------
CDB$ROOT
SQL> create user 1_freed identified by y container=current;
Question 6 discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Which type of file system is NOT valid for storing data files, online redo log files, and control files for a
pluggable database?
Question 7 discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
When you start up a CDB, which operations are performed automatically and in what order?
a - The instance is started.
b - Control files are opened.
c - The root container is opened (redo logs and root data files).
d - Seed pluggable database is in READ ONLY mode.
e - Other PDBs are still in MOUNTED mode.
f - Triggers may fire if they exist to open other PDBs.
Question 8 discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Your customer wants to migrate their production database from Oracle Database 10gon AIX to Oracle
Database 12con Solaris, and is concerned about the downtime. Which Oracle solution would you
recommend?
Question 9 discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Which two statements represent where Oracle Net must reside?
Question 10 discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Question 1 of 10
Source context
How this practice set is maintained
Maintained by the CertMage content team, this page loads questions from the exam dataset connected to its preparation resource. When an answer includes a supporting reference, it is shown with that answer so you can review the underlying vendor documentation.
Certification objectives, interfaces, and vendor services can change. Verify important details against the provider's current exam guide and documentation before your exam.