Latihan Soal Uts Kelas 8 - Soal1
Bahan Materi UTS SMT-2 Th. 2013-2014
Questions and Answers
- 1.
Perhitungan rumus pada Query di Access dilakukan dibagian ….
- A.
Table
- B.
Field
- C.
Show
- D.
Citeria
Correct Answer
B. FieldExplanation
The calculation of the formula in a query in Access is performed in the "Field" section.Rate this question:
-
- 2.
Membuat rumus, memilih data tertentu, dan mengurutkan data adalah beberapa kegiatan yang dilakukan di object
- A.
Query
- B.
Form
- C.
Table
- D.
Report
Correct Answer
A. QueryExplanation
The given statement mentions activities such as creating formulas, selecting specific data, and sorting data, which are commonly performed in a query. A query is a request for information from a database, where users can define specific criteria and conditions to retrieve and manipulate data. Therefore, the correct answer for this question is "Query."Rate this question:
-
- 3.
Data yang bertipe Currency dipilih untuk membuat field-field…
- A.
Alamat, Nama
- B.
Kode, Jumlah Item
- C.
Total Harga, Biaya
- D.
Tanggal Lahir
Correct Answer
C. Total Harga, BiayaExplanation
The correct answer is "Total Harga, Biaya". The reason for choosing the data type "Currency" for these fields is that they represent monetary values. The "Total Harga" and "Biaya" fields are likely to store the total cost or price of something, and using the "Currency" data type ensures that these values are formatted correctly and can be easily manipulated in calculations involving money.Rate this question:
-
- 4.
Perhatikan gambar dibawah ini !!!! Perhatikan tabel diatas ini, pernyataan yang benar untuk tabel diatas adalah…
- A.
Tabel terdiri dari 15 kolom
- B.
Tabel terdiri dari 8 record
- C.
Tabel terdiri dari 7 field
- D.
Tabel terdiri dari 8 kolom
Correct Answer
D. Tabel terdiri dari 8 kolomExplanation
The correct answer is "Tabel terdiri dari 8 kolom". This is because the table in the image has 8 columns, as indicated by the number of vertical divisions or headers in the table. The other options are incorrect as they either state a different number of columns or provide unrelated information.Rate this question:
-
- 5.
Field unik yang menjadi penghubung antar tabel ditandai sebagai….
- A.
Master Key
- B.
Ultimate Key
- C.
Submaster Key
- D.
Primary Key
Correct Answer
D. Primary KeyExplanation
The correct answer is "Primary Key". A primary key is a unique field in a table that is used to identify each record uniquely. It is a crucial component in database design as it ensures data integrity and allows for efficient data retrieval and manipulation. By marking a field as a primary key, it becomes the main identifier for the records in the table and serves as a link or reference between different tables in a database.Rate this question:
-
- 6.
Dalam Microsoft Access Tabel terdiri dari….
- A.
Kolom dan Baris
- B.
Field dan Row
- C.
Field dan Record
- D.
Column dan Record
Correct Answer
C. Field dan RecordExplanation
The correct answer is "Field dan Record". In Microsoft Access, a table consists of fields and records. Fields represent the columns in a table and contain specific data types, such as text, numbers, or dates. Records, on the other hand, represent the rows in a table and contain a set of related data values. Therefore, the combination of fields and records forms the structure and content of a table in Microsoft Access.Rate this question:
-
- 7.
Pengetikan Rumus dalam Microsoft Access diawali dengan..
- A.
:
- B.
/
- C.
=
- D.
,
Correct Answer
A. :Explanation
The correct answer is ":". In Microsoft Access, the typing of formulas or expressions is typically started with a colon (":") symbol. This symbol is used to indicate that the following text is a formula or expression that needs to be evaluated.Rate this question:
-
- 8.
Pada Query bagian untuk mengetikan syarat dalam memilih/menampilkan suatu data tertentu adalah....
- A.
Field
- B.
Show
- C.
Criteria
- D.
Sort
Correct Answer
C. CriteriaExplanation
The correct answer is "Criteria". In a query, the criteria are used to specify the conditions that the data must meet in order to be selected or displayed. The criteria help to filter and narrow down the data based on specific requirements or rules. By setting criteria, you can retrieve only the data that meets the specified conditions, making the query more focused and relevant to your needs.Rate this question:
-
- 9.
Icon RUN berguna untuk....
- A.
Membuat rumus
- B.
Memperbaiki Query
- C.
Menghapus Query
- D.
Menampilkan Tabel Query
Correct Answer
D. Menampilkan Tabel QueryExplanation
Icon RUN berguna untuk menampilkan tabel query. Ketika kita telah membuat sebuah query atau perintah dalam sistem basis data, kita dapat menggunakan icon RUN untuk menjalankan query tersebut. Setelah dijalankan, hasil query akan ditampilkan dalam bentuk tabel yang memuat data yang diinginkan sesuai dengan perintah yang telah kita buat. Dengan menggunakan icon RUN, kita dapat melihat hasil dari query kita dan memastikan bahwa query tersebut berfungsi dengan benar.Rate this question:
-
- 10.
Bagian Sort dalam Query berguna untuk...
- A.
Mengetik Rumus
- B.
Mengetik persyaratan data yang akan di show
- C.
Show/Hide Field
- D.
Mengurutkan data
Correct Answer
D. Mengurutkan dataExplanation
The Sort section in a query is used to arrange or organize data in a specific order. It allows the user to specify the criteria for sorting the data, such as ascending or descending order, based on one or multiple fields. This helps in presenting the data in a more structured and meaningful way, making it easier to analyze and understand.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 22, 2023Quiz Edited by
ProProfs Editorial Team -
Mar 18, 2014Quiz Created by
Alianto
Back to top