Deck 6: Additional Database Objects

Question 1

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

Answer 1

True

Question 2

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

Answer 2

True

Question 3

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.

Answer 3

True

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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

Question 19

A sequence serves as a nickname for a database object.​

Question 20

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

Question 21

​The default value for the INCREMENT BY clause is two._________________________

Question 22

Using an identity column is particularly suited to use for a primary key when only random values are needed to uniquely identify rows.

Question 23

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

Question 24

A sequence can be used to speed up row retrieval.​

Question 25

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

Question 26

All synonyms are PUBLIC.

Question 27

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

Question 28

A DEFAULT sequence value will override any value provided for the column in an INSERT statement.

Question 29

A(n)sequence can be used to generate a series of numeric values._________________________

Question 30

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

Question 31

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

Question 32

A sequence value may be set as a DEFAULT value for a column.​

Question 33

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

Question 34

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

Question 35

A synonym is an alternate name assigned to database instances._________________________

Question 36

Only one identity column may be defined on a table.

Question 37

A(n)index can be used to generate a series of unique numbers._________________________​

Question 38

The default beginning value for a sequence is one._________________________​

Question 39

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

Question 40

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

Question 41

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 42

An index is implicitly created whenever a(n)CHECK constraint is created for a table column._________________________​

Question 43

​The USER_ALL data dictionary view displays information about all the relevant objects owned by the user._________________________

Question 44

A(n)index can be used to quickly determine whether a value already exists in a specific column._________________________​

Question 45

Both a minimum and maximum value can be defined for a(n)sequence._________________________

Question 46

​A(n)index can be created based on more than one column._________________________

Question 47

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

Question 48

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

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

Question 49

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

Question 50

The INCREMENT BY setting for a sequence cannot be changed with the ALTER SEQUENCE command._________________________

Question 51

​The CURRVAL pseudocolumn is used to generate the next value in a sequence._________________________

Question 52

A sequence can be deleted from the database using the DROP SEQUENCE command._________________________

Question 53

The CYCLE option prevents a sequence from regenerating previous values._________________________

Question 54

Indexes are usually created for frequently referenced or searched columns._________________________

Question 55

​Sequence settings can be altered using the ALTER SEQUENCE command._________________________

Question 56

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

Question 57

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

Question 58

The lowest possible value for an increasing sequence is 1._________________________

Question 59

To create a PUBLIC synonym,the PUBLIC keyword must be used in the CREATE SYNONYM command._________________________​

Question 60

​A(n)synonym is a collection of objects._________________________

Question 61

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

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

Question 62

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 63

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 64

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 65

​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 66

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 67

Oracle12c 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 68

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

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

Question 69

​The ____ options are used to determine whether Oracle12c 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 70

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 71

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 72

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 73

Which command will modify a sequence?​

A) ​ALTER SEQUENCE...MODIFY
B) ​ALTER SEQUENCE sequencename
C) ​ALTER SEQUENTIAL sequencename
D) ​ALTER SEQUENTIAL sequencename

Question 74

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 75

​Which option is used to have Oracle12c 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

Question 76

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 77

​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 78

Which command will delete a sequence?​

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

Question 79

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

A) ​The cache option instructs Oracle 12c to return the sequence values in the same order in which the user requests were received.
B) ​The cache option instructs Oracle 12c 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 80

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