81-120 Flashcards
struct ImageInfo { public byte[] Data; public int Lenght; public Guid Id; }
void Post() { var uploaded = PostedImage(); var newImage = new ImageInfo(); newImage.Data = uploaded; newImage.Lenght = uploaded.Lenght; newImage.Id = Guid.NewGuid(); }
The bytes that comprise the image are stored on thee stack: Y/N
The length of the image data is stored on the heap: Y/N
The Id of the image is stored on the stack: Y/N
It is No, No, Yes
Bytes[] is not a known size, so is NOT stored on the stack
Length is an int, which is a known size, so is NOT stored on the heap
Id is a Guid, which is a known size, which IS stored on the stack
The following functions are defined:
private static int Printer(int j) { for (var i = j; i > 0; i = Printer(i - 1) { Console.Write(i); } return j; }
What does the console display after the following line?
Printer(2);
A. 210
B. 211
C. 2101
D. 2121
211
The throw keyword is used to perform which two actions? (Choose two.)
A. stop processing of the code
B. move error handling to a separate thread
C. raise exceptions
D. re-throw exceptions as a different type
raise exceptions
re-throw exceptions as a different type
Which three phrases are advantages of connection pooling? (Choose three.) A. reduces time to create a connection B. requires no configuration C. reduces load on the server D. improved scalability E. improved performance
reduces time to create a connection
improved scalability
improved performance
You are creating a database for a student directory. The Students table contains the following fields:
firstName
lastName
emailAddress
telephoneNumber
Which statement will retrieve only the first name, last name, and telephone number for every student listed in the directory?
A. WHERE Students SELECT *
B. SELECT firstName, lastName, telephoneNumber FROM Students
C. SELECT firstName, lastName, telephoneNumber IN Students
D. SELECT * FROM Students
E. WHERE Students SELECT firstName, lastName, telephoneNumber
SELECT firstName, lastName, telephoneNumber FROM Students
An entity relationship diagram (ERD) is designed for an object-oriented database : Y/N
An entity relationship diagram (ERD) contains entities, relationships, and attributes: Y/N
Cardinality refers to how one table is linked to another table; as one-to-many: Y/N
No
Yes
Yes
This question requires that you evaluate the underlined text to determine if it is correct.
The benefit of using a transaction when updating multiple tables is that the update cannot fail.
Select the correct answer if the underlined text does not make the statement correct. Select “No change is needed” if the underlined text makes the statement correct.
A. No change is needed
B. succeeds or fails as a unit
C. finishes as quickly as possible
D. can be completed concurrently with other transactions
succeeds or fails as a unit
What are two advantages of normalization in a database? (Choose two) A. prevents data inconsistencies B. reduces schema limitations C. minimizes impact of data corruption D. decreases space used on disk
prevents data inconsistencies
decreases space used on disk
A queue’s items are stored in the order they were added: Y/N
A queue is a first in, first out (FIFO) data struct: Y/N
A queue has a limited number of items: Y/N
Yes
Yes
No
This question requires that you evaluate the underlined text to determine if it is correct.
Unit testing is the final set of tests that must be completed before a feature or product can be considered finished.
Select the correct answer if the underlined text does not make the statement correct. Select “No change is needed’’ if the underlined text makes the statement correct.
A. No change is needed
B. User acceptance
C. System
D. Integration
User acceptance
User acceptance testing (UAT) is the last phase of the software testing process. During UAT, actual software users test the software to make sure it can handle required tasks in real-world scenarios, according to specifications.
UAT is one of the final and critical software project procedures that must occur before newly developed software is rolled out to the market.
UAT is also known as beta testing, application testing or end user testing.
You need to create a stored procedure that passes in a person’s name and age.
Which statement should you use to create the stored procedure?
A. CREATE PROCEDURE StoreData (@UserName, @Age) B. CREATE PROCEDURE StoreData @UserName nvarchar(255), @Age int C. CREATE PROCEDURE StoreData @UserName char, @Age double D. UPDATE PROCEDURE StoreData @UserName nvarchar(255), @Age int
B
You have a SQL Server database named MyDB that uses SQL Server Authentication.
Which connection string should you use to connect to MyDB?
A. Data Source=MyDB; UserID=username; Password=P@sswOrd; Initial Catalog=Sales
B. Data Source=MyDB; Integrated Security=SSPI; Initial Catalog=Sales
C. Data Source=MyDB; Integrated Security=True; Initial Catalog=Sales
D. Data Source=MyDB; Trusted_Connection=True; MultipleActiveResultSets=True; Initial Catalog=Sales
Data Source=MyDB; UserID=username; Password=P@sswOrd; Initial Catalog=Sales
You are developing a database that other programmers will query to display race results.
You need to provide the ability to query race results without allowing access to other information in the database.
What should you do?
A. Disable implicit transactions.
B. Place the query into a stored procedure.
C. Create an index on the result table.
D. Add an AFTER UPDATE trigger on the result table to reject updates.
Place the query into a stored procedure.
This question requires that you evaluate the underlined text to determine if it is correct.
A piece of text that is 4096 bytes or smaller and is stored on and retrieved from the client computer to maintain state is known as a ViewState.
Select the correct answer if the underlined text does not make the statement correct. Select “No change is needed’’ if the underlined text makes the statement correct.
A. No change is needed
B. cookie
C. form post
D. QueryString
cookie
This question requires that you evaluate the underlined text to determine if it is correct.
Internet Information Services (IIS) must be installed on the client computers in order to run a deployed ASP.NET application.
Select the correct answer if the underlined text does not make the statement correct. Select “No change is needed” if the underlined text makes the statement correct.
A. No change is needed
B. computer that hosts the application
C. computer that you plan to deploy from
D. Application Layer Gateway Service
computer that hosts the application