Deck 6: Additional Database Objects

Question 1

If the minimum value for a sequence is not specified, then NOMINVALUE will be assumed as the default.

Answer 1

True

Question 2

When a sequence is created for internal control purposes, the values should not be cached otherwise gaps may appear in the sequence.

Answer 2

True

Question 3

The highest possible value for a descending sequence is -1.

Answer 3

True

Question 4

The NOCACHE option specifies that the sequence can generate a number only after a request has been made by a user.

Question 5

When a negative value is assigned to the INCREMENT BY clause of the CREATE SEQUENCE command, numeric values are generated in descending order.

Question 6

The START WITH clause is used to identify the starting numeric value for a synonym.

Question 7

A synonym is an alternate name assigned to a database object.

Question 8

The START WITH clause of a sequence cannot be reset with the ALTER SEQUENCE command.

Question 9

The highest possible value for a sequence can be specified through the MAXVALUE clause.

Question 10

The NEXTVALUE pseudocolumn is used to actually generate the next value in a sequence.

Question 11

The NEXTVAL pseudocolumn can be referenced in an INSERT command to add the value to a database table.

Question 12

The USER_SEQUENCES view of the data dictionary can be used to determine the current values and settings for a sequence.

Question 13

A sequence serves as a nickname for a database object.

Question 14

To change the starting value for a sequence, the sequence must be dropped and then re-created.

Question 15

When a positive value is assigned to the INCREMENT BY clause of the CREATE SEQUENCE command, numeric values are generated in descending order.

Question 16

By default, the START WITH clause has a value of one.

Question 17

Pre-generated sequence numbers that have not been used when the database is shut down will no longer be available when the database is restarted.

Question 18

By default, the lowest value that can be generated by a sequence is 0.

Question 19

A database index allows users and application programs to quickly locate specific records.

Question 20

After the highest possible value for a sequence has been reached, previous values can be reused if the NOCYCLE option has been specified.

Question 21

A Bitmap index is useful for improving queries on columns that have low cardinality.

Question 22

A function-based index can be used for queries that include searches based upon arithmetic expressions or functions.

Question 23

A(n) $\underline {\text { sequence } }$ can be used to generate a series of numeric values. _________________________

Question 24

A synonym is an alternate name assigned to database $\underline { \text { instances } }$ . _________________________

Question 25

All synonyms are PUBLIC.

Question 26

A basic CREATE INDEX command will create a B-Tree index.

Question 27

The default beginning value for a sequence is $\underline { \text { one. } }$ _________________________

Question 28

When a positive value is assigned to the INCREMENT BY clause of the CREATE SEQUENCE command, numeric values are generated in $\underline {\text { ascending } }$ order. _________________________

Question 29

The $\underline { \text { CYCLE } }$ option prevents a sequence from regenerating previous values. _________________________

Question 30

Both a minimum and maximum value can be defined for a(n) $\underline { \text { sequence } }$ . _________________________

Question 31

The lowest possible value for an increasing sequence is $\underline { 1 . }$ . _________________________

Question 32

An index is implicitly created when a NOT NULL constraint is added to a table.

Question 33

A synonym can be created for any database object such as a table or sequence.

Question 34

The default value for the INCREMENT BY clause is $\underline { \text { two. } }$ _________________________

Question 35

The USER_INDEXES data dictionary view can be used to verify existing indexes.

Question 36

A(n) $\underline { \text { index } }$ can be used to generate a series of unique numbers. _________________________

Question 37

A sequence can be used to speed up row retrieval.

Question 38

A column has low cardinality if it contains many distinct values.

Question 39

An explicitly created index can be dropped with the DROP INDEX command.

Question 40

The $\underline { \text { GENERATE } }$ option can be used to have a sequence pre-generate a set of numbers before they are requested by a user. _________________________

Question 41

Which of the following is defined in Oracle11g as simply anything that has a name and a defined structure?

A) object
B) index
C) synonym
D) sequence

Question 42

A(n) ____ synonym is used by an individual to reference objects owned by that person.

A) unique
B) duplicated
C) public
D) private

Question 43

A(n) $\underline {\text { index } }$ can be created based on more than one column. _________________________

Question 44

The $\underline {\text { USER ALL }}$ data dictionary view displays information about all the relevant objects owned by the user. _________________________

Question 45

$\underline { \text { Indexes } }$ are usually created for frequently referenced or searched columns. _________________________

Question 46

Sequence settings can be altered using the $\underline {\text { ALTER SEQUENCE }}$ command. _________________________

Question 47

A(n) ____ synonym is used by others to access an individual's database objects.

A) unique
B) duplicated
C) public
D) private

Question 48

The $\underline { \text { INCREMENT BY } }$ BY setting for a sequence cannot be changed with the ALTER SEQUENCE command. _________________________

Question 49

A(n) $\underline {\text { synonym } }$ is a collection of objects. _________________________

Question 50

To create a PUBLIC synonym, the $\underline {\text { PUBLIC } }$ keyword must be used in the CREATE SYNONYM command. _________________________

Question 51

A large table containing a particular column that is frequently referenced by a WHERE clause would probably benefit from a(n) $\underline {\text { sequence } }$ . _________________________

Question 52

An index is implicitly created whenever a(n) $\underline {\text { CHECK } }$ constraint is created for a table column. _________________________

Question 53

A(n) $\underline {\text { index } }$ can be used to quickly determine whether a value already exists in a specific column. _________________________

Question 54

A(n) ____ generates sequential integers that can be used by organizations to assist with internal controls or simply to serve as a primary key for a table.

A) view
B) index
C) synonym
D) sequence

Question 55

The USER_INDEXES data dictionary view can be used to verify existing indexes. _________________________

