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 Join and SQL View
MCQ – Multiple choice questions on SQL join and SQL view with answers and explanation. These SQL join and view mcq are asked in Software jobs written interviews. Q) The SQL join which does Cartesian product is called? Left Join Left Outer Join Right Outer Join Cross Join Answer: 4 Q) Which SQL Join […]
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 […]