ITEC36 FINALS

Question 1

It is a computer language for storing, manipulating and retrieving data stored in a relational database.

Answer 1

SQL

Question 2

It the standard language for Relational Database System.

Answer 2

SQL

Question 3

It consists of the SQL commands that can be used to define the database schema.

Answer 3

DDL or Data Manipulation Language

Question 4

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

Answer 4

Create

Question 5

Modifies an existing database object, such as a table.

Answer 5

Alter

Question 6

Deletes an entire table, a view of a table or other objects in the database.

Answer 6

Drop

Question 7

It deals with the manipulation of data present in the database.

Answer 7

DML or Data Manipulation Language

Question 8

Retrieves certain records from one or more tables.

Answer 8

Select

Question 9

Creates a record.

Answer 9

Insert

Question 10

Modifies records.

Answer 10

Update

Question 11

Delete records.

Answer 11

Delete

Question 12

It deals with the rights, permissions and other controls of the database system.

Answer 12

DCL or Data Control Language

Question 13

Gives a privilege to user.

Answer 13

Grant

Question 14

Takes back privileges granted from user.

Answer 14

Revoke

Question 15

It deals with the transaction within the database.

Answer 15

TCL or Transaction Control Language

Question 16

commits a Transaction.

Answer 16

Commit

Question 17

rollbacks a transaction in case of any error occurs.

Answer 17

Rollback

Question 18

sets a savepoint within a transaction.

Answer 18

Savepoint

Question 19

specify characteristics for the transaction.

Answer 19

Set Transaction

Question 20

It is an attribute that specifies the type of data of any object.

Answer 20

Data type

Question 21

Specifies character type data of length n where n could be any value from 0 to 255.

Answer 21

CHAR (n)

Question 22

Specifies character type data of length ‘n’ where n could be any value from 0 to 65535

Answer 22

VARCHAR (n)

Question 23

specifies an integer value.

Answer 23

INT

Question 24

Holds numbers with decimal points. Each _____ value occupies 4 bytes.

Answer 24

FLOAT

Question 25

is used for dates in ‘YYYY-MM-DD’ format. YYYY is the 4 digit year, MM is the 2 digit month and DD is the 2 digit date. The supported range is ‘1000-01-01’ to ‘9999-12-31’.

Answer 25

DATE

Question 26

These are the rules enforced on data columns on a table. These are used to limit the type of data that can go into a table.

Answer 26

Constraints

Question 27

Ensures that a column cannot have a NULL
value.

Answer 27

NOT NULL

Question 28

Provides a default value for a column when
none is specified.

Answer 28

DEFAULT

Question 29

Ensures that all the values in a column are
different.

Answer 29

UNIQUE

Question 30

Uniquely identifies each row/record in a
database table.

Answer 30

PRIMARY key

Question 31

Uniquely identifies a row/record in any another database table.

Answer 31

FOREIGN key

Question 32

It is used to create a new SQL database.

Answer 32

SQL CREATE DATABASE

Question 33

It is used to drop an existing database in SQL schema.

Answer 33

SQL DROP DATABASE

Question 34

is the keyword telling the database system what you want to do.

Answer 34

CREATE TABLE

Question 35

is used to remove a table definition and all the data, indexes, triggers, constraints and permission specifications for that table.

Answer 35

DROP TABLE

Question 36

These are sets of instruction written in a language that can be understood by the database system.

Answer 36

Queries

Question 37

What the purpose of the query is.

Answer 37

Action

Question 38

Which table or tables the action will be performed on.

Answer 38

Location

Question 39

What columns rows and data will be affected.

Answer 39

WHERE

Question 40

It is used to fetch the data from a database table which returns this data in the form of a result table.

Answer 40

SQL SELECT

Question 41

specifies the columns to be displayed.

Answer 41

SELECT Clause

Question 42

specifies the table containing the columns that are listed in the SELECT Clause

Answer 42

FROM Clause

Question 43

It can be used to select all the available columns and records from a table.

Answer 43

Asterisk (*)

Question 44

It is used to specify a condition while fetching the data from a single table or by joining with multiple tables.

Answer 44

SQL WHERE Clause

Question 45

It is used to modify the existing records in a table.

Answer 45

SQL UPDATE Query

Question 46

It is used to delete the existing records from a table.

Answer 46

SQL DELETE Query

Question 47

It can perform arithmetical operations on numeric operands involved.

Answer 47

Arithmetic Operators

Question 48

It is used to override the default precedence or to clarify the statement.

Answer 48

Parenthesis ()

Question 49

Renames a column heading

Answer 49

Alias

Question 50

These are used in conditions that compare one expression to another or expression.

Answer 50

Comparison Conditions

Question 51

Search for a pattern.

Answer 51

LIKE

Question 52

If you know to exact value you want to return for at least one of the columns.

Answer 52

IN

Question 53

Contain NULL value.

Answer 53

IS NULL

Question 54

Return columns with value.

Answer 54

IS NOT NULL

Question 55

It combines the result of two component conditions to produce a single result based on those conditions, or it inverts the result of a single condition.

Answer 55

Logical Conditions

Question 56

A keyword used to sort the result-set in ascending or descending order.

Answer 56

ORDER BY

Question 57

It is a database design technique that reduces data redundancy and eliminates undesirable characteristics like Insertion, Update and Deletion Anomalies.

Answer 57

Normalization