Introduction to DBMS

Question 1

What does SQL stands for?

Answer 1

Structured Query Language

Question 2

It lets you access and manipulate databases

Answer 2

SQL (Structured Query Language)

Question 3

SQL became the standard of what Institute?

Answer 3

American National Standards Institute (ANSI)

Question 4

When did SQL became the standard of American National Standards Institute?

Answer 4

1986

Question 5

SQL became the standard of an Organization

Answer 5

International Organization for Standardization (ISO)

Question 6

When did SQL became the standard of International Organization for Standardization?

Answer 6

1987

Question 7

What can SQL do?

Answer 7

• Execute Queries
• Retrieve Data
• Insert Records
• Update Records
• Delete Records
• Create new Databases
• Create new Tables
• Create stored Procedures
• Create Views
• Set permissions

Question 8

True or False:
Although SQL is ANSI/ISO standard, there are different versions of the SQL Language

Answer 8

True

Question 9

To be compliant with the ANSI standard, they all support at least the major commands, what are those?

Answer 9

• SELECT
• UPDATE
• DELETE
• INSERT
• WHERE

Question 10

What is the meaning of RDBMS?

Answer 10

Relational Database Management System

Question 11

This is the basis for SQL, and for all modern database systems such as MS SQL Server, IB DB2, Oracle, MySQL, and Microsoft Access

Answer 11

RDBMS (Relational Database Management System)

Question 12

This Statement is used to select data from a database

Answer 12

SELECT statement

Question 13

This command extracts data from a database

Answer 13

SELECT

Question 14

This command updates data in a database

Answer 14

UPDATE

Question 15

This command deletes data from a database

Answer 15

DELETE

Question 16

This command inserts new data into a database

Answer 16

INSERT INTO

Question 17

This command creates a new database

Answer 17

CREATE DATABASE

Question 18

This command modifies a database

Answer 18

ALTER DATABASE

Question 19

This command creates a new table

Answer 19

CREATE TABLE

Question 20

This command modifies a table

Answer 20

ALTER TABLE

Question 21

This command deletes a table

Answer 21

DROP TABLE

Question 22

This command creates an index

Answer 22

CREATE INDEX

Question 23

This command deletes an index

Answer 23

DROP INDEX

Question 24

What does the * mean?

Answer 24

“ALL”

Question 25

This SQL Statement returns the column’s value from all the records of the table

Answer 25

DISTINCT

Question 26

This Statement is used to filter records

Answer 26

WHERE

Question 27

This statement is used to drop an existing SQL database.

Answer 27

DROP DATABASE

Question 28

This statement is used in SQL Server to create a full back up of an existing SQL database

Answer 28

BACKUP DATABASE