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
