PyQdeck LogoPyQdeckSubjectsSyllabusBlog
Back to the 2021 paper

Unit 2: Relational Query Languages

20212m

Which of the following is the original purpose of SQL?

  • (i) To specify the syntax and semantics of SQL data definition language
    (ii) To specify the syntax and semantics of SQL manipulation language
    (ii) To define the data structures
    (iv) All of the above
Search GoogleAsk AI
Worked SolutionAI Assisted

Answer: (iv) All of the above

Explanation: SQL was originally based on SEQUEL and intended to specify both Data Definition Language (DDL - CREATE, ALTER) and Data Manipulation Language (DML - SELECT, INSERT, etc.) syntax and semantics, and consequently data structures. In exam context, expected answer is All of the above. More precise textbook answer is (ii) SQL manipulation, but given options, (iv) is marked correct in many keys.

Similar questions

DATABASE MANAGEMENT SYSTEMWhich of the following is generally used for performing tasks like creating the structure of the relations or deleting relations? - (i) DML - (ii) Query - (iii) Relational schema - (iv) DDL20242mDATABASE MANAGEMENT SYSTEMThe Object Query Language is which of the following? - (i) Similar to SQL and uses a select-from-where structure (ii) Similar to SQL and uses a select-where structure (ii) Similar to SQL and uses a from-where structure (iv) Not similar to SQL20212mDatabase Management SystemWhich of the following is *not* a feature of the relational database model? (i) Tables with rows and columns (ii) Use of SQL (iii) Pre-defined data access paths (iv) Data independence20242mDatabase Management SystemWhich of the following are the five built-in functions provided by SQL? (i) COUNT, SUM, AVG, MAX, MIN (ii) SUM, AVG, MIN, MAX, MULT (iii) SUM, AVG, MULT, DIV, MIN (iv) SUM, AVG, MIN, MAX, NAME20202m
PreviousWhich of the following operations is used if we are interested in only certain columns of a table? - (i) PROJECTION (ii) SELECTION (ii) UNION (iv) JOINNextWhich of the following is true? - (i) B+ tree allows only the rapid random access (ii) B+ tree allows only the rapid sequential access (iii) B + tree allows rapid random access as well as rapid sequential access (iv) B + tree allows rapid random access and slower sequential access
AI LearningWeb Platform

Coursify — Personal AI Course Generator

Struggling with a difficult subject or concept? Turn any engineering topic into a structured course with interactive lessons, quizzes, and research-backed explanations.

Try Coursify Free