-
You are planning the migration of a Microsoft SQL Server 2008 database to SQL Azure. You need to recommend an approach for ensuring that database connectivity does not degrade. Which two actions should you recommend?()
A . Implement transactions for database queries.
B . Close database connections in the application.
C . Use Microsoft ADO.NET in the data access layer.
D . Implement a retry policy in the data access layer.
-
To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file?()
A . Multiple change tracking files can be created for a database.
B . The change tracking file must be created after the first level 0 backup.
C . RMAN does not support backup and recovery of the change tracking file.
D . The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.
-
Which two statements describe good practices for an application developer to reduce lockingconflicts in Oracle database()
A . Avoid coding unnecessary long-running transactions.
B . Allow the database to handle locks in default locking mode.
C . Always explicitly code the locks as per the requirement of the application.
D . Allow escalation of row locks to block locks if too many row locks cause problem.
-
In an environment that includes both a Master Domain Manager (MDM) and Backup Master Domain Manger (BMDM), which two options are appropriate for the location of the database? ()
A . local database installed on the MDM only
B . live local database installed on the BMDM only
C . single database on a clustered machine remote from the MDM and BMDM
D . live database installed on a single Fault Tolerant Agent within IBM Tivoli Workload Scheduler network
E . live database on MDM and High Availability Disaster Recovery/Data Guard standby database on BMDM
-
You need to turn on Tracing for a page that is not performing well. You must store the trace information in a database for reporting and trending. Which two actions should you perform?()
A . Add a TraceContextEventHandler to the Trace.TraceFinished event to add the trace records into the database.
B . Add a system.diagnostics section to the Web.config file. Then add a listener to the new section.
C . Use the System.Diagnostics.Trace object to connect to a database. Then insert the trace records.
D . In the Page_Load for the page, place the Trace.Write call into a SQL INSERT statement.
-
You work as a database administrator for Supportcenter.cn. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this?()
A . Set the UNDO_RETENTION parameter to AUTO.
B . Create an initial undo segment in undotablespace.
C . Set the UNDO_RETENTION parameter to 900 or more
D . Set the initialization parameter UNDO_MANAGEMENT to AUTO
E . Set the UNDO_MANAGEMENT parameter to the name of an undotablespace
-
Which two files in the database can be configured for automatic backups by using the autobackupfeature in Recovery Manager (RMAN)()
A . data files
B . control files
C . parameter file
D . online redo log files
E . server parameter file
-
After performing a clean shut down of the database instance for maintenance, you mount thedatabase and then execute a command to open the database: SQL> ALTER DATABASE OPEN; Which two statements are true()
A . The online redo log files and online data files are opened.
B . All the online data file headers are checked for consistency.
C . Instance recovery is performed before opening the database.
D . The path and existence of all the log file members are checked
-
You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?()
A . User session data
B . Stack space
C . Private SQL area
D . Location of the runtime area for DML and DDL Statements
E . Location of a part of the runtime area for SELECT statement
-
After performing a clean shut down of the database instance for maintenance, you mount the database andthen execute a command to open the database:SQL> ALTER DATABASE OPEN; Which two statements are true()
A . The online redo log files and online data files are opened.
B . All the online data file headers are checked for consistency.
C . Instance recovery is performed before opening the database.
D . The path and existence of all the log file members are checked
-
Which two requirements are critically important to implement for your database backup strategy if you require a 24 hours a day, 7 days a week production environment?()
A . ARCHIVELOG mode.
B . NOARCHIVELOG mode.
C . Open database backups.
D . Consistent whole backups.
-
The RECYCLEBIN parameter is set to ON for your database. You drop a table,PRODUCTS,from the SCOTT schema. Which two statements are true regarding the outcome of this action?()
A . All the related indexes and views are automatically dropped
B . The flashback drop feature can recover only the table structure
C . Only the related indexes are dropped whereas views are invalidated
D . The flashback drop feature can recover both the table structure and its data
-
The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover?()
A . Restore the data file and perform incomplete recovery.
B . Restore the data file and perform point-in-time recover.
C . Drop the tablespace and lose all data in the tablespace.
D . Restore the database and lose all data since the last backup.
-
The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? ()(Choose two)
A . All the related indexes and views are automatically dropped
B . The flashback drop feature can recover only the table structure
C . Only the related indexes are dropped whereas views are invalidated
D . The flashback drop feature can recover both the table structure and its data
-
To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file? ()(Choose two.)
A . Multiple change tracking files can be created for a database.
B . The change tracking file must be created after the first level 0 backup.
C . RMAN does not support backup and recovery of the change tracking file.
D . The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.
-
You are working on a database that must be functioning 24 hours a day, 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups()
A . You can perform consistent backups only.
B . You can perform a complete database backup without shutting down the database instance.
C . You can back up data files only when all data files have the same SCN recorded in the control file.
D . You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP command
-
When a database administrator chooses the dimensions for an MDC table, which two characteristics should beconsidered?()
A . the query transaction rate
B . numeric data versus character data
C . extent size
D . the cardinality of the candidate columns
E . prefetch size&e
-
You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?()
A . Corrupted blocks, if any, are repaired.
B . Checks are performed for physical corruptions.
C . Checks are performed for logical corruptions.
D . Checks are performed to confirm whether all database files exist in correct locations
E . Backup sets containing both data files and archive logs are created.
-
To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change tracking file?()
A . Multiple change tracking files can be created for a database.
B . The change tracking file must be created after the first level 0 backup.
C . RMAN does not support backup and recovery of the change tracking file.
D . The database clears the change tracking file and starts tracking changes again,after whole database restore and recovery operations.
-
Which two statements are true concerning the Resource Manager plans for individual pluggabledatabases (PDB plans) in a multitenant container database (CDB)?()
A . If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that pdb.
B . In a PDB plan, subplans may be used with up to eight consumer groups.
C . If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the cdb.
D . If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
E . If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.
-
Examine the values for the following initialization parameters: FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0 Which two will be the implications of these values in your database()
A . The SGA advisor will be disabled.
B . The MTTR advisor will be disabled.
C . Automatic checkpoint tuning will be disabled.
D . Checkpoint information will not be written to the alert log file.
-
Which two files in the database can be configured for automatic backups by using the autobackup feature inRecovery Manager (RMAN)()
A . Data files
B . Control files
C . Parameter file
D . Online redo log files
E . Server parameter file
-
Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:Which two statements are true about redefining the table?()
<img src='https://img2.soutiyun.com/shangxueba/ask/64224001-64227000/64224740/398a37009eba261eceebfd5a001edaba.png' />
<img src='https://img2.soutiyun.com/shangxueba/ask/64224001-64227000/64224740/a5add098aa6143b225044036df53c199.png' />
A. All the triggers for the table are disabled without changing any of the column names or column types in the table.
B. The primary key constraint on the EMPLOYEES table is disabled during redefinition.
C. VPD policies are copied from the original table to the new table during online redefinition.
D. You must copy the VPD policies manually from the original table to the new table during online redefinition.
-
Flashback is enabled for your multitenant container database (CDB), which contains two plu
Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:SQL > SHUTDOWN IMMEDIATE SQL > STARTUP MOUNT SQL > FLASHBACK DATABASE to TIME TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”;Examine following commands:1. ALTER PLUGGABLE DATABASE ALL OPEN;2. ALTER DATABASE OPEN;3. ALTER DATABASE OPEN RESETLOGS;Which command or commands should you execute next to allow updates to the flashback back schema?()
A. Only 1
B. Only 2
C. Only 3
D. 3 and 1
E. 1 and 2