DBMS | Latihan Pertemuan 5

Question 1

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Pada pemetaan diagram ER dimana untuk setiap entity type E pada diagram ER, dibuat satu relasi R yang mengandung semua ... dari E

Select one:

Simple atribut

Composite atribut

Primary key

Derived atribut

Foreign key

Feedback

Your answer is correct.

The correct answer is: Simple atribut

Question 2

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Pada pemetaan diagram ER dimana masukkan primary key dari relasi-relasi yang berpartisipasi pada relationship digunakan sebagai ... dari S

Select one:

Primary key

Foreign key

Composite atribut

Derived atribut

Simple atribut

Feedback

Your answer is correct.

The correct answer is: Foreign key

Question 3

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Dari gambar disamping, yang merupakan entity adalah

Select one:

Quantity

PART

PartNo & Quantity

PartNo

SUPPLY

Feedback

Your answer is correct.

The correct answer is: PART

Question 4

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Pada gambar di soal No 3, yang merupakan Relasi adalah

Select one:

PartNo

SUPPLY

PART

PartNo & Quantity

Quantity

Feedback

Your answer is correct.

The correct answer is: SUPPLY

Question 5

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Hasil Pemetaan Relasi dari gambar pada soal No 3, adalah

Select one:

PART ( Quantity, ...)

PART ( PartNo, ... )

SUPPLY ( Quantity, ...)

SUPPLY (PartNo, ... )

SUPPLY ( PartNo, Quantity, ...)

Feedback

Your answer is correct.

The correct answer is: SUPPLY ( PartNo, Quantity, ...)

Question 6

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Program aplikasi yang telah terisolasi dari perubahan dalam struktur data yang disimpan, disebut...

Select one:

Case Tools

Repositori

Independensi Data

Model Data

User Interface

Feedback

Your answer is correct.

The correct answer is: Independensi Data

Question 7

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Personilyang bertanggung-jawab merancang program aplikasi  beserta struktur datanya dalam database

Select one:

Administrator Data

Developer Sistem

End User

System Analyst

Programmer

Feedback

Your answer is correct.

The correct answer is: End User

Question 8

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Atribute yang memiliki lebih dari satu harga, biasanya punya batas bawah dan batas atas, disebut

Select one:

Composite

Single Valued

Derived

Simple

Multi valued

Feedback

Your answer is correct.

The correct answer is: Multi valued

Question 9

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Atribut yang dapat dibagi menjadi beberapa atribut dasar, disebut

Select one:

Composite

Derived

Single Valued

Multi valued

Simple

Feedback

Your answer is correct.

The correct answer is: Composite

Question 10

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Kardinalitas untuk gambar diatas yang sesuai adalah

Select one:

1 : M

1 : N

M : N

M : 1

1 : 1

Read More

DBMS | Latihan Pertemuan 4

Question 1

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Sebuah bentuk pernyataan data secara grafis dua dimensi yang terdiri dari sekumpulan kolom bernama dan sejumlah baris, disebut...

Select one:

Tabel

Tuple

Domain

Atribut

relation instance

Feedback

Your answer is correct.

The correct answer is: Tabel

Question 2

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Kumpulan nilai-nilai yang berlaku untuk sebuah kolom dari sebuah table, disebut

Select one:

relation instance

Atribut

Tabel

Tuple

domain

Feedback

Your answer is correct.

The correct answer is: domain

Question 3

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Nilai atribut pada tuple adalah sbb, kecuali

Select one:

Composite attribute dinyatakan dalam simple attribute

Boleh bernilai ganda

Harus atomic (bernilai tunggal)

Multivalued attribute harus direpresentasikan pada relasi lain

Null value bisa disebabkan karena tidak ada harga, atau tidak berguna

Feedback

Your answer is correct.

The correct answer is: Boleh bernilai ganda

Question 4

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Gaji karyawan biasa tidak boleh lebih besar dari gaji manajer. Merupakan contoh dari

Select one:

Semantic integrity const

Referential integrity

Integrity constrains

Key constrains

Entity integrity

Feedback

Your answer is correct.

The correct answer is: Semantic integrity const

Question 5

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Candidate key yang dipilih untuk mengidentifikasi tuple/baris pada suatu relasi, adalah

Select one:

Alternate key

Superkey

Primary key

Foreign key

Semua salah

Feedback

Your answer is correct.

The correct answer is: Primary key

Question 6

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Nama (First_Name, Last_Name), Alamat (Street, Number, City), merupakan contoh atribut

Select one:

Single-valued

Multi-valued

Simple

Atomic

Composite

Feedback

Your answer is correct.

The correct answer is: Composite

Question 7

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Menunjukan batasan keterlibatan suatu entitas dalam  suatu relationship

Select one:

Cardinality Ratio

Participation Constrains

Atribut Type

Relationship Constrains

Skema Type

Feedback

Your answer is correct.

The correct answer is: Participation Constrains

Question 8

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Baris-baris yang ada didalam sebuah tabel yang  menyatakan isi dari tabel tersebut, disebut

Select one:

Relation instance

Domain

Baris/Tuple

Tabel

Atribut

Feedback

Your answer is correct.

The correct answer is: Baris/Tuple

Question 9

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Kumpulan nilai-nilai yang berlaku untuk sebuah kolom dari sebuah tabel

Select one:

Atribut

Tabel

Relation instance

Baris/Tuple

Domain

Feedback

Your answer is correct.

The correct answer is: Domain

Question 10

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Merupakan kendala yang membatasi kemungkinan   kombinasi entitas yang terlibat dalam relationship     instance, disebut

