Quiz - Database Technology - Session 9 (Odd Semester 2023/2024)

Kode Kelas Database Technology Anda​?

LA03 / LF01 / LH01 / LJ01

Masukkan NIM Anda

Masukkan Nama Lengkap Anda

What is the purpose of physical database design?

• To capture information and define tables, columns, and views

• To create a conceptual schema

• To optimize the performance of queries and updates

• To select the appropriate indexes

Which schema is tightly linked to query optimization?

• Conceptual schema

• Logical schema

• Physical schema

• External schema

What is the first step in understanding the workload?

• Identifying the most important queries and updates

• Determining the desired performance for queries and updates

• Analyzing the attributes involved in selection/join conditions

• Estimating the frequency of queries and updates

Which attributes are candidates for index search keys?

• Attributes involved in selection/join conditions

• Attributes mentioned in the SELECT clause

• Attributes involved in aggregation functions

• Attributes mentioned in the FROM clause

What is the recommended approach to minimize the use of DISTINCT?

• Use UNION instead

• Use HAVING instead

• Use WHERE instead

• Use GROUP BY instead

What is the purpose of relational algebra?

• To explain the concepts of DDL and DML

• To manage data and information in databases

• To manipulate data in databases

• To apply database applications

Which operator is used to select specific tuples from a relation?

• Project

• Select

• Union

• Cartesian Product