Test your SQL Server Database Design, Development, Querying and Administration Knowledge
SELECT firstName, lastName AS [Name] FROM Student;
SELECT firstName +' '+ lastName AS [Name] FROM Student;
SELECT Name FROM Student;
SELECT firstName, lastName FROM Student;
The highest salary
The sixth lowest salary
The sixth highest salary
Query has syntax error
SELECT COUNT(*) FROM Sales WHERE salesTime = CONVERT(DATE, GETDATE())
SELECT COUNT(*) FROM Sales WHERE salesTime >= CONVERT(DATE, GETDATE()) AND salesTime < DATEADD(DAY, 1, CONVERT(DATE, GETDATE()))
SELECT COUNT(*) FROM Sales WHERE salesTime = GETDATE()
SELECT COUNT(*) FROM Sales WHERE CONVERT(VARCHAR, salesTime, 112) = CONVERT(VARCHAR, GETDATE(), 112)
MONEY
SMALL MONEY
DECIMAL
INT
Views
Index
Temporary tables
Triggers
User Defined Datatypes
ALTER TABLE Audit ADD TotalItems AS ItemslnStore + ItemsInWarehouse
ALTER TABLE Audit ADD TotalItems AS SUM(ItemsInStore, ItemsInWarehouse)
ALTER TABLE Audit ADD TotalItems AS ItemsInStore + ItemsInWarehouse PERSISTED
ALTER TABLE Audit ADD TotalItems AS SUM(ItemsInStore, ItemsInWarehouse) PERSISTED
All of the Above
None of the Above
CREATE TRIGGER TrgPhoneNumberChange ON Customers FOR UPDATE AS IF COLUMNS_UPDATED (HomeNumber, MobileNumber) - - Create Audit Records
CREATE TRIGGER TrgPhoneNumberChange ON Customers FOR UPDATE AS IF EXISTS( SELECT HomeNumber from inserted) OR EXISTS (SELECT MobileNumber FROM inserted) - - Create Audit Records
CREATE TRIGGER TrgPhoneNumberChange ON Customers FOR UPDATE AS IF COLUMNS_CHANGED (HomeNumber, MobileNumber) - - Create Audit Records
CREATE TRIGGER TrgPhoneNumberChange ON Customers FOR UPDATE AS IF UPDATE (HomeNumber) OR UPDATE (MobileNumber) - - Create Audit Records
Convert the view into an indexed view.
Convert the view into a table-valued function.
Convert the view into a Common Table Expression (CTE).
Convert the view into a stored procedure and retrieve the result from the stored procedure into a temporary table.
SERIALIZABLE
READ COMMITTED SNAPSHOT
SNAPSHOT
REPEATABLE READ
All of the Above
SQL user without login
Windows login from domain
SQL user with login
Domain user
MONEY
TINYINT
BIGINT
INT
All of the above
DATEDIFF
DATETIME
GETDATE()
None of the above
ISDAY()
ISDATE()
ISYEAR()
ISVALID()
Different Mode Level
Data Manipulation Language
Data Model Language
Data Mode Lane
SELECT * FROM Persons WHERE FirstName=’a’
SELECT * FROM Persons WHERE FirstName LIKE ‘a%’
SELECT * FROM Persons WHERE FirstName=’%a%’
SELECT * FROM Persons WHERE FirstName LIKE ‘%a’
SELECT DIFFERENT
SELECT UNIQUE
SELECT DISTINCT
SELECT ALL
The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints
Updates data in a user database table
The SQL ALTER TABLE clause is used to delete a database table
Is used to add Stored procedures or other objects to a database
SELECT * FROM Persons ORDER FirstName DESC
SELECT * FROM Persons SORT ‘FirstName’ DESC
SELECT * FROM Persons ORDER BY FirstName DESC
SELECT * FROM Persons SORT BY ‘FirstName’ DESC