5. Run Group Questions & Reference Passages Setup

This step enables Group Questions (comprehension passages with follow‑up questions) and Reference Passages (non‑scored passages that stay visible during related questions). Run this SQL code after the database has been created by the software.

Step‑by‑Step Instructions:

• Open SSMS — Launch SQL Server Management Studio from the Start Menu.
• Connect to the server:
  • Server name: localhost\SQLEXPRESS
  • Authentication: SQL Server Authentication
  • Login: sa
  • Password: CBT@2026!Secure or (yourpassword)
• Select the correct database — In the toolbar at the top, click the dropdown that says master and change it to CBT_SchDB.

  ⚠️ Very important! You must select CBT_SchDB — do NOT run this on the master database.

• Open a New Query — Click the "New Query" button in the toolbar (or press Ctrl+N).
• Paste and run the code — Copy the entire block below, paste it into the query window, and click "Execute" (or press F5):
  -- Run this AFTER the CBT software has created the database
  -- Make sure you have selected CBT_SchDB from the database dropdown
  
  ALTER TABLE Questions ADD GroupId INT NULL;
  ALTER TABLE Questions ADD IsReference BIT NOT NULL DEFAULT 0;
  
  -- Verify the columns were added
  SELECT COLUMN_NAME, DATA_TYPE
  FROM INFORMATION_SCHEMA.COLUMNS
  WHERE TABLE_NAME = 'Questions'
  AND COLUMN_NAME IN ('GroupId', 'IsReference');
• Check the result — You should see a green message Commands completed successfully and a table showing both GroupId and IsReference columns.
• Done! — Close SSMS. Group questions and reference passages are now enabled in your CBT software.