Infosys Certified Backend Layers Developer

Assume that the below table Course got created successfully.

CREATE TABLE Course
(
	CourseId INT PRIMARY KEY IDENTITY(100,1),
	CourseName VARCHAR(100) UNIQUE NOT NULL
)

Which of the following option helps to get the below mentioned output?

What would be the output when the following SQL scripts gets executed?

CREATE TABLE Roles
(
	RoleId INT PRIMARY KEY IDENTITY(1000,2),
	RoleName VARCHAR(50) UNIQUE NOT NULL
)
GO

INSERT INTO Roles VALUES ('Admin')
GO

SET IDENTITY_INSERT Roles ON
INSERT INTO Roles(RoleId,RoleName) VALUES (1100,'HR')
SET IDENTITY_INSERT Roles OFF

DELETE FROM Roles
SELECT @@IDENTITY
GO

Consider the below SQL statements

CREATE TABLE Dancer
(
	DancerId INT PRIMARY KEY IDENTITY(1,2),
	Name VARCHAR(100)
)

INSERT INTO Dancer VALUES ('Priya')
INSERT INTO Dancer VALUES ('Riya')

SET IDENTITY_INSERT Dancer ON
DELETE FROM Dancer WHERE DancerId = 2
INSERT INTO Dancer VALUES ('Linza')
SET IDENTITY_INSERT Dancer OFF

INSERT INTO Dancer VALUES ('Shreya')

What will be the value of identity for the last inserted row?

Consider the following procedure

CREATE PROCEDURE Test
(
	@Id INT OUTPUT, 
	@Name VARCHAR(10)
) 
AS 
BEGIN 
	SET @Id=10 
	SET @Name='James' 
END 

What will be the output after executing the following statements?

DECLARE @Name VARCHAR(10)='Tom' 
DECLARE @Id INT 
EXEC Test @Id OUTPUT, @Name 
SELECT @Id, @Name

What would be the output of the following batch?

BEGIN
	DECLARE @Num1 INT,@Result INT
	SET @Num1=10
	BEGIN TRY
		SET @Result=@Num1/0
		SELECT @Result
	END TRY
	BEGIN CATCH
		PRINT 'Num1 cannot be divided by zero'
	END CATCH
END

BEGIN 
	BEGIN TRY 
		SELECT 1/0 
	END TRY 
	BEGIN CATCH 
		PRINT 'Some Error Occurred' 
	END CATCH 
	IF @@ERROR <> 0 
	PRINT 'Divide by Zero Exception Occurred' 
END

Predict the output of the code given above.

Along with a simple read operation, what other operation/s can be performed on entities while querying data using LINQ?

Choose the correct syntax from the given options, that will delete multiple rows of a table, which contains the provided substring as part of the bookType.

For the following code,

SqlParameter prmStudentName = new SqlParameter("@StudentName", studentName);

SqlParameter prmReturnResult = new SqlParameter("@ReturnResult", System.Data.SqlDbType.Int);
prmReturnResult.Direction = System.Data.ParameterDirection.Output;

result = context.Database
.ExecuteSqlRaw("EXEC @ReturnResult = usp_ AddStudentDetails @ StudentName”, prmReturnResult, prmStudentName);
returnResult = Convert.ToInt32(prmReturnResult.Value);

what is the value of the variable result when NO rows are affected in the database? Assume that the procedure usp_AddStudentDetails contains one update and one insert statement and the procedure returns 1, only if they are executed successfully.

Alex has following Entity Classes in the DAL for the tables Transaction and User for his UPITransaction application. He wants to fetch all the transaction details depending on the UserName.

Choose from the given options that help him achieve the requirement.

public partial class Transaction
{
	public string TransactionId { get; set; }
	public string TransactionType { get; set; }
	public string TransactionDate { get; set; }
	public string UserId { get; set; }
	public string TransactionStatus { get; set; }
	public User User { get; set; }
}
public partial class User
{
	public string UserId { get; set; }
	public string UserName { get; set; }
	public string Password { get; set; }
	public string MobileNumber { get; set; }
	public ICollection<Transaction> Transactions { get; set; }
}

Assumptions:

a.Transactions and Users are the DbSet properties in the UPITransactionDBContext

b.Context is an object of the class UPITransactionDBContext

Choose TWO correct options.