Knowee
Questions
Features
Study Tools

What is/are the basic SQL command/commandsWhereSelectOrder byUp to

Question

What is/are the basic SQL command/commandsWhereSelectOrder byUp to

🧐 Not the exact question you are looking for?Go ask a question

Solution

The basic SQL commands are:

  1. SELECT: This command is used to select data from a database. The data returned is stored in a result table, called the result-set.

  2. WHERE: This command is used to filter records. It is used to extract only those records that fulfill a specified condition.

  3. ORDER BY: This command is used to sort the result-set in ascending or descending order. It sorts the records in a result-set by one or more columns.

  4. UPDATE: This command is used to modify the existing records in a table.

  5. DELETE: This command is used to delete existing records in a table.

  6. INSERT INTO: This command is used to insert new records in a table.

  7. CREATE DATABASE: This command is used to create a new SQL database.

  8. ALTER DATABASE: This command is used to modify an existing database.

  9. CREATE TABLE: This command is used to create a new table in a database.

  10. ALTER TABLE: This command is used to add, delete/drop or modify columns in an existing table.

  11. DROP TABLE: This command is used to delete a table in a database.

  12. CREATE INDEX: This command is used to create an index (search key).

  13. DROP INDEX: This command is used to delete an index.

This problem has been solved

Similar Questions

The Database Management Query language is generally designed for the ________.a.Support in the development of the complex applications softwareb.Support end-users who use English like commandsc.Specifying the structure of the databased.All of the above

In SQL, which of the following is not a data Manipulation Language Commands?

Which of the following is the subset of SQL commands used to manipulate Oracle Structures, including tables?a.Data Manipulation Languageb.Data Retrieval Languagec.Data Described Languaged.Data Definition Language

Which SQL command is used to retrieve data from the database?AINSERTBUPDATECSELECT

The PL/SQL executable section contains which type of statements ?

1/3

Upgrade your grade with Knowee

Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.