Question 1

A(n) ____ database is structured with tables that are related to one another so data can be stored and retrieved efficiently.
A) relational
B) rational
C) informational
D) accessible
E) none of the above

Accepted Answer

A relational database is structured with tables that are related to one another, allowing for efficient data storage and retrieval. This is based on the relational model of data, as proposed by E.F. Codd.

Question 2

To query a database, it is common practice to use which language?
A) Java
B) C+
C) XML
D) SQL
E) None of the above

Accepted Answer

SQL (Structured Query Language) is the standard language for querying and manipulating databases.

Question 3

A ______ key is a field that holds a unique value for each record.
A) combination
B) foreign
C) primary
D) private
E) public

Accepted Answer

A primary key is a field in a table which uniquely identifies each row/record in a database table. Primary keys must contain unique values, and cannot contain NULL values. A table can have only one primary key, which may consist of single or multiple fields.

Question 4

A table is known more formally as a(n):
A) entity
B) record
C) relationship
D) field
E) file

Accepted Answer

The answer of A table is known more formally as...

Question 5

The _____ keyword designates which fields to display as a result of the query.
A) FROM
B) SELECT
C) WHERE
D) AND
E) OR

Accepted Answer

The SELECT keyword is used in SQL to specify which columns or fields should be returned in the result set of a query.

Question 6

The ______ keyword designates which tables to search when querying a database.
A) FROM
B) SELECT
C) WHERE
D) AND
E) OR

Accepted Answer

The "FROM" keyword is used in SQL to specify the table from which to retrieve data.

Question 7

The ______ keyword specifies the search criteria, or query condition to use in finding records.
A) FROM
B) SELECT
C) WHERE
D) AND
E) OR

Accepted Answer

The WHERE keyword is used in SQL to specify the conditions that must be met for records to be selected.

Question 8

Is SQL case-sensitive?
A) Yes
B) No
C) For keywords only
D) Sometimes
E) None of the above

Accepted Answer

SQL is generally case-insensitive, meaning that keywords and identifiers are not case-sensitive. However, this can depend on the database system and its configuration.

Question 9

To designate a character or text constant as such, you must use which punctuation marks?
A) Exclamation point
B) Question mark
C) Quotation marks
D) Ampersand
E) None of the above

Accepted Answer

Quotation marks are used to designate a character or text constant in many programming languages, indicating that the enclosed text should be treated as a string of characters rather than as code to be executed.

Question 10

Which of the following SQL statements is correct?
A) FROM Table SELECT Field WHERE Record = 'X' ORDER BY Field
B) WHERE Record = 'X' SELECT Field FROM Table ORDER BY Field
C) SELECT FROM Table Field WHERE Record = 'X' ORDER BY Field
D) ORDER BY Field SELECT Field FROM Table WHERE Record = 'X'
E) None of the above is correct

Accepted Answer

The correct syntax for an SQL query is "SELECT column_name(s) FROM table_name WHERE condition ORDER BY column_name(s);" None of the options provided follow this syntax, making all of them incorrect.

Question 11

Which comparison operators below is not used in conjunction with the WHERE keyword? A) greater than (>) B) less than (<) C) greater than or equal to (>=) D) added to (+) E) not equal to (<>)

Accepted Answer

The "+" operator is an arithmetic operator used for addition, not a comparison operator. Comparison operators like ">", "<", ">=", and "<>" are used with the WHERE keyword to filter records in SQL queries.

Question 12

It is also possible to combine conditions in a query by using the AND or OR operators, known as _____ operators.
A) comparison
B) compound
C) arithmetic
D) logical
E) aggregate

Accepted Answer

The answer of It is also possible to combine conditions...

Question 13

The _____ operator uses the wildcard character as a replacement for unknown or non-existing characters in an attempt to find matches to a group of characters.
A) AND
B) OR
C) SELECT
D) LIKE
E) WHEN

Accepted Answer

The LIKE operator in SQL is used to search for a specified pattern in a column. The wildcard characters '%' and '_' can be used with LIKE to represent unknown or non-existing characters, allowing for partial matches.

Question 14

To insert a new record for a book with an item code of KOB, a retail price of $12.95, and an item cost of $7.95 into the Product table of a database, the SQL statement is:
A) INSERT INTO Product Values('KOB', 'Book', 12.95, 7.95)
B) INSERT INTO Product Values('KOB', 'Book', '$12.95', '$7.95')
C) ADD INTO Product Values('KOB', 'Book', 12.95, 7.95)
D) ADD INTO Product Values('KOB', 'Book', '$12.95', '$7.95')
E) None of the above

