Question 51 : Which SQL statement is used to delete data FROM a database?
1. COLLAPSE
2. REMOVE
3. ALTER
4. DELETE
View Answer   Discuss with Members

Question 52 : Which SQL statement is used to update data in a database?
1. SAVE
2. UPDATE
3. SAVE AS
4. MODIFY
View Answer   Discuss with Members

Question 53 : Which of the following is a SQL aggregate function?
1. LEFT
2. AVG
3. JOIN
4. LEN
View Answer   Discuss with Members

Question 54 : Which of the following SQL commands is used to retrieve data?
1. DELETE
2. INSERT
3. SELECT
4. JOIN
View Answer   Discuss with Members

Question 55 : Which SQL keyword is used to retrieve a maximum value?
1. TOP
2. MOST
3. UPPER
4. MAX
View Answer   Discuss with Members

Question 56 : Which SQL keyword is used to retrieve only unique values?
1. DISTINCTIVE
2. UNIQUE
3. DISTINCT
4. DIFFERENT
View Answer   Discuss with Members

Question 57 : The FROM SQL clause is used to...
1. specify what table we are selecting or deleting data FROM
2. specify range for search condition
3. specify search condition
4. None of these
View Answer   Discuss with Members

Question 58 : A command that lets you change one or more fields in a record is
1. Insert
2. Modify
3. Look-up
4. All of the above
View Answer   Discuss with Members

Question 59 : In SQL, which command is used to SELECT only one copy of each set of duplicable rows
1. SELECT DISTINCT
2. SELECT UNIQUE
3. SELECT DIFFERENT
4. All of the above
View Answer   Discuss with Members

Question 60 : In SQL, which of the following is not a data definition language commands?
1. RENAME
2. REVOKE
3. GRANT
4. UPDATE
View Answer   Discuss with Members