Question 1

The MODIFY command can be used to change existing data stored in a table.​

Accepted Answer

The MODIFY command is not a valid SQL command. The correct SQL command to modify an existing data in a table is UPDATE.

Question 2

If non-numeric data is being added to a column,the data must be enclosed in double quotation marks.​

Accepted Answer

Non-numeric data can be enclosed in either single or double quotation marks depending on the programming language or context.

Question 3

If one of the data values being entered into a table by the INSERT command violates an existing constraint,the remaining portion of the row will be added,but the data violating the constraint will need to be added at a later time using the UPDATE command.​

Accepted Answer

If a data value violates an existing constraint, the entire INSERT command will fail and the row will not be added to the table. The data will need to be corrected before attempting to insert again.

Question 4

When a subquery is used in the INSERT command,the subquery does not have to be enclosed in parentheses.​

Accepted Answer

When using a subquery in the INSERT command, it can be written without enclosing it in parentheses.

Question 5

The UPDATE command can be used to add data to existing rows in a table.​

Accepted Answer

The UPDATE command is used to modify the values of existing rows in a table, including adding new data to them. It is commonly used to update only specific rows or columns within a table based on certain conditions.

Question 6

The BLOCK ACCESS command can be used to prevent other users from updating a specific table.​

Accepted Answer

The BLOCK ACCESS command does not exist in SQL or database management systems for controlling access to tables. Access control is typically managed through GRANT and REVOKE commands or through roles and permissions settings in the database.

Question 7

When data is added to a database table,it is automatically converted to upper-case letters.​

Accepted Answer

This is not a universal rule and depends on the settings and configuration of the specific database management system being used. Some systems may convert data to uppercase letters by default, but others may preserve the case of the input data or have configurable options to control how case is handled.

Question 8

​A subquery can be used with the INSERT command to enter data from an existing table into the destination table.

Accepted Answer

The subquery can be used to select data from an existing table and insert it into the destination table as new rows.

Question 9

When the INSERT command is used to add rows to a table,the column names of the table must be specified.
​

Accepted Answer

It is not mandatory to specify the column names in the INSERT command. If column names are not specified, values must be provided for all columns in the same order as they appear in the table.

Question 10

The SYSDATE keyword cannot be included in the INSERT command,only the UPDATE command.​

Accepted Answer

The SYSDATE keyword can be included in both INSERT and UPDATE commands in Oracle SQL. It is used to insert the current date and time into a date column.

Question 11

The VALUES clause is not included with the INSERT command if the data is being retrieved from another table.​

Accepted Answer

When inserting data from another table, the SELECT statement is used to specify the data to be inserted, eliminating the need for the VALUES clause.

Question 12

Single-row functions cannot be included in the UPDATE command.​

Accepted Answer

Single-row functions can be included in the UPDATE command. For example, you can use a function to manipulate the value being updated or to set a new value based on the existing value in a column.

Question 13

If the WHERE clause is omitted from the UPDATE command,then all columns in the table will be changed.​

Accepted Answer

If the WHERE clause is omitted, the UPDATE command will change all rows in the table, but not all columns. The SET clause still specifies which columns to update.

Question 14

If data is only being added to some of the columns in a table,the names of the columns must be listed in the VALUES clause.​

Accepted Answer

When only some columns are being added to in a SQL INSERT statement, the names of those columns must be listed in the INSERT INTO clause, not in the VALUES clause. The VALUES clause is used to specify the values to be inserted into the specified columns.

Question 15

If no value is assigned to a column when a row is added to a table,the column will contain a NULL value.​

Accepted Answer

When a row is added to a table without assigning a value to a column, that column will have a NULL value by default.

Question 16

The INSERT command is used to modify existing data in a row.​

Accepted Answer

The INSERT command is used to add new data into a row, not modify existing data. To modify existing data, the UPDATE command should be used.

Question 17

The LOCK TABLE command can be used to prevent other users from making changes to a table.​

