DP 900

Question 1

DML

Answer 1

insert, delete, update

Question 2

DQL

Answer 2

select, show, explain, plan, help.

Question 3

DCL

Answer 3

Grant, revoke

Question 4

DDL

Answer 4

create, drop, alter, truncate

Question 5

Descriptive

Answer 5

what happened

Question 6

Diagnostic

Answer 6

Why did it happen

Question 7

Predictive

Answer 7

What will happen

Question 8

Prescriptive

Answer 8

How can we make it happen

Question 9

Cognitive

Answer 9

what if this happens. ML/AI

Question 10

Normalized

Answer 10

store Non redundant data. data integrity good. many tables. optimized for storage

Question 11

Denormalized

Answer 11

combines data for fast querying. bad data integrity. redundant data common

Question 12

Json object uses

Answer 12

{object}

Question 13

JSON array uses

Answer 13

[array]

Question 14

Clustered Index

Answer 14

Clustered indexes sort and store the data rows in the table or view based on their key values. These are the columns included in the index definition. There can be only one clustered index per table, because the data rows themselves can be stored in only one order.