sql8

docx

School

Centennial College *

*We aren’t endorsed by this school

Course

004

Subject

Computer Science

Date

Dec 6, 2023

Type

docx

Pages

Uploaded by yam1231

Certainly! Here are some multiple-choice questions (MCQs) related to SQL (Structured Query Language): 1. **What does SQL stand for?** - A) Structured Language - B) Standard Query Language - C) Structured Query Language - D) Sequential Query Language 2. **Which SQL statement is used to retrieve data from a database?** - A) GET - B) FETCH - C) SELECT - D) RETRIEVE 3. **What is the purpose of the SQL WHERE clause?** - A) To specify the columns to be retrieved - B) To filter the rows based on a condition - C) To join multiple tables - D) To sort the result set 4. **Which SQL command is used to insert new data into a database?** - A) INSERT - B) ADD - C) UPDATE - D) MODIFY 5. **What is the function of the SQL GROUP BY clause?** - A) To filter rows based on a condition - B) To sort the result set

- C) To group rows based on the values in one or more columns - D) To perform mathematical calculations on columns 6. **Which SQL data type is used to store alphanumeric characters of varying length?** - A) INT - B) VARCHAR - C) CHAR - D) FLOAT 7. **What does the SQL statement DELETE do?** - A) Removes a table from the database - B) Deletes all records from a table - C) Deletes a specific record from a table - D) Deletes a column from a table 8. **Which SQL command is used to change data in a database?** - A) ALTER - B) CHANGE - C) MODIFY - D) UPDATE 9. **What is the purpose of the SQL ORDER BY clause?** - A) To filter the rows based on a condition - B) To sort the result set based on one or more columns - C) To group rows based on the values in one or more columns - D) To join multiple tables 10. **Which SQL constraint is used to ensure that a column cannot have NULL values?** - A) PRIMARY KEY

- B) UNIQUE - C) NOT NULL - D) CHECK Answers: 1. C) Structured Query Language 2. C) SELECT 3. B) To filter the rows based on a condition 4. A) INSERT 5. C) To group rows based on the values in one or more columns 6. B) VARCHAR 7. C) Deletes a specific record from a table 8. D) UPDATE 9. B) To sort the result set based on one or more columns 10. C) NOT NULL

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Related Documents

Midterm Cheat Sheet.pdf

S_Barrett-Interactive Whiteboards Lesson Plan.docx

Lab Project 2 Tesah Capers.docx

Benefits of Global. Thao Dinh. .docx

INT 220 Business Brief Template Thao Dinh (1).docx

sql13.docx

sql11.docx

RajbirSinghKhasria_Assignment1.docx

SCS22 week2.docx

CH19 MC1,2,4 & C2 - Tina Miller.docx

hw08 (1).pdf

Elias Mukhtarzada Literature Review Final Draft 1.docx

Recommended textbooks for you

Oracle 12c: SQL

Computer Science

ISBN:9781305251038

Author:Joan Casteel

Publisher:Cengage Learning

Principles of Information Systems (MindTap Course...

Computer Science

ISBN:9781285867168

Author:Ralph Stair, George Reynolds

Publisher:Cengage Learning

A Guide to SQL

Computer Science

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Course Technology Ptr

Principles of Information Systems (MindTap Course...

Computer Science

ISBN:9781305971776

Author:Ralph Stair, George Reynolds

Publisher:Cengage Learning

Programming Logic & Design Comprehensive

Computer Science

ISBN:9781337669405

Author:FARRELL

Publisher:Cengage

Database Systems: Design, Implementation, & Manag...

Computer Science

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Cengage Learning

SEE MORE TEXTBOOKS

Recommended textbooks for you

Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning