Free Mock Test : SQL : SQL Table (Test 1)

Home

Technology

Blog

Free Mock Test - SQL : SQL Table (Test 1)

In recent years, SQL (Structured Query Language) has emerged as one of the most important subjects in competitive examinations related to Information Technology, Computer Science, Banking IT, and government technical recruitment. Experts believe that the increasing dependence on data management systems has made SQL knowledge essential for students and job aspirants.
Educational institutions and coaching centers across India are now giving special attention to SQL preparation. Questions related to database creation, data retrieval, joins, normalization, primary keys, foreign keys, and SQL queries are frequently appearing in exams such as SSC Scientific Assistant, Banking IT Officer, NIELIT, Railway technical posts, and various state-level computer operator examinations.
According to academic professionals, SQL is considered a scoring subject because most questions are logic-based and directly related to database operations. Candidates who practice SQL commands regularly can solve examination questions quickly and accurately.

Total Questions : 29

Timer : sec

Question : What is a table in SQL?
A table is a collection of related data organized in rows and columns.

Collection of databases

Collection of rows and columns

Collection of keys only

Collection of indexes

Question : Which SQL command is used to create a table?

MAKE TABLE

NEW TABLE

CREATE TABLE

BUILD TABLE

Question : Which command removes all records but keeps the table structure?

DROP

DELETE

TRUNCATE

REMOVE

Question : Which command removes both data and table structure?

DELETE

DROP TABLE

REMOVE TABLE

CLEAR TABLE

Question : Which command is used to rename a table?

CHANGE TABLE

ALTER RENAME

RENAME TABLE

MODIFY TABLE

Question : Which command deletes selected rows from a table?

DROP

DELETE

TRUNCATE

REMOVE

Question : Which statement deletes all rows using DELETE?
DELETE FROM Student;

Deletes table structure

Deletes all rows

Renames table

Copies table

Question : Which command is faster for removing all records?

DELETE

TRUNCATE

DROP

UPDATE

Question : Which SQL command copies data from one table to another?

MOVE TABLE

COPY TABLE

INSERT INTO SELECT

DUPLICATE TABLE

Question : Which table exists temporarily during a session?

Permanent Table

Temp Table

Backup Table

Foreign Table

Question : Which keyword creates a temporary table?

TEMP

TEMPORARY

Both TEMP & TEMPORARY

SESSION

Question : Which command modifies table structure?

CHANGE TABLE

ALTER TABLE

UPDATE TABLE

MODIFY STRUCTURE

Question : Which command adds a new column?
ALTER TABLE Student ADD age INT;

Adds row

Adds column

Deletes column

Renames table

Question : Which command removes a column?

DELETE COLUMN

REMOVE COLUMN

DROP COLUMN

CLEAR COLUMN

Question : Which command changes column datatype?

ALTER TABLE MODIFY

CHANGE TYPE

UPDATE TYPE

MODIFY DATA

Question : Which statement is used to rename a column in MySQL?

CHANGE COLUMN

ALTER COLUMN

RENAME COLUMN

MODIFY COLUMN

Question : Which operation cannot be rolled back in many DBMS?

DELETE

UPDATE

TRUNCATE

SELECT

Question : Which command removes duplicate structure and data permanently?

DROP TABLE

DELETE

ALTER

COPY

Question : What will this command do?

CREATE TABLE Emp AS
SELECT * FROM Employee;

Delete Employee

Copy structure and data

Rename Employee

Truncate Employee

Question : Which SQL command changes table name from Student to Learner?

RENAME Student Learner;

RENAME TABLE Student TO Learner;

CHANGE Student Learner;

ALTER Student Learner;

Question : Which command preserves auto increment reset?

DELETE

UPDATE

TRUNCATE

SELECT

Question : Which command is DDL?

DELETE

INSERT

CREATE TABLE

UPDATE

Question : Which command belongs to DML?

ALTER

DELETE

CREATE

DROP

Question : What is the default storage object in SQL?

View

Index

Table

Trigger

Question : Which statement creates a temp table?

CREATE TEMP TABLE Test(
id INT
);

Permanent table

Temporary table

Backup table

Virtual table

Question : Which command copies only structure without data?

COPY TABLE

SELECT INTO

TRUNCATE TABLE

CREATE TABLE NewTable AS
SELECT * FROM OldTable WHERE 1=0;

Question : Which command can add constraints to existing table?

ALTER TABLE

DELETE TABLE

DROP TABLE

TEMP TABLE

Question : Which is TRUE about DELETE?

Removes structure

Cannot use WHERE

Deletes selected rows

Faster than TRUNCATE always

Question : Which command is used before removing a table permanently?

DROP TABLE

DELETE TABLE

CLEAR TABLE

REMOVE TABLE

About us

Term & conditions

Privacy & Policy

Free Mock Test - SQL : SQL Table (Test 1)

Cookies & Disclaimer