Brainscape's Knowledge GenomeTM

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


See full index

Oracle 11g SQL > Ch.1/ Lab 6 Quiz > Flashcards

Ch.1/ Lab 6 Quiz Flashcards

1
Q

Data in second normal form (2NF) may contain which of the following?

  • repeating groups
  • transitive dependencies
  • partial dependencies
  • both a and b
A

transitive dependencies

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

Analyzing historical sales data stored in a database is commonly referred to as ____.

  • data storage
  • data mining
  • data manipulation
  • archived data
A

data mining

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

Which of the following may contain partial dependencies, but cannot contain repeating groups?

  • unnormalized data
  • first normal form (1NF)
  • second normal form (2NF)
  • third normal form (3NF)
A

first normal form (1NF)

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

What is added to a relational database to eliminate many-to-many relationships?

  • bridging table
  • transitive dependency
  • primary entity
  • secondary entity
A

bridging table

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

A DBMS includes which of the following capabilities?

  • security
  • data dictionary
  • multiuser access
  • all of the above
A

all of the above

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

Which of the following is an interface tool that allows a user to create, edit, and manipulate data in Oracle11g?

  • SQL
  • SQL*Plus
  • ASCII
  • Script
A

SQL*Plus

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

In which step of the Systems Development Life Cycle (SDLC) are the logical and physical components defined?

  • systems recovery
  • systems analysis
  • systems design
  • systems implementation and review
A

systems design

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

If entity A in Figure 2 represents customers and entity B represents automobiles, which of the following statements is correct?

  • Each customer can only own one car, but each car can be owned by many customers.
  • Each customer can only own one car and each car can only be owned by one customer.
  • Each customer can own many cars and each car can be owned by many customers.
  • Each customer can own many cars, but each car can be owned by only one customer
A

Each customer can own many cars, but each car can be owned by only one customer.

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

Which of the following is used to determine the correct organization for data that is to be stored in a database?

  • E-R model
  • normalization process
  • systems implementation and review
  • systems analysis
A

normalization process

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

A ____ is a storage structure designed to hold a collection of data.

  • column
  • row
  • table
  • database
A

database

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

Which of the following is used to uniquely identify each record?

  • primary key
  • row
  • partial dependency
  • account number
A

primary key

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

Which of the following is not a step in the Systems Development Life Cycle (SDLC)?

  • systems analysis
  • -systems investigation
  • systems design
  • all of the above are steps in the SDLC
A

all of the above are steps in the SDLC

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

Data in third normal form (3NF) contains which of the following?

  • repeating groups
  • transitive dependencies
  • partial dependencies
  • none of the above
A

none of the above

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

What represents a characteristic or attribute that is being collected about an entity?

  • record
  • row
  • field
  • both a and b
A

field

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

Suppose that a patient in a hospital can only be assigned to one room. However, the room may be assigned to more than one patient at a time. This is an example of what type of relationship?

  • one-to-many
  • many-to-many
  • one-to-all
  • one-to-one
A

one-to-many

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

A record in the logical design of a database is represented by what in the physical database?

  • attribute
  • field
  • tuple
  • row
A

row

17
Q

Which of the following can be used to link the data in two or more tables together?

  • repeating group
  • relationships
  • SDLC
  • common field
A

common field

18
Q

Which of the following committees are responsible for establishing SQL guidelines?

  • ANSI and ASCII
  • ANSI and ISO
  • IEEE and OSI
  • OSI and ASCII
A

ANSI and ISO

19
Q

Which of the following terms refers to a group of related records?

  • database
  • character
  • field
  • file
A

file

20
Q

A field in the logical design of a database is represented by what in the physical database?

  • column
  • row
  • field
  • row
A

column

21
Q

A foreign key is usually found on which side of a relationship?

  • one
  • many
  • unnormalized
  • primary entity
A

many

22
Q

The fact that a person can wear different size clothes and that different people can wear the same size clothes is best characterized as a what type of relationship?

  • one-to-many
  • many-to-many
  • one-to-all
  • one-to-one
A

many-to-many

23
Q

Which of the following usually correlates to a primary key in another table?

  • transitive dependency
  • composite primary key
  • foreign key
  • partial dependency
A

foreign key

24
Q

Which of the following is used to create and maintain the physical database?

  • Data mining
  • Database Management System (DBMS)
  • E-R Model
  • Systems Development Life Cycle (SDLC)
A

Database Management System (DBMS)

25
Q

Partial dependency exists if what conditions exist?

  • a column is dependent on a portion of the table that is not identified as the primary key
  • a column is dependent only on a portion of a composite primary key
  • the data contains repeating groups
  • the table is not in first normal form (1NF)
A

a column is dependent only on a portion of a composite primary key

26
Q

In an E-R Model a person, place, or thing with characteristics to be stored in the database are referred to as?

  • entity
  • row
  • attribute
  • file
A

entity

27
Q

The multi-step process used when creating a new system is referred to as ____.

  • Systems Development Life Cycle (SDLC)
  • data mining
  • E-R Modeling
  • SQL
A

Systems Development Life Cycle (SDLC)

28
Q

What name is used to denote a common field that exists between two tables, but is also the primary key for one of the tables?

  • duplicate key
  • foreign key
  • composite primary key
  • distinct key
A

-foreign key

29
Q

Which of the following does not contain repeating groups, but has a primary key and possibly partial dependencies?

  • unnormalized data
  • first normal form (1NF)
  • second normal form (2NF)
  • third normal form (3NF)
A

-first normal form (1NF)

30
Q

Which of the following can lead to partial dependencies?

  • composite primary key
  • common fields
  • foreign keys
  • normalization
A

composite primary key

Oracle 11g SQL (10 decks)

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