1. Which of the following is not one of the main traits that defines Big Data: Q
ID: 3859239 • Letter: 1
Question
1. Which of the following is not one of the main traits that defines Big Data:
Question options:
A
Multiple venues of data relationships
B
Diverse variety in data formats
C
High velocity in data flow
D
Large volumes of digitally stored data
2.
For the following tables, which SQL command would:
List the Supplier Name and Item Description [ItemDesc] for each item the supermarket sales.
Question options:
A
SELECT SupName, ItemDesc FROM ITEM JOIN SUPPLIER ON supIDfk = supID
B
SELECT * from ITEM, SUPPLIER
C
LIST SupName, ItemDesc FROM ITEM, SUPPLIER where supIDfk = supID
D
SELECT SupName, ItemDesc FROM ITEM, SUPPLIER
3. ______________________ is a popular technology designed to efficiently process large amounts of diverse types of data. Words associated with this technology include 'Pig', 'Hive', 'Zookeeper'.
Question options:
A
data warehousing
B
hadoop
C
high speed SQL processing
D
data mining
4.
NoSQL databases are predicted to overtake relational database systems in the next few years.
Question options:
True
False
5.
Choose the answer that best maps the following ERD to tables.
Question options:
A
MOVIE(MovieID,Title,ReleaseDate,Director) ACTOR(ActorID,ActorLastname,ActorFirstName,AgentName) INTERSECTION(MovieID,ActorID)
B
MOVIE(MovieID,Title,ReleaseDate,Director) ACTOR(ActorID,ActorLastname,ActorFirstName,AgentName,MovieID)
C
MOVIE(MovieID,Title,ReleaseDate,Director,ActorID) ACTOR(ActorID,ActorLastname,ActorFirstName,AgentName) INTERSECTION(MovieID,ActorID,ActorLastName,ReleaseDate)
D
MOVIEINFO(MovieID, Title,ReleaseDate,Director, ActorLastname,ActorFirstName,AgentName)
E
MOVIE(MovieID,Title,ReleaseDate,Director,ActorID) ACTOR(ActorID,ActorLastname,ActorFirstName,AgentName)
6.
When a transaction functions in such a way that either all of the transaction actions are completed or none of them will be, the transaction is said to be:
Question options:
A
consistent
B
atomic
C
locked
D
logical
E
isolated
7.
What concurrent processing problem occurs when a transaction reads a changed record that has not been committed to the database?
Question options:
A
Unlocked reads
B
Serialized reads
C
Dirty reads
D
Nonrepeatable reads
E
Phantom reads
8.
The purpose of concurrency control is to:
Question options:
A
Ensure that no two SQL statements are executed at the same time.
B
Ensure that every input form has a corresponding output report.
C
Ensure that one user's work does not interfere with another's.
D
Ensure that resource locking is always used.
9.
Serializable prevents which of the following?
Question options:
A
Lost-update
B
Phantom read
C
Dirty read
D
Nonrepeatable read
E
All of the above
10.
Given the following security matrix, the GAMES table is accessed by how many forms?
Question options:
A
None
B
1
C
2
D
3
E
All tables
11.
SELECT ALL THAT APPLY:
Who is responsible for insuring the confidentiality of data in the Kennesaw Owlexpress database?
Remember: SELECT ALL THAT APPLY.
Question options:
A
Students
B
Database Administrators
C
Faculty
D
Database programmers
12.
What concurrent processing problem occurs when a transaction rereads data and finds new rows that were inserted by a different transaction since the prior read?
Question options:
A
Unlocked reads
B
Nonrepeatable reads
C
Phantom reads
D
Dirty reads
E
Serialized reads
13.
Row level security is often implemented through the use of:
Question options:
A
SQL views
B
Prepared Queries
C
User profiles and assigned processing rights
D
Username and password
14.
HIPPA is related to:
Question options:
A
Police records
B
DNA databases
C
Bank records
D
healthcare data
15.
It is the KSU Fighting Owls football team's inaugural season and season tickets are in high demand. In fact, only one season ticket remains. Student A and Student B both want season tickets. Given the following, who gets the ticket?
Question options:
A
Student A and Student B both get the ticket
B
Not enough information to tell.
C
Student B
D
Student A
16.
SQL injections occur most often because of stolen passwords.
Question options:
A
True
B
False
17.
Which of the following about deadlocks is untrue?
Question options:
A
Most database systems automatically check for and resolve deadlocks.
B
Deadlocks occur when two transactions are each waiting for access to a table that the other one has locked.
C
Deadlocks rarely happen.
D
Serialized locking of all resources utilized by a transaction helps to prevent deadlocks.
A
Multiple venues of data relationships
B
Diverse variety in data formats
C
High velocity in data flow
D
Large volumes of digitally stored data
SUPPLIER ITEM ItemID ItemDesc 001 Qty SupIDfk SupD Sulame SupAddress SupPhone L23456LuChen 40ak Street 72344567 G12345 Hameen 2356 Avenue Rios 24173981 Kollege Com Flakes 152 | L23456 217 G12345 ! Crikey Orange Juice 244 575Explanation / Answer
1a)option A
because we can say data is Big data if it satifies 4 criteria.
v pow (4)===volume ,velocity,variety,verocity
volume=data should be in large volume
velocity=with high speed
varity=different formats of data
verocity=faith we should have that is big data
2a)option A
because all the 3 options are invalid options
if we want data from multiple table we should use joins ..the only query where join is there is first option
3a)option B
hadoop is open source technology which comes with all these technologies in it like pig hive zookeper
4a)False
because there is need for use for relational data base
relational data bases are depends on specific schema..most of the organization data are in specific format ..so relational databases are used ever.
5a)option B atomic
a transcation shoudl satifies 4 properites
atomicity
consistancy
isolation
durability
in that atomicity is the transaction is fully completed or stops
8a)option D
concurancy control is used for multiple transactions not conflict with other by uses of locking
9ans)All the above.
the puprose of seriaizaton is eventhough the transaction is cuncurent for each individual user his transaction is serial
11 ans)optio B
for every database the database administrator is responsible for every security issuses
13 ans)option A
row level security can be implemented by using sql views ..views are nothing but logical creation of table from different table colums
14 ans)option D
hippa is generally related to healthcare data
16 ans)opton A
sql injuction is some code included in transaction to stolen user password by unauthenticate person
17 ans)D option
5 ans)option B
because if we want to acces both table there should be one critera som we use id of both
10 ans)opton c
15 ans)option A
the next chance handled by student A
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.