What is the primary data access technology used for relational databases in ASP.NET?
a. ADO.NET
b. Entity Framework
c. Dapper
d. NHibernate
Answer: a. ADO.NET
Which class in ADO.NET provides a way to execute SQL queries and commands against a SQL Server database?
a.
SqlCommand
b.
SqlConnection
c.
SqlDataAdapter
d.
SqlDataReader
Answer: a.
SqlCommand
Which ADO.NET class is used to establish a connection to a SQL Server database?
a.
SqlConnection
b.
SqlCommand
c.
SqlDataAdapter
d.
SqlDataReader
Answer: a.
SqlConnection
What is the purpose of the
SqlDataAdapter class in ADO.NET?
a. To fill a
DataSet or
DataTable with data from a database
b. To execute SQL commands against a database
c. To open and manage database connections
d. To read data from a database
Answer: a. To fill a
DataSet or
DataTable with data from a database
Which method of the
SqlCommand class is used to execute a query that returns a single value?
a.
ExecuteScalar()
b.
ExecuteNonQuery()
c.
ExecuteReader()
d.
ExecuteXmlReader()
Answer: a.
ExecuteScalar()
What is the purpose of the
DataSet class in ADO.NET?
a. To hold data in memory in a tabular format
b. To execute SQL commands against a database
c. To manage database connections
d. To perform transactions
Answer: a. To hold data in memory in a tabular format
Which ADO.NET class is used to read data from a database in a forward-only, read-only manner?
a.
SqlDataReader
b.
SqlDataAdapter
c.
SqlConnection
d.
SqlCommand
Answer: a.
SqlDataReader
What is the primary purpose of the
Entity Framework (EF) in ASP.NET?
a. To provide an Object-Relational Mapping (ORM) framework
b. To execute raw SQL queries
c. To manage database connections
d. To fill
DataSets and
DataTables
Answer: a. To provide an Object-Relational Mapping (ORM) framework
Which method of the
Entity Framework is used to save changes to the database?
a.
SaveChanges()
b.
SubmitChanges()
c.
UpdateDatabase()
d.
Commit()
Answer: a.
SaveChanges()
What is a
DbContext in Entity Framework?
a. A class that manages database connections and transactions
b. A class that represents a session with the database
c. A class that maps SQL queries to C# objects
d. A class that represents a database schema
Answer: b. A class that represents a session with the database
How can you define a one-to-many relationship in Entity Framework?
a. By using navigation properties
b. By using
ForeignKey attributes
c. By configuring relationships in
OnModelCreating
d. By defining
DbSet properties
Answer: a. By using navigation properties
Which class in Entity Framework represents a collection of entities in the context?
a.
DbSet<T>
b.
DbContext
c.
EntitySet
d.
EntityCollection
Answer: a.
DbSet<T>
What is the purpose of
DataAnnotations in Entity Framework?
a. To provide metadata for model properties
b. To configure database connections
c. To execute SQL queries
d. To manage transactions
Answer: a. To provide metadata for model properties
Which attribute is used to specify a primary key in an Entity Framework model?
a.
[Key]
b.
[PrimaryKey]
c.
[Identity]
d.
[DatabaseGenerated]
Answer: a.
[Key]
How can you perform raw SQL queries in Entity Framework?
a. By using the
Database.SqlQuery<T> method
b. By using the
DbContext.ExecuteSqlCommand method
c. By using the
DbSet.SqlQuery method
d. By using the
SqlCommand class directly
Answer: a. By using the
Database.SqlQuery<T> method
What is the role of
LINQ in data access with Entity Framework?
a. To query and manipulate data in a strongly-typed manner
b. To execute raw SQL commands
c. To manage database connections
d. To handle transactions
Answer: a. To query and manipulate data in a strongly-typed manner
Which Entity Framework approach allows for database schema updates based on model changes?
a. Code First Migrations
b. Database First Approach
c. Model First Approach
d. Code First Approach
Answer: a. Code First Migrations
What is the purpose of the
Repository pattern in data access?
a. To abstract data access logic and provide a cleaner interface
b. To directly execute SQL commands
c. To manage database connections
d. To handle transactions
Answer: a. To abstract data access logic and provide a cleaner interface
How do you handle concurrency issues with Entity Framework?
a. By using
ConcurrencyCheck or
RowVersion attributes
b. By locking database tables
c. By using transactions
d. By retrying operations manually
Answer: a. By using
ConcurrencyCheck or
RowVersion attributes
Which method is used to update or insert a record in Entity Framework?
a.
AddOrUpdate()
b.
SaveChanges()
c.
ExecuteNonQuery()
d.
UpdateDatabase()
Answer: b.
SaveChanges()
What is
Dapper in the context of ASP.NET data access?
a. A micro ORM that provides fast and simple data access
b. A full-featured ORM with code-first support
c. A library for managing database connections
d. A tool for generating SQL queries
Answer: a. A micro ORM that provides fast and simple data access
Which method in
Dapper is used to execute a SQL command and return the number of affected rows?
a.
Execute()
b.
Query()
c.
QuerySingle()
d.
ExecuteScalar()
Answer: a.
Execute()
What is the purpose of the
TransactionScope class in ADO.NET?
a. To manage transactions across multiple database operations
b. To execute SQL commands in a batch
c. To manage database connections
d. To handle concurrency issues
Answer: a. To manage transactions across multiple database operations
Which method of
SqlCommand is used to execute a SQL query and return a
DataReader?
a.
ExecuteReader()
b.
ExecuteNonQuery()
c.
ExecuteScalar()
d.
ExecuteXmlReader()
Answer: a.
ExecuteReader()
What is the primary difference between
Entity Framework and
Dapper?
a. Entity Framework is a full ORM, while Dapper is a micro ORM
b. Dapper supports multiple databases, while Entity Framework supports only SQL Server
c. Entity Framework is faster than Dapper
d. Dapper supports LINQ queries, while Entity Framework does not
Answer: a. Entity Framework is a full ORM, while Dapper is a micro ORM
Which class in ADO.NET is used to populate a
DataTable or
DataSet with data from a database?
a.
SqlDataAdapter
b.
SqlCommand
c.
SqlConnection
d.
SqlDataReader
Answer: a.
SqlDataAdapter
How can you configure Entity Framework to use a SQL Server database?
a. By specifying the connection string in
DbContext
b. By configuring settings in
web.config
c. By using
OnConfiguring method in
DbContext
d. By adding a
ConnectionString attribute to the model
Answer: c. By using
OnConfiguring method in
DbContext
What is
Lazy Loading in the context of Entity Framework?
a. Automatically loading related data when it is accessed for the first time
b. Loading all related data in one query
c. Manually loading related data on demand
d. Using eager loading to improve performance
Answer: a. Automatically loading related data when it is accessed for the first time
Which method of
DataTable allows you to filter rows based on a condition?
a.
Select()
b.
Find()
c.
Filter()
d.
Search()
Answer: a.
Select()
How do you map a SQL Server table to a C# class in Entity Framework?
a. By defining a class with properties that match the table columns
b. By using SQL Server Management Studio (SSMS)
c. By configuring the table schema in
web.config
d. By executing a SQL query to create the class
Answer: a. By defining a class with properties that match the table columns
What is the purpose of the
Include() method in Entity Framework?
a. To eagerly load related entities
b. To exclude properties from serialization
c. To specify SQL query parameters
d. To limit the columns returned in a query
Answer: a. To eagerly load related entities
Which method of
DataSet is used to accept changes made to the data?
a.
AcceptChanges()
b.
Update()
c.
SaveChanges()
d.
Commit()
Answer: a.
AcceptChanges()
What is the function of
Stored Procedures in data access?
a. To encapsulate SQL logic and improve performance
b. To manage database connections
c. To handle transactions
d. To automatically generate database schemas
Answer: a. To encapsulate SQL logic and improve performance
Which Entity Framework method is used to create a new database based on the model?
a.
Database.EnsureCreated()
b.
Database.Create()
c.
Database.Initialize()
d.
Database.Generate()
Answer: a.
Database.EnsureCreated()
How can you handle database schema changes with Entity Framework Code First?
a. By using Code First Migrations
b. By manually updating the database schema
c. By re-creating the database
d. By configuring schema changes in
web.config
Answer: a. By using Code First Migrations
What is
Eager Loading in Entity Framework?
a. Loading all related entities in a single query
b. Loading related entities on demand
c. Loading related entities when accessed for the first time
d. Using lazy loading for performance
Answer: a. Loading all related entities in a single query
Which class in ADO.NET provides a way to interact with an XML database?
a.
XmlDataDocument
b.
XmlReader
c.
XmlWriter
d.
XmlSchema
Answer: a.
XmlDataDocument
What does the
DbSet<T> class represent in Entity Framework?
a. A collection of entities of type
T
b. A single entity of type
T
c. A database connection for type
T
d. A query result of type
T
Answer: a. A collection of entities of type
T
Which method is used to execute a SQL command and return a single row of data in Entity Framework?
a.
FirstOrDefault()
b.
Single()
c.
SingleOrDefault()
d.
First()
Answer: c.
SingleOrDefault()
What is the purpose of
Database First approach in Entity Framework?
a. To generate model classes based on an existing database
b. To create a new database based on model classes
c. To configure database connections
d. To manage transactions
Answer: a. To generate model classes based on an existing database
How do you configure the connection string for Entity Framework in ASP.NET Core?
a. By using
IConfiguration in
Startup.cs
b. By setting it in
web.config
c. By defining it in
appsettings.json
d. By specifying it in
DbContext
Answer: a. By using
IConfiguration in
Startup.cs
Which method in
SqlCommand is used to execute a command and return the results as a list of objects?
a.
ExecuteReader()
b.
ExecuteScalar()
c.
ExecuteXmlReader()
d.
ExecuteNonQuery()
Answer: a.
ExecuteReader()
What does
AsNoTracking() do in Entity Framework?
a. Disables change tracking for read-only queries
b. Enables change tracking for updated entities
c. Tracks changes for entities in a query
d. Prevents entities from being read
Answer: a. Disables change tracking for read-only queries
Which class in Entity Framework is used to configure the entity mappings and relationships?
a.
ModelBuilder
b.
DbSet
c.
DbContext
d.
EntityTypeConfiguration
Answer: a.
ModelBuilder
What is the purpose of
Projection in LINQ queries?
a. To shape the data into a specific format or type
b. To filter data based on criteria
c. To group data into collections
d. To sort data based on properties
Answer: a. To shape the data into a specific format or type
