RelationalDBDesign

SiteMap

Server Interaction «Prev Next»

SQL Server [Transactions] - Quiz

Each question is worth one point. Select the best answer for each question.

1.	Which of the following Transact-SQL statements is NOT an accurate variable declaration? Please select the best answer.
A.		DECLARE @x varchar
B.		DECLARE @x int
C.		DECLARE @x myusertype
D.		DECLARE @@x int

2.	John wants to return the database name for database ID 1. He decides to use the DB_NAME function and pass the ID. Which of the following statements could he use? Please select the best answer.
A.		DB_NAME(1)
B.		DB_NAME 1
C.		SELECT DB_NAME(1)
D.		SELECT DB_NAME 1

3.	What is wrong with the following Transact-SQL statement? `RAISERROR ('An error occurred', 19, 1)` Please select the best answer.
A.		Nothing is wrong. The statement will work correctly.
B.		You cannot specify text in the RAISERROR statement. You need to specify a number.
C.		The statement is missing the WITH LOG option.
D.		The severity is outside the range of allowable values.

4.	In SQL Server 2025, which of the following is a valid way to create a vector index on a column that stores embeddings? Please select the best answer.
A.		CREATE INDEX idx_embedding ON MyTable(EmbeddingColumn)
B.		CREATE VECTOR INDEX idx_embedding ON MyTable(EmbeddingColumn) WITH (METRIC = 'cosine', TYPE = 'DISKANN')
C.		ALTER TABLE MyTable ADD VECTOR INDEX idx_embedding (EmbeddingColumn)
D.		CREATE INDEX idx_embedding ON MyTable USING VECTOR(EmbeddingColumn)

5.	Which Transact-SQL statement correctly uses GENERATE_SERIES to generate numbers from 1 to 10? Please select the best answer.
A.		SELECT value FROM GENERATE_SERIES(1, 10)
B.		SELECT * FROM GENERATE_SERIES(1, 10)
C.		SELECT value FROM GENERATE_SERIES(start=1, stop=10)
D.		SELECT * FROM SERIES(1, 10)