SQL Query Concepts and ANSI SQL Constructs MCQs
1. Which type of join is used to combine rows from two or more tables based on a related column between them? A) Equi-joinB) Non-equijoinC) ...
Read more1. Which type of join is used to combine rows from two or more tables based on a related column between them? A) Equi-joinB) Non-equijoinC) ...
Read more1. Which SQL statement is used to add new records to a table? a) SELECTb) INSERTc) UPDATEd) DELETE Answer: b) INSERT Explanation: The INSERT statement ...
Read more1. Which SQL command is used to create a new table in a database? a) INSERTb) CREATE TABLEc) UPDATEd) ALTER Answer: b) CREATE TABLE Explanation: ...
Read more1. Which data model organizes data into a tree-like structure with one-to-many relationships? a) Relational Data Modelb) Hierarchical Modelc) Network Data Modeld) Object-Oriented Model Answer: ...
Read more1. What is the primary purpose of a Database Management System (DBMS)?A) To create complex spreadsheetsB) To organize and manage data efficientlyC) To design websitesD) ...
Read more1. What is an object in object-oriented programming (OOP)? a) A blueprint for creating instances of classesb) A collection of related variables and functionsc) An ...
Read more1. Which of the following best describes a structure in C programming?a) A built-in data typeb) A collection of variables of different data types under ...
Read more1. What is an array? a) A data structure that stores elements of the same type sequentially in memoryb) A data structure that stores elements ...
Read more1. Which of the following is a decision control structure?a) while loopb) for loopc) if statementd) do-while loop Answer: c) if statementExplanation: The if statement ...
Read more1. Which of the following correctly defines a character set in programming? A) A collection of mathematical symbols used in computationsB) A set of predefined ...
Read more