ITPub博客

[AlwaysOn] 创建SQL Server高可用性组T-SQL语法：BASIC参数

[AlwaysOn] 创建SQL Server高可用性组T-SQL语法：DTC_SUPPORT参数

[AlwaysOn] 创建SQL Server高可用性组T-SQL语法：DB_FAILOVER参数

[AlwaysOn] 创建SQL Server高可用性组T-SQL语法：HEALTH_CHECK_TIMEOUT参数

[AlwaysOn] 创建SQL Server高可用性组T-SQL语法：FAILURE_CONDITION_LEVEL参数

[AlwaysOn] 创建SQL Server高可用性组T-SQL语法：AUTOMATED_BACKUP_PREFERENCE参数

[AlwaysOn] 创建SQL Server高可用性组T-SQL语法：group_name参数

[AlwaysOn] 创建SQL Server AlwaysOn高可用性组T-SQL语法

对数据库来说，隐式转换引起执行结果错误，都是一个严重的错误。

3.Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors:ORA-00313: open failed for members of log group 1 of thread 1ORA-00312: online log 1 thread 1: 'D:\REDO01.LOG...

159.Which package provides API's for the SQL Tuning Advisor?A. DBMS_MONITORB. DBMS_STATSC. DBMS_SQLTUNED. DBMS_ADVISORAnswer: C 哪个包提供SQL调优顾问的API？A. DBMS_MONITORB. DBMS_STATS        收集统计信息C. DBMS_SQLTUNE   &...

138.You are working on the APPDB database as a DB A. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop theFlashback Archive FLA1:DROP FLASHBACK ARCHIVE fla1;What is the effect of this command?A. The Flashback Archive FLA1 is dropped on...

137.Your company wants to upgrade the current production database to the RAC environment. To perform testing before migrating to the RAC environment, you performed the workload capture on the production database to record the peak workload. You set up the test RAC database and want to replay the rec...

498.The database Is configured in ARCHIVELOG mode. The database needs to be up 24 X 7. You want to perform user managed backup for the data files of the HR_DATA tablespace. To accomplish the task, you issued the following command:SQL> ALTER TABLESPACE hi_data BEGIN BACKUP;Which two statements are ...

680.Which two operations are NOT performed by the DUPLICATE command in Recovery Manager(RMAN) while duplicating a running database? (Choose Two)A.Creating the control file for the duplicate databaseB.Restoring the target data files to the duplicate databaseC.Performing complete recovery using all...

641.Which three functions are performed by the SQL Tuning Advisor? (Choose three.)A. Building the SQL profileB. Recommending optimization of materialized viewsC. Checking query objects for missing and stale statisticsD. Recommending bitmap, function-based, and B-tree indexesE. Recommending rest...

628.The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;Which action ...

91.Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:SQL> SELECT * FROM sales;Which process would retrieve the result from the database and return it to the client program?A. User processB. Server processC. System Monitor (SMON)D. Proce...

76.Identify three key features of ASM. (Choose three.)A. file stripingB. allocation unit mirroringC. automatic disk rebalancingD. automatic file size incrementE. automatic undo managementAnswer: ABC在ASM 中，条带化主要具有两种用途：? 在磁盘组的所有磁盘中执行I/O 负载平衡。? 改善I/...

360.When performing a full database disaster recovery with RMAN, in what order would you execute these steps?a. Restore the control file from autobackups.b. Run the RMAN restore and recover command.c. Restore the database spfile from autobackups.d. Make the RMAN backup set pieces available.e. O...