Slq Quiz

Slq Quiz

TEST YOUR SQL SKILLS START STUDYIN OR ELSE KT MUBARAK ? YOU LL SCORE GREAT IN DBMS PAPER ? YOU WILL SCORE 100 IN DBMS PAPER :p ?

დაწყება გააზიარეთ
Slq Quiz
1. What does SQL stand for?
Კითხვა 1 out of 8
Strong Question Language Structured Query Language Structured Question Language
Slq Quiz
2. Which SQL statement is used to extract data from a database?
Კითხვა 2 out of 8
GET OPEN SELECT
Slq Quiz
3. Which SQL statement is used to update data in a database?
Კითხვა 3 out of 8
MODIFY SAVE UPDATE
Slq Quiz
4. Which SQL statement is used to insert new data in a database?
Კითხვა 4 out of 8
ADD RECORD INSERT INTO INSERT NEW
Slq Quiz
5. With SQL, how do you select a column named "FirstName" from a table named "Persons"?
Კითხვა 5 out of 8
EXTRACT FirstName FROM Persons SELECT FirstName FROM Persons SELECT Persons.FirstName
Slq Quiz
6. With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?
Კითხვა 6 out of 8
SELECT * FROM Persons WHERE FirstName<>'Peter' SELECT * FROM Persons WHERE FirstName='Peter' SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'
Slq Quiz
7. 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"?
Კითხვა 7 out of 8
SELECT * FROM Persons WHERE FirstName LIKE '%a' SELECT * FROM Persons WHERE FirstName LIKE 'a%' SELECT * FROM Persons WHERE FirstName='%a%'
Slq Quiz
8. 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"?
Კითხვა 8 out of 8
SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen' SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen' SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons
შექმნილია Dixie.West15-ის მიერ
შექმენით თქვენი საკუთარი ვიქტორინა

შემოთავაზებული ტესტები
მეტი ვიქტორინა

შემოთავაზებული გამოკითხვები
სხვა გამოკითხვები

შემოთავაზებული აპები
სხვა აპლიკაციები