Basic SQL questions
What is a field?
A field is a column in a table that is designed to maintain specific information about every record in the table. A vertical entity in a table that contains all information associated with a specific field in a table.
What is a table in a database?
A table is a set of data that is organized in a model with columns and rows. A table can have a specified number of columns and any number of row. A table is the most common and simple for of data storage in a database.
What is DML?
DML stands for Data Manipulation Language It is the set of commands used to manipulate data in records.
What is DQL?
DQL stands for Data Query Language it is the set of commands used to compose queries against a database. The SELECT statement is the only command in this category.
What is Data Administration Commands?
Data administration Commands is the set of commands that enable the user to perform audits and analyses on operations within a database. Helps analyze system performance.
What is SQL?
SQL stands for Structured Query Language, and it is the standard language used to communicate with a database. SQL can be used to perform tasks such as retrieval, updating, insertion and deletion of data from a database.
What are the two general Data administration commands?
START AUDIT STOP AUDIT
What is DBMS?
A Database Management System is a program that controls creation, maintenance and use of a database.
What is RDBMS?
A RDBMS is the most popular kind of DBMS implementation today. A Relational Database Management System stores data into collection of tables, which is related by common fields between the columns of the table. It also provides relational operators to manipulate the data stored into the tables.
What is a clause?
A clause is a component of statements that helps refine the retrieval of information from a database.
What is a database?
A database is an organized form of collecting data for easy access, storing, retrieval and managing of data. A structured for of data which can be accessed in many ways.
What is a query?
A query is an inquiry into a database used to extract information from a database in a readable format according to the user's request. A request for information from a database.
What is a record?
A record is a row of data in a table also know as a record of data. A row is composed of fields that contain data from one record.
What is a statement?
A statement represents an action you want to perform on a database
What are some DCL commands?
ALTER PASSWORD GRANT REVOKE CREATE SYNONYM
What are the basic transactional control commands?
COMMIT ROLLBACK SAVEPOINT SET TRANSACTION
What are the fundamental DDL commands?
CREATE TABLE ALTER TABLE DROP TABLE CREATE INDEX ALTER INDEX DROP INDEX CREATE VIEW DROP VIEW
What is DCL?
DCL stands for Data Control Language It is the set of commands that enables a user to control access of data within a database. The commands are normally used to create objects related to user access and also control the distribution of privileges among users.
What are the different types of SQL commands?
DDL - Data Definition Language DML - Data Manipulation Language DQL - Data Query Language DCL - Data Control Language Data administration commands Transactional Control commands
What is DDL?
DDL stands for Data Definition Language It consists of the SQL commands that enables a user to create and restructure database objects. examples are creating and deleting tables.
What are the 3 basic DML commands?
INSERT UPDATE DELETE
name some storage engines.
InnoDB MyISAM Memory CSV
What is a storage engine?
MySQL components that handle operations for different tables.
How are queries used? How do we use queries?
Queries take form as a SELECT statement and we use them to extract information from a database.
What is Transactional Control Commands
These commands enable the user to manage database transactions
What are some database object?
tables views clusters sequences indexes synonyms