Questão 1
Questão
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],
Questão 2
Questão
A database is made up of [blank_start]columns[blank_end] and [blank_start]rows.[blank_end]
Questão 3
Questão
Columns are also known as [blank_start]fields[blank_end] while rows are also known as [blank_start]records.[blank_end]
Questão 4
Questão
A field is made up of a group of
Questão 5
Questão
Rows are also known as Fields
Questão 6
Questão
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].
Questão 7
Questão
A database uses a [blank_start]key[blank_end] which is found in every record.
Questão 8
Questão
To remain [blank_start]ethical[blank_end], queries must be limited to determine only information required to run the business.
Questão 9
Questão
Metadata is data about [blank_start]data.[blank_end]
Questão 10
Questão
The following are Database Management Systems (DBMS) which must be licensed from the vendor.
Responda
-
DB2
-
Access
-
MySQL
-
SQL Server
-
Oracle Database
Questão 11
Questão
User permissions will allow a user to perform none, some, or all of the following operations:
Responda
-
Read
-
Insert
-
Modify
-
Delete
Questão 12
Questão
In order to query a database, most popular DBMSs use:
Questão 13
Questão
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].
Responda
-
user accounts
-
passwords
-
permission
Questão 14
Questão
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.
Responda
-
change
-
insert
-
read
-
delete
Questão 15
Questão
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].
Responda
-
password rules
-
permissions
-
processing limits
-
user accounts
Questão 16
Questão
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].
Responda
-
development
-
operation
-
backup and recovery
-
adaptation
Questão 17
Questão
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.
Questão 18
Questão
Forms make it easier for users to:
Responda
-
View data
-
Insert new data
-
Update existing data
-
Delete existing data
-
Run reports
Questão 19
Questão
Queries allow users to search for data in an efficient manner.
Questão 20
Questão
Reports are less structured than queries.
Questão 21
Questão
Application programs query the database on behalf of the user.
Questão 22
Questão
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]
Responda
-
produce other reports
-
take other actions.
Questão 23
Questão
Multi-user processing problems occur when two or more users are simultaneously changing the same data.
Questão 24
Questão
Data models are used to determine entities and their relationships. These are required for [blank_start]efficient[blank_end] database design.
Questão 25
Questão
A student's date of birth is an entity.
Questão 26
Questão
An identifier (or key) must be unique.
Questão 27
Questão
Each attribute has and entity.
Questão 28
Questão
1:N signifies a [blank_start]one-to-many[blank_end] relationship.
Questão 29
Questão
N:M signifies a [blank_start]many-to-many[blank_end] relationship.
Questão 30
Questão
A vertical bar on a crow's foot diagram means that one entity is required.
Questão 31
Questão
A small oval on a crow's foot diagram signifies that the relationship need not have an entity of that type.
Questão 32
Questão
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].
Questão 33
Questão
Data integrity problems can result in:
Responda
-
Loss of confidence in the information
-
Incorrect or inconsistent information
-
A poor reputation for the system
-
Raises for everyone
Questão 34
Questão
Combining two tables into one can create problems with [blank_start]data integrity[blank_end].
Questão 35
Questão
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].
Questão 36
Questão
The final judge of whether a data model is accurate is
Questão 37
Questão
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.
Questão 38
Questão
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.
Questão 39
Questão
Examples of NoSQL are [blank_start]Dynamo[blank_end], [blank_start]Bigtable[blank_end] and [blank_start]Cassandra[blank_end].
Responda
-
Dynamo
-
Bigtable
-
Cassandra
Questão 40
Questão
Conversion to NoSQL is being done by many companies because it is easy to learn and easy to convert older systems.
Questão 41
Questão
SQL injection is one of the most common form of attacks.