Download Certiport Software Development #1-4 and more Exams Computer Science in PDF only on Docsity!
Certiport Software Development #1-
The server limits data connections. What should you use for connectivity when the number of users exceeds the number of connections? A.) Named Pipes B.) Connection Pooling C.) Connection Timeouts D.) Normalization B.) Connection Pooling The database administrator will not allow you to write SQL code in your application how do you retrieve data? A.) Call a stored procedure B.) Script a SELECT statement to a file C.) reference an index in the database D.) Query a database view A.) Call a stored procedure A database dictionary that describes the structure of a database is called ______________ A.) DBMS B.) Metacontent C.) Normalization D.) Metadata D.) Metadata You need to ensure the data integrity of a database by resolving insertion, update, and deletion anomalies. Which term is used to describe this process? A.) Resolution B.) Integration C.) Normalization
D.) Isolation C.) Normalization Your database has a table called students that contains the following fields: firstNamelastNameemailAddressphone You need to get the firstName, last Name, and email for all students listed alphabetically by last name and then first name. A.) SELECT lastName, firstName FROM students ORDER BY lastName, firstName B.) SELECT firstName, lastName, email FROM students ORDER BY lastName, firstName C.) SELECT firstName, lastName, email FROM students ORDER BY firstName, lastName D.) SELECT firstName, lastName FROM students ORDER BY lastName, firstName B.) SELECT firstName, lastName, email FROM students ORDER BY lastName, firstName Your application must pull data from a database on a separate server. What must you do? A.) Install the database on each client computer B.) Establish a connection to the database by using the appropriate data provider C.) Create a routine that bypasses firewalls D.) Configure the network routers to allow database connections B.) Establish a connection to the database by using the appropriate data provider Using Asp.net, you need to store a value that can be shared across users on the server A.) Application B.) Session C.) ViewState D.) Cookies A.) Application What is the term for small units of text that are stored on a client computer? A.)Trace
What is displayed on the Surface tablet when this gesture is performed? App bar To minimize the time between when a race official records the results and when the results are available on the web, which part of the system is critical? Satellite Link To increase the number of students that can access race results, what element should be added to the system? Web Application Servers To minimize the amount of storage used on the hard drive by an application that generates many small files, you should make the _____________ as small as possible. A.) Partition B.) No answer text provided. C.) File allocation table D.) Block size D.) Block size Which two types of information should you include in an effective test case? (Choose two.) A.) any pre-conditions necessary to test the case B.) the expected result from testing the case C.) multiple actions combined as a single step to test the case D.) the stakeholders who originated the test case A.) any pre-conditions necessary to test the case B.) the expected result from testing the case The Dog class and the Cat class inherit from the Animal class. The Animal class includes a breathe() method and a speak() method. If the speak() method is called from an object of type Dog, the result is a bark. If the speak() method is called from an object of type Cat, the result is a meow. Which term is used to describe this object-oriented concept? A.) Encapsulation B.) No answer text provided. C.) Data hiding
D.) Polymorphism D.) Polymorphism In your student directory database, the Students table contains the following fields: firstName lastName emailAddress telephoneNumber You need to retrieve the data from the firstName, lastName, and emailAddress fields for all students listed in the directory. The results must be in alphabetical order according to lastName and then firstName. SELECT firstName, lastName, emailAddress FROM Students ORDER BY lastName, firstName What are two advantages of normalization in a database? Choose two. A.) decreases space on disk B.) minimizes impact of data corruption C.) reduces schema limitations D.) prevents data inconsistencies B.) minimizes impact of data corruption D.) prevents data inconsistencies You have a base class named Tree with a friend property named color and a protected property named NumberOfLeaves. In the same project, you also have a class named Person. Q1: Methods in the Person class can access the color property Q2: Methods in the Person class can access the NumberOfLeaves property Q3: Methods in the Tree class can access all private properties in Person Q1 Yes Q2 No Q3 No The specifications require a class that cannot be instantiated but can specify methods that must be implemented in concrete inherited classes.
A table named Student has columns named ID, Name, and Age. An index has been created on the ID column. What advantage does this index provide? A.) It speeds up query execution. B.) It reorders the records alphabetically. A.) It speeds up query execution. Class C and Class D inherit from Class B. Class B inherits from Class A. The classes have the methods shown in the following table. Class Method A m B m C m D m A.) m1, m2, m B.) only m2, m C.) only m3, m D.) only m1, m3 A.) m1, m2, m Dim beakerFull As Boolean = Ture Dim flameOn As Boolean = False Dim iResult As Integer Select Case beakerFull Case True Select Case flameOn
Case True iResult = 1 Case True iResult = 2 End Select Case False Select Case flameOn Case False iResult = 3 Case False iResult = 3 End Select End Select What will the variable result be? A.) 4 B.) 1 C.) 3 D.) 2 D.) 2 In the application life cycle, the revision of an application after it has been deployed is referred to as: A.)Monitoring B.) Maintenance C.) Integration
Which type of Windows application presents a parent window that contains child windows? A.) Single-document interface (SDI) B.) Multiple-document interface (MDI) B.) Multiple-document interface (MDI) The purpose of a constructor in a class is to: A.) Inherit from the base class. B.) Create a value type. C.) Initialize an object of that class. C.) Initialize an object of that class. A class named Manager is derived from a parent class named Employee. The Manager class includes characteristics that are unique to managers. Which term is used to describe this object-oriented concept? A.) Encapsulation B.) Data hiding C.) Inheritance C.) Inheritance Which term is used to describe a class that inherits functionality from an existing class? A.) Derived class B.) Inherited Class A.) Derived class Two classes named Circle and Square inherit from the Shape class. Circle and Square both inherit Area from the Shape class, but each computes Area differently. A.) polymorphism B.) Inheritance A.) polymorphism You are designing a class for an application. You need to restrict the availability of the member variable accessCount to the base class and to any classes that are derived from the base class.
Which access modifier should you use? A.) Protected B.) Private A.) Protected You are creating an application that presents users with a graphical interface. Users will run this application from remote computers. Some of the remote computers do not have the. NET Framework installed. Users do not have permissions to install software. Which type of application should you choose A.) Windows Service B.) Windows Forms C.) ASP.NET C.) ASP.NET Simulating the final design of an application in order to ensure that the development is progressing as expected is referred to as: A.) Prototyping B.) Software testing C.) Analyzing requirements B.) Software testing In the life cycle of an ASP. NET Web page, which phase follows the SaveStateCompletephase? A.) Load B.) Postlnit C.) Render D.) PostBack C.) Render You create an application that uses Simple Object Access Protocol (SOAP).Which technology provides information about the application's functionality to other applications?
You are creating a Web application. The application will be consumed by client computers that run a variety of Web browsers. Which term is used to describe the process of making the application available for client computers to access? A.) Deploying B.) Virtualization C.) Hosting D.) Casting C.) Hosting You are writing a Web application that processes room reservation requests. You need to verify that the room that a guest has selected is not already reserved by another guest. Which type of programming should you use to determine whether the room is still available when the request is made? A.) client-side B.) batch processing C.) multithreaded D.) server-side D.) server-side You need to group all the style settings into a separate file that can be applied to all the pages in a Web application. What should you do? A.) Use a WebKit. B.) Use inline styles C.) Use an Extensible Markup Language (XML) schema
D.) Use a Cascading Style Sheet (CSS) D.) Use a Cascading Style Sheet (CSS) Converting an object to a more general type is called upcasting. A.) downcasting B.) no change is needed B.) no change is needed For each of the following statements, select Yes if the statement is true. Otherwise, select No. Q1 An Entity relationship diagram (ERD) is designed for an object-oriented database. Q2 An entity relationship diagram (ERD) contains entities, relationship and attributes. Q3 Cardinality refers to how one table is linked to another table; as one to many. Q1 No Q2 Yes Q3 Yes Internet Information Services (IIS) must be installed on _____________ in order to run a deployed ASP.NET application. A.) the client computers B.) computer that you plan to deploy from C.) computer that hosts the application C.) computer that hosts the application Which programming language is characterized as client-side, dynamic and weakly typed? A.) JavaScript B.) HTML C.) C# A.) JavaScript What are the three basic states that a Windows service can be in? (Choose three.) A.) running
Customer ------------------Order Customer -------Placed--------Order A.) one to one B.) one to many B.) one to many To improve performance, a SQL SELECT statement should use ____________ A.) indexes B.) ordering C.) grouping A.) indexes Which three items are benefits of encapsulation? (Choose three.) A.) performance B.) Flexibility C.) inheritance D.) maintainability E.) restricted access B.) Flexibility E.) restricted access D.) maintainability When a base class declares a method as virtual, the method _________________bv a derived class. A.) is hidden from implementation B.) can be overridden with its own implementation by a derived class C.) cannot be overridden with its own implementation by a derived class
D.) must be overridden in any non-abstract class that directly inherits from that class B.) can be overridden with its own implementation by a derived class The process of transforming compiled C# code into an XML string for a web service is known as
A.) deserialization B.) serialization B.) serialization You execute the following code. for (int i = 0; i <=10; i+=2) { Console.WriteLine("Hello"); } How many times will the word Hello be printed? A.) 10 B.) 4 C.) 6 D.) 8 C.) 6 Dim beakerFull As Boolean = True Dim flameOn As Boolean = False Dim iResults As Integer = 0 If beakerFull = True Then If flameOn = True Then iResult = Else
A.) Windows Forms application B.) Windows Service application B.) Windows Service application An application presents the user with a graphical interface. The interface includes buttons that the user clicks to perform tasks. Each time the user clicks a button, a method is called that corresponds to that button. Which term is used to describe this programming model? A.) structured B.) event driven B.) event driven What are two methods that can be used to evaluate the condition of a loop at the start of each iteration? (Each correct answer presents a complete solution. Choose two. ) A.) For B.) While C.) If D.) Do...While A.) For B.) While You need to evaluate the following expression:(A>B) AND (C<D)What is the value of this expression if A=3, B=4, C=4, and D=5? A.) False B.) TrueA.) False Which type of application has the following characteristics when it is installed? Runs continuously in the background by default when the startup type is set to automatic Presents no user interface A.) Windows Service
B.) Windows Form A.) Windows Service You are creating the necessary variables for an application. The data you will store in these variables has the following characteristics: Consists of numbers Includes numbers that have decimal points Requires more than seven digits of precision You need to use a data type that will minimize the amount of memory that is used. Which data type should you use? A.) float B.) decimal C.) double C.) double A data dictionary describes the structure of a database is called _________ A.) metacontent B.) metadata B.) metadata What is displayed when you attempt to access a Web service by using a Web browser? A.) a directory listing of the Web service's application structure B.) a listing of methods that are available in the Web service C.) a visual depiction of your preliminary connection to the Web service D.) an error page explaining that you have accessed the Web service incorrectly B.) a listing of methods that are available in the Web service Where must Internet Information Services (IIS) be installed in order to run a deployed ASP.NET application? A.) on the computer that you plan to deploy from B.) on the computer that hosts the application C.) on the client computers
