Arkadaşlar, can sıkıntısı ve baş ağrısı ile + iş yokkene nette dolaşırken(vakit öldürürken kısacası) güzel bir site yakaladım ve oldukça keyifli hemde öğretici. Yarışması var SQL ile ilgili SQL bilginizi ufak bir test edin hemde yeniden bilgilerinizi tazeleyin.
QUİZ :
[Üye Olmadan Linkleri Göremezsiniz. Üye Olmak için TIKLAYIN...]
Benim sonuç bu çıktı (:
Result:
17 of 20
85%
You can be proud of yourself!
Time Spent
5:21
Felaket başım ağırdı ama yapcak birşey yok
Bu forumdaki linkleri ve resimleri görebilmek için en az 25 mesajınız olması gerekir.
Bildiğini yanlış yapmakta keyifli.
PHP Kod: Kodu kopyalamak için üzerine çift tıklayın!
[B]W3Schools SQL Quiz[/B]
SQL QUIZ Points: 17 out of 20
1. What does SQL stand for?
[COLOR=green] Correct Answer![/COLOR]
2. Which SQL statement is used to extract data from a database?
You answered: EXTRACT [COLOR=red] Wrong Answer![/COLOR]
3. Which SQL statement is used to update data in a database?
[COLOR=green] Correct Answer![/COLOR]
4. Which SQL statement is used to delete data from a database?
[COLOR=green] Correct Answer![/COLOR]
5. Which SQL statement is used to insert new data in a database?
[COLOR=green] Correct Answer![/COLOR]
6. With SQL, how do you select a column named "FirstName" from a table named "Persons"?
[COLOR=green] Correct Answer![/COLOR]
7. With SQL, how do you select all the columns from a table named "Persons"?
[COLOR=green] Correct Answer![/COLOR]
8. With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?
[COLOR=green] Correct Answer![/COLOR]
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"?
[COLOR=green] Correct Answer![/COLOR]
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
[COLOR=green] Correct Answer![/COLOR]
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"?
[COLOR=green] Correct Answer![/COLOR]
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"?
[COLOR=green] Correct Answer![/COLOR]
13. Which SQL statement is used to return only different values?
You answered: SELECT DIFFERENT [COLOR=red] Wrong Answer![/COLOR]
14. Which SQL keyword is used to sort the result-set?
[COLOR=green] Correct Answer![/COLOR]
15. With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?
[COLOR=green] Correct Answer![/COLOR]
16. With SQL, how can you insert a new record into the "Persons" table?
[COLOR=green] Correct Answer![/COLOR]
17. With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?
[COLOR=green] Correct Answer![/COLOR]
18. How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?
You answered: UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen' [COLOR=red] Wrong Answer![/COLOR]
19. With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?
[COLOR=green] Correct Answer![/COLOR]
20. With SQL, how can you return the number of records in the "Persons" table?
[COLOR=green] Correct Answer![/COLOR]
[LEFT][/LEFT]
Dökümüde alabiliyoruz, hangileri doğru hangileri yanlış.