Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

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

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

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

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

Accepted Answer

A) True 
 B)False

Question 8

A(n)____ lock will prevent any DDL operations from being performed on the locked table.​

Accepted Answer

A)  ​shared 
B)  ​exclusive 
C)  ​partial 
D)  ​partitioned 
A)  ​shared 
B)  ​exclusive 
C)  ​partial 
D)  ​partitioned

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A)  ​UPDATE acctmanager SET amedate = SYSDATE WHERE amid = 'J500'; 
B)  ​UPDATE acctmanager SET amname = UPPER(amname); 
C)  ​UPDATE acctmanager SET amname = UPPER(amname)WHERE amid = 'J500'; 
D)  ​UPDATE acctmanager WHERE amid = 'J500'; 
A)  ​UPDATE acctmanager SET amedate = SYSDATE WHERE amid = 'J500'; 
B)  ​UPDATE acctmanager SET amname = UPPER(amname); 
C)  ​UPDATE acctmanager SET amname = UPPER(amname)WHERE amid = 'J500'; 
D)  ​UPDATE acctmanager WHERE amid = 'J500';

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

The data values being added to a table with the INSERT command must be listed in the ____________________ clause.​

Accepted Answer

The answer of The data values being added to a...

Question 15

______________________________ commands are used to modify data.​

Accepted Answer

DML
Data m

Question 16

Contents of the PUBLISHER table​
  
-Which of the following commands will delete only publisher 4 from the PUBLISHER table?

Accepted Answer

A)  ​DELETE FROM publisher; 
B)  ​DELETE pubid = 4 FROM publisher; 
C)  ​DROP FROM publisher WHERE pubid = 4; 
D)  ​DELETE FROM publisher WHERE pubid = 4; 
A)  ​DELETE FROM publisher; 
B)  ​DELETE pubid = 4 FROM publisher; 
C)  ​DROP FROM publisher WHERE pubid = 4; 
D)  ​DELETE FROM publisher WHERE pubid = 4;

Question 17

Which keyword permanently saves changed data in a table?​

Accepted Answer

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

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Contents of the PROMOTION table​
   ​
-Which of the following SQL statements will insert a new row into the PROMOTION table?​

Accepted Answer

A)  ​INSERT INTO promotion (gift,minretail,maxretail)
VALUES (FREE BOOK,75.01,89.99); 
B)  ​INSERT INTO promotion (gift,minretail,maxretail)
VALUES ('FREE BOOK',75.01,89.99); 
C)  ​INSERT INTO promotion VALUES (FREE BOOK,75.01,89.99); 
D)  ​both a and c 
A)  ​INSERT INTO promotion (gift,minretail,maxretail)
VALUES (FREE BOOK,75.01,89.99); 
B)  ​INSERT INTO promotion (gift,minretail,maxretail)
VALUES ('FREE BOOK',75.01,89.99); 
C)  ​INSERT INTO promotion VALUES (FREE BOOK,75.01,89.99); 
D)  ​both a and c

Question 20

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

Accepted Answer

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 <= SYSDAT
E) ; 
C)  ​INSERT INTO acctmantable
AS (SELECT amid,amname,amedate,region
FROM acctmanager
WHERE amedate <= SYSDAT
E) ; 
D)  ​none of the above 
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 <= SYSDAT
E) ; 
C)  ​INSERT INTO acctmantable
AS (SELECT amid,amname,amedate,region
FROM acctmanager
WHERE amedate <= SYSDAT
E) ; 
D)  ​none of the above

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

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

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

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

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

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

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

A(n)____ lock will prevent any DDL operations from being performed on the locked table.

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

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

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

Which of the following is not a valid SQL command?

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

The data values being added to a table with the INSERT command must be listed in the ____________________ clause.

______________________________ commands are used to modify data.

Contents of the PUBLISHER table -Which of the following commands will delete only publisher 4 from the PUBLISHER table?

Which keyword permanently saves changed data in a table?

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

Contents of the PROMOTION table -Which of the following SQL statements will insert a new row into the PROMOTION table?

Which of the following is not a valid SQL command?

Overview of Database Concepts

Basic SQL Select Statements

Table Creation and Management

Constraints

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single-Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

Exam 5: Data Manipulation and Transaction Control

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

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

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

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

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

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

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

A(n)____ lock will prevent any DDL operations from being performed on the locked table.​

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

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

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

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

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

The data values being added to a table with the INSERT command must be listed in the ____________________ clause.​

______________________________ commands are used to modify data.​

Contents of the PUBLISHER table​ -Which of the following commands will delete only publisher 4 from the PUBLISHER table?

Which keyword permanently saves changed data in a table?​

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

Contents of the PROMOTION table​ ​ -Which of the following SQL statements will insert a new row into the PROMOTION table?​

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

Overview of Database Concepts

Basic SQL Select Statements

Table Creation and Management

Constraints

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single-Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

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

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

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

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

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

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

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

A(n)____ lock will prevent any DDL operations from being performed on the locked table.

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

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

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

Which of the following is not a valid SQL command?

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

The data values being added to a table with the INSERT command must be listed in the ____________________ clause.

______________________________ commands are used to modify data.

Contents of the PUBLISHER table -Which of the following commands will delete only publisher 4 from the PUBLISHER table?

Which keyword permanently saves changed data in a table?

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

Contents of the PROMOTION table -Which of the following SQL statements will insert a new row into the PROMOTION table?

Which of the following is not a valid SQL command?