SECTION A 1 The command used in SQL to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction is called a CREATE PACKAGE b CREATE CLUSTER c CREATE SCHEMA d CREATE TABLE, VIEW, GRANT e All 2 Is used for traceability when security incidents occur a Verification b Authentication c Identification d Accountability e Assessment 3 The view in which the field data types and field properties for a database table can be seen in Microsoft Access is called the a Datasheet view b Design view c SQL view d Dashboard view Field view 4 Pick the odd one out a INSERT b CREATE c UPDATE d SELECT e DELETE 5 The command that add a new field to an active database is a MODIFY STRUCTURE b b MODIFY COMMAND c c MODIFY REPORT d MODIFY LABEL e MODIFY FIELD 6 Which of these can be used to add a row using SQL in a database a Add b Create c Insert d Make e Update 7 To remove rows from a table 'CUSTOMER', what is the command to use a UPDATE FROM CUSTOMER b DELETE FROM CUSTOMER WHERE c DROP FROM CUSTOMER d REMOVE FROM CUSTOMER e MODIFY FROM CUSTOMER 8 Collecting personal information and effectively posing as another individual is known as the crime of a Spooling b Identity theft c Hacking d Spoofing e Tailgating 9 Choose the correct one out of the following a CREATE, ALTER, DROP b CREATE, DELETE, ALTER c SELECT, UPDATE, DROP d SELECT, INSERT, DROP e SELECT, ALTER, DROP 1 0 The SQL query definition and the expected data can be modified in the database checkpoint a Not false b False c Partly false d Semi false Not totally false I l You can modify the value of the cell or you can parameterize it to use a value from an external source, such as a Environment variable b Data table c A B d Not A , B , C e Not sure 1 2 How many tables may be included with a join a One b Two c Three d A , B C e A B 1 3 Choose the one with the correct order a SELECT, FROM, WHERE, GROUP BY , HAVING, ORDER BY b SELECT, FROM, WHERE, HAVING, ORDER BY , GROUP BY c SELECT, FROM, WHERE, HAVING, GROUP BY , ORDER BY d SELECT, FROM, WHERE, GROUP BY , ORDER BY , HAVING e SELECT, FROM WHERE, ORDER BY , HAVING, GROUP BY 1 4 DBMS helps to achieve a Data independence b More redundancy c Centralized manner to control of data d A C e A , B C 1 5 Redundancy is minimized with a computer based database approach a Not false b False c Partially false d Partially true e None 1 6 In a database, a row is also called a domain a Not false b False c Incorrect question d Question not complete e None 1 7 Needs analysis is the first step in database creation a True b False c Partially false d Partially true e Technically false 1 8 The SQL Having clause a Filters rows b Forms groups of rows with same column value c Filters groups subject to some condition d Specifies which column are to appear in output e Specifies the order of the output 1 9 The most popular commercial DBMS is a Oracle b MySQL c Microsoft Access d Microsoft SQL Server e DB 2 2 0 The SQL WHERE clause a Limits the row data are returned b Limits the column data that are returned c A d Neither A nor B e Question is technically incorrect SECTION B 1 Write the query that returns records of all employees that has Coccurring at the third position of the last name column 2 is the skeleton structure that represents the logical view of the entire database 3 Refers to the need to capture and maintain log files that can be used for traceability when security incidents occur 4 consists of all the activities needed to ensure high quality data is available 5 A data management system that is designed to enable and support business intelligence activities especially analytics is known as 6 involves protecting the database from unauthorized access, modification, or destruction 7 Requires that only authorized users be allowed to modify data 8 Loss of availability is sometimes called 9 Regulate who can access which data 1 0 An application security weakness that allows attackers to control an application's database, letting them access or delete data by tricking the application into sending unexpected SQL commands is SECTION C QUESTION 1 1 a Explain big data and list its characteristics 1 b Difference between variety and variability 1 c Explain Hadoop List the core components of Hadoop 1 d What are the key assumptions made by the Hadoop Distributed File System approach

The Answer is in the image, click to view ...

Question: SECTION A 1 . The command used in SQL to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction is called

SECTION A

1 .

The command used in SQL to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction is called

.

CREATE PACKAGE

.

CREATE CLUSTER

.

CREATE SCHEMA

.

CREATE TABLE, VIEW, GRANT

.

All

2 . . . . . . . . . . . . . . . . . . . . .

Is used for traceability when security incidents occur.

.

Verification

.

Authentication

.

Identification

.

Accountability

.

Assessment

3 .

The view in which the field data types and field properties for a database table can be seen in Microsoft Access is called the

.

Datasheet view

.

Design view

.

SQL view

.

Dashboard view Field view

4 .

Pick the odd one out.

.

INSERT

.

CREATE

.

UPDATE

.

SELECT

.

DELETE

5 .

The command that add a new field to an active database is

.

MODIFY STRUCTURE

.

.

MODIFY COMMAND

.

.

MODIFY REPORT

.

MODIFY LABEL

.

MODIFY FIELD

6 .

Which of these can be used to add a row using SQL in a database?

.

Add b

.

Create c

.

Insert d

.

Make e

.

Update

7 .

To remove rows from a table 'CUSTOMER', what is the command to use?

.

UPDATE FROM CUSTOMER

. . .

.

DELETE FROM CUSTOMER WHERE... c

.

DROP FROM CUSTOMER... d

.

REMOVE FROM CUSTOMER.. e