Select one:

Relationship Constrains

Atribut Type

Cardinality Ratio

Skema Type

Participation Constrains

Read More

DBMS | Latihan Pertemuan 3

Question 1

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Merupakan kendala yang membatasi kemungkinan kombinasi entitas yang terlibat dalam relationship instance, disebut

Select one:

Cardinality ratio

Atribut type

Skema type

Participation constrains

Relationship constrains

Feedback

Your answer is correct.

The correct answer is:
Relationship constrains

Question 2

Correct

Mark 1.00 out of 1.00

Flag question

Question text

One to one (1:1), one to many (1:N), dan Many to many (M:N), merupakan jenis dari...

Select one:

Participation constrains

Cardinality ratio

Relationship constrains

Skema type

Atribut type

Feedback

Your answer is correct.

The correct answer is:
Cardinality ratio

Question 3

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Setiap entitas harus terlibat dalam suatu relationship, hal ini merupakan pengertian dari...

Select one:

Skema type

Participation constrains

Total participation

Cardinality ratio

Partial participation

Feedback

Your answer is correct.

The correct answer is:

Total participation

Question 4

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Dari gambar disamping, key atribut ditunjukkan oleh...

Select one:

Number

Semua benar

Locations

Name

Department

Feedback

Your answer is correct.

The correct answer is:
Name

Question 5

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Dari gambar diatas, atribut multivalued ditunjukkan oleh...

Select one:

Name

Locations

Number

Semua benar

Department

Feedback

Your answer is correct.

The correct answer is:
Name

Question 6

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Integrated Data Store pada awalnya di desain oleh

Select one:

Abraham Lincold

Steve Jobs

Charles Bachman

Charles Babage

Robert Einstein

Feedback

Your answer is correct.

The correct answer is:
Charles Bachman

Question 7

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Deskripsi tentang format dan karakteristik data, termasuk tipenya, ukurannya, nilai-nilai yang absah, dan dokumentasi lainnya, disebut...

Select one:

Informasi

Data

Metadata

DBMS

Database

Feedback

Your answer is correct.

The correct answer is: Metadata

Question 8

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Deskripsi data dalam istilah model data disebut

Select one:

Skema

Model Data

Informasi

Metadata

Data

Feedback

Your answer is correct.

The correct answer is: Skema

Question 9

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Sifat-sifat yang dimiliki oleh entity

Select one:

Value

Derived

Relationship

Attribute

Informasi

Feedback

Your answer is correct.

The correct answer is:
Attribute

Question 10

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Merupakan kendala yang membatasi kemungkinan kombinasi entitas yang terlibat dalam relationship instance, disebut...

Select one:

Participation Constrains

Relationship Constrains

Cardinality Ratio

Atribut Type

Skema Type

Read More

DBMS | Latihan Pertemuan 2

Question 1

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Kumpulan konsep yang digunakan untuk menjelaskan struktur basis data, disebut

Select one:

Model Data

Metadata

File

Data

Informasi

Feedback

Your answer is correct.

The correct answer is: Model Data

Question 2

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Relational, Hierarchy, dan Network Data Model, termasuk dalam contoh 

Select one:

Object-oriented

Object-based logical struct

Record-based logical struct

Functional Data Model

Semantic

Feedback

Your answer is correct.

The correct answer is: Record-based logical struct

Question 3

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Objek riil yang dapat dibedakan satu sama lain, dalam Model ER, disebut

Select one:

Atribut

Instance

Relationship

Entity

Schema

Feedback

Your answer is correct.

The correct answer is: Entity

Question 4

Correct

Mark 1.00 out of 1.00

Flag question

Question text

EMPLOYEE(Name, Age, Salary)COMPANY(Name, Headquarter, President) Dari skema diatas yang termasuk instance adalah

Select one:

EMPLOYEE

COMPANY

EMPLOYEE Name

Name

EMPLOYEE dan COMPANY

Feedback

Your answer is correct.

The correct answer is: EMPLOYEE dan COMPANY

Question 5

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Nama (First_Name, Last_Name), Alamat (Street, Number, City), merupakan contoh atribut

Select one:

Composite

Simple

Single-valued

Atomic

Multi-valued

Feedback

Your answer is correct.

The correct answer is: Composite

Question 6

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Menunjukan batasan keterlibatan suatu entitas dalam  suatu relationship

Select one:

Participation Constrains

Skema Type

Relationship Constrains

Atribut Type

Cardinality Ratio

Feedback

Your answer is correct.

The correct answer is: Participation Constrains

Question 7

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Baris-baris yang ada didalam sebuah tabel yang menyatakan isi dari tabel tersebut, disebut

Select one:

Domain

Atribut

Baris/Tuple

Tabel

Relation instance

Feedback

Your answer is correct.

The correct answer is: Baris/Tuple

Question 8

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Kumpulan nilai-nilai yang berlaku untuk sebuah kolom dari sebuah tabel

Select one:

Baris/Tuple

Relation instance

Tabel

Atribut

Domain

Feedback

Your answer is correct.

The correct answer is: Domain

Question 9

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Dari gambar dibawah ini, yang merupakanentity adalah

Select one:

PartNo & Quantity

PART

PartNo

SUPPLY

Quantity

Feedback

Your answer is correct.

The correct answer is: PART

Question 10

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Dari gambar dibawah, yang merupakan Relasi adalah

Select one:

PartNo

Quantity

SUPPLY

PART

PartNo & Quantity

Read More