Database Course Quiz

What must the first character of a table name in a SQL database be?

• A number

• An underscore

• A letter

• Any special character

Can the same column name appear in different tables within the same database?

• Yes, but only if the tables are related

• No, each column name must be unique across the entire database

• Yes, column names can be reused in different tables

• No, column names cannot be reused even within the same table

How are rows in a table identified?

• By their position in the table

• By their names

• By the data values they contain

• By the number of columns they have

What is the purpose of the SQL SELECT statement?

• Add rows to a table

• Remove rows from a table

• Display rows of one or more tables

• Add tables, indices, views

Which SQL statement is used to add new rows to a table?

• SELECT

• INSERT

• UPDATE

• DROP

What is the purpose of the SQL DELETE statement?

• Change rows in a table

• Add tables, indices, views

• Remove obsolete rows

• Display rows of one or more tables

Which of the following SQL statements is used to modify existing rows in a table?

• CREATE

• DELETE

• SELECT

• UPDATE

What is a SQL statement composed of?

• Functions, classes, and variables

• Clauses, keywords, and parameters

• Methods, operators, and data types

• Protocols, elements, and attributes

How are SQL keywords typically represented in SQL statements?

• In all lowercase letters

• In mixed-case letters

• In all uppercase letters

• In italics

What are parameters in SQL?

• The fixed parts of each clause that cannot be changed

• The variable parts of each clause that are replaced with specific values

• The keywords that define the operation to be performed

• The clauses that specify the structure of the SQL statement