A- Quick Revision

• SQL Stands for: Structured Query Language
• SQL is a type of: Relational Database Management System
• A type of database in which data is stored in the format of rows and columns i.e. in a table is called: Relational Database Management System
• Table in RDBMS is known as: Relation
• Row in RDBMS is known as: Tuple
• Column in RDBMS is known as: Attribute
• No of rows in RDBMS is called: Cardinality
• No of columns in RDBMS is called: Attribute
• Pool of values in a table is referred to as: Domain
• SQL commands are divided into how many parts?: 3 (Three)
• Name all types of SQL commands: DDL, DML, TCL/DCL
• DDL stands for: Data Definition Language
• DML stands for: Data Manipulation Language
• DCL/TCL stands for: Data Control Language / Transaction Control Language
• Example of DDL Commands (any two): create table, alter table
• Example of DML Commands (any two): select, update, insert, delete
• Example of DCL/TCL Commands (any two): grant, revoke, commit, rollback
• Mention any four datatypes of MySQL: char, varchar, integer, decimal
• What are sets of rules called?: Constraint
• Primary key is the combination of: Unique  and   Not Null
• Keys that might be considered as primary key are called as: Candidate Keys
• Secondary key or primary key =: Alternate Keys
• Two or more columns combine to make primary key then it is called as: Composite Key
• Which constraint doesn’t allow duplication of data?: Unique Key
• Which constraint doesn’t allow blank value?: NOT NULL
• Command used to show list of databases: show databases
• Command used to show list of tables: show tables
• Command used to show the structure of table: desc table_name
• Is it possible to insert values in table as per our wish (randomly)?: Yes
• Command used to change structure of table: Alter
• Name Alter Command attribute which is used to add new column: ADD
• Name Alter Command attribute which is used to make change in any column: MODIFY
• Name Alter Command attribute which is used to change name of column: RENAME
• Command used to delete a column: DROP
• Which command is used to update the data of the table?: Update
• Which command is used to delete rows from table?: Delete
• To retrieve data from table we use: Select
• To implement condition in select statement we use: Where
• To use multiple conditions at a time we use: And/Or
• Is it possible to calculate something during extraction of data based on fields?: Yes
• Clause used to remove duplicate values: Distinct
• Clause used to sort data in ascending order: Asc
• Clause used to sort data in descending order: Desc
• Clause used to extract data in a given range: Between
• Clause used to extract data not in the given range: Not Between
• Clause used to extract data from given set of values: In
• For pattern matching we use: Like
• In pattern matching % shows: Many/Infinite  characters
• In pattern matching _ shows: Single/One  character