+ 2
Question. The ______ operator is used to compare a value to a list of literals values that have been specified. a.BETWEEN b.IN
30 Answers
+ 2
What do you think the answer is?
+ 4
Not knowing the context the question is asked in makes it difficult (context is your lesson material). An SQL database is stored in a file, but there are other supporting files associated with it. Then, assuming DBA is database administrator, you could say that is included in users (permissions allow a user to administer the database). I lean towards A) separate files. But you may want to refer to your recent lessons in your text or notes to confirm the answer.
+ 3
Look here for info on IN operator in sql
https://www.w3schools.com/Sql/sql_in.asp
+ 3
In
+ 2
In short, you need IN
+ 2
Like
SELECT * from animals
WHERE name IN('cat', 'dog')
Please note those are literals, not numbers
SELECT * from accessories WHERE price is BETWEEN 100 AND 120
Here we use numbers. It doesn't mean we can't use literals... but it's not a common practice and quite a specific task
+ 1
IN
+ 1
Correct!
+ 1
You r right
+ 1
Thanks for clearing my confusion
+ 1
I'm a computer science student
+ 1
No on the number, but you can tag me in a conversation with the @ sign and my name Wasim🏅 <-- like that
+ 1
Ok sir thank you🙏
+ 1
The database environment has all of the following components except :
A. Separate files B. Database C. Users D. DBA
+ 1
What do you think the answer is and why?
+ 1
Don't know
+ 1
I think separate file
+ 1
Users, dbs, database, are part of dbms environment
+ 1
B., is the answer to the question.
🤔😮