Basis Data

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Vilia
V
Vilia
Community Contributor
Quizzes Created: 1 | Total Attempts: 621
| Attempts: 621
Quiz Flashcard
SettingsSettings
Please wait...
  • 1/15 Questions

    Tampilkan semua data nilai dimana nilai MID lebih besar sama dengan 70 atau nilai finalnya lebih besar 85, maka Syntax SQLnya adalah ....

    • SELECT * FROM NILAI WHERE MID > 70 OR FINAL >=85
    • SELECT * FROM NILAI WHERE MID >= 70 OR FINAL > 85
    • SELECT NILAI FROM NILAI WHERE MID >= 70 OR FINAL > 85
    • SELECT NILAI MID >= 70 OR FINAL > 85 FROM NILAI
    • SELECT NILAI WHERE MID >= 70 OR FINAL > 85 FROM MHS
Please wait...
About This Quiz

Ketiklah nama Anda di kotak YOUR NAME dengan format NIM_NAMA. Yang mengerjakan Kuis ini lebih dari sekali maka di anggap GUGUR. Disarankan untuk membaca MODUL terlebih dahulu sebelum mengerjakan.

Pilihlah a,b,c,d atau e yang menurut Anda Benar!

Basis Data - Quiz

Quiz Preview

  • 2. 

     DROP DATABASE Mahasiswa; Syntax SQL di atas adalah termasuk jenis  SQL...

    • DDL

    • DML

    • DCL

    • Data Akses

    • Data Integrity

    Correct Answer
    A. DDL
    Explanation
    The given SQL syntax "DROP DATABASE Mahasiswa;" is an example of a Data Definition Language (DDL) statement. DDL is used to define and manage the structure of a database, including creating, altering, and deleting database objects such as tables, views, and indexes. The "DROP DATABASE" statement specifically deletes an entire database from the system. DDL statements do not manipulate or retrieve data, which distinguishes them from Data Manipulation Language (DML) statements.

    Rate this question:

  • 3. 

    UPDATE MHS SET ALAMAT=”Depok”  WHERE NPM=”50096487”; Syntax SQL di atas adalah termasuk jenis  SQL...

    • DDL

    • DML

    • DCL

    • Data Akses

    • Data Integrity

    Correct Answer
    A. DML
    Explanation
    The given SQL syntax is an example of DML (Data Manipulation Language). DML is used to modify, insert, delete, and update data in a database. In this case, the UPDATE statement is used to modify the ALAMAT (address) column in the MHS (students) table, setting it to "Depok" for the student with the NPM (student ID) of "50096487". DML statements are used to manipulate the data within a database, while DDL (Data Definition Language) is used to define the structure of the database and DCL (Data Control Language) is used to control access and permissions.

    Rate this question:

  • 4. 

    Dibawah ini yang tidak termasuk Tujuan Normalisasi adalah....  

    • Untuk menghilangkan kerangkapan data

    • Untuk mengurangi kompleksitas

    • Untuk mempermudah pemodifikasian data

    • Untuk menghilangkan redudancy

    • Untuk mempermudah terjadinya anomali

    Correct Answer
    A. Untuk mempermudah terjadinya anomali
    Explanation
    Normalisasi adalah proses mengorganisir data dalam basis data untuk menghilangkan redundansi dan meminimalkan anomali. Tujuan normalisasi adalah untuk menghilangkan kerangkapan data, mengurangi kompleksitas, mempermudah pemodifikasian data, dan menghilangkan redundansi. Namun, tujuan normalisasi tidak termasuk untuk mempermudah terjadinya anomali, karena anomali adalah hal yang harus dihindari dalam desain basis data yang baik.

    Rate this question:

  • 5. 

    Tipe data di SQL Teks maksimal 255 karakter dan bersifat variabel adalah...           

    • Char

    • Text

    • Varchar

    • Float

    • Double

    Correct Answer
    A. Varchar
    Explanation
    The correct answer is Varchar. In SQL, Varchar is a data type that can store variable-length character strings with a maximum length of 255 characters. It is commonly used when the length of the string may vary. Char, on the other hand, is a data type that stores fixed-length character strings, and Text is a data type that can store large amounts of text data. Float and Double are data types used for storing floating-point numbers.

    Rate this question:

  • 6. 
    Maksud  dari syntax diatas adalah ... - ProProfs

    Maksud  dari syntax diatas adalah ...

    • Tampilkan data mata kuliah yang memiliki kode 360 atau yang memilki sks =4

    • Tampilkan data mata kuliah yang memiliki kode 360 dan yang memilki sks =4

    • Tampilkan data mata kuliah yang memiliki kode 360

    • Tampilkan data mata kuliah yang memilki sks = 4

    • Tampilkan kode mata kuliah yang memiliki kode 360 atau yang memilki sks =4

    Correct Answer
    A. Tampilkan data mata kuliah yang memiliki kode 360 atau yang memilki sks =4
    Explanation
    The correct answer is "Tampilkan data mata kuliah yang memiliki kode 360 atau yang memilki sks =4." This means that the query will display the information of the courses that have a code of 360 or have a credit value of 4.

    Rate this question:

  • 7. 

    Definisi Atribut Y pada relasi R dikatakan tergantungfungsional padaatribut X (R.X ---> R.Y), jika dan hanya jika setiap nilai X pada relasi R mempunyai tepat satu nilai Y pada R. R= Relasi / Tabel Y,X = Atribut didalam Tabel R. Dari Definisi diatas adalah pengertian dari...

    • Ketergantungan fungsional

    • Ketergantungan partial

    • Ketergantungan transitif

    • Ketergantungan dependensi transitif

    • Ketergantuang sebagian

    Correct Answer
    A. Ketergantungan fungsional
    Explanation
    The given definition states that attribute Y in relation R is functionally dependent on attribute X if and only if every value of X in relation R has exactly one value of Y in R. This aligns with the concept of functional dependency, which refers to a relationship between two sets of attributes in a database. Therefore, the correct answer is "Ketergantungan fungsional" (Functional dependency).

    Rate this question:

  • 8. 

    Satu atribut atau satuset minimal atribut yang tidak hanya mengidentifikasi secara unik suatu kejadianspesifik, tetapi juga dapat mewakili setiap kejadian dari suatu entity, adalah pengertian dari...

    • Alternative Key

    • Primary Key

    • Foreign Key

    • Candidate Key

    • Super Key

    Correct Answer
    A. Primary Key
    Explanation
    A primary key is a minimal set of attributes that not only uniquely identifies a specific occurrence but can also represent any occurrence of an entity. It is used to uniquely identify each record in a table and ensures data integrity and consistency. The primary key constraint ensures that the values in the key are unique and not null. It is an essential concept in database design and is used to establish relationships between tables.

    Rate this question:

  • 9. 

    Tambahkan kolom JKEL dengan panjang 1 char pada tabel MHS, maka Syntax SQL adalah....

    • ALTER TABLE MHS INSERT (JKEL char(1));

    • ALTER TABLE MHS ADD (JKEL char(1));

    • ALTER TABLE MHS MODIFY (JKEL char(1));

    • ALTER TABLE MHS MODIFY (JKEL char(1));

    • ALTER TABLE ADD INSERT (JKEL char(1));

    Correct Answer
    A. ALTER TABLE MHS ADD (JKEL char(1));
    Explanation
    The correct answer is "ALTER TABLE MHS ADD (JKEL char(1));". This is the correct syntax to add a column named JKEL with a length of 1 char to the table MHS. The ALTER TABLE statement is used to modify the structure of a table, and the ADD keyword is used to add a new column to the table. The column name (JKEL) and its data type (char(1)) are specified in parentheses.

    Rate this question:

  • 10. 

    Atribut Z pada relasi R dikatakan tergantung transitif padaatribut X , jika atribut Y tergantung pada atribut X pada relasi R dan atributZ tergantungpada atributY pada relasiR. (X--> Y, Y-->Z , maka X --> Z ) adalah pengertian dari....

    • Ketergantungan Fungsional

    • Ketergantungan partial

    • Ketergantungan transitif

    • Ketergantungan dependensi transitif

    • Ketergantungan sebagian

    Correct Answer
    A. Ketergantungan transitif
    Explanation
    The given explanation states that attribute Z in relation R is said to depend transitively on attribute X if attribute Y depends on attribute X in relation R and attribute Z depends on attribute Y in relation R. This matches the definition of transitive dependency, where if X -> Y and Y -> Z, then X -> Z. Therefore, the correct answer is "Ketergantungan transitif."

    Rate this question:

  • 11. 

    Normalisasi Sebagai proses untuk mengubah suatu relasi yang memiliki masalah tertentu ke dalam dua buah relasi atau lebih yang tidak memiliki masalah tersebut (anomali) Sebagai proses untuk mengubah suatu relasi yang memiliki masalah tertentu ke dalam dua buah relasi atau lebih yang tidak memiliki masalah tersebut(anomali). Pengertian tersebut berdasarkan teori...

    • E.F. CODD

    • Boyce CODD

    • Kroenke

    • Raymond

    • Charlie

    Correct Answer
    A. Kroenke
    Explanation
    Kroenke is the correct answer because the given explanation matches the concept of normalization. Normalization is the process of organizing data in a database to eliminate redundancy and dependency issues, resulting in multiple tables that do not have anomalies. This aligns with the explanation provided, which states that normalization is the process of converting a relation with certain problems into two or more relations that do not have those problems (anomalies).

    Rate this question:

  • 12. 

    Suatu kondisi dimana ke-2  transaks idalam keadaan menunggu, sehingga keduanya tidak akan pernahselesai dieksekusi.

    • Deadlock

    • Synchpoint

    • Locking

    • Concurency

    • Time stamping

    Correct Answer
    A. Deadlock
    Explanation
    This answer is correct because it accurately identifies the given scenario as a deadlock. A deadlock occurs when two or more processes are unable to proceed because each is waiting for the other to release a resource. In this case, both transactions are in a waiting state, preventing them from being executed and leading to a deadlock situation.

    Rate this question:

  • 13. 

    Masalah ini timbul jika dua transaksi mengakses item   database yang sama yang mengakibatkan nilai dari   database tersebut menjadi tidak benar. Hal tersebut adalah masalah concurency yang disebabkan...

    • Uncommited Update Problem

    • Un Lost Update Problem

    • Lost Update Problem

    • Commited Update Problem

    • Problem of inconsistensi Analisa

    Correct Answer
    A. Lost Update Problem
    Explanation
    The correct answer is Lost Update Problem. This problem occurs when two transactions access the same item in a database, resulting in the value of the database becoming incorrect. It is a concurrency issue where one transaction overwrites the changes made by another transaction, leading to data inconsistency.

    Rate this question:

  • 14. 

    Salah satu alternatif mekanisme kontrol konkurensi yang dapat menghilangkan masalah dead lock

    • Concurency

    • Redudancy

    • Shared

    • Integrity

    • Time Stamping

    Correct Answer
    A. Time Stamping
    Explanation
    Time stamping is one of the alternative concurrency control mechanisms that can eliminate the problem of deadlock. In this mechanism, each transaction is assigned a unique timestamp, which represents the order of their execution. When a transaction requests a resource, the system checks its timestamp with the timestamp of the current holder of the resource. If the requesting transaction has a higher timestamp, it is allowed to access the resource, otherwise, it is made to wait. This ensures that transactions are executed in a non-conflicting order, preventing deadlock situations.

    Rate this question:

  • 15. 

    Menyatakan akhir dari suatu transaksi dimana basis data berada pada state yang konsisten disebut dengan..

    • Deadlock

    • Synchpoint

    • Locking

    • Concurency

    • Time stamping

    Correct Answer
    A. Synchpoint
    Explanation
    A synchpoint refers to the point in a transaction where the database is in a consistent state and the changes made by the transaction are permanently saved. It signifies the end of a transaction and ensures that all the changes made are properly synchronized and integrated into the database.

    Rate this question:

Quiz Review Timeline (Updated): Jul 22, 2024 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Jul 22, 2024
    Quiz Edited by
    ProProfs Editorial Team
  • Apr 27, 2010
    Quiz Created by
    Vilia
Back to Top Back to top
Advertisement