Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Database > Chapter6 > Flashcards

Chapter6 Flashcards

1
Q

is the main database object

A

Tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

is defined with columns and stores rows of data

A

Table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

are used to hold temporary data specific to a transaction or session

A

Temporary tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q
  • these types of columns do not consume storage space on disk
  • database derives values in virtual columns from normal columns
A

Virtual columns

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q
  • is a customized representation of data from one or more tables and/or view
  • are queries stored in the database that select data from one or more tables
A

View

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

is a way to generate continuous numbers

A

Sequence

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

is an alias for any table, view, sequence, or other accessible database object

A

Synonym

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

are objects used to summarize and replicate data

A

Materialized view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

is a logical structure to define the relationship between columns in a table

A

Dimension

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

is a method of storing data from related tables at a common physical

A

Cluster

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

are created with user-defined datatypes.

A

Object table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

is a collection of related database objects grouped together

A

schema

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

is a schema object that enables you to access an object from a different database.

A

Database links

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

is a stored PL/SQL program that gets executed when a specified condition occurs on the table.

A

Tiggers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

any java stuff

A

java objects

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q
  • procedure
  • function
  • packages
A

PL/SQL programs

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

is a PL/SQL programmatic construct

A

procedure

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

like procedure but it returns a value

A

function

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

it is a grouping of related PL/SQL

A

package

20
Q
  • variable length strings (backward compatibility)
  • discourage in Oracle
  • 2GBYTES
A

long

21
Q

variable length binary string

2Kbytes

A

raw

22
Q
  • variable length binary strings

- 2GBYTES

A

long raw

23
Q
  • is one of the Large Object datatypes provided to store variable length character data
  • Character large object
A

CLOB

24
Q

is one of the Large Object datatypes and stores variable-length Unicode character data

A

NCLOB

25
Q
  • represents all non-Oracle numeric datatypes(floats, decimal, integer)
  • can store both fixed-point and floating-point number
A

Number

26
Q

datatype represents a 32-bit floating-point number

A

Binary_Float

27
Q

datatype represents a 64-bit floating-point number

A

BINARY_DOUBLE

28
Q

it a subtype of Number ans is internally represented as Number

A

FLOAT

29
Q

it stores date and time information

A

date

30
Q
  • stores date and time information with fractional seconds precision
  • fractional_seconds_precision
A

timestamp

31
Q

Equivalent to Number (p,0)

A

INTEGER

32
Q

NCHAR with max 4K bytes, no blank-padded

A

NVARCHAR2

33
Q

Base-64 string unique row address

A

ROWID

34
Q

Base-64 string index-organized table

A

UROWID

35
Q

Binary large object

A

BLOB

36
Q

locator to a large binary file outside database

A

BFILE

37
Q

the special characters allowed in identifier name are the $, _ , #

A

also do not use quotation marks on identifier name

38
Q

table and column names are ____

- can be up to 30 characters long

A

identifiers

39
Q

the existing data in the table is validated to verify that it conforms to the constraint.

A

Enable validate

40
Q

This does not validate the existing data but enables the constraint for future constraint checking

A

Enable Novalidate

41
Q

The constraint id disable but the constraint is kept valid

A

Disable Validate

42
Q

the constraint is disabled and no checks are done on or future or existing data

A

Disable novalidate

43
Q

index in the form of a balanced tree

A

B-tree index

44
Q
  • each bit position represents a row that may or may not contain the indexed value
  • best for low-cardinality column
A

bitmap index

45
Q

is a structure associated with tables used to speed up the queries

A

index

Database (6 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions