Oracle certification practice
1Z0-497 Practice Questions
Try 10 free 1Z0-497 exam-style questions for Oracle Database 12c Essentials. Check each answer and review the explanation and source references.
- Exam code
- 1Z0-497
- Provider
- Oracle
- Free questions
- 10
- Full set
- 150 questions
- Last update check
Which two options can you use to list Oracle Database 12c patches by using Queryable Patch
Inventory?
A DBA informs you that an Oracle instance has started. What does this imply?
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?
Your customer wants all email addresses from the database displayed as [hidden]@company.com.
What method of data redaction must you use?
Which targets can be managed by using Enterprise Manager Cloud Control?
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;
Which type of file system is NOT valid for storing data files, online redo log files, and control files for a
pluggable database?
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.
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?
Which two statements represent where Oracle Net must reside?
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.