Which of the following statements related to the limitations of ASP.NET is True? a.ASP.NET Web Form suffered from many issues, especially when building larger applications b.Auto-generated HTML does not provide full control to the developers c.ASP.NET lack of testability, a complex stateful model, ...
Which of the following statements related to the limitations of ASP.NET is True?
a.ASP.NET Web Form suffered from many issues, especially when building larger
applications
b.Auto-generated HTML does not provide full control to the developers
c.ASP.NET lack of testability, a complex stateful model, and limited influence over the
generated HTML led developers to evaluate other options
d.All of the others - CORRECT ANSWERS-D
Which of the following provides temporary storage for a stream of bytes that may be
committed to storage at a later time?
a.BinaryReader
b.FileReader
c.BufferedReader
d.BufferedStream - CORRECT ANSWERS-D
Which of the following is one of the features of ASP.NET Core?
a.Streamlined Web development
b.All of the others
c.A system that is set to work on cloud
d.Good community base - CORRECT ANSWERS-B
Which of the following is one of the process models for Entity Framework Core?
a.None of the others
b.Databases engineering
c.Reverse engineering of existing databases
d.Forward of existing databases - CORRECT ANSWERS-C
What is the data representation in ADO.NET's memory?
a.Datatable
b.Database
c.Recordset
d.Dataset - CORRECT ANSWERS-D
Which of the following commands in EF Core global tool can be used to create object
models from an existing database schema?
a.Dotnet scaffold
b.DbContext scaffold
c.Database scaffold
d.Migrations scaffold - CORRECT ANSWERS-B
1|Page
,Which of the following properties were provided by the ControllerBase Class?
a.Routing
b.NotFound
c.HttpContext
d.NoContent - CORRECT ANSWERS-C
1.For the database named SaleDB has a table named Items ( ItemID int PRIMARY
KEY, ItemName varchar(50) , Price int )
Three records had been inserted in Items table are :
{1, N'Cake', 5} , {2, N'Milk', 10}, {3, N'Coffee', 15}
In this database included a store procedure is :
CREATE PROC spGetPriceByItemID( @ID int, @UnitPrice int output)
as
select @UnitPrice = Price from Items
where ItemID = @ID
2.For the program as the following :
using System.Data;
using Microsoft.Data.SqlClient;
class Program {
static void Main(string[] args){
int s = 0;
string strConnection =
@"server =(local);database=SaleDB;uid=sa;pwd=123";
string SQL = "spGetPriceByItemID";
SqlConnection cnn = new SqlConnection(strConnection);
SqlCommand cmd = new SqlCommand(SQL, cnn);
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = 3;
cmd.Parameters.Add("@UnitPrice", SqlDbType.Int);
cmd.Parameters["@UnitPrice"].Direction =
ParameterDirection.Output;
cmd.Comm - CORRECT ANSWERS-A
Which of the following allows to store primitive data types (Integers, Booleans,
Strings,..) as a binary value?
a.FileReader
b.BinaryReader
c.BinaryWriter
d.FileWriter - CORRECT ANSWERS-C
Which of the following methods of the SqlCommand object is used to add a new record
into the SQL Server database?
a.ExecuteQuery
b.ExecuteUpdate
c.ExecuteNonQuery
2|Page
, d.UpdateNonQuery - CORRECT ANSWERS-C
Which of the following statements related to ASP.NET Web API is True?
a.ASP.NET Web API is based on the MVVM(Mode View-View Model) framework with
optimizations for creating headless services
b.None of the others
c.Calls to a Web API service are based on the core HTTP Verbs (Read, Update, Add
and Remove) through a URI (Uniform Resource Identifier)
d.ASP.NET Web API from the beginning was designed to be a service-based
framework for building RESTful services - CORRECT ANSWERS-D
Which event should be used to detect whenever the text in a TextBox or RichTextBox
changes?
a.Click
b.KeyDown
c.KeyUp
d.TextChanged - CORRECT ANSWERS-D
Which of the following statements related to routing in ASP.NET Core is True?
a.The Routing is the process by which ASP.NET Core inspects the incoming URLs and
maps them to Controller Actions
b.The main responsibility of Routing: generate outgoing URLs that correspond to the
view model
c.None of the others
d.The Routing is the process of URLs handled by the middleware server - CORRECT
ANSWERS-A
Which of the following is one of the new features of Entity Framework Core?
a.Entity Framework Core have slowly execution speeds and especially when reading
data exceed 1.000 records
b.None of the others
c.On mobile devices, EF Core supports only access to the local database such as SQL
Server Database
d.Entity Framework Core runs not only on Windows, Linux, and macOS but also on
mobile devices running Windows 10, iOS, and Android - CORRECT ANSWERS-D
Which of the following statements related to Object-Relational Mapper is True?
a.Working with objects as instances of classes in memory is at the core of object-
oriented programming (OOP)
b.To make the handling of relational databases more natural in object-oriented systems,
the software industry has been relying on object-relational mappers
c.In the database world, relational databases are prevalent and the programming world
is all about objects
d.All of the others - CORRECT ANSWERS-D
3|Page
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller belaccarpsey. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $19.99. You're not tied to anything after your purchase.
