3517741
Pregunta 1
Pregunta
Name the two major reasons for choosing to use a database rather than a spreadsheet: [blank_start]organize and keep track of things[blank_end] and [blank_start]keep track of multiple themes[blank_end],
Respuesta
-
organize and keep track of things
-
keep track of multiple themes
Pregunta 2
Pregunta
A database is made up of [blank_start]columns[blank_end] and [blank_start]rows.[blank_end]
Respuesta
-
columns
-
rows.
Pregunta 3
Pregunta
Columns are also known as [blank_start]fields[blank_end] while rows are also known as [blank_start]records.[blank_end]
Respuesta
-
fields
-
records.
Pregunta 4
Pregunta
A field is made up of a group of
Respuesta
-
bits
-
Bytes
-
Characters
Pregunta 5
Pregunta
Rows are also known as Fields
Respuesta
- True
- False
Pregunta 6
Pregunta
The components of a database are: [blank_start]tables (or files)[blank_end], [blank_start]the relationships among the rows[blank_end] and [blank_start]metadata[blank_end].
Respuesta
-
tables (or files)
-
the relationships among the rows
-
metadata
Pregunta 7
Pregunta
A database uses a [blank_start]key[blank_end] which is found in every record.
Respuesta
-
key
Pregunta 8
Pregunta
To remain [blank_start]ethical[blank_end], queries must be limited to determine only information required to run the business.
Respuesta
-
ethical
Pregunta 9
Pregunta
Metadata is data about [blank_start]data.[blank_end]
Respuesta
-
data.
Pregunta 10
Pregunta
The following are Database Management Systems (DBMS) which must be licensed from the vendor.
Respuesta
-
DB2
-
Access
-
MySQL
-
SQL Server
-
Oracle Database
Pregunta 11
Pregunta
User permissions will allow a user to perform none, some, or all of the following operations:
Respuesta
-
Read
-
Insert
-
Modify
-
Delete
Pregunta 12
Pregunta
In order to query a database, most popular DBMSs use:
Respuesta
-
DB2
-
Access
-
SQL
Pregunta 13
Pregunta
One of thethree main duties of a database administrator are: Setting up a security system which involves [blank_start]user accounts[blank_end], [blank_start]passwords[blank_end] and [blank_start]permission[blank_end].
Respuesta
-
user accounts
-
passwords
-
permission
Pregunta 14
Pregunta
Permissions determine who can [blank_start]insert[blank_end], [blank_start]read[blank_end], [blank_start]change[blank_end] and [blank_start]delete[blank_end] data.
Respuesta
-
change
-
insert
-
read
-
delete
Pregunta 15
Pregunta
A database security system involves creating [blank_start]user accounts[blank_end], [blank_start]password rules[blank_end], [blank_start]permissions[blank_end] and [blank_start]processing limits[blank_end].
Respuesta
-
password rules
-
permissions
-
processing limits
-
user accounts
Pregunta 16
Pregunta
A database administrator has four main categories of tasks. They are: [blank_start]development[blank_end], [blank_start]operation[blank_end], [blank_start]backup and recovery[blank_end] and [blank_start]adaptation[blank_end].
Respuesta
-
development
-
operation
-
backup and recovery
-
adaptation
Pregunta 17
Pregunta
A problem tracking system is created for the [blank_start]operation[blank_end] phase. A change tracking system is created for the [blank_start]adaptation[blank_end] phase.
Respuesta
-
operation
-
adaptation
Pregunta 18
Pregunta
Forms make it easier for users to:
Respuesta
-
View data
-
Insert new data
-
Update existing data
-
Delete existing data
-
Run reports
Pregunta 19
Pregunta
Queries allow users to search for data in an efficient manner.
Respuesta
- True
- False
Pregunta 20
Pregunta
Reports are less structured than queries.
Respuesta
- True
- False
Pregunta 21
Pregunta
Application programs query the database on behalf of the user.
Respuesta
- True
- False
Pregunta 22
Pregunta
A dynamic content report allows the user to click on a field to [blank_start]produce other reports[blank_end] or [blank_start]take other actions.[blank_end]
Respuesta
-
produce other reports
-
take other actions.
Pregunta 23
Pregunta
Multi-user processing problems occur when two or more users are simultaneously changing the same data.
Respuesta
- True
- False
Pregunta 24
Pregunta
Data models are used to determine entities and their relationships. These are required for [blank_start]efficient[blank_end] database design.
Respuesta
-
efficient
Pregunta 25
Pregunta
A student's date of birth is an entity.
Respuesta
- True
- False
Pregunta 26
Pregunta
An identifier (or key) must be unique.
Respuesta
- True
- False
Pregunta 27
Pregunta
Each attribute has and entity.
Respuesta
- True
- False
Pregunta 28
Pregunta
1:N signifies a [blank_start]one-to-many[blank_end] relationship.
Respuesta
-
one-to-many
Pregunta 29
Pregunta
N:M signifies a [blank_start]many-to-many[blank_end] relationship.
Respuesta
-
many-to-many
Pregunta 30
Pregunta
A vertical bar on a crow's foot diagram means that one entity is required.
Respuesta
- True
- False
Pregunta 31
Pregunta
A small oval on a crow's foot diagram signifies that the relationship need not have an entity of that type.
Respuesta
- True
- False
Pregunta 32
Pregunta
The normalization of a data model means converting [blank_start]one poorly structured table[blank_end] into [blank_start]two or more well structured tables[blank_end].
Respuesta
-
one poorly structured table
-
two or more well structured tables
Pregunta 33
Pregunta
Data integrity problems can result in:
Respuesta
-
Loss of confidence in the information
-
Incorrect or inconsistent information
-
A poor reputation for the system
-
Raises for everyone
Pregunta 34
Pregunta
Combining two tables into one can create problems with [blank_start]data integrity[blank_end].
Respuesta
-
data integrity
Pregunta 35
Pregunta
Each entity should have its own [blank_start]table[blank_end] with one [blank_start]attribute[blank_end] in each [blank_start]column[blank_end].
Respuesta
-
table
-
attribute
-
column
Pregunta 36
Pregunta
The final judge of whether a data model is accurate is
Respuesta
-
The database administrator
-
Experienced representatives of the business
Pregunta 37
Pregunta
A new types of DBMS called [blank_start]NoSQL[blank_end] is becoming popular in situations where relational models aren't needed or don't fit.
Respuesta
-
NoSQL
Pregunta 38
Pregunta
The three main attributes of NoSQL are that it supports [blank_start]very high transaction rates[blank_end], [blank_start]relatively simple data structures[blank_end] and can be replicated on many servers in the cloud.
Respuesta
-
very high transaction rates
-
relatively simple data structures
Pregunta 39
Pregunta
Examples of NoSQL are [blank_start]Dynamo[blank_end], [blank_start]Bigtable[blank_end] and [blank_start]Cassandra[blank_end].
Respuesta
-
Dynamo
-
Bigtable
-
Cassandra
Pregunta 40
Pregunta
Conversion to NoSQL is being done by many companies because it is easy to learn and easy to convert older systems.
Respuesta
- True
- False
Pregunta 41
Pregunta
SQL injection is one of the most common form of attacks.
Respuesta
- True
- False
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.