Deck 5: Data Manipulation and Transaction Control

Question 1

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

Answer 1

False

Question 2

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

Answer 2

False

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.​

Answer 3

False

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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

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.​

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.​

Question 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

When Oracle 12c encounters a substitution variable,the user will be prompted for the actual value to be assigned to the variable.

Question 22

The UPDATE command can be used to change data stored in a table._________________________​

Question 23

An explicit commit is issued when the user executes a COMMIT; command.​

Question 24

If the WHERE clause of the DELETE command is omitted,then all rows in the referenced table will be removed.​

Question 25

A value must be provided in an INSERT statement for a virtual column.​

Question 26

A transaction is defined as the set of statements that are committed at one time.​

Question 27

An ON NULL clause may be used in conjunction with a column's DEFAULT option.​

Question 28

The COMMIT command is used to add new rows to a table._________________________​

Question 29

The DROP command can be used to remove rows from an existing table._________________________

Question 30

A shared lock is automatically obtained when the SELECT...FOR UPDATE command is executed.​

Question 31

After a COMMIT command is executed,the ROLLBACK command will have no affect on the changed data._________________________​

Question 32

A shared lock prevents another user from performing DDL or DML operations on the table.​

Question 33

A deadlock occurs when two users hold shared locks on portions of a table that are needed to complete the transaction of the other user.​

Question 34

If a user has a shared lock on a table,this will prevent any other user from obtaining a shared or exclusive lock on the same table.​

Question 35

The USER_TAB_COLUMNS data dictionary object may be used to identify columns that are assigned an ON NULL clause.​

Question 36

The SELECT...FOR UPDATE can be used to create a shared lock._________________________

Question 37

Commands used to modify data are known as DML commands.​

Question 38

The WHERE clause of the DELETE command is used to identify the rows to be deleted from the table.​

Question 39

Data that is being added to a table is specified in the VALUES clause of the INSERT command._________________________

Question 40

If more than one data value is being added to a table,the values must be separated by parentheses._________________________​

Question 41

The variable name of a substitution variable is preceded by a(n)percent sign._________________________​

Question 42

When DDL operations are performed,Oracle 12c will automatically place a(n)shared lock on the table._________________________​

Question 43

A(n)exclusive lock is automatically obtained when the user executes the SELECT...FOR UPDATE command._________________________​

Question 44

If the WHERE clause is omitted from the DELETE command,then all columns from the database table will be dropped._________________________​

Question 45

A(n)implicit commit is issued when the user enters and executes COMMIT; in SQL*Plus._________________________​

Question 46

A table can be locked in SHARE MODE or EXCLUSIVE MODE._________________________​

Question 47

The SYSDATE keyword can be used in the INSERT command to enter the computer's system date when adding a row to a table._________________________​

Question 48

When including a subquery in an INSERT command,the syntax of enclosing the subquery in parentheses is mandatory._________________________​

Question 49

Which of the following commands is used to add rows to a table?​

A) ​ADD
B) ​UPDATE
C) ​INSERT
D) ​ENTER

Question 50

A(n)exclusive lock prevents other users from changing the data stored in the table._________________________​

Question 51

A(n)shared lock prevents other users from obtaining another shared lock on the same table._________________________​

Question 52

When the column names are listed in the INSERT INTO clause of the INSERT command,the order of the names must exactly match the order of the data values in the UPDATE clause._________________________​

Question 53

If the SET clause of the UPDATE command is omitted,then all rows in the table will be updated with the new data value._________________________​

Question 54

A lock is automatically released when the user issues a transaction control statement such as COMMIT or ROLLBACK._________________________​

Question 55

The WHERE clause of the UPDATE command is used to specify exactly which rows should be changed._________________________​

Question 56

A COMMIT is explicitly issued when the user exits SQL*Plus._________________________​

Question 57

Transaction control statements are used to either save modified data or to undo changes before they are committed._________________________​

Question 58

A NULL value can be included in the data being added to a table by explicitly entering the word NULL._________________________​

Question 59

Which of the following commands is used to modify existing data in a table?​

A) ​ADD
B) ​UPDATE
C) ​INSERT
D) ​MODIFY

Question 60

The VALUES clause of the UPDATE command is used to specify the columns being updated and the new data values._________________________​

Question 61

Which of the following keywords is omitted from the INSERT command if the data to be added to a table is already contained in another table?​

A) ​INSERT
B) ​INTO
C) ​VALUES
D) ​none of the above

Question 62

When inserting a row into a table,how can you indicate that a row contains a NULL value?​

A) ​In the VALUES clause,substitute two single quotation marks for the NULL value.
B) ​In the VALUES clause,include the keyword NULL in the position where the value should be listed.
C) ​In the VALUES clause,include a blank space in the position where the value should be listed.
D) ​both a and b

