DAT 380 Wk 1 - Practice: Pre-Course Assessment Quiz | eBooks | Education

DAT 380 Wk 1 - Practice: Pre-Course Assessment Quiz

DAT 380 Wk 1 - Practice: Pre-Course Assessment Quiz PLDZ-13204 Free
In Stock
$ 0.00 USD
Free Download! Description


Click Here To Download Your Files :  



You can buy more tutorials from the below link



DAT 380 Wk 1 - Practice: Pre-Course Assessment Quiz

Which of the following is true of spreadsheet applications?

  • They enhance the user's ability to understand the data.
  • They provide enhanced security and robust data sharing features.
  • They do not allow manipulation of data once entered.
  • They are a better alternative to databases.



Disjoint subtypes are subtypes that contain nonunique subsets of the supertype entity set.

  • True
  • False


A data dictionary is sometimes described as "the database designer's database" because it records the design decisions about tables and their structures.

  • True
  • False


A weak entity has a primary key that is partially or totally derived from the parent entity in the relationship.

  • True
  • False


The "_____" characteristic of a primary key states that the primary key should not have embedded semantic meaning.

  • nonintelligent
  • unique values
  • preferably single-attribute
  • security-compliant


Each row in the relational table is known as an entity instance or entity occurrence in the ER model.

  • True
  • False


In Oracle, you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks.

  • True
  • False



Structure is based on the type of processing to be performed on the data.

  • True
  • False

In the context of total completeness, in a(n) _____, every supertype occurrence is a member of at least one subtype.

  • disjoint constraint
  • overlapping constraint
  • unique constraint
  • foreign key constraint



A(n) _____ is the attribute in the supertype entity that determines to which entity subtype each supertype occurrence is related.

  • subtype discriminator
  • entity supertype
  • specialization hierarchy
  • inheritance discriminator



The tables on which a view, or a virtual table derived from a SELECT query, are based are called _____ tables.

  • indexed
  • core
  • base
  • relation

One of the major advantages of stored procedures is that they can be used to encapsulate and represent business transactions.

  • True
  • False

A _____ is a character or group of characters that has a specific meaning.

  • file
  • record
  • database
  • field

To implement a small database, a database designer must know the "1" and the "M" sides of each relationship and whether the relationships are mandatory or optional.

  • True
  • False

Database design is a(n) _____ process based on repetition.

  • linear
  • sequential
  • intermittent
  • iterative

A system is always at some stage of SDLC because every request for structural changes requires retracing the steps of the Systems Development Life Cycle (SDLC).

  • True
  • False

SQL allows the use of logical restrictions on its inquiries such as OR, AND, and NOT.

  • True
  • False

In a(n) _____ diagram, the arrows above the attributes indicate all desirable dependencies.

  • Chen
  • ER
  • functionality
  • dependency

The term "database development" is used to describe the process of database design and implementation.

  • True
  • False

The hierarchical data model was developed in the _____.

  • 1990s
  • 1960s
  • 1980s
  • 1970s

In the _____ model, the basic logical structure is represented as an upside-down tree.

  • entity relationship
  • network
  • relational
  • hierarchical

Each table _____ represents an attribute.

  • value
  • dimension
  • column
  • row

When the specific cardinalities are not included on the diagram in Crow's Foot notation, cardinality is implied by the use of _____.

*************************************************************** Click Here To Download Your Files : https://uopcourse.com/category/dat-380/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ You can buy more tutorials from the below link http
Recent Reviews Write a Review
0 0 0 0 reviews