Accepted Answer

The correct SQL syntax to insert a new record into a table is "INSERT INTO table_name VALUES (value1, value2, ...);". Choice A correctly follows this syntax and does not include dollar signs for the numeric values, which is the proper format for inserting numeric data into SQL tables.

Question 15

Which of the following SQL statements will change all the records from the table Courses that begin with ITM and change it to BTM?
A) CHANGE Course WHERE CourseCode = 'ITM' SET CourseCode = 'BTM'
B) CHANGE Course SET CourseCode = 'BTM' WHERE CourseCode = 'ITM'
C) UPDATE Course WHERE CourseCode = 'ITM' SET CourseCode = 'BTM'
D) UPDATE Course SET CourseCode = 'BTM' WHERE CourseCode = 'ITM'
E) None of the above

Accepted Answer

The correct SQL syntax to update records in a table is the UPDATE statement followed by the SET clause to specify the new value, and the WHERE clause to specify which records should be updated. Option D correctly follows this syntax to change records from 'ITM' to 'BTM'.

Question 16

Which of the following SQL statements will delete all the records from the table Students that have the last name "Sample"?
A) REMOVE FROM Courses WHERE LastName = 'Sample'
B) REMOVE WHERE LastName = 'Sample' FROM Courses
C) DELETE FROM Courses WHERE LastName = 'Sample'
D) DELETE WHERE LastName = 'Sample' FROM Courses
E) None of the above

Accepted Answer

The correct SQL statement to delete records from a table based on a condition is the DELETE FROM statement followed by the table name, then the WHERE clause specifying the condition. Option C correctly uses this syntax to delete records from the "Courses" table where the LastName is 'Sample'.

Question 17

In order to use an aggregate function, you must use a _____ field.
A) numeric
B) alpha-numeric
C) string
D) dummy
E) none of the above

Accepted Answer

The answer of In order to use an aggregate function,...

Question 18

The SQL operation used to calculate certain values in the table, such as COUNT are called _____ functions
A) comparison
B) compound
C) arithmetic
D) logical
E) aggregate

Accepted Answer

Aggregate functions are used in SQL to perform calculations on a set of values and return a single value. Examples include COUNT, SUM, AVG, MAX, and MIN.

Question 19

Which of the following is not an aggregate function?
A) AVG
B) CNT
C) MIN
D) MAX
E) SUM

Accepted Answer

CNT is not a standard SQL aggregate function. The correct function for counting items in SQL is COUNT. AVG, MIN, MAX, and SUM are all standard SQL aggregate functions used to perform calculations on a set of values to return a single value.

Question 20

Which of the following is not an advantage to using a relational database?
A) Increasing data redundancy
B) Improving data access and sharing by using database standards
C) Maintaining the integrity of the data by having security and controls to prevent errors, duplication, and unauthorized entry
D) Allowing configurable views of the data to match the user needs
E) None of the above

Accepted Answer

Increasing data redundancy is not an advantage of using a relational database. Relational databases aim to minimize redundancy through normalization, which organizes data to reduce duplication.

Quiz 11: Tech Guide C: The Details of SQL, Logical Modelling, and XML

A(n) ____ database is structured with tables that are related to one another so data can be stored and retrieved efficiently.

To query a database, it is common practice to use which language?

A ______ key is a field that holds a unique value for each record.

A table is known more formally as a(n) :

The _____ keyword designates which fields to display as a result of the query.

The ______ keyword designates which tables to search when querying a database.

The ______ keyword specifies the search criteria, or query condition to use in finding records.

Is SQL case-sensitive?

To designate a character or text constant as such, you must use which punctuation marks?

Which of the following SQL statements is correct?

Which comparison operators below is not used in conjunction with the WHERE keyword?

It is also possible to combine conditions in a query by using the AND or OR operators, known as _____ operators.

The _____ operator uses the wildcard character as a replacement for unknown or non-existing characters in an attempt to find matches to a group of characters.

To insert a new record for a book with an item code of KOB, a retail price of $12.95, and an item cost of $7.95 into the Product table of a database, the SQL statement is:

Which of the following SQL statements will change all the records from the table Courses that begin with ITM and change it to BTM?

Which of the following SQL statements will delete all the records from the table Students that have the last name "Sample"?

In order to use an aggregate function, you must use a _____ field.

The SQL operation used to calculate certain values in the table, such as COUNT are called _____ functions

Which of the following is not an aggregate function?

Which of the following is not an advantage to using a relational database?