Lesson 3

Question 1

What are the Data languages

Answer 1

Data Query Language (DQL)
Data Control Language (DCL)
Data Definition Language (DDL)
Data Manipulation Language (DML)

Question 2

Used to query the database for information.

Answer 2

Data Query Language

Question 3

Get information that is already stored.

Answer 3

Data Query Language

Question 4

What command is used in DQL

Answer 4

Select

Question 5

It Retrieves certain records from one or more tables in DQL

Answer 5

Select

Question 6

Used for defining database schemas

Answer 6

Data Definition Language

Question 7

What are the commands used in DDL

Answer 7

Create
Alter
Drop

Question 8

Creates a new table, a view of a table, or other object in database in DDL

Answer 8

Create

Question 9

Modifies an existing database object, such as a table in DDL

Answer 9

Alter

Question 10

Deletes an entire table, a view of a table or other object in the database in DDL

Answer 10

Drop

Question 11

Use to create (completely define) a database, modify its structure, and destroy it when you no longer need it.

Answer 11

Data Definition Language

Question 12

Create, alter, and drop schema objects and other database structures, including the database itself and database users. Most ______ statements start with the keywords CREATE, ALTER, or DROP.

Answer 12

Data Definition Language (DDL)

Question 13

Use to create, change, or destroy the basic elements of a relational database. Basic elements include tables, views, schemas, catalogs, clusters, and possibly other things as well.

Answer 13

Data Definition Language (DDL)

Question 14

Delete all the data in schema objects without removing the structure of these objects (___________) in DDL

Answer 14

TRUNCATE

Question 15

Used for controlling access to the data in database.

Answer 15

Data Control Language (DCL)

Question 16

User & permission management

Answer 16

Data Control Language (DCL)

Question 17

Commands or Statements in DCL?

Answer 17

Grant
Revoke
Commit
Rollback

Question 18

Gives a privilege to user in DCL

Answer 18

Grant

Question 19

Takes back privileges granted from user in DCL

Answer 19

Revoke

Question 20

provides security for your database; the amount of protection depends on the implementation.

Answer 20

Data Control Language (DCL)

Question 21

These commands protect the database from harm, both accidental and intentional.

Answer 21

DCL Statements or Commit, Rollback, Grant, and Revoke

Question 22

manage the changes made by DML statements and group DML statements into transactions.

Answer 22

Transaction control statements

Question 23

Used for inserting, updating and deleting data from the database

Answer 23

Data Manipulation Language (DML)

Question 24

Statements you can use in DML are?

Answer 24

INSERT
UPDATE
DELETE
MERGE
SELECT

Question 25

Creates a record in DML

Answer 25

Insert

Question 26

Modifies records in DML

Answer 26

Update

Question 27

Deletes records in DML

Answer 27

Delete

Question 28

These statements can consist of a variety of parts, including multiple clauses.

Answer 28

DML Statements

Question 29

changes the structure of a table in DML

Answer 29

ALTER TABLE

Question 30

adds one or more rows to the table.

Answer 30

Insert

Question 31

enable you to query or change the contents.

Answer 31

DML Statements

Question 32

Add new rows of data into a table or view by specifying a list of column values or using a sub query to select and manipulate existing data.

Answer 32

Insert

Question 33

Change column values in existing rows of a table or view

Answer 33

Update

Question 34

Update or insert rows conditionally into a table or view

Answer 34

Merge

Question 35

Remove rows from tables or views

Answer 35

Delete

Question 36

Retrieve or fetch data from one or more tables or views

Answer 36

Select