Question
click below
click below
Question
Normal Size Small Size show me how
csc final
Question | Answer |
---|---|
Which is an example of a scripting language? | c. JavaScript |
Which software development methodology is based on an iterative project management process that aligns development with customer needs? | c. Agile |
Which language is compiled? | C++ |
Developing an algorithm for a program occurs during which phase of the SDLC? | a. designing the program phase |
Which is the most popular programming language today? | c. Java |
Which is NOT an example of a markup language? | PHP |
Which markup language is concerned more with the structure and transporting of information than with displaying it? | b. XML |
Which language is used to produce Web pages that can be read on many different types of devices, including mobile devices? | a. XHTML |
Which is a program, written in assembly language, that controls a device attached to a computer? | b. Device driver |
Using the Bike class example in this chapter, if DIRTBIKES were added to the structure, which element in the class would it be? | b. Subclass |
Which sequence represents the hierarchy of terms, from smallest to largest? | c. Record, field, table, database |
You perform several edits in a table within an Access database. When should you execute the Save command? | d. Records are saved automatically; the save command is not required. |
You have opened an Access file. The left pane displays a table with forms, queries, and reports listed below a table name. Then another table and its objects display. You notice some of the object names are repeated under different tables. Why? | b. The Navigation Pane has been set to Tables and Related Views. The object names repeat because a query or report is frequently based on multiple tables. |
Which of the following is not true of an Access database? | b. Every table in a database contains the same number of records as every other table. |
Which of the following is true regarding the record selector box? | d. A gold border surrounds the active record. |
You have finished an Access assignment and wish to turn it in to your instructor for evaluation. As you prepare to transfer the file, you discover that it has grown in size. It is now more than double the original size. You should: | c. Compact and repair the database file prior to transmitting it to the instructor. |
Which of the following will be accepted as valid during data entry? | c. Entering numbers into a text field |
Which of the following conditions is available through Filter by Selection? | c. An Equals condition |
You open an Access form and use it to update an address for customer Lee Fong. After closing the form, you later open a report that generates mailing labels. What will the address label for Lee Fong show? | a. The new address |
You are looking at an Employees table in Datasheet view. You want the names sorted alphabetically by last name and then by first name-for example, Smith, Andrea is listed before Smith, William. To accomplish this, you must: | a. First sort ascending on first name and then on last name. |
Which TPS report alerts managers to unexpecteddevelopments? | Exception report |
Which system allows vendors to detect insufficient funds for a purchase by accessing a database of delinquent accounts? | check-screen system |
Which language is commonly used to create queries in relational databases? | SQL |
Which database is usually visualized as a cube? | Multidimensional |
Which type of management decision focuses on localized issues that need immediate attention? | Operational |
Which technique makes information stored in databases available via Internet? | a. Web–database integration |
Which of the following is an example of a file management program? | a. Microsoft Access |
Which is a check that verifies a required field has NOT been left empty? | c. Completeness |
Which is a functional division of an organization? | d. Marketing & Sales |
Which of the following is NOT an acceptable datatype? | d. Character |
When entering, deleting, or editing table data: | b. The table must be in Datasheet view. |
Which of the following is true for the Query Wizard? | No criteria can be added. |
Which of the following was not a suggested guideline for designing a table? | Avoid calculated fields. |
A query's specifications providing instructions about which records to include must be entered: | c. On the Criteria row of the query design grid. |
An illustration of a one-to-many relationship would be: | b. A customer may have multiple orders. |
When adding criteria to the query design view: | d. Access will add the correct delimiters for you ("),("), (#), or (). |
Which of the following is true with respect to an individual's hire date and years of service? | b. Hire date should be a stored field; years of service should be a calculated field. |
When importing data into Access, which of the following statements is true? | c. You can assign a primary key while you are importing Excel data. |
The main reason to enforce referential integrity in Access is to: | b. Keep invalid data from being entered into a table. |
It is more efficient to make a copy of an existing query, rather than create a new query, when which of the following is true? | b. The existing query and the new query use the same tables and fields. |
What identifies the project’s goals and specifies all activities that must be completed for the project to succeed? | c. Project plan |
What examines the losses and gains related to a project? | b. Cost-benefit analysis |
What automates the tedious activity of documenting entity relationships and data flow? | c. Computer-aided software engineering |
Which type of conversion method is the safest? | c. Parallel |
What phase of the SDLC involves ongoing evaluation, referred to as post implementation system review? | d. Maintenance |
What is the deliverable for phase 3 of the SDLC? | c. A logical design providing an overall picture of how the system will work |
What linear and sequential model for system development requires one step to be fully completed before the next can start? | c. Waterfall |
Application and acceptance testing take place in which phase of the SDLC? | c. Implementation |
Which is an example of a tangible benefit? | Better employee morale |
What is the decision to develop a system in-house or purchase one from an outside vendor? | Build-or-buy |
Which of the following correctly identifies the rules for the order of operations? | c. Parentheses, exponentiation, multiplication, division, addition, subtraction |
What is the result of the following expression? (3 * 5) + 7 - 2 - 6 * 2 | d. 8 |
The Builder command that opens the Expression Builder is found in the: | b. Query Setup group on the Design tab. |
Which function enables you to insert today's date into an expression? | a. Date () |
You correctly calculated a value for the OrderAmount using an expression. Now you need to use the newly calculated value in another expression calculating sales tax. The most efficient method is to: | b. Create a new query based on the query containing the calculated Order amount, and then calculate the sales tax in the new query. |
If state law requires that a restaurant's wait staff be at least 21 to serve alcohol and you have a database that stores each employee's birth date in the Employee table, which of the following is the proper syntax to identify the employees' year of birth | a. Age:DatePart("yyyy", [Employee] ! [BirthDate]) |
Which statement about a totals query is true? | d. A totals query may contain several grouping fields and several aggregate fields. |
After creating a calculated field, you run the query and a parameter dialog box appears on your screen. How do you respond to the Parameter dialog box? | b. Read the field name specified in the parameter box, and then look for a possible typing error in the calculated expression. |
An updatable query contains student names. You run the query and while in Datasheet view, you notice a spelling error on one of the student's names. You correct the error in Datasheet view. Which statement is true? | b. The name is correctly spelled in the table and in all queries based on the table. |
Which of the following is not true about the Total row in the query design grid? | d. The Total row can only be applied to numeric fields. |