Oracle 1z0-497 Exam Practice Questions (P. 4)
- Full Access (150 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 three statements represent the benefits of multitenant architecture for database consolidation?
- AYou 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.
- BYou can consolidate shared database memory by combining multiple PDBs in a single CDB.
- CPatching individual PDBs requires the same amount of time as patching individual databases.
- DConsolidating separate databases into a single CDB requires the same amount of storage allocation.
- EIn 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.
Correct Answer:
ABE
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.
References:
ABE
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.
References:
send
light_mode
delete
Question #17
Which statement about the Oracle Advanced Security Data Redaction feature is true?
- AIt transparently encrypts data at rest in Oracle databases.
- BIt securely manages encryption keys.
- CIt protects against theft or loss of disks and backups.
- DIt prevents OS users from inspecting tablespace files.
- EIt limits the exposure of sensitive data in applications.
- FIt alters data in caches, buffers, and persistent storage.
- GIt impacts operational activities such as backup & restore, upgrade & patch, and replication.
Correct Answer:
E
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.
References:
E
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.
References:
send
light_mode
delete
Question #18
Which three statements about Automatic Database Diagnostic Monitor (ADDM) are true?
- AIt requires the database to be open.
- BIt analyzes the performance of specified objects.
- CIt implements all recommendations automatically.
- DIt recommends solutions and quantifies expected benefits.
- EIt retains snapshots in the SYSAUX tablespace until the database is restarted.
- FIt analyzes the snapshots stored in the Automatic Workload Repository (AWR).
Correct Answer:
ADF
References:
ADF
References:
send
light_mode
delete
Question #19
Which is the default port number for Database Express?
send
light_mode
delete
Question #20
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?
- 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?
- AAutomatic Storage Management (ASM)
- BOnline Data and Application change
- CGlobal Data Services (GDS)
- DReal Application Clusters (RAC)
- EOracle Streams
- FOnline Table Redefinition
- GOracle Database Vault
Correct Answer:
ABDF
ABDF
send
light_mode
delete
All Pages