McqMate
| Q. |
Which of the following can be used to get those items that fall within a range? |
| A. | IN |
| B. | BETWEEN |
| C. | DISTINCT |
| D. | LIKE |
| Answer» B. BETWEEN | |
|
Explanation: The BETWEEN operator is used in SQL to filter the results that fall within a specific range of values (inclusive). For example: SELECT * FROM products WHERE price BETWEEN 10 AND 50; IN: is used to filter results that match any value in a list. DISTINCT: is used to return unique values. LIKE: is used for pattern matching in strings. |
|
1.1k
0
Do you find this helpful?
6
View all MCQs in
Advanced Database Management Systems (ADBMS)Discussion
Chandu Dodali
8 months ago
Answer is b(BETWEEN) not c(DISTINCT).
0
Related MCQs
- Which of the following is used to get all the columns of a table ?
- In creating a procedure, you may get a message if you have compile errors. Which of the following is true?
- A distributed database can use which of the following strategies?
- Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?
- Which of the following schemas defines the stored data structures in terms of the database model used?
- Which of the following is the operation that is used if we are interested in only certain attributes or columns of a table?
- Replication should be used when which of the following exist?
- Which is the symbol used to denote the SELECT operation?
- The granularity of a database item can be chosen to be
- Timestamp can be generated by: