Multiple Choice
Given the table
CUSTOMER(CustID,Name,PhoneNum,AcctBalance)
What is the standard SQL query phrase to retrieve data for customers with an account balance greater than 50?
A) WHERE CUSTOMER-AcctBalance > 50
B) WHERE (CUSTOMER-AcctBalance > 50)
C) WHERE AcctBalance > 50
D) WHERE (AcctBalance > 50)
E) HAVING AcctBalance > 50
Correct Answer:

Verified
Correct Answer:
Verified
Q52: Data from a maximum of three tables
Q53: SQL was developed by _ in the
Q54: Microsoft Access SQL supports and will correctly
Q55: To force the DBMS to remove duplicate
Q56: Which SQL keyword is used to eliminate
Q58: Which symbol is used in standard SQL
Q59: The SQL command used to add new
Q60: When using SQL to create a table,a
Q61: In SQL,the LIKE keyword can be combined
Q62: The _ statement removes all data from