MCQ-SQL

MCQs – SQL Basics

MCQ –  Basic SQL multiple-choice questions with answers for written test in software job interview in IT companies. Q) Which statement is wrong about PRIMARY KEY constraint in SQL? The PRIMARY KEY uniquely identifies each record in a SQL database table Primary key can be made based on multiple columns Primary key must be made […]

MCQs – Stored Procedure and SQL function

MCQ – Multiple choice questions on stored procedure sql and function with answers and explanation. Objective questions are asked in Software jobs written interviews. Q) A stored procedure in SQL is a___________ Block of functions Group of SQL statements. None Answer: 2 Q) Advantage of SQL stored procedure Maintainability Re-use of code Security All Answer: […]

MCQs – SQL Database

MCQ – Multiple choice questions on SQL Database with answers and explanation. Many of the objective questions are asked in IT jobs written interviews. Q)Combination of primary key with foreign key forms Answer: 1   Q)Match SQL language with SQL commands 1)DDL    i)Revok, Grant2)DML   ii)rename a table3)TCL    iii)insert, update4)DCL    iv)rollback , commit Answer: 3   Q)Types […]

MCQs – SQL commands

MCQ – This section contains multiple choice questions on SQL Commands with answers and explanation. Many of the objective questions are asked in software jobs written interviews. Q) Which SQL commands can be used to delete all records from the table in a sql database? Answer: 1 and 3 Read difference between delete, truncate and […]

Scroll to top