Baze de date
SQL Mastery Quiz
Test your knowledge of SQL with our comprehensive quiz designed for both beginners and seasoned professionals. This quiz covers various topics essential for database management and querying.
Key Features:
- 17 Engaging Questions
- Multiple Choice and Checkbox Formats
- Assess Your SQL Knowledge
Cand sortati rezultatele dupa valorile unei coloane unde sunt valori intregi, ce cuvant cheie ati folosi pentru a sorta de la valoarea cea mai mare la cea mai mica?
DESC
AESC
ASC
DSC
Ce cuvant cheie puteti folosi pentru a imbina doua tabele folosind o coloana potrivita ?
MERGE
JOIN
AND
ATTACH
Cand doriti sa obtineti numai valorile unei singure coloane, ce cuvant cheie folositi inainte numelei coloanei pentru a returna numai valori unice ?
ONE
DISTINCT
SINGLE
UNIQUE
Daca doriti sa aplicati o conditie secundara la sintaxa acolo unde ambele cerinte sunt corecte, ce cuvant cheie ati folosi intre conditii ?
AND
WHERE
BOTH
TRUE
Ce instructiune SQL poate fi folosita pentru a sterge toate datele dintr-un tabel ?
DELETE
TRUNCATE
DELETE * FROM tabel
REMOVE
De la ce provine SQL ?
Structured Query Language
Stuctured Question Language
Strong Question Language
Strong Query Language
Ce functie puteti folosi pentru a rotunji valorile ?
ROUNDMAX
CELING sau CEL
ROUND UP
MAX
Ce cuvant cheie ati folosi intr-o interogare UPDATE pentru a actualiza valoarea existenta ?
EDIT
WRITE
MAKE
SET
Pentru a sorta rezultatele dupa o coloana, ce cuvant cheie trebuie sa folositi inainte de numele coloanei ?
IF
BY
SORT BY
ORDER BY
In interogarea "SELECT address FROM users", ce colana este selectata ?
FROM
SELECT
Users
Address
Ce cuvant cheie ati folosi pentru a grupa rezultatele dupa valorile unei coloane ?
ORDER BY
BY
GROUP BY
JOIN
Ce cuvant cheie puteti folosi pentru cauta o valoarea string dintr-o coloana ?
HAS STRING
LIKE
CONSTRAINS STRING
FIND STRING
{"name":"Baze de date", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Test your knowledge of SQL with our comprehensive quiz designed for both beginners and seasoned professionals. This quiz covers various topics essential for database management and querying.Key Features:17 Engaging QuestionsMultiple Choice and Checkbox FormatsAssess Your SQL Knowledge","img":"https:/images/course8.png"}