oDesk My SQL 5.0 Test is the most important test for getting the Webstie Designing job on oDesk. You can take help before take the test.
You can find the test answers
oDesk MySQL 5.0 Test 2015.
1. What does SQL stand for?
c) Structured Query Language
2. Which SQL statement is used to
extract data from a database?
d) SELECT
3. Which SQL statement is used to
update data in a database?
a) UPDATE
4. Which SQL statement is used to
delete data from a database?
b) DELETE
5. Which SQL statement is used to
insert new data in a database?
c) INSERT
6. With SQL, how do you select a
column named “FirstName” from a table named “Persons”?
b) SELECT FirstName FROM
Persons
7. With SQL, how do you select all
the columns from a table named “Persons”?
d) SELECT * FROM Persons
8. With SQL, how do you select all
the records from a table named “Persons” where the value of the column
“FirstName” is “Peter”?
eter’
d)SELECT * FROM Persons WHERE
FirstName=’Peter’
9. With SQL, how do you select all
the records from a table named “Persons” where the value of the column
“FirstName” starts with an “a”?
d) SELECT * FROM Persons WHERE
FirstName LIKE ‘a%’
10. The OR operator displays a record
if ANY conditions listed are true. The AND operator displays a record if ALL of
the conditions listed are true
a) True
11. With SQL, how do you select all
the records from a table named “Persons” where the “FirstName” is “Peter” and
the “LastName” is “Jackson”?
b) SELECT * FROM Persons
WHERE FirstName=’Peter’ AND LastName=’Jackson’
12. With SQL, how do you select all
the records from a table named “Persons” where the “LastName” is alphabetically
between (and including) “Hansen” and “Pettersen”?
b) SELECT * FROM Persons WHERE
LastName BETWEEN ‘Hansen’ AND ‘Pettersen’
13. Which SQL statement is used to
return only different values?
d) SELECT DISTINCT
14. Which SQL keyword is used to sort
the result-set?
c) ORDER BY
15. With SQL, how can you return all
the records from a table named “Persons” sorted descending by “FirstName”?
b) SELECT * FROM Persons ORDER BY
FirstName DESC
16. With SQL, how can you insert a
new record into the “Persons” table?
a) INSERT INTO Persons
VALUES (‘Jimmy’, ‘Jackson’)
17. With SQL, how can you insert
“Olsen” as the “LastName” in the “Persons” table?
a) INSERT INTO Persons
(LastName) VALUES (‘Olsen’)
18. How can you change “Hansen” into
“Nilsen” in the “LastName” column in the Persons table?
b) UPDATE Persons SET
LastName=’Nilsen’ WHERE LastName=’Hansen’
19. With SQL, how can you delete the
records where the “FirstName” is “Peter” in the Persons Table?
a) DELETE FROM Persons
WHERE FirstName = ‘Peter’
20. With SQL, how can you return the number
of records in the “Persons” table?
b) SELECT COUNT(*) FROM Persons
21. Given an employees table as
follows: empid name managerid a1 bob NULL b1 jim a1 B2 tom a1 What value will
select count(*) from employees return?
c) 3
22. The result of a SELECT statement
can contain duplicate rows.
a) True
23. Sometimes the expression “select
count(*)” will return fewer rows than the expression “select count(value)”.
b) False
24. What type of lock will deny users
any access to a table?
c) EXCLUSIVE
25. Which of the following is the
correct SQL statement to use to remove rows from a table?
c) DELETE
26. The only way to join two tables
is by using standard, ANSI syntax.
b) False
27. A NULL value is treated as a
blank or 0.
b) False
28. The left outer join is one type
of outer join. Another one is the.
e) all of the above
You can find the test answers
oDesk MySQL 5.0 Test 2015.
