Database Fundamentals MCQs with Answers and Explanations
Practice Database Fundamentals MCQs. from Software Engineering & Programming subject. with solved answers and explanations. updated syllabus-based questions.
Search MCQs, Papers, Topics
Question 1: Which SQL statement is used to fetch data from a table?
SELECT retrieves data from database tables.
Question 2: What is the purpose of a primary key in a database table?
A primary key uniquely identifies each row in a table.
Question 3: Which SQL clause is used to filter records according to a condition?
The WHERE clause is used to filter rows that match specific criteria.
Question 4: Which of the following SQL commands are used for data manipulation?
INSERT, UPDATE, and DELETE are common SQL data manipulation commands.
Question 5: Which database concept is used to relate one table to another?
A foreign key creates a relationship between tables in a relational database.
Question 6: What is normalization in databases mainly used for?
Normalization organizes data efficiently and reduces duplication in database design.
Question 7: Which SQL statement is used to retrieve data from a database table?
SELECT is used to retrieve data from one or more database tables.
Question 8: What is the main purpose of a primary key in a database table?
A primary key uniquely identifies each row in a database table.
Question 9: Which of the following SQL statements are used for data manipulation?
INSERT, UPDATE, and DELETE are data manipulation commands used in CRUD operations.
Question 10: Which clause is used in SQL to filter rows based on a condition?
The WHERE clause is used to filter records according to specified conditions.
Showing 1 to 10 of 13 results