Download Certiport Software Development #1-4 actual practice test and more Exams Advanced Education in PDF only on Docsity!
1 / 41
- 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 A.) Call a stored procedure 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 database dictionary that describes the structure of a D.) Metadata database is called A.)DBMS B.)Metacontent C.)Normalization D.)Metadata
- You need to ensure the data integrity of a database by C.) Normalization resolving insertion, update, and deletion anomalies. Which term is used to describe
2 / 41 this process? A.)Resolution B.)Integration
4 / 41 Name, email FROM stu-dents ORDER BY lastName, firstName B.) Establish a connection to the database by us-ing the appropriate data provider A.) Application
5 / 41 B.)Session C.)ViewState D.)Cookies
- What is the term for small units of text that are stored D.) Cookie on a client computer? A.) Trace B.)Transfer C.)Cross page post D.)Cookie
- For these statements match the correct response XHTML attribute names must be in uppercase XHTML attribute names must be in quotation marks XHTML attribute minimization is forbidden A.)True, False, True B.)True, False, False C.)True, True, True D.)False, True, True
- Which function does Simple Object Access Protocol (SOAP) provide when using web service? A.)Model for describing Web services B.)Directory of registered web services C.)Communications protocol D.)Security model
- You need to debug a Windows Service application by using breakpoints. What should you do?
7 / 41 A.)Implement the Console.WriteLine method through-out the Windows Service. B.)Set the Windows Service status to Paused. C.)Write all events to an event log. D.)Use the Attach to Process menu in Microsoft Visual Studio.
- What is the gesture when running your finger across a Swiping device?
- What is displayed on the Surface tablet when this ges- App bar ture is performed?
- 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?
- To increase the number of students that can access race results, what element should be added to the system?
- 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 possi-ble. A.)Partition B.)No answer text provided. C.)File allocation table D.)Block size
- Which two types of information should you include in an effective test case? (Choose two.)
8 / 41 Satellite Link Web Application Servers D.) Block size A.) any pre-conditions necessary to test the case
10 / 41 directory. The results must be in alphabetical order according to lastName and then firstName.
- What are two advantages of normalization in a data-base? Choose two. Name, emailAddress FROM Students ORDER BY lastName, firstName B.) minimizes impact of data corruption
11 / 41 A.)decreases space on disk B.)minimizes impact of data corruption C.)reduces schema limitations D.)prevents data inconsistencies
- You have a base class named Tree with a friend prop-erty 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 Num-berOfLeaves property Q3: Methods in the Tree class can access all private properties in Person
- The specifications require a class that cannot be in-stantiated but can specify methods that must be im-plemented in concrete inherited classes. A.)abstract B.)public C.)sealed D.)stub D.) prevents data inconsis-tencies Q Yes Q No Q No C.) sealed
- When creating a site to utilize message queuing, the ip A.) Protocol must be configured to MSMQ. A.)Protocol B.)Address
13 / 41 from Class A. The classes have the methods shown in the following table. Class Method A m
14 / 41 B m C m D m A.)m1, m2, m B.)only m2, m C.)only m3, m D.)only m1, 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 C a s e F a l s e i R e s u l t = 3 E n d S e l
16 / 41
A.) 4
B.) 1
C.) 3
D.) 2
- In the application life cycle, the revision of an applica-tion after it has been deployed is referred to as: A.) Monitoring B.)Maintenance C.)Integration D.)Unit testing
- You are creating a database for a student directory. The Students table contains the following fields: firstName lastName emailAddress telephoneNumb er You need to retrieve the data from the firstName, last-Name, and emailAddress fields for all students listed in the directory. The results must be in alphabetical order according to lastName and then firstName. A.)SELECT firstName, lastName, emailAddress FROM Students ORDER BY lastName, firstName B.)SELECT firstName, lastName, emailAddress FROM Students ORDER BY lastName, firstName , emailAd-dress
- Which statement should you use to create the stored procedure?
17 / 41 B.) Maintenance A.) SELECT firstName, lastName, emailAddress FROM Students ORDER BY lastName, firstName
19 / 41 oriented concept?
20 / 41 A.)Encapsulation B.)Data hiding C.)Inheritance
- Which term is used to describe a class that inherits functionality from an existing class? A.)Derived class B.)Inherited 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
- You are designing a class for an application. You need to restrict the availability of the member variable ac-cessCount 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
- 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 permis- sions to install software. Which type of application should you choose
