
ExamenSentències SQL - BATX
Authored by Martí Taberner
Computers
12th Grade
14 Questions
Used 4+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Quina sentència s'utilitza per extreure dades d'una base de dades?
EXTRACT
OPEN
INSERT
SELECT
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Quina instrucció SQL s'utilitza per actualitzar les dades existents en una base de dades?
UPDATE DATA
MODIFY RECORD
CHANGE INTO
UPDATE SET
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Quina sentència s'utilitza per esborrar la taula 'Professors' per complet?
DELETE * FROM Professors;
DROP TABLE Professors;
REMOVE TABLE Professors;
ERASE TABLE Professors;
4.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
L'operador WHERE només es pot utilitzar dins instruccions SELECT
VERITAT
MENTIDA
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Quina instrucció SQL s'utilitza per inserir dades noves en una base de dades?
ADD NEW
INSERT NEW
ADD RECORD
INSERT INTO
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Quina sentència s'utilitza per afegir una nova columna a la taula 'Persones' amb el nom 'Nacionalitat' i que sigui un tipus de variable 'integer'?
INSERT INTO Persones (Nacionalitat) VALUES ('Sí'/'No');
ADD COLUMN Persones boolean TO Nacionalitat;
ALTER TABLE Persones ADD Nacionalitat int;
CREATE COLUMN Nacionalitat integer IN Persones;
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Quina sentència s'utilitza per eliminar tots els registres de la taula 'Assignatures' que tenguin la columna 'Curs' amb el valor '3r ESO'?
DROP FROM Assignatures WHERE CURS='3r ESO';
ERASE FROM Assignatures WHERE CURS='3r ESO';
REMOVE * FROM Assignatures WHERE CURS='3r ESO';
DELETE FROM Assignatures WHERE CURS='3r ESO';
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Popular Resources on Wayground
5 questions
This is not a...winter edition (Drawing game)
Quiz
•
1st - 5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
Identify Iconic Christmas Movie Scenes
Interactive video
•
6th - 10th Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
11 questions
How well do you know your Christmas Characters?
Lesson
•
3rd Grade
14 questions
Christmas Trivia
Quiz
•
5th Grade
20 questions
How the Grinch Stole Christmas
Quiz
•
5th Grade
Discover more resources for Computers
26 questions
Christmas Movie Trivia
Lesson
•
8th Grade - Professio...
15 questions
Christmas Song Emoji Pictionary
Quiz
•
7th - 12th Grade
20 questions
Christmas Movies
Quiz
•
1st - 12th Grade
55 questions
CHS Holiday Trivia
Quiz
•
12th Grade
20 questions
Christmas Movie Trivia
Quiz
•
9th - 12th Grade
29 questions
christmas facts
Lesson
•
5th - 12th Grade
20 questions
Christmas Trivia
Quiz
•
5th - 12th Grade
20 questions
Stages of Meiosis
Quiz
•
9th - 12th Grade