PrepAway - Latest Free Exam Questions & Answers

which of the following?

SQL commands do not include which of the following?

PrepAway - Latest Free Exam Questions & Answers

A.
Select, Update

B.
Grant, Revoke

C.
Delete, Insert

D.
Add, Relist

Explanation:
There is no Add command within the Structure Query Language (SQL). Instead the Insert command is used to
add new data to the database.
There is also no Relist command within SQL.
Incorrect Answers:
A: Select and Update are Data Manipulation Language (DML) commands. The Select statement is used to
select data from a database while the Update statement is used to update existing records in a table.
B: Grant and Revoke are Data Control Language (DCL) commands are used to enforce database security. The
Grant statement is used to provide access or privileges on the database objects while the Revoke statement is
used to remove those privileges.
C: Delete and Insert are Data Manipulation Language (DML) commands. The Delete statement is used to
remove data from a database while the Insert statement is used to add data to a table.

https://technet.microsoft.com/en-us/library/ff848799.aspx
https://technet.microsoft.com/en-us/library/ff848766.aspx
http://www.cs.utexas.edu/~mitra/csFall2012/cs329/lectures/sql.html
http://www.w3schools.com/SQl/sql_select.asp
http://www.w3schools.com/SQl/sql_update.asp
http://beginner-sql-tutorial.com/sql-grant-revoke-privileges-roles.htm


Leave a Reply