Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
All Vendors
  2. Home
  3. Exams
  4. Oracle
  5. 1Z0-497

Free Oracle 1Z0-497 Exam Braindumps (page: 5)

Page 5 of 31
PDF with 150 Questions

Which three statements represent the benefits of multitenant architecture for database consolidation?

  1. You can unplug a PDB from a development CDB and plug it into a production CDB, which allows for easier and more rapid movement of data and code.
  2. You can consolidate shared database memory by combining multiple PDBs in a single CD
  3. Patching individual PDBs requires the same amount of time as patching individual databases.
  4. Consolidating separate databases into a single CDB requires the same amount of storage allocation.
  5. In multitenant architecture, a PDB behaves the same as a non-CDB as seen from a client connecting with Oracle Net. No client modification is required.

Answer(s): A,B,E

Explanation:

By design, you can quickly plug a PDB into a CDB, unplug the PDB from the CDB, and then plug this PDB into a different CDB. The implementation technique for plugging and unplugging is similar to the transportable tablespace technique.
A PDB is a portable collection of schemas, schema objects, and nonschema objects that appears to an Oracle Net client as a non-CDB. All Oracle databases before Oracle Database 12c were non-CDBs.


Reference:

Benefits of the Multitenant Architecture for Database Consolidation URL: http://docs.oracle.com/cd/E16655_01/server.121/e17633/cdbovrvw.htm#CNCPT89239



Which statement about the Oracle Advanced Security Data Redaction feature is true?

  1. It transparently encrypts data at rest in Oracle databases.
  2. It securely manages encryption keys.
  3. It protects against theft or loss of disks and backups.
  4. It prevents OS users from inspecting tablespace files.
  5. It limits the exposure of sensitive data in applications.
  6. It alters data in caches, buffers, and persistent storage.
  7. It impacts operational activities such as backup & restore, upgrade & patch, and replication.

Answer(s): E

Explanation:

Redacting Sensitive Data for Display
Data Redaction provides selective, on-the-fly redaction of sensitive data in query results prior to display by applications so that unauthorized users cannot view the sensitive data. It enables consistent redaction of database columns across application modules accessing the same data. Data Redaction minimizes changes to applications because it does not alter actual data in internal database buffers, caches, or storage, and it preserves the original data type and formatting when transformed data is returned to the application. Data Redaction has no impact on database operational activities such as backup and restore, upgrade and patch, and high availability clusters.


Reference:

Oracle Advanced Security, 12c, Oracle Data Sheet



Which three statements about Automatic Database Diagnostic Monitor (ADDM) are true?

  1. It requires the database to be open.
  2. It analyzes the performance of specified objects.
  3. It implements all recommendations automatically.
  4. It recommends solutions and quantifies expected benefits.
  5. It retains snapshots in the SYSAUX tablespace until the database is restarted.
  6. It analyzes the snapshots stored in the Automatic Workload Repository (AWR).

Answer(s): A,D,F


Reference:

http://docs.oracle.com/cd/B19306_01/server.102/b14211/diagnsis.htm



Which is the default port number for Database Express?

  1. 7801
  2. 5500
  3. 2243
  4. 1521
  5. 22

Answer(s): B


Reference:

http://dbasolved.com/2013/07/05/em-express-12c-edition/



Your customer is looking for a solution to address these downtime needs:
- Online addition and removal of disks should automatically rebalance data across new storage configurations while storage, database, and applications remain online.
- Dynamically add or remove clustered nodes without disrupting the database or applications.
- Automate the sizing and distribution of shared memory.
- Add a column with a default value without disrupting the database or applications.
- Perform rolling patch upgrades.
Which four would you recommend to address those needs?

  1. Automatic Storage Management (ASM)
  2. Online Data and Application change
  3. Global Data Services (GDS)
  4. Real Application Clusters (RAC)
  5. Oracle Streams
  6. Online Table Redefinition
  7. Oracle Database Vault

Answer(s): A,B,D,F



Viewing page 5 of 31
Viewing questions 21 - 25 out of 150 questions



Post your Comments and Discuss Oracle 1Z0-497 exam prep with other Community members:

1Z0-497 Exam Discussions & Posts