MS SQL Server Quiz 280324

In SQL, what is the correct syntax to create a new database named 'SalesData'?

• CREATE DATABASE SalesData

• NEW DATABASE SalesData

• BEGIN DATABASE SalesData

• DATABASE CREATE SalesData

What is a column in the context of a SQL database?

• A set of data values of a particular simple type

• A collection of rows

• The name of a table

• A type of SQL command

In SQL, a table is created using which statement?

• CREATE TABLE

• MAKE TABLE

• BUILD TABLE

• ESTABLISH TABLE

What is SQL?

• A programming language for database management

• A tool for managing SQL Server

• A type of database

• A user interface for databases

Which data type in SQL Server is used to store text?

• VARCHAR

• INTEGER

• BOOLEAN

• FLOAT

A row in a SQL table represents what?

• A category of data

• A single, implicitly structured data item

• The header of a column

• A database command

How can you delete a table in SQL Server?

• REMOVE TABLE table_name

• DELETE TABLE table_name

• DROP TABLE table_name

• ERASE TABLE table_name

Which keyword is used to add a condition to a SQL query?

• ADD

• WHEN

• WHERE

• IF

What is the primary function of SQL?

• Designing web pages

• Managing and manipulating relational databases

• Creating graphic interfaces

• Programming operating systems

Which statement is used to create a new database in SQL Server?

• CREATE DATABASE

• NEW DATABASE

• START DATABASE

• MAKE DATABASE