SQL Database Quiz

Correct query for making a database;

• SELECT * FROM database_name;
• CREATE DATABASE database_name;
• ALTER DATABASE database_name;
• DROP DATABASE database_name;

DROP (a)   databasename;

How to create table in SQL Server at least 4 column names ID with Primary key and Identity (1, 1);

• CREATE TABLE YourTableName (ID INT, Column1 VARCHAR(50), Column2 INT);
• CREATE TABLE YourTableName (ID INT PRIMARY KEY, Column1 VARCHAR(50), Column2 INT, Column3 DATETIME, Column4 FLOAT);
• CREATE TABLE YourTableName (ID INT PRIMARY KEY IDENTITY(1,2), Column1 VARCHAR(50), Column2 INT, Column3 DATETIME);
• CREATE TABLE YourTableName ( ID INT PRIMARY KEY IDENTITY(1,1), Column1 VARCHAR(50), Column2 INT, Column3 DATETIME );

This is question shows that, how you can drop your table.
"DROP (a)   Users;

Who properly query in SQL Server, Select all data in a table;

• SELECT * FROM table_name;
• SELECT ALL FROM table_name;
• GET * FROM table_name;
• FETCH * FROM table_name;