Intermediate Level

Q1. SQL Stands for

• Style query language

• Structured query language

• Syntax query language

• Symbol query language

Q2. The commends in SQL are case sensitive

• True

• False

• Update student_marks set result ='pass' where id = 3

• Update table student_marks set column result = 'pass' where id=3

Q3. All the rows from one table are fetched when ....….... is used

• Inner join

• Left join

• Write join

• B and C

Q4. Boolean data type contains only two possible values

• True

• False

• Select sum(salary) from employee

• Select add salary as totalsalary from employee

Q5. avg() is an .......

• Operator

• Clause

• Alias

• Aggregate function

Q6. Which of the following command is used to delete columns from a table

• Delete

• Drop

• Truncate

• All of the above

Q7. AI stands for

• Artificial intelligence

• Actual intelligence

• Art of intelligence

• Act of intelligence

Q8. SIRI and Alexa or examples of

• AI robots

• AI machines

• AI programs

• All of the above

Q9. Which of the following is not a characteristics of big data?

• Volume

• Vastness

• Veracity

• Variety

Q10. Which of the following captures the gestures of the VR user

• Head mounted display

• Hand held devices

• Both

• None of the above