Copy and Edit

Llena blanco Cap 1 y 2

Description

Yes you can!
Angel Perez
Quiz by Angel Perez, updated more than 1 year ago
Angel Perez
Created by Angel Perez over 8 years ago
13
1
0

Resource summary

Question 1

Question
It is the job of a program called a(n) [blank_start]database management system[blank_end] to store and retrieve data in database tables.
Answer
  • database management system

Question 2

Question
A single-user database that is used by only one person at a time is called a(n) [blank_start]personal[blank_end] database.
Answer
  • personal

Question 3

Question
A database that is used by more than one person at a time is called a(n) [blank_start]multi-user[blank_end] database.
Answer
  • multi-user

Question 4

Question
[blank_start]Organizational[blank_end] databases were the first applications of database technology.
Answer
  • Organizational

Question 5

Question
A(n) [blank_start]workgroup[blank_end] database is characterized by having 25 or fewer concurrent users and 100 megabytes or less data.
Answer
  • workgroup

Question 6

Question
In database processing systems, the data is directly accessed only by the [blank_start]database management system[blank_end].
Answer
  • database management system

Question 7

Question
In database application processing systems, the user interacts directly with the [blank_start]database application programs[blank_end].
Answer
  • database application programs

Question 8

Question
The first business information systems stored groups of records in separate files and were called [blank_start]file-processing systems[blank_end].
Answer
  • file-processing systems

Question 9

Question
The most serious problem with data duplication concerns [blank_start]data integrity[blank_end].
Answer
  • data integrity

Question 10

Question
A collection of data has [blank_start]integrity[blank_end] if it is logically consistent.
Answer
  • integrity

Question 11

Question
In file-processing systems, the [blank_start]physical format[blank_end] of files and records are part of the application code.
Answer
  • physical format

Question 12

Question
A(n) [blank_start]database[blank_end] is a self-describing collection of integrated records.
Answer
  • database

Question 13

Question
The description of the structure of a database is stored in the [blank_start]metadata[blank_end] , also known as the data dictionary or the data directory.
Answer
  • metadata

Question 14

Question
In the standard data hierarchy, a byte, or character, is composed of [blank_start]bits[blank_end] .
Answer
  • bits

Question 15

Question
In the standard data hierarchy, a field is composed of [blank_start]bytes[blank_end] .
Answer
  • bytes

Question 16

Question
In the standard data hierarchy, a record is composed of [blank_start]fields[blank_end] .
Answer
  • fields

Question 17

Question
In the standard data hierarchy, a file is composed of [blank_start]records[blank_end] .
Answer
  • records

Question 18

Question
A(n) [blank_start]index[blank_end] is used to represent relationships among the data and to improve the performance of database applications.
Answer
  • index

Question 19

Question
When the structure of a form or report is part of the database it is called [blank_start]application metadata[blank_end] .
Answer
  • application metadata

Question 20

Question
The database is a(n) [blank_start]dynamic[blank_end] model because businesses change.
Answer
  • dynamic

Question 21

Question
[blank_start]Transactions[blank_end] are representations of events that must be processed against the database.
Answer
  • Transactions

Question 22

Question
A database is a model of the [blank_start]users’[blank_end] model or view of the business.
Answer
  • users’

Question 23

Question
The [blank_start]relational[blank_end] database model stores data as tables, with rows and columns.
Answer
  • relational

Question 24

Question
In the relational model, the process of [blank_start]normalization[blank_end] is used to change an undesirable table into two or more desirable tables.
Answer
  • normalization

Question 25

Question
Originally, it was thought that the relational model would allow [blank_start]users[blank_end] to obtain their own information from databases.
Answer
  • users

Question 26

Question
One impact of the movement of database technology from mainframes to microcomputers was the dramatic improvement in DBMS [blank_start]user interfaces[blank_end] .
Answer
  • user interfaces

Question 27

Question
The use of multiple CPUs in processing database applications in LAN-based multi-user database architecture produced greater [blank_start]performance[blank_end] .
Answer
  • performance

Question 28

Question
Of the two types of LAN-based multi-user database processing, [blank_start]client-server database architecture[blank_end] is the more complex and robust.
Answer
  • client-server database architecture

Question 29

Question
Of the two types of LAN-based multi-user database processing, [blank_start]file-sharing architecture[blank_end] is the simpler and less robust.
Answer
  • file-sharing architecture

Question 30

Question
A(n) [blank_start]distributed[blank_end] database is logically integrated but physically located in more than one place.
Answer
  • distributed

Question 31

