Sign in

Search for:

Kontak
Register
Login

Search for:

Kuis Menggunakan Fungsi Pada SQL

0% Complete

0/0 Steps

Kuis 1 of 0

Kuis Menggunakan Fungsi Pada SQL

Garda Dafi 14/05/2025

Time limit: 0

Kuis Summary

0 of 5 Pertanyaan completed

Questions:

Information

You have already completed the kuis before. Hence you can not start it again.

Kuis is loading…

You must sign in or sign up to start the kuis.

You must first complete the following:

Results

Kuis complete. Results are being recorded.

Results

0 of 5 Pertanyaan answered correctly

Your time:

Time has elapsed

You have reached 0 of 0 point(s), (0)

Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)

Categories

Not categorized 0%

1
2
3
4
5

Current
Review
Answered
Correct
Incorrect

Pertanyaan 1 of 5

1. Question
Buatlah perintah SQL yang berfungsi untuk menampilkan tanggal transaksi dalam menjadi bulan dan tahun tabel penjualan
- SELECT TO_MONTH_YEAR (transaction_date) FROM penjualan
- SELECT MONTH_YEAR(transaction_date) FROM penjualan
- SELECT YEAR_MONTH(transaction_date) FROM penjualan
- SELECT MONTH(transaction_date), YEAR(transaction_date) FROM penjualan
Correct

Incorrect
Pertanyaan 2 of 5

2. Question
Buatlah perintah SQL yang berfungsi untuk menggabungkan first_name dan last_name pada tabel customers
- SELECT CONCAT(first_name, ‘ ‘, last_name) from customers
- SELECT FLOOR(first_name, ‘ ‘, last_name) from customers
- SELECT ROUND(first_name, ‘ ‘, last_name) from customers
- SELECT SUM(first_name, ‘ ‘, last_name) from customers
Correct

Incorrect
Pertanyaan 3 of 5

3. Question
Buatlah perintah SQL yang berfungsi untuk membulatkan ke atas harga pada tabel buku
- SELECT SUM(harga) from buku
- SELECT FLOOR(harga) from buku
- SELECT ROUND(harga) from buku
- SELECT CEIL(harga) from buku
Correct

Incorrect
Pertanyaan 4 of 5

4. Question
Buatlah perintah SQL yang berfungsi menampilkata data tabel penjualan dengan format tanggal/bulan/tahun (31/01/2021)
- SELECT DATE_FORMAT(transaction_date, “%d/%m/%Y) from penjualan
- SELECT DATE_FORMAT(transaction_date, “%m/%d/%Y) from penjualan
- SELECT DATE_FORMAT(transaction_date, “%y/%m/%D) from penjualan
- SELECT DATE_FORMAT(transaction_date, “%y/%d/%M) from penjualan
Correct

Incorrect
Pertanyaan 5 of 5

5. Question
Buatlah perintah SQL yang berfungsi untuk menampilkan judul buku dengan huruf besar (kapital) pada tabel buku
- SELECT LOWER(judul) from buku
- SELECT UPPER(judul) from buku
- SELECT CAPSLOCK(judul) from buku
- SELECT CONCAT(judul) from buku
Correct

Incorrect

Report

There was a problem reporting this post.

Harassment Harassment or bullying behavior

Inappropriate Contains mature or sensitive content

Misinformation Contains misleading or false information

Offensive Contains abusive or derogatory content

Suspicious Contains spam, fake content or potential malware

Other

Report note

Block Member?

Please confirm you want to block this member.

You will no longer be able to:

See blocked member's posts
Mention this member in posts
Invite this member to groups
Message this member
Add this member as a connection

Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.

Report

You have already reported this .