Q.1
What is SQL Server?
  • a) SQL Server is a relational database management system
  • b) SQL Server is a software whose main purpose is to store and retrieve data
  • c) SQL Server is a highly secure server and does not allow any database file manipulation during execution
  • d) All of the mentioned
Q.2
When was the first version of Microsoft SQL Server released?
  • a) 1991
  • b) 1990
  • c) 1988
  • d) 1983
Q.3
Which of the following is a free database software running free SQL Server technology?
  • a) SQL Server Web
  • b) SQL Server Enterprise
  • c) SQL Server Workgroup
  • d) SQL Server Express
Q.4
Which of the following companies originally worked together to create and market the first version of SQL Server?
  • a) Sybase
  • b) Ashton-Tate
  • c) Microsoft
  • d) All of the Mentioned
Q.5
What is the Codename for SQL Server 2012?
  • a) Katmai
  • b) Denali
  • c) Hekaton
  • d) Kilimanjaro
Q.6
Which was the first version of SQL Server to introduce in-memory capability?
  • a) SQL Server 2005
  • b) SQL Server 2008
  • c) SQL Server 2012
  • d) SQL Server 2014
Q.7
Which of the following data type is not present in SQL Server?
  • a) geography
  • b) hierarchyid
  • c) boolean
  • d) bit
Q.8
Which database is used by SQL Server Agent for scheduling alerts and jobs, and recording operators?
  • a) temp
  • b) model
  • c) msdb
  • d) master
Q.9
SQL Server has mainly how many types of views?
  • a) four
  • b) three
  • c) one
  • d) two
Q.10
Which of the following is not a SQL Server INFORMATION_SCHEMA view?
  • a) sys.dm_exec_connections
  • b) INFORMATION_SCHEMA.KEY_COLUMN_USAGE
  • c) INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS
  • d) INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE
Q.11
Which of the following joins are SQL server default?
  • a) Inner
  • b) Equi
  • c) Outer
  • d) None of the Mentioned
Q.12
Which of the following is not a class of constraint in SQL Server?
  • a) UNIQUE
  • b) NOT NULL
  • c) CHECK
  • d) NULL
Q.13
Which of the reasons will force you to use the XML data model in SQL Server?
  • a) Order is inherent in your data
  • b) Your data is sparse or you do not know the structure of the data
  • c) Your data represents containment hierarchy
  • d) All of the Mentioned
Q.14
What is the hybrid model in SQL Server?
  • a) Using XML with views
  • b) Using XML with triggers
  • c) Combination of relational and XML data type columns
  • d) Combination of relational and non relational data type columns
Q.15
Which of the following feature of SQL Server was used before XML technology for semi structured data?
  • a) In memory database
  • b) Stored Procedure
  • c) Dynamic management views
  • d) None of the mentioned
Q.16
Which of the following language is used for procedural flow in SQL Server?
  • a) Control-of-flow language
  • b) Flow language
  • c) Control language
  • d) None of the mentioned
Q.17
Exception handling is possible in SQL Server using _____________
  • a) FINAL
  • b) FINALLY
  • c) THROW
  • d) All of the mentioned
Q.18
Which of the following stored procedure is already defined in SQL Server?
  • a) System defined Procedure
  • b) CLR Stored Procedure
  • c) Extended Procedure
  • d) User Defined Stored Procedure
Q.19
DML triggers in SQL Server is applicable to _____________
  • a) Update
  • b) Delete
  • c) Insert
  • d) All of the mentioned
Q.20
User defined function in SQL Server can return ____________
  • a) Result set
  • b) Scalar value
  • c) Set of values
  • d) All of the mentioned
0 h : 0 m : 1 s