1.
Merupakan kumpulan dari data yang saling berhubungan satu dengan yang lainnya, tersimpan dalam perangkat keras komputer dan digunakan perangkat lunak untuk memanipulasinya. Merupakan definisi dari ....
Correct Answer
C. Basis Data
Explanation
The given definition describes Basis Data, which is a collection of data that is interrelated and stored in computer hardware, and is used by software to manipulate it.
2.
Berikut ini merupakan keuntungan menggunakan basis data adalah, kecuali ....
Correct Answer
B. Perawatan yang super ekstra
Explanation
The given answer states "Perawatan yang super ekstra" which translates to "Super extra maintenance." However, this does not align with the benefits of using a database. The correct benefits of using a database include independence of program-data, improving the ability to handle various data, and minimizing data redundancy. Therefore, the given answer is incorrect as it does not relate to the advantages of using a database.
3.
Urutan atau hirarki basis data yang benar adalah ....
Correct Answer
D. DBMS > Database > Table > Field & Record
Explanation
The correct answer is DBMS > Database > Table > Field & Record. In a database management system (DBMS), the highest level is the DBMS itself, which manages the entire database. Within the DBMS, there are multiple databases, each containing different sets of tables. Each database can have multiple tables, which store the actual data. Finally, within each table, there are fields (columns) and records (rows) that hold the individual data values.
4.
Merupakan sebuah kumpulan nilai yang saling terkait, definisi dari ....
Correct Answer
A. Record
Explanation
A record is a collection of related values. It is used to store and organize data in a structured manner. In a database or spreadsheet, a record represents a single instance or entry of information. It consists of multiple fields, each representing a specific attribute or piece of data. The fields within a record are interconnected and together they form a cohesive unit of information. Therefore, a record can be defined as a group of values that are interrelated and stored together.
5.
Merupakan suatu field yang dapat dijadikan kunci dalam operasi tabel dalam konsep database, definisi dari ....
Correct Answer
B. Key
Explanation
A key is a field that can be used as a unique identifier in a database table. It helps in organizing and retrieving data efficiently by providing a way to uniquely identify each record in the table. Keys ensure data integrity and enforce constraints such as uniqueness and referential integrity.
6.
Merupakan kumpulan data (nilai) yang diorganisasikan ke dalam baris (record) dan kolom (field), definisi dari ....
Correct Answer
A. Table
Explanation
The correct answer is "Table". A table is a collection of organized data that is arranged in rows and columns. It is used to store and manage large amounts of information in a structured manner. Tables are commonly used in databases and spreadsheets to store data in a tabular format, making it easier to search, sort, and analyze the information.
7.
Merupakan kolom dari sebuah table, definisi dari ....
Correct Answer
B. Field
Explanation
A field is a column in a table that defines a specific attribute or property of the data being stored in the database. It represents a single piece of information within a record and is used to organize and categorize data. Fields are used to store different types of data such as numbers, text, dates, and more. They provide a way to structure and organize data in a database, allowing for efficient storage, retrieval, and manipulation of information.
8.
Merupakan suatu bahasa (language) yang digunakan untuk mengakses database, definisi dari ....
Correct Answer
C. SQL
Explanation
SQL stands for Structured Query Language, which is a language used to access and manipulate databases. It allows users to retrieve, insert, update, and delete data from a database. SQL is specifically designed for managing and querying relational databases. It provides a standardized way to communicate with databases and is widely used in the field of database management systems (DBMS). SQL is not a programming language like PHP, but rather a language used to interact with databases. Therefore, the correct answer is SQL.
9.
Jenis type data (Aplikasi Ms. Access) yang digunakan untuk menangani inputan berupa huruf dan angka maupun simbol-simbol yang lainya merupakan type data ....
Correct Answer
D. Text
Explanation
The correct answer is "Text" because the question is asking for the type of data in Microsoft Access that is used to handle input consisting of letters, numbers, and other symbols. The "Text" data type in Access is used for storing alphanumeric characters and can handle a wide range of input values, making it suitable for handling input that includes both letters and numbers, as well as symbols.
10.
Jenis type data (Aplikasi Ms. Access) yang digunakan untuk menangani inputan berupa angka merupakan type data ....
Correct Answer
C. Number
Explanation
The correct answer is "Number" because in Ms. Access, the "Number" data type is used to handle input in the form of numbers. This data type allows for mathematical calculations and operations to be performed on the inputted numbers.
11.
Kepanjangan dari ERD adalah ....
Correct Answer
B. Entity Relatiobship Diagram
Explanation
The correct answer is "Entity Relationship Diagram". An Entity Relationship Diagram (ERD) is a visual representation of the entities (objects) in a database and the relationships between them. It helps to illustrate the structure of a database system, showing how different entities are related to each other.
12.
Merupakan jaringan yang menggunakan susunan data yang disimpann dari system secara abstrak, definisi dari ....
Correct Answer
A. ERD
Explanation
ERD stands for Entity Relationship Diagram. It is a visual representation of the relationships between entities in a database. It helps in designing and understanding the structure of a database system. ERD uses symbols and lines to depict entities, attributes, and relationships between them. This diagram is used by database designers and developers to plan and organize the data storage and retrieval in a database.
13.
Sebuah obyek yang ada (exist) dan dapat dibedakan dengan obyek yang lain, definisi dari ....
Correct Answer
C. Entity
Explanation
The correct answer is "Entity". In the given question, the definition of an object that exists and can be distinguished from other objects aligns with the concept of an entity. In the context of databases and information systems, an entity refers to a distinct object or concept that can be represented and stored in a database. Entities have attributes and relationships with other entities, making them essential for organizing and managing data effectively.
14.
Yang termasuk entity bersifat konkrit adalah ....
Correct Answer
B. Guru
Explanation
The correct answer is "Guru." Guru is a concrete entity because it refers to a specific occupation or profession that involves teaching and guiding students. It can be observed and identified in the real world as individuals who work in schools or educational institutions. On the other hand, "Profesi," "Status," and "Mata Pelajaran" are more abstract concepts that do not refer to specific tangible objects or people.
15.
Yang termasuk entity bersifat abstrak adalah, kecuali ....
Correct Answer
C. Guru
Explanation
The given options include "Profesi," "Mata Pelajaran," "Guru," and "Status." These options are all related to abstract concepts. However, "Guru" is the odd one out because it refers to a specific occupation or profession, whereas the other options are more general and abstract in nature.
16.
Guru, siswa, dosen, karyawan dan dokter merupakan contoh entity yang bersifat ....
Correct Answer
A. Konkrit
Explanation
The given answer is "Konkrit" because the entities mentioned (guru, siswa, dosen, karyawan, dan dokter) are all concrete or tangible entities. They are all individuals or professions that can be physically observed or experienced in the real world. Therefore, "konkrit" is the appropriate description for these entities.
17.
Status, profesi, kejadian dan mata pelajaran merupakan contoh entity yang bersifat ....
Correct Answer
D. Abstrak
Explanation
The given answer "Abstrak" is correct because the entities mentioned (status, profession, event, and subject) are all abstract in nature. They cannot be physically touched or perceived through the senses. Instead, they represent concepts, ideas, or qualities that exist in the mind or as a result of human interpretation.
18.
Yang disebut calon kunci adalah ....
Correct Answer
B. Candidate Key
Explanation
The term "calon kunci" in Indonesian translates to "candidate key" in English. A candidate key is a set of attributes that can uniquely identify a tuple in a relation. It is a potential primary key for a table but may not be selected as the primary key. Therefore, the correct answer for this question is "Candidate Key."
19.
Entity yang tidak mempunyai kunci disebut ....
Correct Answer
A. Weak Entity
Explanation
A weak entity is an entity that does not have its own unique identifier or primary key. It depends on another entity, known as the owner entity, to provide a partial or complete identifier. In other words, a weak entity cannot be uniquely identified without the presence of its owner entity. This is different from a strong entity, which has its own unique identifier. Therefore, the correct answer is "Weak Entity."
20.
Hubungan yang terjadi antara satu entity dengan entity lainnya, definisi dari ....
Correct Answer
A. Relationship
Explanation
The correct answer is "Relationship." In the context of the given question, a relationship refers to the connection or association between one entity and another entity. It represents how entities are related or linked to each other in a database or system. Relationships define the interactions and dependencies between entities, allowing for the organization and structuring of data.