
Pytania dotyczące SQL Alter Table
Quiz
•
Computers
•
8th Grade
•
Practice Problem
•
Medium
Grzegorz Godlewski
Used 2+ times
FREE Resource
Enhance your content in a minute
38 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
ak zmienić nazwę tabeli orders na purchases?
ALTER TABLE orders RENAME TO purchases
RENAME TABLE orders TO purchases
ALTER orders TO purchases
CHANGE TABLE orders TO purchases
2.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Jak dodać nową kolumnę age typu INT do tabeli users?
ALTER TABLE users ADD COLUMN age INT
ALTER TABLE users INSERT COLUMN age INT
ALTER TABLE users CREATE COLUMN age INT
ALTER TABLE users NEW age INT
3.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Co zrobi ALTER TABLE employees DROP COLUMN department?
Doda kolumnę department
Usunie kolumnę department
Zmodyfikuje kolumnę department
Nic nie zrobi
4.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Jak ustawić kolumnę email w tabeli customers jako unikalną?
ALTER TABLE customers SET UNIQUE(email)
ALTER TABLE customers MODIFY email UNIQUE
ALTER TABLE customers ADD UNIQUE(email)
ALTER TABLE customers CONSTRAINT UNIQUE email
5.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Jak zmienić typ kolumny phone_number w tabeli contacts na VARCHAR(15)?
ALTER TABLE contacts CHANGE phone_number VARCHAR(15)
ALTER TABLE contacts MODIFY phone_number VARCHAR(15)
ALTER TABLE contacts ALTER phone_number VARCHAR(15)
ALTER TABLE contacts SET phone_number VARCHAR(15)
6.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Co zrobi poniższa komenda: ALTER TABLE orders DROP PRIMARY KEY?
Usunie klucz główny
Ustawi klucz główny
Zmieni typ kolumny
Doda nowy klucz główny
7.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Jak dodać kolumnę status typu ENUM('active', 'inactive') do tabeli accounts?
ALTER TABLE accounts ADD status ENUM('active', 'inactive')
ALTER TABLE accounts NEW status ENUM('active', 'inactive')
ALTER TABLE accounts SET COLUMN status ENUM('active', 'inactive')
ALTER TABLE accounts ALTER COLUMN status ENUM('active', 'inactive')
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?
Similar Resources on Wayground
40 questions
Final Test
Quiz
•
8th Grade
40 questions
Digital Technology Quiz
Quiz
•
7th - 8th Grade
34 questions
T3 B2- Kriptografi smkkps
Quiz
•
6th - 8th Grade
40 questions
INFORMATIKA GANJIL KELAS 8 2024
Quiz
•
8th Grade
34 questions
Database Quiz
Quiz
•
6th - 8th Grade
40 questions
Spreadsheet Formulas,Charts,Formatting
Quiz
•
7th - 8th Grade
40 questions
LATIHAN SOAL ASTS GENAP INFORMATIKA 8
Quiz
•
8th Grade
40 questions
Latihan PAT
Quiz
•
8th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
