SQL Server Quiz

Froggy Jumps

Played 0

Create copy

About this activity

Mid-level SQL Server quiz

Created by

leandro reyes

Dominican Republic

Download the paper version to play

Top 10 results

There are still no results for this game. Be the first to stay in the ranking! Log in to identify yourself.

Make your own free game from our game creator

Compete against your friends to see who gets the best score in this game

Make challenge

pizza

Lorelay Tyana

Romania

(258)

joc despre pizza
The Integumentary System

Breanna Nesbitt

United States

(58)

Functions and Structures of the skin
Bill of Rights Game - The Constitutionalist

Doni The Don

United States

(89)

Test your knowledge on the Bill of Rights. A fun way to test your knowledge and focus on where you need to improve.
Ethos, Pathos, and Logos Quiz

Kristine Vester

United States

(131)

Test your knowledge of ethos, pathos, and logos with these 10 questions on examples of persuasive techniques.
Phlebotomy Order of Draw Quiz

Pamela Chapman

United States

(59)

Test your knowledge of the order of draw in Phlebotomy with these 10 questions!

		%
	Anonymous	%
		%
		%

Print your game

SQL Server Quiz


Froggy Jumps SQL Server QuizOnline version Mid-level SQL Server quiz by leandro reyes 1 What T-SQL command is used to create a new table in SQL Server? a MAKE TABLE b CREATE TABLE c ADD TABLE 2 Which isolation level prevents dirty reads but allows non-repeatable reads and phantom reads? a SERIALIZABLE b READ UNCOMMITTED c READ COMMITTED 3 Which object is used to reuse code and can accept parameters in SQL Server? a Trigger b Stored Procedure c View 4 Which statement is used to modify existing table structure? a ALTER TABLE b CHANGE TABLE c MODIFY TABLE 5 Which index type is typically used to enforce uniqueness in SQL Server? a Full-Text Index b Clustered Index c Unique Index 6 What database object stores data in a precomputed, rapidly accessible format for reporting? a Materialized View b Temporary Table c Indexed View 7 Which command is used to back up a SQL Server database? a BACKUP DATABASE b SAVE DATABASE c EXPORT DATABASE 8 What is the tempdb used for in SQL Server? a Backup scratch space b User data storage c Temporary storage for intermediate results and objects 9 Which statement creates a new user-defined function that returns a scalar value? a CREATE FUNCTION @returns scalar b CREATE PROCEDURE c CREATE VIEW 10 Which feature helps ensure data integrity across related rows in different tables? a Foreign Key b Primary Key c Checksum 11 Which command retrieves data from a SQL Server database? a SELECT b GET c OPEN 12 What is the default behavior when a transaction is opened and not yet committed or rolled back? a It auto-commits after each statement b It remains active until COMMIT or ROLLBACK c It cancels at end of session 13 Which tool is commonly used for graphical query design and management in SQL Server? a Toad for SQL Server b Visual Studio c SQL Server Management Studio (SSMS) 14 Which statement defines a user in SQL Server? a CREATE USER b CREATE LOGIN c ALTER ROLE

You can integrate the game into an LMS compatible with LTI 1.1 or LTI 1.3 such as Canvas, Moodle, or Blackboard. This way, the scores will be automatically saved into the platform’s gradebook.

SQL Server Quiz

Froggy Jumps

About this activity

Created by

Download the paper version to play

Top Games

Froggy Jumps

pizza

Froggy Jumps

The Integumentary System

Froggy Jumps

Bill of Rights Game - The Constitutionalist

Froggy Jumps

Ethos, Pathos, and Logos Quiz

Froggy Jumps

Phlebotomy Order of Draw Quiz

Froggy Jumps

SQL Server QuizOnline version

by leandro reyes

What T-SQL command is used to create a new table in SQL Server?

Which isolation level prevents dirty reads but allows non-repeatable reads and phantom reads?

Which object is used to reuse code and can accept parameters in SQL Server?

Which statement is used to modify existing table structure?

Which index type is typically used to enforce uniqueness in SQL Server?

What database object stores data in a precomputed, rapidly accessible format for reporting?

Which command is used to back up a SQL Server database?

What is the tempdb used for in SQL Server?

Which statement creates a new user-defined function that returns a scalar value?

Which feature helps ensure data integrity across related rows in different tables?

Which command retrieves data from a SQL Server database?

What is the default behavior when a transaction is opened and not yet committed or rolled back?

Which tool is commonly used for graphical query design and management in SQL Server?

Which statement defines a user in SQL Server?