1.
Suatu obyek yang dapat dibedakan dengan objek lainnya, disebut dengan...
Correct Answer
E. Entitas
Explanation
An object that can be distinguished from other objects is referred to as an "entitas" in Indonesian. This term is commonly used in the context of data modeling and database systems, where entities represent real-world objects or concepts that have distinct characteristics and can be uniquely identified.
2.
Kumpulan record-record sejenis yang mempunyai panjang elemen sama, atribute yang sama namun berbeda-beda data valuenya, disebut dengan ...
Correct Answer
C. File
Explanation
A group of similar records with the same length and attributes but different data values is referred to as a file.
3.
Masing-masing bagian dari database dapat diakses oleh pemakai dalam waktu yang bersamaan, untuk aplikasi yang berbeda, disebut dengan... .
Correct Answer
D. Shared
Explanation
The correct answer is "Shared." Each part of the database can be accessed by users simultaneously, for different applications. This means that multiple users can access and modify the database at the same time, allowing for efficient collaboration and utilization of the database resources.
4.
Yang bukan termasuk dari ciri-ciri Tradisional File Management adalah...
Correct Answer
C. Bersifat luwes/fleksible
Explanation
The correct answer is "Bersifat luwes/fleksible." This is because one of the characteristics of traditional file management is that it is rigid and inflexible. Traditional file management systems have fixed structures and formats for storing and organizing data, which makes it difficult to adapt to changing needs or accommodate different types of data. In contrast, modern database management systems are more flexible and can easily handle diverse data types and structures.
5.
Menerangkan struktur penyimpanan basisdata secara fisik dan organisasi file yang digunakan adalah ...
Correct Answer
B. Internal level
Explanation
The correct answer is Internal level. The internal level of a database describes the physical storage structure and file organization used in a database system. It deals with how data is stored on the storage media, such as disks or tapes, and how it is accessed and manipulated at the lowest level. It focuses on the implementation details and is closer to the physical representation of the data.
6.
Salah satu contoh tipe data DML non prosedural adalah
Correct Answer
B. SQL
Explanation
SQL (Structured Query Language) is a programming language used for managing relational databases. It is a non-procedural DML (Data Manipulation Language) because it allows users to specify what data they want to retrieve or modify, without specifying how to do it. In other words, SQL allows users to focus on the desired outcome rather than the specific steps to achieve it. This makes SQL a powerful and efficient language for working with databases.
7.
Simbol ERM yang berupa garis lurus berfungsi untuk...
Correct Answer
D. Menunjukan adanya relasi
Explanation
The correct answer is "Menunjukan adanya relasi". This is because a straight line symbol in an Entity-Relationship Model (ERM) is used to represent a relationship between entities. It shows that there is a connection or association between two or more entities in the database.
8.
Di bawah ini yang termasuk Object Database Model, kecuali ... .
Correct Answer
E. Model Data Fisik
Explanation
The given options represent different database models. The infological model, semantic data model, binary model, and entity relationship model are all examples of object database models. However, the physical data model is not an object database model. It is a representation of how data is stored and organized in a database system, focusing on the physical aspects such as tables, columns, and indexes. Therefore, the physical data model is the exception in this list.
9.
Gambar di bawah ini adalah model data dari ... .
Correct Answer
B. Semantic model
Explanation
The given correct answer is "Semantic model". The explanation for this answer is that the picture below represents a data model known as the semantic model. The semantic model is a conceptual model that focuses on the meaning and relationships between data elements. It is used to describe the semantics, or meaning, of data in a system. This model is often used in database design to ensure that data is organized and structured in a way that accurately represents the real-world entities and their relationships.
10.
Sekumpulan konsep-konsep untuk menerangkan data, hubungan-hubungan antara data dan batasan-batasan data yang terintegrasi di dalam suatu organisasi, adalah pengertian dari...
Correct Answer
D. Model Data
Explanation
Model Data adalah sekumpulan konsep-konsep untuk menerangkan data, hubungan-hubungan antara data, dan batasan-batasan data yang terintegrasi di dalam suatu organisasi. Model Data digunakan untuk menggambarkan struktur data, hubungan antara entitas, atribut-atribut yang dimiliki oleh entitas, dan batasan-batasan yang ada dalam pengelolaan data di dalam suatu organisasi. Dengan menggunakan Model Data, organisasi dapat merencanakan dan mengorganisir data mereka dengan lebih efisien dan efektif.
11.
Simbol ER dibawah ini disebut dengan
Correct Answer
A. ATRIBUT PRIMARY KEY
Explanation
The correct answer is "ATRIBUT PRIMARY KEY" because a primary key is a unique identifier for each record in a database table. It ensures that each record can be uniquely identified and helps maintain data integrity. The other options mentioned, such as "ATRIBUT MULTI KEY" and "ATRIBUT DERIVATIF," are not valid terms in the context of ER symbols.
12.
Bentuk-bentuk topologi distribusi data pada gambar di bawah ini, disebut dengan ... .
Correct Answer
B. Partialy conneted network
Explanation
The given correct answer for this question is "Partialy conneted network". This type of network topology refers to a network where some nodes are directly connected to each other while others are connected through intermediate nodes. In this topology, data can be distributed efficiently as it allows for multiple paths between nodes.
13.
Kumpulan operasi terhadap relasi, dimana setiap operasi menggunakan satu atau lebih relasi untuk menghasilkan satu relasi yang baru, adalah pengertian dari ...
Correct Answer
E. Aljabar Relational
Explanation
Aljabar Relational adalah kumpulan operasi terhadap relasi, dimana setiap operasi menggunakan satu atau lebih relasi untuk menghasilkan satu relasi yang baru.
14.
Operasi yang menggabungkan operasi cartesian product dengan operasi selection dengan suatu kriteria, disebut dengan operasi
Correct Answer
D. THETA JOIN
Explanation
The operation that combines the cartesian product operation with the selection operation based on a certain criteria is called a theta join. In a theta join, the join condition can be any condition using comparison operators such as greater than, less than, equal to, etc. This allows for more flexibility in joining tables compared to other join operations like natural join or set intersection.
15.
Operasi untuk menghasilkan gabungan tabel dengan syarat kedua tabel memiliki atribut yang sama yaitu domain atribut ke-i masing-masing tabel harus sama , disebut dengan operasi
Correct Answer
E. Union
Explanation
The correct answer is Union. Union is the operation used to combine two tables where the attributes in both tables have the same domain. It takes the rows from both tables and creates a new table that contains all the rows from both tables, without any duplicates.