View Count: 0
Duration: 57 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 11 mins
Accessed date:
Not Yet Viewed
Post your comment / feedback here
 
 

Be the first one to comment about this video

Sorry!For this module there is no Sample Code.
Sorry!For this module there is no Assignments.
Question No: 1 of 27
How many types of authentication are provided in SQL Server 
Options:
  1. 1
  2. 3
  3. 2
View Answer/Explanation:
c
Explanation:
There are two types of authentication provided in SQL Server. They are Windows authentication and SQL authentication Windows authentication: The identity of the client on the Domain of the OS/Network is used by Sql server to allow or deny access to the resources in the database.SQL Server Authentication: The permissions to the client are granted based on the identity which was created and stored in the SQL Server database.

Question No: 2 of 27
How is a named instance of SQL Server identified? 
Options:
  1. By the Network name of the computer
  2. By the instance name
  3. By both the instance name and the network name of the computer
View Answer/Explanation:
c
Explanation:

Question No: 3 of 27
Can we install more than one instance of the SQL Server? 
Options:
  1. Yes
  2. No
View Answer/Explanation:
a
Explanation:

Question No: 4 of 27
What kind of data does nchar data type hold? 
Options:
  1. Unicode
  2. Non-unicode
View Answer/Explanation:
a
Explanation:

Question No: 5 of 27
Which of the following is true regarding a bit data type? 
Options:
  1. It is an integer data type
  2. It can hold either a 0 or 1 value
  3. It can hold either true or false value
View Answer/Explanation:
a b
Explanation:
A bit datatype is an integer data type which can store either a 0 or 1 or null value.

Question No: 6 of 27
Can we create a user defined data type? 
Options:
  1. Yes
  2. No
View Answer/Explanation:
a
Explanation:
User defined data types are based on system data types. They should be used when multiple tables need to store the same type of data in a column and you need to ensure that all these columns are exactly the same including length, and nullability.Parameters for user defined datatype:Name System data type on which user defined data type is based upon.Nullability.For example, a user-defined data type called post_code could be created based on char system data type.

Question No: 7 of 27
How many system databases are present in SQL Server 
Options:
  1. 3
  2. 4
View Answer/Explanation:
b
Explanation:
The System databases present in SQL Server are master,model,tempdb and msdb

Question No: 8 of 27
The SQL Server cannot start if which of the following databases is not present? 
Options:
  1. Model
  2. Master
  3. Msdb
View Answer/Explanation:
b
Explanation:

Question No: 9 of 27
Which system database functions as a template database? 
Options:
  1. Master
  2. Msdb
  3. Model
  4. Tempdb
View Answer/Explanation:
c
Explanation:

Question No: 10 of 27
Which database is recreated everytime the SQL Server starts? 
Options:
  1. Master
  2. Msdb
  3. Model
  4. Tempdb
View Answer/Explanation:
d
Explanation:

  1