Question 63

When new rows are being added to a table,the actual data being added are listed in the ____ clause.​

A) ​INSERT INTO
B) ​DATA
C) ​VALUES
D) ​ADD

Question 64

Which of the following is not a valid SQL command?​

A) ​INSERT INTO acctmantable
SELECT amid,amname,amedate,region
FROM acctmanager
WHERE amedate <= SYSDATE;
B) ​INSERT INTO acctmantable
(SELECT amid,amname,amedate,region
FROM acctmanager
WHERE amedate <= SYSDATE);
C) ​INSERT INTO acctmantable
AS (SELECT amid,amname,amedate,region
FROM acctmanager
WHERE amedate <= SYSDATE);
D) ​none of the above

Question 65

If a table already exists,what command would you issue to add copies of existing rows from one table to the other?​

A) ​INSERT command with an UPDATE clause
B) ​INSERT command with a SET clause
C) ​INSERT command with a subquery
D) ​none of the above

Question 66

Which keyword permanently saves changed data in a table?​

A) ​COMMIT
B) ​SAVE
C) ​UPDATE
D) ​ADD

Question 67

Which of the following commands is used to add data to an existing row in a table?​

A) ​ADD
B) ​UPDATE
C) ​INSERT
D) ​MODIFY

Question 68

Use the ____ keyword to enter the computer's date as a data value in the INSERT command.​

A) ​SYSTEMDATE
B) ​DATE
C) ​SYSDATE
D) ​COMPDATE

Question 69

When the INSERT command is being used to enter data into a non-numeric column,the data must be enclosed in ____.​

A) ​parentheses
B) ​double quotation marks
C) ​single quotation marks
D) ​upper-case letters

Question 70

Which of the following commands is used to remove rows from a table?​

A) ​DELETE
B) ​DROP
C) ​REMOVE
D) ​MODIFY

Question 71

Which of the following will allow a user to enter a NULL value using the INSERT command?​

A) ​Omit the column from the column list in the INSERT INTO clause.
B) ​Substitute two single quotation marks in the VALUES clause in the position of the column that is to be assigned the NULL value.
C) ​Use the NULL keyword.
D) ​all of the above

Question 72

What will happen if you try to use the INSERT command to insert a NULL value into a column that has been assigned a PRIMARY KEY constraint? ​

A) ​The command will execute because a PRIMARY KEY value can be NULL.
B) ​An error message is returned and the row is not added to the table.
C) ​The command will execute because only a UNIQUE constraint forbids NULL values.
D) ​An error message is returned but the unaffected portion of the row is added to the table.

Question 73

If more than one column is listed in the INSERT INTO clause,the column names must be separated by ____.​

A) ​commas
B) ​single quotation marks
C) ​double quotation marks
D) ​parentheses

Question 74

Which of the following is a valid statement?​

A) ​When rows are added to a table,the column names can be omitted if an entry is only being made into the first column.
B) ​When rows are added to a table,the column names can be omitted if the values are listed in the same order as the columns are listed in the table.
C) ​If rows are being added to a table with the UPDATE command,an entry must be made into each column contained in the table.
D) ​none of the above

Question 75

Which of the following statements about the INSERT keyword is incorrect?​

A) ​The keywords INSERT INTO are followed by the table name.
B) ​The VALUES clause identifies the data values that will be inserted into the table.
C) ​Oracle 12c does not allow column names to be omitted from the INSERT INTO clause.
D) ​If more than one column is listed,column names must be separated by commas.

Question 76

Which keywords create a shared lock on a table to prevent another user from making changes to data in specified columns?​

A) ​SELECT...LOCK
B) ​SELECT...COMMIT
C) ​SELECT...FOR UPDATE
D) ​SELECT...FOR CHANGE

Question 77

Which of the following commands allows a user to "undo" uncommitted changes to data?​

A) ​UNDO
B) ​ROLLBACK
C) ​UNCOMMIT
D) ​UNLOCK

Question 78

When data is being entered into a VARCHAR2 or CHAR column using the INSERT command,the data will be stored in ____.​

A) ​upper-case characters
B) ​lower-case characters
C) ​the default case setting for the table
D) ​the same case used in the INSERT command

Question 79

Regarding the INSERT statement,which of the following is correct?​

A) ​Non-numeric data is enclosed in single quotation marks.
B) ​Column names are enclosed in parentheses ( ).
C) ​The data values to be inserted are enclosed in parentheses ( )after the VALUES keyword.
D) ​all of the above

Question 80

Which command is used to prevent other users from making changes to a table?

A) ​COMMIT
B) ​COMMIT TABLE
C) ​BLOCK
D) ​LOCK TABLE