Sail E0 Webinar

MCQs

Total Questions : 11 | Page 1 of 2 pages
Question 1. How many types of backups are provided by SQL Server ?
  1.    5
  2.    6
  3.    7
  4.    8
 Discuss Question
Answer: Option D. -> 8


DatabaseBackup is the SQL Server Maintenance Solution's stored procedure for backing up databases.


Question 2. Database mirroring operates in how many modes ?
  1.    2
  2.    3
  3.    4
  4.    5
 Discuss Question
Answer: Option B. -> 3


Database mirroring operates in three different modes: high-availability mode, high-protection mode, and high-performance mode.


Question 3. The resources owned by WSFC node include:
  1.    Destination address
  2.    SQL Server Browser
  3.    One file share resource, if the FILESTREAM feature is installed
  4.    None of the mentioned
 Discuss Question
Answer: Option C. -> One file share resource, if the FILESTREAM feature is installed


One file share resource is included only if the FILESTREAM feature is installed.


Question 4. Which of the following is used to determine the fragmentation for tables and indexes ?
  1.    DBCC SHOWCONTIG
  2.    DBCC CHECKDB
  3.    DBCC CHECKCATALOG
  4.    None of the mentioned
 Discuss Question
Answer: Option A. -> DBCC SHOWCONTIG


In SQL Server 2005 DBCC SHOWCONTIG remains a viable short term option to determine the database fragmentation.


Question 5. Which of the following scenario prefers not to use database snapshots ?
  1.    Database Snapshots should be seen as high availability option
  2.    Database Snapshots should not be seen as an alternative to regular backups of your data
  3.    Snapshots can be created very quickly
  4.    All of the mentioned
 Discuss Question
Answer: Option B. -> Database Snapshots should not be seen as an alternative to regular backups of your data


Database snapshots can not protect your databases against disk errors or database corruption.


Question 6. Which of the following SQL Server tools is used to enhance data management and governance
  1.    SSIT
  2.    SSDT
  3.    OBEII
  4.    All of the mentioned
 Discuss Question
Answer: Option B. -> SSDT


SSDT stands for SQL Server Data Tools and is available for data management and quality.


Question 7. In which of the following modes, the database is read-only ?
  1.    Stand by
  2.    Read only
  3.    Restore mode
  4.    All of the mentioned
 Discuss Question
Answer: Option A. -> Stand by


There are two available modes and they are related to the state in which the secondary, log shipped.


Question 8. Which of the following is policy based management tip related to administration ?
  1.    Evaluate and Implement Policies in Multiple SQL Server Instances
  2.    Identify SQL Server Databases Not in Full Recovery Model
  3.    SQL Server Policy Base Management Has Clustered Index Condition
  4.    None of the mentioned
 Discuss Question
Answer: Option A. -> Evaluate and Implement Policies in Multiple SQL Server Instances


Policy-Based Management is a system for managing one or more instances of SQL Server.


Question 9. How many types of recovery model is provided by SQL Server ?
  1.    2
  2.    3
  3.    4
  4.    5
 Discuss Question
Answer: Option B. -> 3


Three recovery models exist: simple, full, and bulk-logged.


Question 10. SQL Agent Job definitions are specified in which database ?
  1.    msdb
  2.    master
  3.    tempdb
  4.    all of the mentioned
 Discuss Question
Answer: Option A. -> msdb


msdb is a system database that is created when you first install SQL Server.


Latest Videos
Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)
Direction Sense Test Part 1 Reasoning (Hindi)
Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE
Cube & Cuboid Part 1 Reasoning (Hindi)
Data Interpretation (DI) Basic Concept Reasoning (Hindi)
Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)
Sail E0 free webinar Webinars
Real Numbers Part 7 Class 10 Maths
Real Numbers Part 1 Class 10 Maths
Polynomials Part 1 Class 10 Maths

Latest Test Papers

Pie Chart - Test Paper 1 Data Interpretation Reasoning & DI
Tabulation - Test Paper 2 Data Interpretation Reasoning & DI
Test Paper 1 Direction Sense Test Reasoning & DI
ICA , RDIC,GFM Free Modal Test Paper - Non - Technical Branch Old Syllabus 2022 - SAIL Junior Officer E0
GFM Combined 1 Free Revision Test SAIL JO E-0