Introduction to DBMS Flashcards
What does SQL stands for?
Structured Query Language
It lets you access and manipulate databases
SQL (Structured Query Language)
SQL became the standard of what Institute?
American National Standards Institute (ANSI)
When did SQL became the standard of American National Standards Institute?
1986
SQL became the standard of an Organization
International Organization for Standardization (ISO)
When did SQL became the standard of International Organization for Standardization?
1987
What can SQL do?
- Execute Queries
- Retrieve Data
- Insert Records
- Update Records
- Delete Records
- Create new Databases
- Create new Tables
- Create stored Procedures
- Create Views
- Set permissions
True or False:
Although SQL is ANSI/ISO standard, there are different versions of the SQL Language
True
To be compliant with the ANSI standard, they all support at least the major commands, what are those?
- SELECT
- UPDATE
- DELETE
- INSERT
- WHERE
What is the meaning of RDBMS?
Relational Database Management System
This is the basis for SQL, and for all modern database systems such as MS SQL Server, IB DB2, Oracle, MySQL, and Microsoft Access
RDBMS (Relational Database Management System)
This Statement is used to select data from a database
SELECT statement
This command extracts data from a database
SELECT
This command updates data in a database
UPDATE
This command deletes data from a database
DELETE
This command inserts new data into a database
INSERT INTO
This command creates a new database
CREATE DATABASE
This command modifies a database
ALTER DATABASE
This command creates a new table
CREATE TABLE
This command modifies a table
ALTER TABLE
This command deletes a table
DROP TABLE
This command creates an index
CREATE INDEX
This command deletes an index
DROP INDEX
What does the * mean?
“ALL”
This SQL Statement returns the column’s value from all the records of the table
DISTINCT
This Statement is used to filter records
WHERE
This statement is used to drop an existing SQL database.
DROP DATABASE
This statement is used in SQL Server to create a full back up of an existing SQL database
BACKUP DATABASE
