PRN1409/ PRN 1409 WITH ANSWERS (A+)

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