MCQs
Total Questions : 12
| Page 1 of 2 pages
Answer: Option C. -> With
With is used to create temporary relation and its not a aggregate function.
Answer: Option D. -> SELECT city, temperature FROM weather ORDER BY city
The ORDER BY keyword sorts the records in ascending order by default.
Answer: Option A. -> SELECT COUNT() FROM Persons
COUNT(column_name) is used to count the number of rows of a table where column name is a column that does not allow NULL values.
Answer: Option D. -> CEIL
SQL Server has CEILING fuction to get the smallest integer greater than the specified expression.
Answer: Option A. -> DELETE
The SQL DELETE Query is used to delete the existing records from a table.
Answer: Option A. -> 2012
LocalDB was introduced in SQL Server 2012 CTP3. It?s basically a new version of SQL Express, with same functionality, dedicated to developers.
Answer: Option D. -> sql_variant
sql_variant is data type that stores values of various SQL Server-supported data types.
Answer: Option B. -> Add or remove a bookmark
To toggle bookmarks on/off within SSMS, press Ctrl+K+K.
Answer: Option A. -> T-SQL scripts
Template Explorer is used to create and manage T-SQL code templates.
Answer: Option D. -> All of the Mentioned
Latest Videos
Latest Test Papers
Login With Google
Old way of Login
Login With Email