SQL Server Quiz

Froggy Jumps

Parties jouées 0

Créer une copie

À propos de cette activité

Mid-level SQL Server quiz

Créé par

leandro reyes

Dominican Republic

Téléchargez la version pour jouer sur papier

Top 10 résultats

Il n'y a toujours pas de résultats pour ce jeu. Soyez le premier à apparaître dans le classement! Connectez-vous pour vous identifier.

Créez votre propre jeu gratuite à partir de notre créateur de jeu

Affrontez vos amis pour voir qui obtient le meilleur score dans ce jeu

Créer un défi

		%
	Anonyme	%
		%
		%

Imprimez votre jeu

SQL Server Quiz


Froggy Jumps SQL Server QuizVersion en ligne Mid-level SQL Server quiz par 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

Vous pouvez intégrer le jeu dans un LMS compatible avec LTI 1.1 ou LTI 1.3 comme Canvas, Moodle ou Blackboard. Les scores seront ainsi automatiquement enregistrés dans le carnet de notes de la plateforme.

SQL Server Quiz

Froggy Jumps

À propos de cette activité

Créé par

Téléchargez la version pour jouer sur papier

Top Jeux

Froggy Jumps

The Integumentary System

Froggy Jumps

pizza

Froggy Jumps

Bill of Rights Game - The Constitutionalist

Froggy Jumps

Phlebotomy Order of Draw Quiz

Froggy Jumps

Ethos, Pathos, and Logos Quiz

Froggy Jumps

SQL Server QuizVersion en ligne

par 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?