ITS Databases Practice Exam #19 | American Baptist College - Edubirdie

University:
American Baptist College
Course:
CIT370 | Database Design and Processing
Academic year:

2024
Views:

474

Pages:

2
Author:

Muthia M.

Answer these question bellows. 1. An analyst needs to know the lowest amount of sales in a list of daily sales amounts. Which keyword should the analyst use to obtain that amount? A. MIN B. MOST C. AVG D. HIGH 2. Evaluate the following SQL Statement: DELETE view UtahCustomers; A developer runs this statement and gets an error message that this is unable to be deleted. What is the most likely cause of the error? A. The TRUNCATE keyword should be used instead of DELETE. B. The developer has insufficient permissions to delete the view. C. The DROP keyword should be used instead of DELETE. D. The REVOKE keyword should be used instead of DELETE. 3. _______ removes a SQL Server login account. A. Drop Login B. Drop User C. Delete Login D. Delete User 4. An attack on your company server is being made using the following image: COOKIE COOKIE1982 COOKIE293C COOKIE361 COOKIE75 COOKIEDOUGH COOKIEMONSTER COOKIES COOKINGFRUITS COOLBOY! COOLBOY123 COOLCLOWN8 COOLCOOL COOLDOOL COOLER COOLGIRL COOLGUYS33 COOL_13 Use the dropdown menus to complete each statement. a. This is an example of a _____ attack. Answer: Brute force b. To prevent this type of attack from being successful, you should enable _____. Answer: Account lockout after a reasonable number of attempts. 5. For each of the following statements, select Yes if the statement is true and No if it is false. a. The ALTER TABLE command can add a new column. (YES) b. The ALTER TABLE command can change the IDENTITY specification of an existing column.(NO) c. The ALTER TABLE command can drop multiple columns from a table. (YES) d. The ALTER TABLE command can modify the data type of an existing column. (YES)

Related Documents

ITS Databases Practice Exam #19

ITS Databases Practice Exam #19 - Page 1

ITS Databases Practice Exam #19 - Page 2

of 2

Recommended Documents

Quiz 1: Fundamental Of Data Visualization - Knowledge And Comprehension

Quiz 1: Fundamental Of Data Visualization - Knowledge And Comprehension

American Baptist College CIT370 | Database Design and Processing

Assignment

Quiz 3: Fundamental Of Data Visualization - Synthesis And Creation

Quiz 3: Fundamental Of Data Visualization - Synthesis And Creation

American Baptist College CIT370 | Database Design and Processing

Assignment

Quiz 4: Fundamental Of Data Visualization - Evaluation And Reflection

Quiz 4: Fundamental Of Data Visualization - Evaluation And Reflection

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam 18

Data Analytics Practice Exam 18

American Baptist College CIT370 | Database Design and Processing

Answer Key

Quiz 5: Fundamental Of Data Visualization - Application To Real-World Scenarios

Quiz 5: Fundamental Of Data Visualization - Application To Real-World Scenarios

American Baptist College CIT370 | Database Design and Processing

Assignment

Quiz 8 : Fundamental Of Data Visualization – Effectiveness Of Chart Usage

Quiz 8 : Fundamental Of Data Visualization – Effectiveness Of Chart Usage

American Baptist College CIT370 | Database Design and Processing

Assignment

ITS Databases Practice Exam #12

ITS Databases Practice Exam #12

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #5

Data Analytics Practice Exam #5

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #16

Data Analytics Practice Exam #16

American Baptist College CIT370 | Database Design and Processing

Assignment

ITS Databases Practice Exam

ITS Databases Practice Exam

American Baptist College CIT370 | Database Design and Processing

Assignment

ITS Databases Practice Exam #2

ITS Databases Practice Exam #2

American Baptist College CIT370 | Database Design and Processing

Assignment

ITS Databases Practice Exam #10

ITS Databases Practice Exam #10

American Baptist College CIT370 | Database Design and Processing

Assignment

New Documents from this Course

ITS Databases Practice Exam #5

ITS Databases Practice Exam #5

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #13

Data Analytics Practice Exam #13

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #17

Data Analytics Practice Exam #17

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #14

Data Analytics Practice Exam #14

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #12

Data Analytics Practice Exam #12

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #9

Data Analytics Practice Exam #9

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #6

Data Analytics Practice Exam #6

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #2

Data Analytics Practice Exam #2

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #10

Data Analytics Practice Exam #10

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #3

Data Analytics Practice Exam #3

American Baptist College CIT370 | Database Design and Processing

Assignment

Storytelling With Data

Storytelling With Data

American Baptist College CIT370 | Database Design and Processing

Lecture Note