Font size
WorksheetsMS SQL SERVER Day6
Total questions: 10
Worksheet time: 5mins
How many kinds of RAID are there
4
5
6
7
Mirroring is which kind of RAID
RAID 0
RAID 1
RAID 2
RAID 3
Reason for Mirroring Databse
Back up of the DB
Running the Copy of the DB simultaniously
To avoid slowness
Provide ExraSecurity
Advantages of Mirroring DB
Quick access of the DB
Less DownTime
Automatic Failover
All of the Above
The back up that we take before Mirroring
Full Backup
Differential Backup
Transactional Log Backup
All of the Above
If there are 2 Differential backup, a) taken on 4th
Sept and b) bckup taken on 8th Sept. Which bckup file will be considered for
"Restore"
4th Sept
8th Sept
Both Backup
None
There are 3 Transaction Log Backup files take on
10th Sept, 14th Sept and 16th Sept. Which Backup files will be taken into account for Restoration
16th Sept
10th Sept
14th Sept
All of the Above
Which of the Codd rule is associated with the
statement that changes in the data storage should not affect programs that access the data?
Information Rule
Comprehensive Sub Language
Physical Data Independence Rule
Distribution Rule
The table emp has 56 records. This value
corresponds to which of the following term?
Relation
Degree
Cardinality
Domain
Main editions of SQL server
Entp Edition
Standard Edition
Business Intelligence Edition
All of the above