.

MODIFY FROM CUSTOMER...

8 .

Collecting personal information and effectively posing as another individual is known as the crime of

.

Spooling b

.

Identity theft c

.

Hacking d

.

Spoofing e

.

Tailgating

9 .

Choose the correct one out of the following;

.

CREATE, ALTER, DROP b

.

CREATE, DELETE, ALTER c

.

SELECT, UPDATE, DROP d

.

SELECT, INSERT, DROP e

.

SELECT, ALTER, DROP

10 .

The SQL query definition and the expected data can be modified in the database checkpoint.

.

Not false b

.

False c

.

Partly false d

.

Semi

-

false Not totally false

I l

.

You can modify the value of the cell or you can parameterize it to use a value from an external source, such as

.

Environment variable b

.

Data table c

.

A & B d

.

Not A

,

,

& C e

.

Not sure

12 .

How many tables may be included with a join?

.

One b

.

Two c

.

Three d

.

,

B & C e

.

A & B

13 .

Choose the one with the correct order.

.

SELECT, FROM, WHERE, GROUP BY

,

HAVING, ORDER BY

.

SELECT, FROM, WHERE, HAVING, ORDER BY

,

GROUP BY

.

SELECT, FROM, WHERE, HAVING, GROUP BY

,

ORDER BY

.

SELECT, FROM, WHERE, GROUP BY

,

ORDER BY

,

HAVING

.

SELECT, FROM WHERE, ORDER BY

,

HAVING, GROUP BY

14 .

DBMS helps to achieve

.

Data independence b

.

More redundancy c

.

Centralized manner to control of data

.

A & C e

.

,

B & C

15 .

Redundancy is minimized with a computer

-

based database approach

.

Not false b

.

False c

.

Partially false d

.

Partially true e

.

None

16 .

In a database, a row is also called a domain.

.

Not false b

.

False c

.

Incorrect question d

.

Question not complete e

.

None

17 .

Needs analysis is the first step in database creation

.

True b

.

False c

.

Partially false d

.

Partially true e

.

Technically false

18 .

The SQL Having clause

.

Filters rows

.

Forms groups of rows with same column value

.

Filters groups subject to some condition

.

Specifies which column are to appear in output

.

Specifies the order of the output

19 .

The most popular commercial DBMS is

. . .

.

Oracle b

.

MySQL c

.

Microsoft Access d

.

Microsoft SQL Server e

.

2

20 .

The SQL WHERE clause:

.

Limits the row data are returned

.

Limits the column data that are returned

.

A &

.

Neither A nor B

.

Question is technically incorrect

SECTION B

1 .

Write the query that returns records of all employees that has Coccurring at the third position of the last name column

_______________________\

2 .____________

is the skeleton structure that represents the logical view of the entire database.

3 ._____________

Refers to the need to capture and maintain log files that can be used for traceability when security incidents occur.

4 ._____________

consists of all the activities needed to ensure high quality data is available.

5 .

A data management system that is designed to enable and support business intelligence activities especially analytics is known as

________________

6 ._______________

involves protecting the database from unauthorized access, modification, or destruction.

7 .___________________

Requires that only authorized users be allowed to modify data.

8 .

Loss of availability is sometimes called

______________________

9 .___________________

Regulate who can access which data.

10 .

An application security weakness that allows attackers to control an application's database, letting them access or delete data by tricking the application into sending unexpected SQL commands is

_________________

SECTION C

QUESTION

1

1

.

Explain big data and list its characteristics.

1

.

Difference between variety and variability

1

.

Explain Hadoop List the core components of Hadoop

1

.

What are the key assumptions made by the Hadoop Distributed File System approach?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Creation of objects Entities and Attributes Creation of Relationship Types Identify and include constraints ( Such as not null, unique, Supertype, Subtype, etc. ) Identify and include Primary Keys,...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

The assignment specification The java file JabberServer.java package com.bham.fsd.assignments.jabberserver; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet;...

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

CSIS 325 Lab 4 (SQL CREATE TABLE) Before beginning this lab, be sure you have successfully downloaded and installed SQL Server Express 2014: (You should have already done this in your first lab, but...

In SQL, Using MAMP It says it thoughout each part. It is SQL. 3. Write one statement to alter the table Booking to add a column, property No, which: a is an integer representing the property No for...

I am working on my final project in an SQL class using MYSQL. I am working my way through it but it is going slow so I think that I may need a little bit of help to finish in time. If I could get a...

There are two problems due this week (each worth 35 points) as follows. Case 5-1David L. Miller: Portrait of a White-Collar Criminal (page 144). In comprehensive paragraphs, answerrequirements 1?6....

-- ************************************************************* -- This script creates the database -- for Labs 4-7 based on OM (Order Management) database -- **REVISED by PRP to remove some orders...

Solve the separable differential equation for U u du =e5u+7t dt Use the following initial condition: u(0) = 5. U=

A coil of area 0.100 m2 is rotating at 60.0 rev/s with the axis of rotation perpendicular to a 0.200-T magnetic field (a) If the coil has 1 000 turns, what is the maximum emf generated in it? (b)...

Last year the Baldwin company increased their equity. In 2 0 2 4 their equity was $ 4 9 , 1 3 1 . Last year ( 2 0 2 5 ) it increased to $ 5 3 , 5 5 3 . What are causes of change in equity? Check all...

I am confused can you please help me with this. Data is posted below