Which of the following is a valid datatype definition?
Answer : C
Columns in a table may be zonemapped. How are those columns chosen?
Answer : A
When doing a CREATE SEQUENCE, the largest "maximum value" is based onwhat?
Answer : A
On which component(s) does the UDX run?
Answer : B
Which procedural logic is NOT supported by NZPLSQL?
A. Scrollable Cursors -
B. Looping (while, for)
C. Conditionals (if/else)
D. Returning a scalar result or a result set
Answer : A Topic 2, Volume B
Which attribute CANNOT be defined for both users and groups?
Answer : D
Zone Maps provide what information about a table?
Answer : C
What is the maximum number of databases that can be created?
Answer : D
When working with sequences, which statement will always be true?
Answer : B
What is a characteristic of a column that is based on the TIMESTAMP datatype?
Answer : A
Which will result in support for zonemaps on the LastName column?
Answer : D
What is the maximum number of columns you can choose as organizing keys for clustered base table?
Answer : C
Which clause CANNOT be used with a CREATE VIEW statement?
Answer : C
When doing a CREATE TABLE, constraints can be specified at the column level. Which two constraints are NOT automatically enforced via the database? (Choose two.)
Answer : B,D