COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What is the expected output from following SQL Query:SELECT titleFROM videogamesWHERE title LIKE ‘%2’
|
|
It will only show video games which contains the character 2 somewhere in the title
|
|
|
It will only show videogames which begins with the character 2 in the title
|
|
|
It will only show videogames which ends with the character 2 in the title
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -The asterisk tells the database to select all data in the table.
Detailed explanation-2: -An UPDATE statement without a WHERE clause will update all the rows of the table.
Detailed explanation-3: -An SQL SELECT statement retrieves records from a database table according to clauses (for example, FROM and WHERE ) that specify criteria.
Detailed explanation-4: -In this chapter, we will focus on using SQL to create the database and table structures, mainly using SQL as a data definition language (DDL). In Chapter 16, we will use SQL as a data manipulation language (DML) to insert, delete, select and update data within the database tables.
There is 1 question to complete.