LESSON

Lesson 1: Understanding Core Database Concepts

Multiple Choice

1. What kind of filename extension do Microsoft SQL Server transaction log files have?

a) .mdf

b) .ldf

c) .ndf

d) .log

Answer: b

Difficulty: Easy

Section Reference: Understanding Database Concepts

Explanation: Microsoft SQL Server transaction log files use an .ldf extension and don’t contain any objects such as tables or views. Transaction log files can be used to perform a point-in-time restore or rollback.

SOAL1

https://drive.google.com/file/d/19dxoMQwWdvK9MuQp4vhYDjeKuLBWtqvY/view?usp=sharing

https://drive.google.com/file/d/19dxoMQwWdvK9MuQp4vhYDjeKuLBWtqvY/view?usp=sharing

https://drive.google.com/file/d/19dxoMQwWdvK9MuQp4vhYDjeKuLBWtqvY/view?usp=sharing

https://drive.google.com/file/d/1qPF5CcwfJqjL4qYmoO9JamwQthg6XWSl/view?usp=sharing


LESSON
https://drive.google.com/file/d/1MAROqwOMJiB605U0NiEOPCJOlxsHdtBw/view?usp=sharing
https://drive.google.com/file/d/1M5G_8S0y4z_caoOjTuavBrCx0Nhc9QL7/view?usp=sharing
https://drive.google.com/file/d/1C0t2ta71iMsnEu_VY4vNpUC0xyKyM7v0/view?usp=sharing
https://drive.google.com/file/d/1s_OOH7i2wfzU99dKM3CuEdwv2qCT2mrZ/view?usp=sharing
https://drive.google.com/file/d/1ERoTzqTTNSGSY_SvPlmC1isfPcYdChG2/view?usp=sharing

DFA

·         What is a simple database that uses two-dimensional tables consisting of rows and columns?

Apa itu basis data sederhana yang menggunakan tabel dua dimensi yang terdiri atas baris dan kolom?

Flat type database.

·         First normal form requires that a database exclude :

Bentuk normal pertama mengharuskan database tidak termasuk:

Repeating Groups

·    What clause would you use with the SELECT command that would pull records based on a range?

Apa klausa yang akan Anda gunakan dengan perintah SELECT yang akan menarik catatan berdasarkan rentang?

BETWEEN