COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Table
|
|
|
Values
|
|
|
Relation
|
|
|
Field
|
Detailed explanation-1: -5. Insert into employee (1002, Joey, 2000); In the given query which of the keyword has to be inserted? Explanation: Value keyword has to be used to insert the values into the table.
Detailed explanation-2: -Note that the INSERT statement requires the column names in the parenthesis if you don’t want to insert data in all the columns but to some specific columns only. INSERT INTO Employee(EmpId, FirstName, LastName) VALUES(2, ’James’, ’Bond’); Now, the Select * from Employee query will display the following result.
Detailed explanation-3: -Which of the following employee id will be displayed for the given query? Explanation: Greater than symbol does not include the given value unlike >=. 9.
Detailed explanation-4: -Explanation: The select clause is used to list the attributes desired in the result of a query.
Detailed explanation-5: -The WHERE clause is used to restrict the number of rows returned from a SELECT query.