SQL

Question 1

An organized collection of data or information

Answer 1

Database

Question 2

A set of computer programs for organizing the information in a database

Answer 2

Database Management System

Question 3

A DBMS provides tools for data input, storage, retrieval and manipulation

Answer 3

x

Question 4

Where are Database applications

Answer 4

everywhere from Banking, online ticket booking, online retailer, etc

Question 5

What does DBMS do?

Answer 5

DBMS controls all functions of capturing, processing, storing, retrieving data and generates various forms of data output

Question 6

Data is organized in

Answer 6

tables

Question 7

Table contains

Answer 7

rows and columns

Question 8

Tables can be related to one another through common values called

Answer 8

Keys

Question 9

Uniquely identifies each row of the table

Answer 9

Primary Key

Question 10

Column in one table that serves as a primary key in another

Answer 10

Foreign Key

Question 11

What are different types of relationship exist

Answer 11

One to One, One to Many, Many to Many

Question 12

A set of rules to help designers to reduce redundancy and avoid data update anomalies

Answer 12

Normalization

Question 13

Entity and Attributes

Answer 13

X

Question 14

Language for accessing and manipulating the data

Answer 14

DML

Question 15

Language for Create, Alter, Drop, Truncate, Comment and Rename

Answer 15

DDL

Question 16

DDL stands for

Answer 16

Data Definition Language

Question 17

Which language is used for the control of data

Answer 17

Data Control Language DCL

Question 18

What operations can you perform using DCL

Answer 18

Grant and Revoke

Question 19

What are transaction control statements

Answer 19

Commit, Rollback, Savepoint

Question 20

Restore database to original from the last COMMIT

Answer 20

Rollback

Question 21

Save work done

Answer 21

Commit

Question 22

Data Types in SQL

Answer 22

Character, Varchar, Boolean, Integer, Float, Date, Time, Timestamp

Question 23

Fixed width character string

Answer 23

Char

Question 24

Variable width character string

Answer 24

Varchar

Question 25

Whole numbers

Answer 25

int

Question 26

Floating precision number

Answer 26

float

Question 27

Syntax for creating a table

Answer 27

Create Table table_name (column1 data_type (size), column2 data_type (size));

Question 28

What are the different types of Operators in SQL

Answer 28

Arithmetic Operator, Relational Operator, Logical Operator and Comparison Operator

Question 29

+ - * / are

Answer 29

Arithmetic Operators

Question 30

=, != and <>, >, =, <=, !

Answer 30

Relational Operators

Question 31

AND OR NOT

Answer 31

Logical Operators

Question 32

IN BETWEEN LIKE

Answer 32

Comparison Operators

Question 33

Used to temporarily rename a table or a column heading. to make them more readable

Answer 33

Alias

Question 34

Where Clause

Answer 34

It’s a condition to select particular rows or data from the table

Question 35

Delete command

Answer 35

Used to delete the rows from the table

Question 36

This command removes all rows from the table

Answer 36

Truncate

Question 37

This command removes table from the database

Answer 37

Drop

Question 38

Drop Command

Answer 38

Drop Table

Question 39

Delete Command

Answer 39

Delete Table where

Question 40

Truncate Command

Answer 40

Truncate Table

Question 41

Drop and Truncate are

Answer 41

DDL commands

Question 42

Delete is a

Answer 42

DML command

Question 43

SQL INSERT INTO syntax

Answer 43

INSERT INTO table_name (column1, column2, colum3) Values (value1, value2, value3);

Question 44

Create Table Statement

Answer 44

Used to create table in a database

Question 45

Create Table Syntax

Answer 45

Create Table (column1 data type (size), column2 data type (size), column3 data type (size));

Question 46

Instructions used to communicate with the database to perform specific task that with data

Answer 46

SQL commands

Question 47

Create Alter and Drop; Grant and Revoke

Answer 47

DDL commands

Question 48

Select, Insert, Update, and Delete

Answer 48

DML commands

Question 49

These SQL commands are used for storing, retrieving, modifying and deleting data

Answer 49

DML

Question 50

A clause used to combine records from two or more tables in a database

Answer 50

JOINS

Question 51

What are the different types of Join available in SQL

Answer 51

Inner Join, Left Join, Right Join, Full Join, Self Join, Cartesian Join

Question 52

What’s the most frequently used Join statement

Answer 52

Inner Join

Question 53

Inner Join creates a new result table by combining column values of two tables

Answer 53

table 1 and table 2

Question 54

Basic Syntax of Inner Join

Answer 54

Select table1.column1, table2.column2 from table1 inner join table2 ON table1.common_filed = table2.commond_field

Question 55

Left Join returns all rows from the left table even if there are no matches in the right table

Answer 55

x

Question 56

Basic Syntax for Left Join

Answer 56

Select column1, column2, column3 from table 1 left join table 2 On table1.common_field = table2.common_field

Question 57

Right Join returns all the rows from the right table even if there are no matches in the left table

Answer 57

x

Question 58

Basic Syntax for Right Join

Answer 58

Select column1, column2, column3 from table1 right join table 2 on table1.common_field = table2.common_field