Quiz – SQL Server Introduction Quiz – SQL Server Basics 1 This is is the 1st part of the SQL Server Basics Quiz where you will be tested on various basics concepts of Microsoft Server. 1 / 10 Which one of the below clause removes all rows from a table without logging in SQL Server? TRUNCATE DELETE DROP REMOVE TRUNCATE statement is a Data Definition Language (DDL) operation that marks the extents of a table for deallocation. 2 / 10 What is the purpose of the SQL AS clause? The AS SQL clause is used to change the name of a column in the result set or to assign a name to a derived column The AS clause is used with the JOIN clause only All of the Above The AS clause defines a search condition SQL Aliases are defined for columns and tables. Basically aliases are created to make the column selected more readable. 3 / 10 Which of the following data types does SQL Server not support? bit boolean geography hierarchyid There is no Boolean data type keyword in SQL Server. Instead use BIT keyword that is used to store true , false or NULL. 4 / 10 Which of the below data type is a spatial data type? sql_variant cursor All of the above geometry For storing spatial data, SQL Server supports the geometry and geography data types. These types provide methods and properties for creating, comparing, analysing, and retrieving spatial data. 5 / 10 Which of the following SQL clauses is used to DELETE records from a database table? CLEAR DELETE DROP REMOVE The SQL DELETE Query is used to delete the existing records from a table 6 / 10 Which of the following is not a DDL command in SQL Server? UPDATE ALTER None of the Above TRUNCATE Data definition language (DDL) commands enable you to perform the following tasks:Create, alter, and drop schema objects. 7 / 10 Which SQL keyword is used to retrieve a maximum value? UPPER MIN TOP MAX The MAX() function returns the largest value of the selected column. 8 / 10 What is the default ORDERING in SQL Server for a ORDER BY Clause? None of the Above ASC DESC First Descending and then Ascending ASC is the default sort order. Null values are treated as the lowest possible values. 9 / 10 Which SQL function is used in a SQL query to count the number of rows? COUNT(*) NUMBER() AVERAGE() MIN() COUNT Function does this work 10 / 10 Which of these is a monetary data type in SQL Server? sql_variant Cursor Smallmoney None of the Above Monetary data types, such as smallmoney and money, are data types that represent monetary or currency values. Your score is Share LinkedIn Facebook Twitter VKontakte 0% Share: admin Next post Do you call all dogs “puppies?” February 26, 2023
