Answer the following statements true (T) or false (F)

1) A view is created with WITH CHECK OPTION to prevent modifications to all
columns used in the view.
2) CURRVAL returns the START WITH value of a sequence for a sequence that is
created but never used to generate a value.
3) When a view is dropped, the underlying table is also dropped.
4) When a table is dropped, the sequence used on that table also gets dropped.


1) F
2) F
3) F
4) F

Computer Science & Information Technology

You might also like to view...

Which of the following statements is false?

a. Each intermediate operation results in a new stream. b. Each new stream is simply an object representing the processing steps that have been specified to that point in the pipeline. c. Chaining intermediate-operation method calls adds to the set of processing steps to perform on each stream element. The last stream object in the stream pipeline contains all the processing steps to perform on each stream element. d. When you initiate a stream pipeline with a terminal operation, the each processing step is applied for to all the stream elements before the next processing step is applied.

Computer Science & Information Technology

Which of the following is not an advantage of a high level language?

a. It is easier to use than machine language. b. Its statements resemble English. c. It is portable. d. Memory can be referenced symbolically. e. It is easy for the machine to understand.

Computer Science & Information Technology

The convention used in this book for named constants is ____ characters ____ underscores to separate words.

A. uppercase, with B. uppercase, without C. lowercase, with D. lowercase, without

Computer Science & Information Technology

In ____, the procedure Pg sleep(5) delays a system for five seconds.

A. Access B. Oracle C. MySQL D. SQL Server

Computer Science & Information Technology