1. Which SQL statement is used to update data in table?
A. INSERT
B. DELETE
C. UPDATE
D. EDIT
E. MODIFY
2. Which SQL function converts a field to upper case?
A. UPPER()
B. UPPERCASE()
C. CAPITAL()
D. UCASE()
3. What defines how a field is to be displayed?
A. Show()
B. Display()
C. Format()
D. View()
4. Using SQL, How do you select all rows with all columns from a table named "Users"?
A. Select all from Users
B. Select total from Users
C. Select columns from Users
D. Select * from Users
5. Which SQL query will selects all rows from a table called "Customers" and orders the result by " Customer name" ?
A. Select * from Customers Order By customer name
B. Select * from Customers Order On customer name
C. Select * from Customers Order customer name
D. Select * from Customers Ordered customer name
6. Which of the following statement is correct and has no syntax error?
A. insert into customer (first,last) values ('JOHN','Reid');
B. save into customer (first,last) values ('JOHN','Reid');
C. update into customer (first,last) values ('JOHN','Reid');
D. insert into customer first,last values ('JOHN','Reid');
7. Which SQL statement is used to return only different values?
A. Select Unique
B. Select Different
C. Select Distinct
D. Select Once
8. Statement to delete all records from a table "students" ?
A. Delete * from students;
B. Delete from table students;
C. Remove from students;
D. Delete from students;
9. Which SQL function returns a maximum value?
A. Highest()
B. Maximum()
C. Max()
D. Most()
10. Which SQL function returns count of rows in a table?
A. Total()
B. Count()
C. Number()
D. rows()
0
{"name":"SQL", "url":"https://www.quiz-maker.com/QZKP0WP","txt":"1. Which SQL statement is used to update data in table?, 2. Which SQL function converts a field to upper case?, 3. What defines how a field is to be displayed?","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}