Question
QUESTION 4 First normal form disallows: composite attributes multivalued attributes nested relations All of the above. 3 points QUESTION 5 Second normal form all attributes
QUESTION 4
First normal form disallows:
composite attributes | ||
multivalued attributes | ||
nested relations | ||
All of the above. |
3 points
QUESTION 5
Second normal form all attributes depend on nothing but the key.
True
False
3 points
QUESTION 6
Indexes are used to speed up record retrieval in response to certain search conditions
True
False
3 points
QUESTION 7
Index structures do not provide secondary access paths
True
False
3 points
QUESTION 8
Any field can be used to create an index
True
False
3 points
QUESTION 9
A ________ Index is an order file with two fields. A primary Key and a pointer to a disk block.
3 points
QUESTION 10
Dynamic multilevel indexes use B trees.
True
False
3 points
QUESTION 11
You cannot do indexes on multiple attributes.
True
False
3 points
QUESTION 12
_______ indexes are another type of index.
3 points
QUESTION 13
An index used in SQL server that uses all of the fields in a query is called a _________ index.
3 points
QUESTION 14
A transaction is a local unit of database processing.
True
False
3 points
QUESTION 15
The lost update problem is:
Occurs when two transactions that access the same database items have operations in sequence. | ||
Occurs when two transactions that access the same database items have operations interleaved. | ||
Occurs when two transactions that access the same database items have operations out of order. | ||
Occurs when two transactions that access the same database items have operations that are distinct from each other. |
3 points
QUESTION 16
The _________ log keeps track or transaction operations.
3 points
QUESTION 17
ACID means
Atomicity, Concurrency, isolation, and durability. | ||
Atomicity, Concurrency, independent, and durability. | ||
Atomicity, conistency, isolation, and durability. | ||
Atomicity, Concurrency, isolation, and dependability. |
3 points
QUESTION 18
repeatable read is the highest level of transaction support that allows no dirty reads, nonrepeatable reads, or phantoms to occur.
True
False
3 points
QUESTION 19
Serializable is the highest level of transaction support that allows no dirty reads, nonrepeatable reads, or phantomsto occur.
True
False
3 points
QUESTION 20
A ________ follows an event-condition-action model.
3 points
QUESTION 21
Temporal databases require some aspect of time when organizing information.
True
False
3 points
QUESTION 22
Time is not considered as an ordered sequence of points.
True
False
3 points
QUESTION 23
bitemporal time uses:
uses valid time and transaction time | ||
uses space time and transaction time | ||
uses valid time and trigger time | ||
uses valid time and invalid time |
3 points
QUESTION 24
Spatial databases support information about objects in time.
True
False
3 points
QUESTION 25
Spatial databases support information about objects in multidimensional space.
True
False
3 points
QUESTION 26
A ____________ database uses facts and rules.
3 points
QUESTION 27
XML and JSON
use self describing documents | ||
dynamic web pages | ||
all of the above | ||
none of the above. |
3 points
QUESTION 28
Conditions for well formed XML documents
Begins with XML declaration | ||
Syntaxically correct | ||
Valid (must follow a particular schema) | ||
All of the above. |
3 points
QUESTION 29
A XML ___________ defines a set of commands that can be used.
3 points
QUESTION 30
XML Query language standards are
Xpath | ||
Xquery | ||
none of the above | ||
both 1 and 2 are correct. |
3 points
QUESTION 31
XML Queries may use a ________ expression.
3 points
QUESTION 32
NOSQL means
Not only SQL | ||
Never a SQL | ||
T-SQL | ||
PL/SQL |
3 points
QUESTION 33
Cassandra
uses concepts from both key value store and column-bases systems. | ||
uses concepts from onlykey value store . | ||
uses concepts from column-bases systems. | ||
none of the above. |
3 points
QUESTION 34
Neo4j is a graph bases NOSQL system.
True
False
3 points
QUESTION 35
Voldemort is a
on demand system | ||
open source key value system | ||
undesirable attribute in a database | ||
row based sql system |
3 points
QUESTION 36
Hbase stored multiple versions of data items.
True
False
3 points
QUESTION 37
Hbase does not use apache zookeeper and HDFS.
True
False
3 points
QUESTION 38
Marklogic is a XML bases NOSQL database that uses Xquery.
True
False
3 points
QUESTION 39
To insert a lot of data into a marklogic database.
have a lot of people key in the data. | ||
use the marklogic data pump. | ||
use T-SQL | ||
use PL/SQL |
3 points
QUESTION 40
Marklogic uses both d-nodes and e-nodes in a cluster.
True
False
3 points
QUESTION 41
Data Mining is the discovery of new information in term of patterns or rules from vast amounts of data.
True
False
3 points
QUESTION 42
A _____ _______ is a historical database designed for decision support.
3 points
QUESTION 43
Classification is not the process of learning a model that is able to describe different classes of data.
True
False
3 points
QUESTION 44
______ Clusering is a popular data mining algorithm.
3 points
QUESTION 45
Some commerical data mining tools are:
Intelligent miner | ||
Polyanalyst | ||
Enterprise miner | ||
all of the above |
3 points
QUESTION 46
Database security is NOT a broad area, it is very specific.
True
False
3 points
QUESTION 47
Some types of database control measures are:
Access control | ||
Inference control | ||
Flow control | ||
All of the above |
3 points
QUESTION 48
The concept of privacy goes beyond security.
True
False
3 points
QUESTION 49
The most common threat to a database system is _____ ________.
3 points
QUESTION 50
Risks associated with SQL Injection:
Denial of Service | ||
T-SQL not working. | ||
Oracle not being able to sell products. | ||
ACID being upheld. |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started