What is the main purpose of indexing in a database? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Database Management System (DBMS) Questions
Question #1
Report Error
The process of organizing a relational database schema to minimize data redundancy and prevent update anomalies is called what?
Correct Answer: Option D
Explanation:
Normalization is the systematic process of structuring relational database schemas to eliminate redundant data and maintain data integrity through decomposition.
Normalization is the systematic process of structuring relational database schemas to eliminate redundant data and maintain data integrity through decomposition.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
Which of the following is not an aggregate function in SQL?
Correct Answer: Option C
Explanation:
DESC is a keyword for sorting order, not an aggregate function.
DESC is a keyword for sorting order, not an aggregate function.
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
Which SQL keyword is used within a SELECT query to filter records matching a specified pattern using wildcards?
Correct Answer: Option C
Explanation:
The LIKE operator is specifically used in a WHERE clause to perform pattern matching on string columns using wildcards (% and _).
The LIKE operator is specifically used in a WHERE clause to perform pattern matching on string columns using wildcards (% and _).
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!