Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/24

Click to flip

24 Cards in this Set

  • Front
  • Back
  • 3rd side (hint)
optional structure designed to help you gain faster access to data by placing it in a sorted order.
index
You can include up to how many columns in a composite index?
16
Which type of Oracle index contains multiple columns?
composite
contains information that speeds access to data by determining the location of indexed data with as few I/Os as possible
index segment
Oracle indexes data by using an index structure known as a?
B*-tree index
The index blocks on the lowest level that contain every indexed data value and the associated ROWID of that data is called?
leaf blocks
the data values are sorted first by the index key and then by the ROWID with this type of index?
nonunique
Use indexes when queries access less than "x%" of the rows in the table.
5%
This helps to determine whether your queries are taking advantage of the indexes.
sql trace facility
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.
where
This shows the query execution plan that the optimizer has chosen for your SQL statements.
explain plan
Helps you to tell whether you are taking advantage of indexes
indexes can be created using these 3 utilites?
Enterprise Manager, Schema Manager or Create index command
Clicking the Table Columns field on the Create Index screen determines which of the following?
The order the columns are created in the new index
Which SQL command is used to define a new Oracle index?
create index
Write the code statement that creates the index IDNUM_IX1 for the table DOG_INFO. It will include the table column named ID.
create index IDNUM_IX1 on DOG_INFO (ID);
These kind of indexes are created in a manner different from the underlying partitioning of the table that is indexed.
global
These kind of indexes are partitioned in the same manner as the underlying table partitioning and are created for partitioned tables only.
Local
Write a code statement that creates a local index named region_ix1 for the region column in the warehouse table of an Oracle database.
create index region_ix1 on warehouse (region) Local;
indicates which rows correspond to the index item.
bitmap index
If set, this indicates that the corresponding row contains the key value; if not set, the corresponding row does not contain the value.
This term is used when there is a small amount of variance in the possible values stored in that column.
Low cardinality
bitmap index can greatly improve performance with columns that have this.
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.
create bitmap index dname_bx1 on dog_info (dog_name);
database objects that point to another object in the system
Synonyms
they are aliases for tables, views, sequences, or program units.
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.
a)Public, b)private
Write the command that creates the synonym DOGS for the DOG_ID table in an Oracle database. Make it a public synonym.
create public synonym DOGS for DOG_ID;