Question 1

MySQL allows multiple triggering conditions per trigger.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A)   no rows will be deleted
B)   the first row will be deleted
C)   the last row will be deleted
D)   all rows will be deletedE) A) and B)
F) A) and C)

Question 3

In Oracle, _____ retrieves the current value of a sequence.

Accepted Answer

A)   NEXTVAL
B)   CURRVAL
C)   VARCHAR
D)   VARCHAR2E) A) and B)
F) C) and D)

Question 4

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

Accepted Answer

A)   DELETE FROM      PRODUCTWHERE                   P_CODE = 'BRT-345';
B)   REMOVE FROM PRODUCTWHERE P_CODE = 'BRT-345';
C)   ERASE FROM        PRODUCTWHERE                   P_CODE = 'BRT-345';
D)   ROLLBACK FROM   PRODUCTWHERE                      P_CODE = 'BRT-345';E) B) and C)
F) None of the above

Question 5

_____ is the term used to describe an environment in which the SQL statement is not known in advance and is generated at run time.

Accepted Answer

The answer of _____ is the term used to describe...

Question 6

Words used by a system that cannot be used for any other purpose are called _____ words. For example, in Oracle SQL, the word INITIAL cannot be used to name tables or columns.

Accepted Answer

A)   reserved
B)   unique
C)   null
D)   characterE) A) and B)
F) A) and C)

Question 7

In Oracle, you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks.

Accepted Answer

A) True 
 B)False

Question 8

_____ words are words used by SQL to perform specific functions.

Accepted Answer

Reserved

Question 9

What is a schema? How many schemas can be used in one database?

Accepted Answer

In the SQL environment, a schema is a lo...

Question 10

A view is a virtual table based on a SELECT query.

Accepted Answer

A) True 
 B)False

Question 11

A(n) _____-length character data type, like VARCHAR, is typically specified with a maximum length.

Accepted Answer

The answer of A(n) _____-length character data type, like VARCHAR,...

Question 12

A(n) _____ view is a view that can be used to update attributes in the base table(s) that are used in the view.

Accepted Answer

updatable

Question 13

Summarize the hierarchy of steps involved in creating and running an executable program with embedded SQL statements.

Accepted Answer

While the steps required to create and e...

Question 14

The SQL data type DATE stores date in the _____ date format.

Accepted Answer

The answer of The SQL data type DATE stores date...

Question 15

Which statement describes a feature of Oracle sequences?

Accepted Answer

A)   Oracle sequences are tied to columns and tables.
B)   Oracle sequences generate a character string that can be assigned to tables.
C)   An Oracle sequence uses the identity column property to automatically number rows.
D)   Dropping a sequence does not delete values assigned to table attributes; it deletes only the sequence object from the database.E) None of the above
F) C) and D)

Question 16

All changes in a table structure are made using the _____ TABLE command, followed by a keyword that produces the specific changes a user wants to make.

Accepted Answer

A)   ALTER
B)   COMMIT
C)   UPDATE
D)   ROLLBACKE) B) and D)
F) A) and B)

Question 17

The _____ specification creates an individualindex ona respective attribute; use it to avoid having duplicated values in a column.

Accepted Answer

A)   UNIQUE
B)   NOT NULL
C)   UPDATE
D)   VARCHARE) A) and B)
F) None of the above

Question 18

How can a table be deleted from the database? Provide an example.

Accepted Answer

A table can be deleted from the database using the DROP TABLE command.For example, a user can delete the PART table with the following command:
DROP TABLE PART;
The user can drop a table only if it is not the "one" side of any relationship.If the user tries to drop a table otherwise, the RDBMS will generate an error message indicating that a foreign key integrity violation has occurred.

Question 19

The _____ command permanently saves all changes-such as rows added, attributes modified, and rows deleted-made to any table in the database.

Accepted Answer

A)   COMMIT
B)   SELECT
C)   ROLLBACK
D)   UPDATEE) None of the above
F) All of the above

Question 20

The most useful feature of PL/SQL blocks is that they let a designer create code that can be named, stored, and executed by the DBMS.

Accepted Answer

A) True 
 B)False

Exam 8: Advanced Sql

