Accounting
Anthropology
Archaeology
Art History
Banking
Biology & Life Science
Business
Business Communication
Business Development
Business Ethics
Business Law
Chemistry
Communication
Computer Science
Counseling
Criminal Law
Curriculum & Instruction
Design
Earth Science
Economic
Education
Engineering
Finance
History & Theory
Humanities
Human Resource
International Business
Investments & Securities
Journalism
Law
Management
Marketing
Medicine
Medicine & Health Science
Nursing
Philosophy
Physic
Psychology
Real Estate
Science
Social Science
Sociology
Special Education
Speech
Visual Arts
Humanities
Q:
Which of the following steps in the configuration process of a SqlDataSource server control represents the main difference between connecting to an Oracle vs. an SQL Server data source?a) Connecting to a databaseb) Saving the connection to a filec) Choosing the data providerd) Configuring the select statement
Q:
After the GridView control has been associated with a particular data source control, which of the following changes take place?
a) Grid remains unchanged until viewed in the browser, at which point it displays the corresponding data source.
b) Grid changes to reflect the columns in the data source, and when viewed in the browser, it displays the corresponding records.
c) Grid changes to reflect the columns and records in the data source, which can then be view in the browser as well.
d) Grid changes to reflect the records in the data source, and when viewed in the browser, it displays the corresponding columns.
Q:
GridView task used to associate the grid with the existing data source is which of the following?
a) New data source
b) Open data source
c) Choose data source
d) Configure data source
Q:
Which of the following server controls displays the data in the form of a table?
a) TableView
b) GridView
c) DataList
d) FormView
Q:
Which of the following steps in the configuration process of a SqlDataSource server control specifies the data that will be brought into the application?
a) Connecting to a database
b) Saving the connection to a file
c) Choosing the data provider
d) Configuring the select statement
Q:
Which of the following steps in the configuration process of a SqlDataSource server control allows the user to store the connection details in Web.config file?
a) Connecting to a database
b) Saving the connection to a file
c) Creating a new data connection
d) Choosing the data provider
Q:
Which of the following steps in the configuration process of a SqlDataSource server control designates a particular SQL Server database to connect to?
a) Connecting to a database
b) Saving the connection to a file
c) Creating a new data connection
d) Choosing the data provider
Q:
Which of the following data sources typically does not require user authentication?
a) Microsoft SQL Server
b) Microsoft Access Database
c) Oracle Database
d) Microsoft ODBC Data Source
Q:
Which of the following steps in the configuration process of a SqlDataSource server control designates Oracle as a database of choice?
a) Connecting to a database
b) Saving the connection to a file
c) Creating a new data connection
d) Choosing the data provider
Q:
The initial step in configuring a SqlDataSource server control is which of the following?
a) Connecting to a database
b) Saving the connection to a file
c) Creating a new data connection
d) Choosing the data provider
Q:
The server control used to access an Oracle database is which one of the following?
a) SqlDataSource
b) AccessDataSource
c) ObjectDataSource
d) XmlDataSource
Q:
The server control used to access a Microsoft SQL Server database is which of the following?
a) SqlDataSource
b) AccessDataSource
c) ObjectDataSource
d) XmlDataSource
Q:
For years, QuickTax, Inc. has helped small businesses manage their taxes. The management wants a database to keep track of clients, employees, and jobs. Managers need to keep track of client names, addresses, contact persons, phone numbers, and email addresses. They also need to track the employee's social security numbers, names, and birth dates. Also, the company needs to be able to keep track of the data on each job an employee performs for each of their clients.For questions 44-56, please refer to the preceding paragraph.The server control used to access a Microsoft Access database is which of the following?a) SqlDataSourceb) AccessDataSourcec) ObjectDataSourced) XmlDataSource
Q:
In an ASP page, which of the following is used to add the controls to the page?a) Toolboxb) Toolbarc) Build menud) Tools menu
Q:
In an ASP page, the view used to directly enter HTML statements is which of the following?
a) Datasheet view
b) Design view
c) Source view
d) Code view
Q:
Major components of Web Developer is(are) which of the following?
a) An ASP page
b) Solution Explorer
c) Properties window
d) All of the above
Q:
Programming logic component is used to do which of the following?
a) Control the behavior of the page.
b) Control the properties of server controls.
c) Implement procedures that accomplish tasks.
d) All of the above
Q:
The extension of the programming logic Web Form component file is which one of the following
a) aspx
b) asp.net
c) aspx.vb
d) vb.net
Q:
The extension of the visual Web Form component file is which of the following?
a) aspx
b) asp.net
c) aspx.vb
d) vb.net
Q:
A Web Form is divided into which of the following?
a) Visual and graphical components
b) Visual and programming logic components
c) Server and programming logic components
d) Code and programming logic components
Q:
Which one of the following is a typical Web Form control and an associated event?
a) Button, Update
b) Drop-down list, Delete
c) Text box, Change
d) Label, Click
Q:
When the Web Form is sent back to the Web server, which of the following occurs?
a) User and event-related information is returned.
b) All the returned information is analyzed.
c) Database is updated if necessary with new information.
d) All of the above
Q:
The fourth step in the basic ASP model is which of the following?
a) Server sends Web Form from the Web server.
b) User requests Web Form from the user's browser.
c) Web server processes data and returns form to the user's browser.
d) User enters data and returns form to the Web server.
Q:
The third step in the basic ASP model is which of the following?
a) Server sends Web Form from the Web server.
b) User requests Web Form from the user's browser.
c) Web server processes data and returns form to the user's browser.
d) User enters data and returns form to the Web server.
Q:
The second step in the basic ASP model is which of the following?
a) Server sends Web Form from the Web server.
b) User requests Web Form from the user's browser.
c) Web server processes data and returns form to the user's browser.
d) User enters data and returns form to the Web server.
Q:
The first step in the basic ASP model is which of the following?
a) Server sends Web Form from the Web server.
b) User requests Web Form from the user's browser.
c) Web server processes data and returns form to the user's browser.
d) User enters data and returns form to the Web server.
Q:
ASP.NET Web Form is built using which of the following?
a) Standard HTML tags
b) ASP.NET server controls
c) HTML tags and ASP.NET server controls
d) Text boxes, tables, radio buttons and list boxes
Q:
ASP Web page is constructed using which of the following?
a) Text and graphics
b) User input and events
c) Data from a database
d) All of the above
Q:
ASP.NET is the Microsoft development environment that allows us to do which of the following?
a) Develop static Web pages that consist of text and graphics.
b) Develop dynamic Web applications that interact with the user.
c) Design Web databases and manage their content.
d) Design desktop-based applications that interact with databases.
Q:
ASP stands for which of the following?
a) Access Server Page
b) Access SQL Property
c) Active Server Page
d) Associative Server Property
Q:
GridView server control requires the number of columns and rows to be specified in advance in order to provide the appropriate space.
Q:
GridView server control is used to display data in the form of a table.
Q:
Configuring data source is done by specifying an appropriate SQL statement.
Q:
The advantages of saving connection to Web.config file include easier deployment and portability.
Q:
Storing connection strings simplifies database maintenance.
Q:
The connection to qtax database would look like sqlservername.qtax.dbo, where sqlservername is the name of SQL Server being used.
Q:
Test Connection button makes sure that the Web Developer can connect to qtax SQL Server database.
Q:
All types of data sources require some form of user authentication.
Q:
Configure data source wizard is used to establish new connection with qtax SQL server database.
Q:
DataSource server controls are used to display data.
Q:
Common Tasks is a feature used to setup data server controls.
Q:
Database related server controls are located on the Toolbox under the Data tab.
Q:
SqlDataSource server control is used for either SQL Server or Oracle databases.
Q:
For years, QuickTax, Inc. has helped small businesses manage their taxes. The management wants a database to keep track of clients, employees, and jobs. Managers need to keep track of client names, addresses, contact persons, phone numbers, and email addresses. They also need to track the employee's social security numbers, names, and birth dates. Also, the company needs to be able to keep track of the data on each job an employee performs for each of their clients.For questions 13-26, please refer to the preceding paragraph.The server control used to access qtax.mdb Access database is called the SqlDataSource.
Q:
In an ASP page, the Source view is used to place all the server control and the Design view is used to write HTML statements.
Q:
An ASP.NET Web site is a collection of files stored in a unique folder.
Q:
Major components of Web Developer are an ASP page, Solution Explorer, and Properties window.
Q:
In order to develop applications with Web Developer Express, you need all three tiers: client browser, Web server, and database server.
Q:
Microsoft Web Developer Express is a subset of a powerful development environment called Visual Studio.
Q:
An ASP.NET Web Form is divided into the user interface and programming logic components.
Q:
When a button is clicked or list selection made, an event is raised and the information is just displayed in the user's browser.
Q:
Web Form sent back to the Web server contains both user supplied and other relevant information associated with the ASP Web page.
Q:
ASP.NET server controls include dynamic versions of typical HTML tags.
Q:
ASP.NET Web Form is built using standard HTML tags.
Q:
A dynamic Web page is based on the responses to user inputs and events related to the page.
Q:
Active Server Page (ASP) is a Web page that displays static content like text and graphics.
Q:
In SQL Query Analyzer, the statement used to retrieve client's contacts with emails ending in "net", and from area code 603, would be __.
Q:
In SQL Query Analyzer, the statement used to retrieve client's contacts with emails ending in "net", would be __.
Q:
In SQL Query Analyzer, the statement used to retrieve an employee name and birth date, for an employee with social security number 261284363, would be __.
Q:
In SQL Query Analyzer, the statement used to retrieve all the jobs with jobid over 5, displaying only jobids and associated dates, would be __.
Q:
In SQL Query Analyzer, the statement used to retrieve all the client data, ordered first by state and then by zip code would be __.
Q:
In SQL Query Analyzer, the statement used to retrieve all of the client's names, sorted A to Z, with city, state, and zip code would be __.
Q:
In SQL Query Analyzer, the statement used to retrieve all of the client's contacts and emails would be __.
Q:
In SQL Query Analyzer query design view, the __ is used to enter SQL queries.
Q:
For years, QuickTax, Inc. has helped small businesses manage their taxes. The management wants a database to keep track of clients, employees, and jobs. Managers need to keep track of client names, addresses, contact persons, phone numbers, and email addresses. They also need to track the employee's social security numbers, names, and birth dates. Also, the company needs to be able to keep track of the data on each job an employee performs for each of their clients.For questions 60-81, please refer to the preceding paragraph.In SQL Query Analyzer, the statement used to retrieve all of the data from the employee table would be __.
Q:
In SQL Query Analyzer, the statement used to display employees' social security numbers and names that don"t have any jobs assigned to them, would be which of the following?a) Select employee.ssn, employee.name From job Where employee.ssn Not In (Select Distinct job.ssn From job)b) Select employee.ssn, employee.name From job Where employee.ssn Not In (Select Distinct employee.ssn From employee)c) Select employee.ssn, employee.name From employee Where employee.ssn Not In (Select Distinct job.ssn From job)d) Select employee.ssn, employee.name From employee Where employee.ssn In (Select Distinct job.ssn From job)
Q:
In SQL Query Analyzer, the statement used to display employee and client names together with all of the job dates, sorted from earliest to latest, would be which of the following?
a) Select employee. name, client.name, job.jobdate From employee Inner Join (client Inner Join job On client.email = job.jobid) On employee.ssn = job.jobid Order by job.jobdate
b) Select employee. name, client.name, job.jobdate From employee Inner Join client Inner Join job On (client.email = job.email And employee.ssn = job.ssn ) Order by job.jobdate
c) Select employee. name, client.name, job.jobdate From employee Inner Join client On (client.email = job.email And employee.ssn = job.ssn) Order by job.jobdate
d) Select employee. name, client.name, job.jobdate From employee Inner Join (client Inner Join job On client.email = job.email) On employee.ssn = job.ssn Order by job.jobdate
Q:
In SQL Query Analyzer, the statement used to display employee names together with job dates and times, for all jobs starting on either 3/12/06 or at 8 A.M., would be which of the following?
a) Select employee. name, job.jobdate, job.timestart, job.timeend From employee Inner Join job On employee.ssn = job.ssn Where job.jobdate = #3/12/06# And job.timestart = #8:00 AM#
b) Select employee. name, job.jobdate, job.timestart , job.timeend From employee Inner Join job On employee.ssn = job.jobid Where job.jobdate = #3/12/06# Or job.timeend = #8:00 AM#
c) Select employee. name, job.jobdate, job.timestart , job.timeend From employee Inner Join job On employee.ssn = job.ssn Where job.jobdate = #3/12/06# Or job.timestart = #8:00 AM#
d) Select employee. name, job.jobdate, job.timestart , job.timeend From employee , job On employee.ssn = job.ssn Where job.jobdate = #3/12/06# Or job.timestart = #8:00 AM#
Q:
In SQL Query Analyzer, the statement used to display employee names together with job dates and times, for all jobs starting at 8 A.M., would be which of the following?
a) Select employee. name, job.jobdate, job.timestart, job.timeend From employee Inner Join job On employee.ssn = job.ssn Where job.timestart = #8:00 AM#
b) Select employee. name, job.jobdate, job.timestart, job.timeend From employee Inner Join job On employee.ssn = job.ssn Where job.timeend = #8:00 AM#
c) Select employee. name, job.jobdate, job.timestart, job.timeend From employee Inner Join job Where job.timestart = #8:00 AM#
d) Select employee. name, job.jobdate, job.timestart, job.timeend From employee, job On employee.ssn = job.ssn Where job.timestart = #8:00 AM#
Q:
In SQL Query Analyzer, the statement used to display employee names together with all of their job dates and times would be which of the following?
a) Select employee.name, job.jobdate, job.timestart, job.timeend From employee, job Where employee.ssn = job.jobid
b) Select employee. name, job. jobdate, job. timestart, job. timeend From employee Inner Join job On employee.ssn = job.ssn
c) Select employee. name, job. jobdate, job. timestart, job. timeend From employee.ssn Inner Join On job.ssn
d) Select employee. name, job. jobdate, job. timestart, job. timeend From employee Inner Join job On employee = job
Q:
In SQL Query Analyzer, the statement used to calculate the number of clients from each NH zip code, labeled "Zip Clients", would be which of the following?
a) Select zipcode, Count(email) From client Group by zipcode Where state != "NH"
b) Select zipcode, Count(email) As "Zip Clients' From client Group by zipcode
c) Select zipcode, Count(email) As "Zip Clients' From client Group by zipcode Where state = "NH"
d) Select zipcode, Count(email) As "Zip Clients' From client Group by zipcode Where state Is "NH"
Q:
In SQL Query Analyzer, the statement used to retrieve all the jobs with jobid greater than 5 and less than 8, displaying only jobid and associated dates, would be which of the following?
a) Select jobid, date From job Where jobid between 5 and 8
b) Select jobid, date From job Where jobid >5 And <8
c) Select jobid, date From job Where jobid >=5 and <=8
d) Select jobid, date From job Where jobid 5 and 8
Q:
In SQL Query Analyzer, which of the following statements would result in contacts, emails, and zip codes for the clients whose emails end in "net", and who live in 03264 zip code?
a) Select contact, email, zipcode From client Where email Not Like "net" And zipcode!= "03264"
b) Select contact, email, zipcode From client Where email Like "*net" Or zipcode = "03264"
c) Select contact, email, zipcode From client Where email Like "net" Or zipcode = "03264"
d) Select contact, email, zipcode From client Where email Like "*net" And zipcode = "03264"
Q:
In SQL Query Analyzer, which of the following statements would result in contacts, emails, and zip codes for the clients whose emails either end in "net", or who live in 03264 zip code?
a) Select contact, email, zipcode From client Where email Not Like "net" And zipcode!= "03264"
b) Select contact, email, zipcode From client Where email Like "*net" Or zipcode = "03264"
c) Select contact, email, zipcode From client Where email Like "net" Or zipcode = "03264"
d) Select contact, email, zipcode From client Where email Like "*net" And zipcode = "03264"
Q:
In SQL Query Analyzer, which of the following statements would result in contacts and emails only for the clients in 603 area code?
a) Select contact, email From client Where phone Not Like "603*"
b) Select contact, email From client Where phone Like "603"
c) Select contact, email From client Where phone Like "603*"
d) Select contact, email From client Where phone Like "*603*"
Q:
In SQL Query Analyzer, which of the following statements would result in contacts and emails only for the clients in the state of New Hampshire?
a) Select contact, email From client Where state equals "NH"
b) Select contact, email From client Where state != "NH"
c) Select contact, email From client Where state = "NH"
d) Select contact, email From client Where state is "NH"
Q:
Which one of the following are referred to as conditional operators?
a) +, -, *, /
b) =, >, <, >=, <=, !=
c) %, &, @, #
d) (, [, {, ), ], }
Q:
In SQL Query Analyzer, the condition restricting jobs to those with jobid of 5 or more, would be placed after which of the following keywords?
a) Select
b) From
c) Order by
d) Where
Q:
Sorting on multiple columns in SQL Query Analyzer involves which of the following?
a) Placing the fields in order in which they should be sorted
b) Choosing the type of sort (Ascending, Descending)
c) Make sure that the required fields are shown
d) All of the above
Q:
In SQL Query Analyzer, which of the following would be used to sort the client list consisting of contacts and emails, alphabetically from Z to A, by contact?
a) Select * From client Order by contact
b) Select contact, email From client Order by contact desc
c) Select contact, email From client Order by contact
d) Select contact, email Order by contact desc