SQL Commands and Functions Overview

What is the main topic discussed in this lesson?

• Basic Computer Science for Form 3

• Database and SQL

• Code Commands

• Usage of SQL Statements

What is the primary purpose of SQL commands in database software?

• To create new database records.

• To retrieve data from stored records.

• To delete existing database records.

• To modify database structures.

What does SQL syntax represent?

• A set of rules for defining commands based on the English language.

• The structure of a database table.

• The type of data stored in a database.

• A method for connecting to a database.

In a SELECT...FROM statement, what is the role of the SELECT clause compared to the FROM clause?

• SELECT chooses the table, FROM chooses the fields.

• SELECT chooses the fields, FROM chooses the table.

• Both SELECT and FROM choose the fields.

• Both SELECT and FROM choose the table.

What is the function of the SELECT * FROM statement in SQL?

• To select specific attributes from a table.

• To retrieve data for all attributes in the selected entity.

• To order the data based on a specific attribute.

• To filter data based on certain criteria.

What is the purpose of the WHERE clause in a SQL query?

• To select specific columns

• To specify the table

• To filter rows based on a condition

• To sort the results

What information is displayed when the query SELECT Nama_Murid, Jantina, Kaum FROM MURID WHERE Jantina = "PEREMPUAN"; is executed?

• All student data

• Only male student data

• Only female student data including their name, gender, and race

• Only student IDs and names

What is the primary function of the ORDER BY clause in a SQL query?

• To select specific fields

• To filter data based on criteria

• To sort the result set

• To join multiple tables

In SQL, what does ASC stand for when used with the ORDER BY clause?

• Ascending

• Attribute

• Alphabetical

• All

If a query includes ORDER BY Nama_Murid DESC;, how will the student names be arranged in the output?

• Alphabetically from A to Z

• Randomly

• Alphabetically from Z to A

• By student ID