Exam (elaborations)
MTA 98-361 Exam Questions With Complete Solutions
- Course
- Institution
MTA 98-361 Exam Questions With Complete Solutions
[Show more]
Content preview
MTA 98-361 Exam Questions With Complete Solutions•That not a single column in the table is allowed to host multiple
values in the same row of data. •That the entire primary key
determines the functionality of all non-key columns.
•That functional dependency is not shared by non-key attributes.
What prerequisites does this configuration allow for?
A. The prerequisites of 4NF.
B. The prerequisites of 3NF.
C. The prerequisites of 2NF.
D. The prerequisites of 1NF. Correct Answer B. The
prerequisites of 3NF.
a data structure that satisfies the following requirements:
•Prohibits random access to its items.
•Are extremely fast in executing insert and delete operations.
•Are not stored in contiguous memory locations.
What data structure should you make use of?
A. An array data structure.
B. A linked list data structure.
C. A stack data structure.
D. A queue data structure. Correct Answer B. A linked list data
structure.
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-------
A. No change is needed
B. cookie
C. form post
D. QueryString Correct Answer B. cookie
,A table whose attributes depend only on the primary key must
be at least ---------normal form.
A. second
B. first
C. third
D. fourth Correct Answer A. second
ABC.com has an Internet Information Services (IIS) server,
named ABC-SR07, which hosts a newly developed Web
application. You are then informed that you must ensure that all
ABC.com's staff is able to make use of the new Web
application. Which of the following actions should you take?
A. You should consider making sure that all client workstations
have Windows 7 installed.
B. You should consider making sure that all client workstations
have the necessary hardware requirements.
C. You should consider making sure that all client workstations
are password protected.
D. You should consider making sure that all client workstations
have a suitable Web browser installed. Correct Answer D. You
should consider making sure that all client workstations have a
suitable Web browser installed.
ABCWebApp makes use of a Web service to obtain data. You
want to make sure that you are able to make use of the methods
of this Web service inside ABCWebApp by creating the client-
side proxy classes. Which of the following actions should you
take?
A. You should consider inserting the reference in the
machine.config file
,B. You should consider inserting the reference in the app.config
file
C. You should consider inserting the reference in the
Web.config file.
D. You should consider configuring a Web reference to identify
the Web service. Correct Answer D. You should consider
configuring a Web reference to identify the Web service.
Arguments are passed to console applications as a ---------object.
A. No change is needed .
B. String Array
C. StoredProcedureCollection
D. Dictionary Correct Answer B. String Array
As you design a database for your company, you review the
normalization rules for the database tables. You need to ensure
that your table design meets the requirements for the third
normal form. Which of the following statements must be true for
your tables? (Choose all that apply.)
A. None of the columns in the table should have multiple values
in the same row of data.
B. All non-key columns are functionally dependent on the entire
primary key.
C. At least one non-key column is functionally dependent on the
entire primary key.
D. Non-key attributes don't share any functional dependency.
E. Non-key attributes share functional dependency. Correct
Answer A. None of the columns in the table should have
multiple values in the same row of data.
B. All non-key columns are functionally dependent on the entire
primary key.
, D. Non-key attributes don't share any functional dependency.
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. All methods have a protected scope. Which methods does
Class C have access to?
A. only m3, m4
B. only m2, m3
C. only ml, m3
D. m1, m3, m3
E. m2, m3, m4
F. m1, m2, m3 Correct Answer F. m1, m2, m3
In the life cycle of an ASP. NET Web page, which phase
follows the SaveStateComplete phase?
A. PostBack
B. Postlnit
C. Load
D. Render Correct Answer D. Render
In your application, you are using a queue data structure to
manipulate information. You need to find whether a data item
exists in the queue, but you don't want to actually process that
data item yet. Which of the following queue operations will you
use?
A. enqueue
B. dequeue
C. peek
D. contains Correct Answer D. contains
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Classroom. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $14.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
84146 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now