Question 1

Which of the following queries will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1?

Accepted Answer

The query in option A uses the less than operator "<" to compare the P_CODE field with the value "1558-QW1". This will return all rows where the P_CODE field has a value that is alphabetically less than "1558-QW1". Options B, C, and D use incorrect syntax for comparing a string value in SQL.

Question 2

A(n) is an alternate name given to a column or table in any SQL statement.

Accepted Answer

An alias is an alternate name given to a column or table in any SQL statement in order to make the query more readable or to shorten the column or table name. It is commonly used in SELECT statements when joining tables together.

Question 3

Which of the following queries will list all the rows in which the inventory stock dates occur on or after January 20, 2010?

Accepted Answer

Option A correctly uses the greater than or equal to operator (>=) and the date value is in the correct format ('20-JAN-2010'). Option B uses dollar signs around the date value which is not correct syntax. Option C uses the less than or equal to operator (<=) which would result in listing all the rows with dates prior to or on January 20, 2010. Option D uses curly braces around the date value which is not correct syntax.

Question 4

Which of the following queries will output the table contents when the value of V_CODE is not equal to 21344?

Accepted Answer

the operator '<>' (not equal to) is used to filter out the values that are equal to 21344, hence selecting only the rows where V_CODE is not equal to 21344. The other operators used in the other queries (<, =, =>) are not suitable for this purpose.

Question 5

The special operator used to check whether an attribute value is within a range of values is .

Accepted Answer

The BETWEEN operator is used to check whether an attribute value is within a specified range of values. The syntax for using BETWEEN is as follows:

SELECT column_name(s)
FROM table_name
WHERE column_name BETWEEN value1 AND value2;

This will return all rows where the column_name value is between value1 and value2, inclusive.

Question 6

The special operator used to check whether a subquery returns any rows is .

Accepted Answer

The special operator used to check whether a subquery returns any rows is EXISTS. This operator is used in the WHERE clause of a SQL statement and returns a Boolean value indicating whether the subquery returns any rows or not. It can be used with correlated subqueries to determine if a condition is true for any of the related rows. Therefore, the best choice in this case is B) EXISTS.

Question 7

When a user issues the DELETE FROM tablename command without specifying a WHERE condition, .

Accepted Answer

The DELETE FROM tablename command without specifying a WHERE condition will delete all rows from the table. It is important to use caution when using this command as it can result in the loss of all data in the table.

Question 8

Which of the following queries will use the given columns and column aliases from the PRODUCT table to determine the total value of inventory held on hand and display the results in a column labeled TOTVALUE?

Accepted Answer

The query in option A uses the P_QOH and P_PRICE columns to calculate the total value of inventory on hand (P_QOH*P_PRICE) and aliases it as TOTVALUE. This column is then displayed alongside the P_DESCRIPT and P_QOH columns.

Question 9

Which of the following is used to select partial table contents?

Accepted Answer

The SQL command to select partial table contents is 'SELECT' with the 'WHERE' clause to specify conditions. Therefore, option C is the correct choice as it has both the 'SELECT' and 'WHERE' clauses.

Question 10

Which of the following queries uses the correct SQL syntax to list the table contents for either V_CODE = 21344 or V_CODE = 24288?

Accepted Answer

In SQL, the operator for equality is "=" not "<=" or ">=". Therefore, option A and B are incorrect. Option C would also return all records where V_CODE is greater than 24288, but we only want records where V_CODE equals either 21344 or 24288. Option D uses the correct syntax, using the "OR" operator to list the table contents where V_CODE equals either 21344 or 24288.

Question 11

The command is used to restore the database to its previous condition.

Accepted Answer

The answer of The command is used to restore the...

Question 12

The command would be used to delete the table row where the P_CODE is 'BRT-345'.

Accepted Answer

The correct syntax to delete a row in SQL is "DELETE FROM [table name] WHERE [condition]". In this case, we want to delete the row where the P_CODE is 'BRT-345', so the correct command would be "DELETE FROM PRODUCT WHERE P_CODE = 'BRT-345'". The other options use incorrect syntax or are not relevant to this task.

Question 13

Which of the following queries will output the table contents when the value of V_CODE is equal to 21344?

Accepted Answer

The query "SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344;" specifically looks for rows where V_CODE is equal to 21344. The other queries either look for rows where V_CODE is not equal to 21344 (A), includes rows where V_CODE is less than or equal to 21344 (B), or use invalid syntax (D) with the ">=" operator.

Question 14

Which of the following queries will output the table contents when the value of P_PRICE is less than or equal to 10?

Accepted Answer

The query B selects the columns P_DESCRIPT, P_INDATE, P_PRICE, and V_CODE from the table PRODUCT where the value of P_PRICE is less than or equal to 10. The operator <= means "less than or equal to." Option A selects all rows where the value of P_PRICE is not 10, while option C uses the incorrect operator =>, which should be >=. Option D selects only rows where the value of P_PRICE is equal to 10.

Question 15

The special operator is used to check whether an attribute value is null.

Accepted Answer

The IS NULL operator is used to check whether an attribute value is null. It returns true if the value is null and false if it is not null. Therefore, the best choice is B.

Question 16

The special operator used to check whether an attribute value matches a given string pattern is .

Accepted Answer

The LIKE operator is used for pattern matching expressions. It allows us to check whether an attribute value matches a given string pattern. The pattern can include wildcards, such as % or _. This operator is commonly used with the WHERE clause in SQL queries.

Question 17

A(n) is a query that is embedded (or nested) inside another query.

Accepted Answer

A subquery is a query that is nested inside another query. It can be used to retrieve data that will be used in the main query as a filtering condition or for calculations.

Question 18

To remove a row from the PRODUCT table, one must use the command.

Accepted Answer

The correct command to remove a row from a database table is DELETE. COMMIT is used to save changes to the database, ERASE is not a recognized command in most database management systems, and KILL is typically used to terminate a process or connection, not remove a row from a table.

Question 19

Some RDBMSs, such as Oracle, automatically data changes when issuing data definition commands.

Accepted Answer

The answer of Some RDBMSs, such as Oracle, automatically data...

Question 20

Which of the following queries will use the given columns and column aliases from the PRODUCT table to determine the total value of inventory held on hand?

Accepted Answer

The query in option C uses the appropriate mathematical formula to calculate the total value of inventory held on hand (quantity on hand multiplied by price), and includes the necessary columns and aliases from the PRODUCT table. The other options include incorrect formulas or syntax that would not result in the desired calculation.

Quiz 7: Introduction to Structured Query Language Sql