Oracle-Database Schema Objects Part 2

Front 1

optional structure designed to help you gain faster access to data by placing it in a sorted order.

Back 1

index

Front 2

You can include up to how many columns in a composite index?

Back 2

16

Front 3

Which type of Oracle index contains multiple columns?

Back 3

composite

Front 4

contains information that speeds access to data by determining the location of indexed data with as few I/Os as possible

Back 4

index segment

Front 5

Oracle indexes data by using an index structure known as a?

Back 5

B*-tree index

Front 6

The index blocks on the lowest level that contain every indexed data value and the associated ROWID of that data is called?

Back 6

leaf blocks

Front 7

the data values are sorted first by the index key and then by the ROWID with this type of index?

Back 7

nonunique

Front 8

Use indexes when queries access less than "x%" of the rows in the table.

Back 8

5%

Front 9

This helps to determine whether your queries are taking advantage of the indexes.

Back 9

sql trace facility

Front 10

If you do not include the columns that are indexed in the this clause, the index will probably be bypassed, thus causing a table scan.

Back 10

where

Front 11

This shows the query execution plan that the optimizer has chosen for your SQL statements.

Back 11

explain plan

Hint 11

Helps you to tell whether you are taking advantage of indexes

Front 12

indexes can be created using these 3 utilites?

Back 12

Enterprise Manager, Schema Manager or Create index command

Front 13

Clicking the Table Columns field on the Create Index screen determines which of the following?

Back 13

The order the columns are created in the new index

Front 14

Which SQL command is used to define a new Oracle index?

Back 14

create index

Front 15

Write the code statement that creates the index IDNUM_IX1 for the table DOG_INFO. It will include the table column named ID.

Back 15

create index IDNUM_IX1 on DOG_INFO (ID);

Front 16

These kind of indexes are created in a manner different from the underlying partitioning of the table that is indexed.

Back 16

global

Front 17

These kind of indexes are partitioned in the same manner as the underlying table partitioning and are created for partitioned tables only.

Back 17

Local

Front 18

Write a code statement that creates a local index named region_ix1 for the region column in the warehouse table of an Oracle database.

Back 18

create index region_ix1 on warehouse (region) Local;

Front 19

indicates which rows correspond to the index item.

Back 19

bitmap index

Hint 19

If set, this indicates that the corresponding row contains the key value; if not set, the corresponding row does not contain the value.

Front 20

This term is used when there is a small amount of variance in the possible values stored in that column.

Back 20

Low cardinality

Hint 20

bitmap index can greatly improve performance with columns that have this.

Front 21

Write a code statement that creates a bitmap index named dname_bx1 for the dog_name column in the dog_info table of an Oracle database.

Back 21

create bitmap index dname_bx1 on dog_info (dog_name);

Front 22

database objects that point to another object in the system

Back 22

Synonyms

Hint 22

they are aliases for tables, views, sequences, or program units.

Front 23

a)This synonym is available to every user in the database, b)This synonym is contained in the schema of the user who created it, and that user has control over who has access to it.

Back 23

a)Public, b)private

Front 24

Write the command that creates the synonym DOGS for the DOG_ID table in an Oracle database. Make it a public synonym.

Back 24

create public synonym DOGS for DOG_ID;