A SQL Azure database generates an error when a row is inserted into any table in the database.  No error is generated when a row is deleted.  You need to recommend an approach for locating the source of the errors.  What 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.

A . YYYY-DD-MM:HH24:SS:MI  B . YYYY-DD-MM:HH24:SS:MM  C . YYYY-MM-DD:HH24:MI:SS  D . YYYY-DD-MM:SS:MI:HH24

A . The database must have multiplexed redo logs for the flashback to succeed. B . The database must be MOUNTED for the flashback to succeed. C . The database must use block change tracking for the flashback to succeed. D . The database must be opened in restricted mode for the flashback to succeed. E . The database must be opened with the RESETLOGS option after the flashback is complete. F . The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.

A .  Use SQL Server Profiler to identify missing indexes. B .  Use the Database Engine Tuning Advisor to identify missing indexes. C .  Use a Dynamic Management View to analyze query plans. D .  Use a DynamicManagement View to ascertain the number of pending I/O requests.

A . The CDB must be open. B . The CDB must be in the mount stage. C . The CDB must be in the nomount stage. D . Alt existing PDBs must be closed.

A .  It must be executed from the Oracle Database 11g environment. B .  It must be executed only after the SYSAUX tablespace has been created. C .  It must be executed from the environment of the database that is being upgraded. D .  It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces. E .  It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

A .  SYSDATE should not be used with TIMESTAMP. B .  The database must have multiplexed redo log files. C .  The database must be in the MOUNT state to execute the command. D .  The database must be opened with the RESETLOGS option after the flashback operation. E .  The entire database needs to be restored from the most recent backup before the flashback operation.

A .  Every SQL statement in the STS is considered only once for execution. B .  The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics. C .  The execution plan and execution statistics are computed for each SQL statement in the STS.  D .  The effects of DDL and DML are considered to produce the execution plan and execution statistics.

A . The database must have multiplexed redo log files B . The database must be in the MOUNT state to execute the command C . The database must be in the NOMOUNT state to execute the command D . The database must be opened in RESTRICTED mode before this operation E . The database must be opened with the RESETLOGS option after the flashback operatio

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

A . PMON coordinates media recovery. B . SMON coordinates instance recovery. C . PMON coordinates instance recovery. D . Undo Advisor would roll back all uncommitted transactions. E . SQL*PLUS reports an error with the message asking you to perform instance recovery.

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

A . It must be executed from the Oracle Database 11g environment. B . It must be executed only after the SYSAUX tablespace has been created. C . It must be executed from the environment of the database that is being upgraded. D . It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces. E . It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

A .  Create a database view to retrieve the data. B .  Use a clustered index on the SQL Azure database tables. C .  Open a new database connection when an operation times out. D .  Create SQL Azure database table indexes basedon application querie

A .  Use Microsoft ADO.NET connection pooling. B .  Pass exceptions to the user interface layer. C .  Implement a retry policy in the data access layer. D .  Begin a transaction before each data access operation.

A . Mysql＞ USE sakila; LOAD DATA INFILE 'sakila2013.sql'; B . Shell＞ mysql –u root –p sakila sakila2013.sql C . Shell＞ mysql import –u root –p sakila sakila2013.sql D . Shell＞ mysql –u root -p –e 'use sakila; source sakila2013.sql' E . Shell＞ mysql –u root –p –silent ＜ sakila2013.sql

A . DBCC DBREINDEX B . SELECT * FROM sys.dm_db_index_physical_stats C . DBCC INDEXDEFRAG D . SELECT * FROM sys.indexe

A . SYSDATE should not be used with TIMESTAMP. B . The database must have multiplexed redo log files. C . The database must be in the MOUNT state to execute the command. D . The database must be opened with the RESETLOGS option after the flashback operation. E . The entire database needs to be restored from the most recent backup before the flashback operation.

A . PMON coordinates media recovery. B . SMON coordinates instance recovery. C . PMON coordinates instance recovery. D . Undo Advisor would roll back all uncommitted transactions. E . SQL*PLUS reports an error with the message asking you to perform instance recovery.&e

A . Parallel compilation of only the stored PL/SQL code B . Sequential recompilation of only the stored PL/SQL code C . Parallel recompilation of any stored PL/SQL code D . Sequential recompilation of any stored PL/SQL code E . Parallel recompilation of Java code F . Sequential recompilation of Java code

A .  Use Dynamic Management Views to analyze performance issues. B .  Decrease the connection timeout in the database connection string. C .  Make sure the application is closing database connections that are not needed. D .  Use SQL Profiler to analyze performance issues by configuring it to connect to SQL Azure.

A .  The database must have multiplexed redo log files B .  The database must be in the MOUNT state to execute the command C .  The database must be in the NOMOUNT state to execute the command D .  The database must be opened in RESTRICTED mode before this operation E .  The database must be opened with the RESETLOGS option after the flashback operatio

A . User process B . Server process C . System Monitor (SMON) D . Process Monitor (PMON) E . Checkpoint process (CKPT)