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
Design
Q:
Query builder allows us to use either graphical interface when building a query or a place to write SQL statements to accomplish the same.
Q:
There are four tabs in a custom SQL statement window, one for each of the select, update, insert, and delete SQL statements.
Q:
When configuring the data source, the option to specify a custom SQL statement or stored procedure allows us to automatically generate insert, update, and delete statements.
Q:
Consecutive numbers at the bottom of DetailsView control allow us to browse through the records in associated table.
Q:
Server control used to make changes to data in the database is called GridView.
Q:
Draw the appropriate server control that will allow you to display the customer data, and describe the steps needed for proper configuration.
Q:
Fill the appropriate elements of the last step in data source configuration assuming we want to retrieve all the customers from customer table in Exposures database.
Q:
List the connection properties that need to be defined in order to set up data connection to Exposure database on Microsoft SQL Server. Describe the benefits of saving the connection details to Web.config file.
Q:
Exposures is a specialty retailer of fine gifts, picture frames, albums, scrapbooks, as well as occasional gift ideas. Visit their Web site at www.exposureonline.com, and using the registration, billing, catalog, and shopping cart screens below, go through each of the five ER design steps.For questions 90-93, please refer to the preceding paragraph and Web screens.Draw the appropriate server control and describe the steps for creating the new connection and selecting the appropriate server provider, assuming Exposures database is available on SQL Server.
Q:
Draw the appropriate server control that will allow you to display the flower data and describe the steps needed for proper configuration.
Q:
Fill the appropriate elements of the last step in data source configuration assuming we want to retrieve all the flowers from flower table in flower database.
Q:
List the connection properties that need to be defined in order to set up data connection to flower database on Microsoft SQL Server. Describe the benefits of saving the connection details to Web.config file.
Q:
Jerry, the owner of Exotic Flower's Inc., built a small greenhouse to store several types of exotic flowers that he purchases from wholesale suppliers around the world. Each exotic flower Jerry buys and resells falls into one of several flower groups that differ with respect to their storage needs, duration, time in bloom, price, etc. Each of the orders placed by customers specifies the type of exotic flower, the supplier it came from, the date of order, expected delivery date, flower condition on delivery, as well as the quantity ordered. Customer's data contain all the standard information needed to collect payment and deliver the flowers.For questions 86-89, please refer to the preceding paragraph.Draw the appropriate server control and describe the steps of creating the new connection and selecting the appropriate server provider, assuming flower database is available on SQL Server.
Q:
Draw the appropriate server control that will allow you to display the customer data and describe the steps needed for proper configuration.
Q:
Fill the appropriate elements of the last step in data source configuration assuming we want to retrieve all the customers from customer table in rental database.
Q:
List the connection properties that need to be defined in order to set up data connection to rental database on Microsoft SQL Server. Describe the benefits of saving the connection details to Web.config file.
Q:
Plymouth Car Rental (PCR) started with two compact cars and has expanded its fleet of vehicles with several sedans and trucks. When a customer books a rental, his/her age has to be at least 18 for compact cars and sedans, which are rented by the day and must be returned the following morning by 11 A.M. Trucks are rented for a maximum of six hours. The owner requires a deposit on the reservation to be paid within seven days of booking. Vehicle records consist of the makes and types (Honda sedan), color, seating capacity, required deposit, rental rate and rental limit (in hours). Customer data consists of customer's names, addresses, phone numbers, and birth dates. Bookings identify the customer, vehicle, as well as the time rented and returned. There can be several payments up until the reservation date. Payments must reflect the payment status for each booking, including deposit, when the deposit was made, then each of the payments made, and when the entire payment was completed.For questions 82-85, please refer to the preceding paragraph.Draw the appropriate server control and describe the steps of creating the new connection and selecting the appropriate server provider, assuming rental database is available on SQL Server.
Q:
The most appropriate server control that will allow the user to indicate the presence (yes) or absence (no) of a certain property is called a(n) __.
Q:
The most appropriate server control that will allow the user to enter text or variable length is called a(n) __.
Q:
Once the ASP page with SqlDataSource and associated GridView control are loaded up in the browser, the GridView appearance will change to reflect the _ in the data source.
Q:
Once a particular SqlDataSource is chosen, the GridView appearance changes to reflect the __ in the data source.
Q:
The first step in configuring the GridView control is to __.
Q:
A server control used to display data in a form of a table is called the _.
Q:
The last step in configuring an SqlDataSource for qtax SQL server database is to retrieve data from the database using the appropriate __.
Q:
The details of the data connection can be saved in a file called __.
Q:
The properties of a data connection that authenticate the user are __ and __.
Q:
The property of a data connection indicating Microsoft SQL Server as a data provider is called __.
Q:
The initial step in configuring an SqlDataSource for qtax SQL Server database is to create a new __.
Q:
The server control used to access an Oracle database qtax is __.
Q:
The server control used to access a Microsoft SQL Server database qtax is _.
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 68-81, please refer to the preceding paragraph.The server control used to access a Microsoft Access database qtax.mdb is _.
Q:
ASP.NET application is tested by viewing it in a __.
Q:
The assistance with entering Visual Basic statements is provided by a feature called __.
Q:
The behavior of controls, such as what happens when a button is clicked, is specified by __.
Q:
The appearance of controls, such as the size and text on a button, can be modified using the __.
Q:
Interaction with the ASP page in the main window of Web Developer can occur in __ view and __ view.
Q:
The visual component of an ASP Web page is stored in a(n) __ file and its programming logic is stored in a(n) __ file.
Q:
In addition to user inputs, the information associated with various Web Form __ is also returned to the Web server.
Q:
ASP Web page is built using a mixture of HTML tags and __.
Q:
The basic ASP.NET component is a(n) __.
Q:
Number of items left in stock for a particular product displayed on an ASP Web page most likely come from a(n) __.
Q:
Active Server Page is a Web page whose content is __ generated in response to user inputs and events related to the page.
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.