DotNet Chapter 7

ADO.NET is mainly used to ______ between a .NET application and a database. / ADO.NET digunakan untuk ______ antara aplikasi .NET dan pangkalan data.

• decorate UI
• act as a bridge (jambatan)
• compile C# code
• create HTML only

Answer explanation

ADO.NET acts as a bridge between your application and data sources like SQL Server.

Which namespace is commonly used for SQL Server database access in ADO.NET? / Namespace biasa untuk akses SQL Server ialah…

• System.Net
• System.Data / Microsoft.Data.SqlClient
• System.IO
• System.Threading

Answer explanation

ADO.NET SQL Server access typically uses System.Data.SqlClient or Microsoft.Data.SqlClient.

Which ADO.NET component opens and manages the database connection? / Komponen yang buka & urus sambungan DB ialah…

• Command
• Connection
• DataReader
• DataSet

Answer explanation

Connection (e.g., SqlConnection) creates and manages the link to the database.

Which component executes SQL statements or stored procedures? / Komponen yang jalankan SQL ialah…

• SqlCommand (Command)
• SqlDataReader
• DataView
• DataColumn

Answer explanation

Command (SqlCommand) runs SQL queries or stored procedures.

SqlDataReader is best described as… / SqlDataReader paling tepat ialah…

• offline editable table
• fast forward-only, read-only stream
• tool to design UI
• stores multiple tables + relations

Answer explanation

DataReader reads data quickly, forward-only, read-only, and needs an open connection.

Which component is the “bridge” between a DataSet and the database (disconnected model)? / Komponen ‘jambatan’ DataSet↔DB ialah…

• DataAdapter
• DataTable
• DataView
• ValidationSummary

Answer explanation

DataAdapter fills a DataSet and can update changes back to the database.

Which object can hold multiple DataTables and relationships in memory? / Objek yang boleh simpan banyak jadual dalam memori ialah…

• DataSet
• SqlCommand
• SqlTransaction
• SqlParameter

Answer explanation

A DataSet is an in-memory cache that can store multiple DataTables and relations.

DataTable represents… / DataTable mewakili…

• an entire database server
• one table of rows & columns
• a SQL query text
• a login session

Answer explanation

A DataTable is a single table inside a DataSet with rows and columns.

DataView is used mainly to… / DataView digunakan untuk…

• open a connection
• sort/filter/search data without changing the DataTable
• execute INSERT
• encrypt connection strings

Answer explanation

DataView provides a customizable view of a DataTable (sorting/filtering).

Connected architecture usually uses ______ for reading data. / Seni bina connected biasanya guna ______ untuk baca data.

• DataSet
• SqlDataReader
• DataView
• Validation controls

Answer explanation

Connected model reads directly from DB using SqlDataReader while connection stays open.