Question. The ______ operator is used to compare a value to a list of literals values that have been specified. a.BETWEEN b.IN | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 2

Question. The ______ operator is used to compare a value to a list of literals values that have been specified. a.BETWEEN b.IN

15th Feb 2022, 12:50 PM
Wasim🏅
Wasim🏅 - avatar
30 Answers
+ 2
What do you think the answer is?
15th Feb 2022, 1:20 PM
Paul K Sadler
Paul K Sadler - avatar
+ 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.
15th Feb 2022, 2:29 PM
Paul K Sadler
Paul K Sadler - avatar
+ 3
Look here for info on IN operator in sql https://www.w3schools.com/Sql/sql_in.asp
15th Feb 2022, 1:26 PM
Paul K Sadler
Paul K Sadler - avatar
+ 3
In
16th Feb 2022, 12:35 PM
K. Soumya
K. Soumya - avatar
+ 2
In short, you need IN
16th Feb 2022, 8:10 AM
Viktor Tsybenko
+ 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
16th Feb 2022, 8:16 AM
Viktor Tsybenko
+ 1
IN
15th Feb 2022, 1:22 PM
Wasim🏅
Wasim🏅 - avatar
+ 1
Correct!
15th Feb 2022, 1:23 PM
Paul K Sadler
Paul K Sadler - avatar
+ 1
You r right
15th Feb 2022, 1:35 PM
Wasim🏅
Wasim🏅 - avatar
+ 1
Thanks for clearing my confusion
15th Feb 2022, 1:35 PM
Wasim🏅
Wasim🏅 - avatar
+ 1
I'm a computer science student
15th Feb 2022, 1:35 PM
Wasim🏅
Wasim🏅 - avatar
+ 1
No on the number, but you can tag me in a conversation with the @ sign and my name Wasim🏅 <-- like that
15th Feb 2022, 1:40 PM
Paul K Sadler
Paul K Sadler - avatar
+ 1
Ok sir thank you🙏
15th Feb 2022, 1:43 PM
Wasim🏅
Wasim🏅 - avatar
+ 1
The database environment has all of the following components except : A. Separate files B. Database C. Users D. DBA
15th Feb 2022, 2:10 PM
Wasim🏅
Wasim🏅 - avatar
+ 1
What do you think the answer is and why?
15th Feb 2022, 2:21 PM
Paul K Sadler
Paul K Sadler - avatar
+ 1
Don't know
15th Feb 2022, 2:21 PM
Wasim🏅
Wasim🏅 - avatar
+ 1
I think separate file
15th Feb 2022, 2:31 PM
Wasim🏅
Wasim🏅 - avatar
+ 1
Users, dbs, database, are part of dbms environment
15th Feb 2022, 2:32 PM
Wasim🏅
Wasim🏅 - avatar
+ 1
B., is the answer to the question. 🤔😮
15th Feb 2022, 3:58 PM
ASIM FARHEEN ❄️⚡⚡🤳⚡⚡❄️
ASIM FARHEEN ❄️⚡⚡🤳⚡⚡❄️ - avatar
15th Feb 2022, 4:05 PM
Wasim🏅
Wasim🏅 - avatar