Question
Object-oriented database systems developed to handle the structures processed by [blank_start]object-oriented programming[blank_end] .
Answer
  • object-oriented programming

Question 32

Question
The database is processed by the [blank_start]Database Management System[blank_end] , which is used by both users and developers.
Answer
  • Database Management System

Question 33

Question
Today, most databases represent user data in [blank_start]relations[blank_end] , which are tables of data.
Answer
  • relations

Question 34

Question
In a table of users’ data, the columns contain [blank_start]fields[blank_end].
Answer
  • fields

Question 35

Question
The process of [blank_start]normalization[blank_end] is used to change poorly structured tables into well-structured ones.
Answer
  • normalization

Question 36

Question
Most DBMS products store metadata in tables, sometimes called [blank_start]system tables[blank_end] .
Answer
  • system tables

Question 37

Question
One advantage to storing metadata in tables is that [blank_start]developers[blank_end] can use the same tools to query the metadata as they do to query the users’ data.
Answer
  • developers

Question 38

Question
A type of database data that consists primarily of indexes is called [blank_start]overhead data[blank_end] .
Answer
  • overhead data

Question 39

Question
Overhead data typically includes indexes and sometimes [blank_start]linked lists[blank_end] .
Answer
  • linked lists

Question 40

Question
Indexes are useful for [blank_start]sorting[blank_end] and search operations.
Answer
  • sorting

Question 41

Question
The structure and format of user forms, reports, and other application components are stored in the database as [blank_start]application metadata[blank_end] .
Answer
  • application metadata

Question 42

Question
The [blank_start]design tools[blank_end] subsystem contains tools to facilitate the creation of the database.
Answer
  • design tools

Question 43

Question
The [blank_start]run-time[blank_end] subsystem processes the application components created using the design tools
Answer
  • run-time

Question 44

Question
The DBMS engine is the intermediary between the other DBMS components and the [blank_start]data[blank_end] .
Answer
  • data

Question 45

Question
The DBMS engine receives requests from the other DBMS components and translates them into commands for the [blank_start]operating system[blank_end] to read or write data from the physical media.
Answer
  • operating system

Question 46

Question
A database [blank_start]schema[blank_end] defines a database’s structure – its tables, relationships, domains, and business rules.
Answer
  • schema

Question 47

Question
A database schema is a(n) [blank_start]design[blank_end] .
Answer
  • design

Question 48

Question
A(n) [blank_start]domain[blank_end] is a set of values that a column may have.
Answer
  • domain

Question 49

Question
[blank_start]Business rules[blank_end] are restrictions on the business’s activities that need to be reflected in the database and database applications.
Answer
  • Business rules

Question 50

Question
A primary key from one table that is placed into another table to declare a relationship is called a(n) [blank_start]foreign key[blank_end] in the second table.
Answer
  • foreign key

Question 51

Question
[blank_start]Surrogate keys[blank_end] are identifiers that are created only to allow each row in a table to be uniquely identified and have no meaning to the users.
Answer
  • Surrogate keys

Question 52

Question
Queries can be expressed to the database using the data access language called [blank_start]SQL[blank_end] .
Answer
  • SQL

Question 53

Question
QBE, which stands for [blank_start]query by example[blank_end] , is a means of expressing a query to the database.
Answer
  • query by example

Question 54

Question
Queries can be [blank_start]parameterized[blank_end] , meaning that they are constructed to accept a criteria value at the time they are run.
Answer
  • parameterized

Question 55

Question
A means of expressing a query to the database called [blank_start]query by form[blank_end] allows the user to enter query constraints on a data entry form.
Answer
  • query by form

Question 56

Question
A(n) [blank_start]report[blank_end] is a formatted display of data.
Answer
  • report

Question 57

Question
[blank_start]Menus[blank_end] are used to organize application components to make them more accessible to the end user and to provide control over the users’ activities.
Answer
  • Menus
Show full summary Hide full summary

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

Quiz Geral
miminoma
Macbeth Scene Summaries
Ebony1023
PHYSICS P1 1
x_clairey_x
To Kill A Mockingbird GCSE English
naomisargent
Maths Revision- end of year test
hannahsquires
Enzymes and Respiration
I Turner
GCSE REVISION TIMETABLE
gracemiddleton
AQA Biology B2 Unit 2.1 - Cells Tissues and Organs
BeccaElaine
AS Biology Unit 1
lilli.atkin
2PR101 1.test - 3. část
Nikola Truong
Creating Mind Maps with GoConqr
Sarah Egan
Browse Library