Font size
WorksheetsTiket Data Townhall
Total questions: 15
Worksheet time: 6mins
SQL is
Structured Query Language
Simple Query Language
Structured Question Language
Structure Quality Language
28
If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default
ASC
DESC
There is no default value
None of the mentioned
Which SQL statement would add a record to the database?
INSERT INTO Designer VALUES ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456')
INSERT VALUES ('SMI01', 'M Smith', 'mail@msmith.com', 01224123456') INTO Designer
INSERT ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456') INTO Designer
INSERT Designer INTO VALUES (''SMI01', 'M Smith', 'mail@msmith.com', '01224123456')
Pada tahun ini, rencananya tiket.com akan melakukan pemindahan headquarter ke gedung baru. Apakah nama gedung baru tersebut?
Wisma Barito Pasific 2
Wisma Barito
Wisma Barito Pasific
Wisma Barito Pacific 2
Berapa kode pos dari gedung baru tersebut?
11430
10310
10330
11410
How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?
UPDATE Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
MODIFY Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
Victor Setya, merupakan VP of Data dari tiket.com. Per hari ini, ada berapa banyak karyawan yang report langsung kepada Victor secara formal dan tercatat di Workday?
3
4
5
6
Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy.
SELECT city, temperature, condition FROM weather WHERE condition NOT IN (‘sunny’, ‘cloudy’)
SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN (‘sunny’, ‘cloudy’)
SELECT city, temperature, condition FROM weather WHERE condition IN (‘sunny’, ‘cloudy’)
SELECT city, temperature, condition FROM weather WHERE condition BETWEEN (‘sunny’, ‘cloudy’);
Berikut ini merupakan cuti besar yang ada di tiket.com, kecuali..
Cuti Bencana Alam
Cuti Pindah Rumah
Cuti Menjaga Keluarga
Cuti Inagurasi/Wisuda
Dalam serial TV Layangan Putus, apakah nama kota impian Kinan yang dijadikan tempat liburan Aris bersama Lydia? Dan berapakah harga penthouse yang dibelikan Aris untuk Lydia?
Istanbul, 5M
Cappadocia, 5M
Istanbul, 10M
Cappadocia, 10M
