Basis Data
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!
Questions and Answers
- 1.
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...
- A.
E.F. CODD
- B.
Boyce CODD
- C.
Kroenke
- D.
Raymond
- E.
Charlie
Correct Answer
C. KroenkeExplanation
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:
-
- 2.
Dibawah ini yang tidak termasuk Tujuan Normalisasi adalah....
- A.
Untuk menghilangkan kerangkapan data
- B.
Untuk mengurangi kompleksitas
- C.
Untuk mempermudah pemodifikasian data
- D.
Untuk menghilangkan redudancy
- E.
Untuk mempermudah terjadinya anomali
Correct Answer
E. Untuk mempermudah terjadinya anomaliExplanation
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:
-
- 3.
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...
- A.
Ketergantungan fungsional
- B.
Ketergantungan partial
- C.
Ketergantungan transitif
- D.
Ketergantungan dependensi transitif
- E.
Ketergantuang sebagian
Correct Answer
A. Ketergantungan fungsionalExplanation
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:
-
- 4.
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....
- A.
Ketergantungan Fungsional
- B.
Ketergantungan partial
- C.
Ketergantungan transitif
- D.
Ketergantungan dependensi transitif
- E.
Ketergantungan sebagian
Correct Answer
C. Ketergantungan transitifExplanation
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:
-
- 5.
UPDATE MHS SET ALAMAT=”Depok” WHERE NPM=”50096487”; Syntax SQL di atas adalah termasuk jenis SQL...
- A.
DDL
- B.
DML
- C.
DCL
- D.
Data Akses
- E.
Data Integrity
Correct Answer
B. DMLExplanation
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:
-
- 6.
Tambahkan kolom JKEL dengan panjang 1 char pada tabel MHS, maka Syntax SQL adalah....
- A.
ALTER TABLE MHS INSERT (JKEL char(1));
- B.
ALTER TABLE MHS ADD (JKEL char(1));
- C.
ALTER TABLE MHS MODIFY (JKEL char(1));
- D.
ALTER TABLE MHS MODIFY (JKEL char(1));
- E.
ALTER TABLE ADD INSERT (JKEL char(1));
Correct Answer
B. 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:
-
- 7.
DROP DATABASE Mahasiswa; Syntax SQL di atas adalah termasuk jenis SQL...
- A.
DDL
- B.
DML
- C.
DCL
- D.
Data Akses
- E.
Data Integrity
Correct Answer
A. DDLExplanation
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:
-
- 8.
Tampilkan semua data nilai dimana nilai MID lebih besar sama dengan 70 atau nilai finalnya lebih besar 85, maka Syntax SQLnya adalah ....
- A.
SELECT * FROM NILAI WHERE MID > 70 OR FINAL >=85
- B.
SELECT * FROM NILAI WHERE MID >= 70 OR FINAL > 85
- C.
SELECT NILAI FROM NILAI WHERE MID >= 70 OR FINAL > 85
- D.
SELECT NILAI MID >= 70 OR FINAL > 85 FROM NILAI
- E.
SELECT NILAI WHERE MID >= 70 OR FINAL > 85 FROM MHS
Correct Answer
B. SELECT * FROM NILAI WHERE MID >= 70 OR FINAL > 85Explanation
The correct answer is "SELECT * FROM NILAI WHERE MID >= 70 OR FINAL > 85". This SQL query selects all data from the table "NILAI" where the value of the column "MID" is greater than or equal to 70, or the value of the column "FINAL" is greater than 85. This query will display all the data that meets this condition.Rate this question:
-
- 9.
Tipe data di SQL Teks maksimal 255 karakter dan bersifat variabel adalah...
- A.
Char
- B.
Text
- C.
Varchar
- D.
Float
- E.
Double
Correct Answer
C. VarcharExplanation
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:
-
- 10.
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...
- A.
Alternative Key
- B.
Primary Key
- C.
Foreign Key
- D.
Candidate Key
- E.
Super Key
Correct Answer
B. Primary KeyExplanation
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:
-
- 11.
Maksud dari syntax diatas adalah ...
- A.
Tampilkan data mata kuliah yang memiliki kode 360 atau yang memilki sks =4
- B.
Tampilkan data mata kuliah yang memiliki kode 360 dan yang memilki sks =4
- C.
Tampilkan data mata kuliah yang memiliki kode 360
- D.
Tampilkan data mata kuliah yang memilki sks = 4
- E.
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 =4Explanation
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:
-
- 12.
Menyatakan akhir dari suatu transaksi dimana basis data berada pada state yang konsisten disebut dengan..
- A.
Deadlock
- B.
Synchpoint
- C.
Locking
- D.
Concurency
- E.
Time stamping
Correct Answer
B. SynchpointExplanation
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:
-
- 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...
- A.
Uncommited Update Problem
- B.
Un Lost Update Problem
- C.
Lost Update Problem
- D.
Commited Update Problem
- E.
Problem of inconsistensi Analisa
Correct Answer
C. Lost Update ProblemExplanation
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
- A.
Concurency
- B.
Redudancy
- C.
Shared
- D.
Integrity
- E.
Time Stamping
Correct Answer
E. Time StampingExplanation
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.
Suatu kondisi dimana ke-2 transaks idalam keadaan menunggu, sehingga keduanya tidak akan pernahselesai dieksekusi.
- A.
Deadlock
- B.
Synchpoint
- C.
Locking
- D.
Concurency
- E.
Time stamping
Correct Answer
A. DeadlockExplanation
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:
-
(2).bmp "Maksud dari syntax diatas adalah ...")
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Apr 27, 2010Quiz Created by
Vilia
Sekolah Global Mandiri - Wilayah Negara Kesatuan Republik Indonesia
Sekolah Global Mandiri - Wilayah Negara Kesatuan Republik Indonesia
Seleksi Penerimaan Mahasiswa Baru Poltekkes Hermina Tahun 2020
Seleksi Penerimaan Mahasiswa Baru Poltekkes Hermina Tahun 2020
Back to top