Accepted Answer

The LOCK TABLE command is used to lock a table and prevent other users from making changes to it until the lock is released.

Question 18

The ROLLBACK command is used to permanently save changed data.​

Accepted Answer

The ROLLBACK command is used to undo changes made since the last commit or savepoint. It does not permanently save changed data, but rather restores the database to its previous state. The command used to permanently save changes is the COMMIT command.

Question 19

​The data being inserted into a table are listed in the ADD clause of the INSERT command.

Accepted Answer

The data being inserted into a table are specified in the VALUES clause of the INSERT command, not the ADD clause.

Question 20

The SET clause of the UPDATE command is used to identify the column(s)being updated.​

Accepted Answer

The SET clause of the UPDATE command is used to specify the new value(s) for the column(s) being updated.

Quiz 5: Data Manipulation and Transaction Control

The MODIFY command can be used to change existing data stored in a table.​

If non-numeric data is being added to a column,the data must be enclosed in double quotation marks.​

If one of the data values being entered into a table by the INSERT command violates an existing constraint,the remaining portion of the row will be added,but the data violating the constraint will need to be added at a later time using the UPDATE command.​

When a subquery is used in the INSERT command,the subquery does not have to be enclosed in parentheses.​

The UPDATE command can be used to add data to existing rows in a table.​

The BLOCK ACCESS command can be used to prevent other users from updating a specific table.​

When data is added to a database table,it is automatically converted to upper-case letters.​

​A subquery can be used with the INSERT command to enter data from an existing table into the destination table.

When the INSERT command is used to add rows to a table,the column names of the table must be specified. ​

The SYSDATE keyword cannot be included in the INSERT command,only the UPDATE command.​

The VALUES clause is not included with the INSERT command if the data is being retrieved from another table.​

Single-row functions cannot be included in the UPDATE command.​

If the WHERE clause is omitted from the UPDATE command,then all columns in the table will be changed.​

If data is only being added to some of the columns in a table,the names of the columns must be listed in the VALUES clause.​

If no value is assigned to a column when a row is added to a table,the column will contain a NULL value.​

The INSERT command is used to modify existing data in a row.​

The LOCK TABLE command can be used to prevent other users from making changes to a table.​

The ROLLBACK command is used to permanently save changed data.​

​The data being inserted into a table are listed in the ADD clause of the INSERT command.

The SET clause of the UPDATE command is used to identify the column(s)being updated.​

The MODIFY command can be used to change existing data stored in a table.

If non-numeric data is being added to a column,the data must be enclosed in double quotation marks.

If one of the data values being entered into a table by the INSERT command violates an existing constraint,the remaining portion of the row will be added,but the data violating the constraint will need to be added at a later time using the UPDATE command.

When a subquery is used in the INSERT command,the subquery does not have to be enclosed in parentheses.

The UPDATE command can be used to add data to existing rows in a table.

The BLOCK ACCESS command can be used to prevent other users from updating a specific table.

When data is added to a database table,it is automatically converted to upper-case letters.

A subquery can be used with the INSERT command to enter data from an existing table into the destination table.

When the INSERT command is used to add rows to a table,the column names of the table must be specified.

The SYSDATE keyword cannot be included in the INSERT command,only the UPDATE command.

The VALUES clause is not included with the INSERT command if the data is being retrieved from another table.

Single-row functions cannot be included in the UPDATE command.

If the WHERE clause is omitted from the UPDATE command,then all columns in the table will be changed.

If data is only being added to some of the columns in a table,the names of the columns must be listed in the VALUES clause.

If no value is assigned to a column when a row is added to a table,the column will contain a NULL value.

The INSERT command is used to modify existing data in a row.

The LOCK TABLE command can be used to prevent other users from making changes to a table.

The ROLLBACK command is used to permanently save changed data.

The data being inserted into a table are listed in the ADD clause of the INSERT command.

The SET clause of the UPDATE command is used to identify the column(s)being updated.