QUIZ

Certification Test


Que No. 1 ) Which SQL Server command is used to remove a table from the database? A.) DELETE B.) DROP TABLE C.) TRUNCATE TABLE D.) ALTER TABLE
Que No. 2 ) What is the purpose of SQL Server views? A.) To store large binary data, such as images or documents B.) To create a snapshot of a table's data C.) To provide a virtual table that can be used to simplify complex queries D.) To enforce data integrity rules
Que No. 3 ) Which SQL Server statement is used to add a new column to an existing table? A.) ALTER TABLE B.) CREATE TABLE C.) UPDATE TABLE D.) INSERT INTO
Que No. 4 ) What is the purpose of SQL Server constraints? A.) To store large binary data, such as images or documents B.) To create indexes for faster data retrieval C.) To enforce data integrity rules on a table D.) To calculate aggregate functions
Que No. 5 ) Which SQL Server feature allows you to group multiple statements into a single transaction? A.) BEGIN TRANSACTION B.) COMMIT TRANSACTION C.) ROLLBACK TRANSACTION D.) SAVE TRANSACTION
Que No. 6 ) What is the purpose of SQL Server indexes? A.) To store large binary data, such as images or documents B.) To enforce data integrity rules on a table C.) To optimize data retrieval by speeding up data access D.) To calculate aggregate functions
Que No. 7 ) Which SQL Server statement is used to remove rows from a table based on a specified condition? A.) DELETE B.) TRUNCATE TABLE C.) DROP TABLE D.) UPDATE
Que No. 8 ) What is the purpose of SQL Server transactions? A.) To permanently delete data from a table B.) To group multiple statements into a single unit of work C.) To change the structure of a table D.) To create new tables
Que No. 9 ) Which SQL Server command is used to make changes to existing data in a table? A.) DELETE B.) TRUNCATE TABLE C.) UPDATE D.) ALTER TABLE
Que No. 10 ) What is the purpose of the SQL Server "ROLLBACK TRANSACTION" statement? A.) To permanently delete data from a table B.) To group multiple statements into a single unit of work C.) To undo changes made during a transaction D.) To create new tables

Que No. 1 ) Which SQL Server command is used to remove a table from the database?

A.) DELETE
B.) DROP TABLE
C.) TRUNCATE TABLE
D.) ALTER TABLE

Que No. 2 ) What is the purpose of SQL Server views?

A.) To store large binary data, such as images or documents
B.) To create a snapshot of a table's data
C.) To provide a virtual table that can be used to simplify complex queries
D.) To enforce data integrity rules

Que No. 3 ) Which SQL Server statement is used to add a new column to an existing table?

A.) ALTER TABLE
B.) CREATE TABLE
C.) UPDATE TABLE
D.) INSERT INTO

Que No. 4 ) What is the purpose of SQL Server constraints?

A.) To store large binary data, such as images or documents
B.) To create indexes for faster data retrieval
C.) To enforce data integrity rules on a table
D.) To calculate aggregate functions

Que No. 5 ) Which SQL Server feature allows you to group multiple statements into a single transaction?

A.) BEGIN TRANSACTION
B.) COMMIT TRANSACTION
C.) ROLLBACK TRANSACTION
D.) SAVE TRANSACTION

Que No. 6 ) What is the purpose of SQL Server indexes?

A.) To store large binary data, such as images or documents
B.) To enforce data integrity rules on a table
C.) To optimize data retrieval by speeding up data access
D.) To calculate aggregate functions

Que No. 7 ) Which SQL Server statement is used to remove rows from a table based on a specified condition?

A.) DELETE
B.) TRUNCATE TABLE
C.) DROP TABLE
D.) UPDATE

Que No. 8 ) What is the purpose of SQL Server transactions?

A.) To permanently delete data from a table
B.) To group multiple statements into a single unit of work
C.) To change the structure of a table
D.) To create new tables

Que No. 9 ) Which SQL Server command is used to make changes to existing data in a table?

A.) DELETE
B.) TRUNCATE TABLE
C.) UPDATE
D.) ALTER TABLE

Que No. 10 ) What is the purpose of the SQL Server "ROLLBACK TRANSACTION" statement?

A.) To permanently delete data from a table
B.) To group multiple statements into a single unit of work
C.) To undo changes made during a transaction
D.) To create new tables

Quick Link

About Us Benefits Contact Us Online Certificate Verification

Contact

Ist floor,F-465, K&B Tower, Ind. Area Phase-8B, Sector-74, Near Ajeet Press, Mohali

0172-418-2618

info@letsstartindia.com

Collaboration

Verification

Click on below button to verify certificate no.