FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 8: Advanced Sql

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

True/False

Review LaterAdd Note

Review Later

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.

A) True
B) False

Correct Answer

verified

Show Answer

Question 2

Essay

Review LaterAdd Note

Review Later

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

Correct Answer

verified

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 3

Multiple Choice

Review LaterAdd Note

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.

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

Which statement describes a feature of Oracle sequences?

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

MySQL allows multiple triggering conditions per trigger.

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

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.

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

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

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

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

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

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

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

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

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

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

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