Question 56

Which of the following can be used to provide an alternative, simplified name, to identify database objects?

A) view
B) index
C) synonym
D) sequence

Question 57

Which of the following serves the same basic purpose as an index in a book, by allowing users to quickly locate specific records?

A) view
B) index
C) synonym
D) sequence

Question 58

The $\underline { \text { CURRVAI } }$ pseudocolumn is used to generate the next value in a sequence. _________________________

Question 59

The USER_SEQ data dictionary view can be used to verify sequence settings. _________________________

Question 60

A sequence can be deleted from the database using the $\underline { \text { DROP SEQUENCE } }$ command. _________________________

Question 61

Which command will create a synonym for a table?

A) CREATE SYNONYM synonymname IN tablename;
B) CREATE SYNONYM synonymname ON tablename;
C) CREATE SYNONYM synonymname REFERENCE tablename;
D) CREATE SYNONYM synonymname FOR tablename;

Question 62

Which of the following statements about sequences is incorrect?

A) A sequence can be used to generate unique names for database objects.
B) A sequence can be used to generate unique values to serve as a primary key.
C) A sequence can be used to generate sequential values for internal control purposes.
D) A sequence can be used to generate sequential numbers to track records like checks, invoices, and purchase orders.

Question 63

The ____ options are used to determine whether Oracle10g should begin reissuing values from the sequence once the minimum or maximum value has been reached.

A) CYCLE | NOCYCLE
B) MINIMUMVALUE | MAXIMUMVALUE
C) CACHE | NOCACHE
D) REORDER | NOREORDER

Question 64

Which of the following is a pseudocolumn?

A) CURRENTVAL
B) DUAL
C) NEXTVAL
D) both a and c

Question 65

If a sequence is set to pre-generate sequential values, ____ values will be generated at one time by default.

A) 5
B) 10
C) 15
D) 20

Question 66

A negative number can be assigned to the ____ clause to generate sequential numbers in decreasing order.

A) DECREMENT BY
B) INCREMENT BY
C) DECREASE BY
D) GENERATE BY

Question 67

Which command will create a sequence named NEWSEQUENCE to generate a series of integers?

A) CREATE SEQUENCE newsequence;
B) CREATE SEQUENCE STARTING WITH 5;
C) CREATE SEQUENTIAL newsequence STARTING WITH 5;
D) none of the above

Question 68

When working with cached sequence values, which of the following is correct?

A) The cache option instructs Oracle10g to return the sequence values in the same order in which the user requests were received.
B) The cache option instructs Oracle10g not to generate any more numbers after the minimum or maximum value has been reached.
C) When a value has been generated and cached, that value has been assigned and cannot be regenerated until the sequence begins a new cycle.
D) The highest value for a cached number is 10^44.

Question 69

Which command will delete a sequence?

A) ALTER SEQUENCE...DELETE
B) ALTER SEQUENCE...DROP
C) DELETE SEQUENCE sequencename
D) DROP SEQUENCE sequencename

Question 70

To verify individual settings for the clauses of a sequence, you can query the ____ table in the data dictionary.

A) USER_SEQUENCES
B) V$SEQUENCES
C) DISPLAY_SEQUENCES
D) VIEW_SEQUENCES

Question 71

Which options are used in application cluster environments where multiple users may be requesting sequence values at the same time?

A) CYCLE | NOCYCLE
B) MINVALUE | MAXVALUE
C) VALUECACHE | NOVALUECACHE
D) ORDER | NOORDER

Question 72

The ____ clause is used to specify the interval between two sequential values.

A) INTERVAL SIZE
B) INCREMENT BY
C) STEP BY
D) START WITH

Question 73

Which command will create an index?

A) CREATE INDEX indexname IN tablename (columnname)
B) CREATE INDEX indexname REFERENCE (columnname)
C) CREATE INDEX indexname ON tablename (columnname)
D) CREATE INDEX indexname INCREMENT BY (columnname)

Question 74

Which of the following keywords is used to actually generate a sequence value?

A) NEXTVALUE
B) NEXTVAL
C) GENERATEVAL
D) GENERATE

Question 75

Which of the following is used to establish a minimum or maximum value, respectively, for a sequence?

A) MINIMUMVALUE | MAXIMUMVALUE
B) MINVALUE | MAXVALUE
C) STARTWITH | ENDWITH
D) BEGINVALUE | ENDVALUE

Question 76

Which of the following statements about NEXTVAL and CURRVAL is incorrect?

A) The pseudocolumn NEXTVAL is used to actually generate the sequence value.
B) After the value is generated, it is stored in the CURRVAL pseudocolumn so it can be referenced again by a user.
C) A reference to CURRVAL will not cause Oracle10g to generate a new sequence number; a reference to NEXTVAL, however, will generate a new number.
D) NEXTVAL and CURRVAL are pseudocolumns that store unique names for database objects.

Question 77

Which command will modify a sequence?

A) ALTER SEQUENCE...MODIFY
B) ALTER SEQUENCE sequencename
C) ALTER SEQUENTIAL sequencename
D) CREATE OR REPLACE SEQUENCE

Question 78

Oracle10g will begin each sequence with the value of one, unless another value is specified in the ____ clause.

A) START WITH
B) INTERVAL SIZE
C) INCREMENT BY
D) VALUE START

Question 79

When creating a sequence, which of the following is not an optional clause?

A) INCREMENT BY value
B) CYCLE | NOCYCLE
C) MAXVALUE value | NOMAXVALUE
D) CREATE SEQUENCE

Question 80

Which option is used to have Oracle11g pre-generate a set of values and store those values in the server's memory?

A) INTERVAL STORE
B) CACHE VALUE
C) CACHE
D) INCREMENT BY