Basis Data (Kelas Xi)
Soal Remidial TTSG (Test Tengah Semester Gasal)Kompetensi Keahlian : Rekayasa Perangkat LunakGuru Mata Pelajaran : M. Ardiyansah, S.KomMata Pelajaran : Basis DataKelas : XI RPL
Questions and Answers
- 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 ....
- A.
Table
- B.
Record
- C.
Basis Data
- D.
Field
Correct Answer
C. Basis DataExplanation
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.Rate this question:
-
- 2.
Berikut ini merupakan keuntungan menggunakan basis data adalah, kecuali ....
- A.
Independensi program-data
- B.
Perawatan yang super ekstra
- C.
Meningkatkan kemampuan berbagai data
- D.
Meminimalkan redundansi data
Correct Answer
B. Perawatan yang super ekstraExplanation
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.Rate this question:
-
- 3.
Urutan atau hirarki basis data yang benar adalah ....
- A.
Database > Table > DBMS > Field & Record
- B.
DBMS > Table > Database > Field & Record
- C.
Database > Table > DBMS > Field & Record
- D.
DBMS > Database > Table > Field & Record
Correct Answer
D. DBMS > Database > Table > Field & RecordExplanation
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.Rate this question:
-
- 4.
Merupakan sebuah kumpulan nilai yang saling terkait, definisi dari ....
- A.
Record
- B.
Key
- C.
Field
- D.
Table
Correct Answer
A. RecordExplanation
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.Rate this question:
-
- 5.
Merupakan suatu field yang dapat dijadikan kunci dalam operasi tabel dalam konsep database, definisi dari ....
- A.
Field
- B.
Key
- C.
Database
- D.
Tabel
Correct Answer
B. KeyExplanation
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.Rate this question:
-
- 6.
Merupakan kumpulan data (nilai) yang diorganisasikan ke dalam baris (record) dan kolom (field), definisi dari ....
- A.
Table
- B.
Field
- C.
Record
- D.
Key
Correct Answer
A. TableExplanation
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.Rate this question:
-
- 7.
Merupakan kolom dari sebuah table, definisi dari ....
- A.
DBMS
- B.
Field
- C.
Database
- D.
Record
Correct Answer
B. FieldExplanation
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.Rate this question:
-
- 8.
Merupakan suatu bahasa (language) yang digunakan untuk mengakses database, definisi dari ....
- A.
Table
- B.
DBMS
- C.
SQL
- D.
PHP
Correct Answer
C. SQLExplanation
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.Rate this question:
-
- 9.
Jenis type data (Aplikasi Ms. Access) yang digunakan untuk menangani inputan berupa huruf dan angka maupun simbol-simbol yang lainya merupakan type data ....
- A.
Number
- B.
Autonumber
- C.
Date/Time
- D.
Text
Correct Answer
D. TextExplanation
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.Rate this question:
-
- 10.
Jenis type data (Aplikasi Ms. Access) yang digunakan untuk menangani inputan berupa angka merupakan type data ....
- A.
Text
- B.
Date/Time
- C.
Number
- D.
Currency
Correct Answer
C. NumberExplanation
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.Rate this question:
-
- 11.
Kepanjangan dari ERD adalah ....
- A.
Entity Relationship Model
- B.
Entity Relatiobship Diagram
- C.
Entity Relationship Key
- D.
Entitas Redudansi Diagram
Correct Answer
B. Entity Relatiobship DiagramExplanation
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.Rate this question:
-
- 12.
Merupakan jaringan yang menggunakan susunan data yang disimpann dari system secara abstrak, definisi dari ....
- A.
ERD
- B.
DFD
- C.
DBMS
- D.
Flowchart
Correct Answer
A. ERDExplanation
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.Rate this question:
-
- 13.
Sebuah obyek yang ada (exist) dan dapat dibedakan dengan obyek yang lain, definisi dari ....
- A.
Diagram
- B.
Database
- C.
Entity
- D.
Relationship
Correct Answer
C. EntityExplanation
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.Rate this question:
-
- 14.
Yang termasuk entity bersifat konkrit adalah ....
- A.
Profesi
- B.
Guru
- C.
Status
- D.
Mata Pelajaran
Correct Answer
B. GuruExplanation
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.Rate this question:
-
- 15.
Yang termasuk entity bersifat abstrak adalah, kecuali ....
- A.
Profesi
- B.
Mata Pelajaran
- C.
Guru
- D.
Status
Correct Answer
C. GuruExplanation
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.Rate this question:
-
- 16.
Guru, siswa, dosen, karyawan dan dokter merupakan contoh entity yang bersifat ....
- A.
Konkrit
- B.
Abstrak
- C.
Terpadu
- D.
Redudansi
Correct Answer
A. KonkritExplanation
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.Rate this question:
-
- 17.
Status, profesi, kejadian dan mata pelajaran merupakan contoh entity yang bersifat ....
- A.
Konkrit
- B.
Redudansi
- C.
Terpadu
- D.
Abstrak
Correct Answer
D. AbstrakExplanation
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.Rate this question:
-
- 18.
Yang disebut calon kunci adalah ....
- A.
Forigen Key
- B.
Candidate Key
- C.
Primary Key
- D.
Master Key
Correct Answer
B. Candidate KeyExplanation
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."Rate this question:
-
- 19.
Entity yang tidak mempunyai kunci disebut ....
- A.
Weak Entity
- B.
Null Entity
- C.
Zero Entity
- D.
Not Null
Correct Answer
A. Weak EntityExplanation
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."Rate this question:
-
- 20.
Hubungan yang terjadi antara satu entity dengan entity lainnya, definisi dari ....
- A.
Relationship
- B.
Primary Key
- C.
Entity
- D.
Kardinalitas
Correct Answer
A. RelationshipExplanation
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.Rate this question:
-
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 -
Nov 17, 2014Quiz Created by
Ardiyansah
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