MySQL allows multiple triggering conditions per trigger.

Correct Answer
verified

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

Correct Answer
verified

In Oracle, _____ retrieves the current value of a sequence.

Correct Answer
verified

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

Correct Answer
verified

_____ is the term used to describe an environment in which the SQL statement is not known in advance and is generated at run time.

Correct Answer
verified

Words used by a system that cannot be used for any other purpose are called _____ words. For example, in Oracle SQL, the word INITIAL cannot be used to name tables or columns.

Correct Answer
verified

In Oracle, you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks.

Correct Answer
verified

_____ words are words used by SQL to perform specific functions.

Correct Answer
verified
Reserved

What is a schema? How many schemas can be used in one database?

Correct Answer
verified
In the SQL environment, a schema is a lo...
View Answer

A view is a virtual table based on a SELECT query.

Correct Answer
verified

A(n) _____-length character data type, like VARCHAR, is typically specified with a maximum length.

Correct Answer
verified

A(n) _____ view is a view that can be used to update attributes in the base table(s) that are used in the view.

Correct Answer
verified
updatable

Summarize the hierarchy of steps involved in creating and running an executable program with embedded SQL statements.

Correct Answer
verified
While the steps required to create and e...
View Answer

The SQL data type DATE stores date in the _____ date format.

Correct Answer
verified

Which statement describes a feature of Oracle sequences?

Correct Answer
verified

All changes in a table structure are made using the _____ TABLE command, followed by a keyword that produces the specific changes a user wants to make.

Correct Answer
verified

The _____ specification creates an individualindex ona respective attribute; use it to avoid having duplicated values in a column.

Correct Answer
verified

How can a table be deleted from the database? Provide an example.

The _____ command permanently saves all changes-such as rows added, attributes modified, and rows deleted-made to any table in the database.

Correct Answer
verified

The most useful feature of PL/SQL blocks is that they let a designer create code that can be named, stored, and executed by the DBMS.

Correct Answer
verified

Exam 8: Advanced Sql

MySQL allows multiple triggering conditions per trigger.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

In Oracle, _____ retrieves the current value of a sequence.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

_____ is the term used to describe an environment in which the SQL statement is not known in advance and is generated at run time.

Correct AnswerverifiedShow Answer

Words used by a system that cannot be used for any other purpose are called _____ words. For example, in Oracle SQL, the word INITIAL cannot be used to name tables or columns.

Correct AnswerverifiedShow Answer

In Oracle, you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks.

Correct AnswerverifiedShow Answer

_____ words are words used by SQL to perform specific functions.

Correct AnswerverifiedReserved

What is a schema? How many schemas can be used in one database?

Correct AnswerverifiedIn the SQL environment, a schema is a lo...View AnswerShow Answer

A view is a virtual table based on a SELECT query.

Correct AnswerverifiedShow Answer

A(n) _____-length character data type, like VARCHAR, is typically specified with a maximum length.

Correct AnswerverifiedShow Answer

A(n) _____ view is a view that can be used to update attributes in the base table(s) that are used in the view.

Correct Answerverifiedupdatable

Summarize the hierarchy of steps involved in creating and running an executable program with embedded SQL statements.

Correct AnswerverifiedWhile the steps required to create and e...View AnswerShow Answer

The SQL data type DATE stores date in the _____ date format.

Correct AnswerverifiedShow Answer

Which statement describes a feature of Oracle sequences?

Correct AnswerverifiedShow Answer

All changes in a table structure are made using the _____ TABLE command, followed by a keyword that produces the specific changes a user wants to make.

Correct AnswerverifiedShow Answer

The _____ specification creates an individualindex ona respective attribute; use it to avoid having duplicated values in a column.

Correct AnswerverifiedShow Answer

How can a table be deleted from the database? Provide an example.

The _____ command permanently saves all changes-such as rows added, attributes modified, and rows deleted-made to any table in the database.

Correct AnswerverifiedShow Answer

The most useful feature of PL/SQL blocks is that they let a designer create code that can be named, stored, and executed by the DBMS.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Reserved

Correct Answer
verified
In the SQL environment, a schema is a lo...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
updatable

Correct Answer
verified
While the steps required to create and e...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified