Devry Exams
1.0K views | +0 today
Follow
Your new post is loading...
Your new post is loading...
Scooped by CeliaAlexander
Scoop.it!

COMP 230 Final Exam (Set 2)

http://www.devryexams.com/product/comp-230-final-exam-set-2/

CeliaAlexander's insight:

http://www.devryexams.com/product/comp-230-final-exam-set-2/

 

1. (TCO 7) In an SQL Query statement used in a VBScript program, what Boolean operator can be used to test a set of conditions whereby any condition being true must test true?

2. (TCO 7) Which one of the following is a correct SELECT clause in a VBScript program for selecting the fields: FirstName and LastName and Age?

3. (TCO 7) What SQL clause is used in a VBScript program to determine the Table or Tables to be accessed in an SQL Query statement?

4. (TCO 7) Which one of the follows fields would be suitable as a primary key in a table that contains employee records?

5. (TCO 1) Which Windows shutdown command switch is used to log off the current user of the local computer?

6. (TCO 1) Which one of the following Windows NET commands will allow other computers to access the C:\Data directory under the share name UserData?

7. (TCO 1) From the Start/Run dialog, the command used to open the 32-bit Windows command prompt is _____.

8. (TCO 1) Which of the following Windows commands will shutdown and power down the computer FileServer in 2 minutes?

9. (TCO 6) What WSH object is required for VBScript File I/O?

10. (TCO 6) To evaluate whether a file exists or not before you overwrite it in VBScript, use the following command (assuming that fso is an object of type Scripting.FileSystemObject).

11. (TCO 6) The following VBScript statement will open a text file.

Set file = fso.OpenTextFile(“C:\Data\CustData.txt”, ForWriting) 

To open this file for writing, the value of ForWriting must be _____.

12. (TCO 2) Given the rules of operator precedence, what value would the variable contain after the following statement was executed? distance = 2 + 5 * 3

13. (TCO 2) What is an example of a numeric constant?

14. (TCO 2) What is the problem with the following statement? 75 = percent

15. (TCO 2) What is the best choice for a variable name representing a bank balance?

16. (TCO 2) What is the problem with the following statement? 65 = seniorAge

17. (TCO 5) What name is best suited to a function or subroutine that calculates overtime pay?

18. (TCO 5) A good example of a well-named constant is _____.

19. (TCO 3) What VBScript decision-making statement would be for a single condition and two alternative code blocks to be executed?

20. (TCO 3) What produces the same result as the following pseudocode?

21. (TCO 3) In VBScript, which relational operator is used to test for equality?

22. (TCO 3) Boolean expressions can have which outcomes?

23. (TCO 3) When using the _____ operator, both conditions must be true in order for the entire expression to be evaluated as true

24. (TCO 4) What is the issue with the following VBScript While loop?

25. (TCO 4) When a VBScript loop control variable is not altered during loop execution, a(n) _____ loop may result

26. (TCO 4) Which VBScript statement represents incrementing the loop counter variable called count?

27. (TCO 4) When a variable is incremented by 1, _____.

28. (TCO 4) What is the term used to represent individual items in an array?

1. (TCO 1) Write the Windows CLI commands that will Clear the screen; Turn off Command echo; and display the current IP address, Subnet Mask, and Default Gateway

2. (TCO 1) Write the Windows CLI command that will shutdown and restart your computer in 2 minutes with the message “Restart in 2 Minutes!!”

3. (TCO 2) Write the VBScript code lines that perform the following tasks: Define a variable name that is initialized to “John Doe” and a variable age that is initialized to 35. USING THESE VARIABLES, display the following message: “Your name is John Doe and your age is 35.”

4. (TC0 3) Given the variables hoursWorked and payRate, write the VBScript code that will calculate grossPay. Keep in mind that any hours worked over 40 are paid at time and a half.

5. (TCO 3) Write the VBScript code that implements this logic. Given the numeric variable age, display the message “You are a Senior” if age is greater than or equal to 65, otherwise display the message “You are not a Senior”.

1. (TCO 5) Write a VBScript function called MaxNum that accepts two numbers and returns the largest to the two numbers

2. (TCO 6) Write the VBScript code that will delete the file C:\Data\DataFile.txt using a Script.FileSystemObject, but do this only if the file exists.

3. (TCO 7) Assuming that you are connected to a database called Computers.mdb with a table called Inventory with the fields Computer, Hostname Room_Num, CPU_Type, Num_CPUs, Bit_Size, OS_Type, Memory, and HDD_Size. Write the SQL Query String sqlStr such that the fields Computer, Room_Num, and OS_Type will be displayed for the records that indicate an OS_Type of “Fedora 10” or “Windows XP.” The returned records should be sorted by OS_Type.

more...
No comment yet.
Scooped by CeliaAlexander
Scoop.it!

COMP 220 Final Exam

http://www.devryexams.com/product/comp-220-final-exam/

CeliaAlexander's insight:

http://www.devryexams.com/product/comp-220-final-exam/

 

1. (TCO 1) Assume you have the following declaration.
int beta[50];
Which of the following is a valid element of beta?

2. (TCO 1) Consider the following statement.
double alpha[10][5];
The number of components of alpha is ____.

3. (TCO 1) Consider the following declaration.
int j;
int sum;
double sale[10][7];
Which of the following correctly finds the sum of the elements of the fourth column of sale?

4. (TCO 1) Which of the following correctly declares and initializes alpha to be an array of 4 rows and 3 columns with the component type int?

5. (TCO 1) What is the value of alpha[4] after the following code executes?

6. (TCO 1) Assume you have the following declaration.
char nameList[100];
Which of the following ranges is valid for the index of the array nameList?

7. (TCO 2) The member functions of a class should usually be _____.

8. (TCO 2) Consider the following.
bool clockType::equalTime(const clockType&) const {…}
void clockType::getTime(int&, int&, int&) const {…}
The word ____ at the end of the member functions in the class clockType specifies that these functions cannot modify the member variables of a clockType object

9. (TCO 2) Consider the following class definition.
class rectangleType
{
public:
void setLengthWidth(double x, double y);
//Postcondition: length = x; width = y;
void print() const;
//Output length and width;
double area();
//Calculate and return the area of the rectangle;
double perimeter();
//Calculate and return the parameter;
rectangleType();
//Postcondition: length = 0; width = 0;
rectangleType(double x, double y);
//Postcondition: length = x; width = y;
private:
double length;
double width;
};
And consider this object declaration.
rectangleType bigRect(14,10);
Which of the following statements is correct?

10. (TCO 2) Consider the following class definition.

class circleType
{
public:
void set(double r);
//Postcondition: radius = r;
void print();
//Output radius, area, and circumference.
double area();
//Postcondition: Calculate and return area.
double circumference();
//Postcondition: Calculate and return circumference.
circleType();
//Postcondition: radius = 0;
circleType(double r);
//Postcondition: radius = r;
private:
double radius;
};

And consider this declaration.

circleType myCircle;
double r;

Which of the following statements is valid in C++?

(i)
cin >> r;
myCircle.area = 3.14 * r * r;
cout

(ii)
cin >> r;
myCircle.set(r);
cout

1. (TCO 2) Consider the following class definition.

class rectangleType
{
public:
void setLengthWidth(double x, double y);
//Postcondition: length = x; width = y;
void print() const;
//Output length and width;
double area();
//Calculate and return the area of the rectangle;
double perimeter();
//Calculate and return the parameter;
rectangleType();
//Postcondition: length = 0; width = 0;
rectangleType(double x, double y);
//Postcondition: length = x; width = y;
private:
double length;
double width;
};

Which of the following class-variable declarations is correct?

2. (TCO 2) Suppose you have the following UML class diagram of a class

3. (TCO 2) Consider the following declaration.

class myClass
{
public:
void print();
private:
int x;
};
myClass myObject;

Which statement is legal?

4. (TCO 3) Composition is when one or more members of a class are _____.

5. (TCO 3) Composition, like inheritance, demonstrates what software-development advantage of object-oriented programming?

6. (TCO 3) What is the correct statement for declaring an array of 10 objects of ClassB?

7. (TCO 3) Which is a true statement about classes and structures?

8. (TCO 4) A derived class can redefine _____.

9. (TCO 4) Which of the following is true about a derived class?

10. (TCO 4) Which of the following base class members is never inherited by a derived class, regardless of access attributes?

1. (TCO 4) Which of the following base class members is never inherited by a derived class, regardless of access attributes?

2. (TCO 4) Single inheritance means _____.

3. (TCO 4) If inheritance is private, then _____.

4. (TCO 5) If p is a pointer variable of type int, and num is an int variable, what is the result of the statement p = #?

5. (TCO 5) Given the definition of a class called Employee, which of the following correctly dynamically allocates an array of 20 Employee objects?

6. (TCO 5) Which of the following statements correctly allocates space to store 15 real numbers?

7. (TCO 5) If p is a pointer, which statement uses the pointer and then increments it?

8. (TCO 6) The operator>>() function overloads the ____ operator.

9. (TCO 6) What is the difference between a friend function and a member function of the class?

10. (TCO 6) Which of the following statements is true for the C++ language?

11. (TCO 6) If you overload the binary arithmetic operator + as a member function, how many objects must be passed as parameters?

12. (TCO 7) Overriding a base-class member function with a derived member function demonstrates the concept of _____.

13. (TCO 7) If the class Shape is an abstract class, what type of variable may be declared of the type Shape?

14. (TCO 7) Consider the following class definitions

class Employee { };
class Boss : public Employee { };
class Worker : public Employee { };

Which class(es) should declare the function as virtual if all three classes have a member function double CalculateEarnings();?

15. (TCO 7) If a destructor of a base class is made virtual, then _____.

16. (TCO 7) Another definition for dynamic binding is _____.

17. (TCO 8) Which is not a preprocessor directive statement?

18. (TCO 8) Which preprocessor directive essentially inserts another file into your source file?

19. (TCO 8) All preprocessor directives begin with a(n) ___.

20. (TCO 8) In a multifile, object-oriented, C++ project, which is the correct statement for the constructor implementation, given that the constructor is correctly defined in the class definition file?

1. (TCO 1) Given the following array declaration and program statement, describe–in detail–the condition and what potential problems could occur if a program containing both was compiled and executed.

int array[5][4] = {0};
array[4][4] = 5;

2. (TCO 2) Explain the basic C++ syntax for creating a class. Include an explanation of the private and public section of a class and the class members. Include a code segment to illustrate your answer.

3. (TCO 3) Using a personal computer as a base model, write a C++, syntactically correct class definition demonstrating composition. In the class definition, include at least the following three items that are common to a PC: a CD drive, a hard disk drive, and a power supply. You are not required to include any constructors, destructors, or additional member functions; you are only required to list the members that directly show composition and the proper access attributes

4. (TCO 4) If a class is derived protected from a base class, explain how this affects the inheritance of all the public, protected, and private members of the base class by the derived class

5. (TCO 5) Describe what a memory leak is and why it could cause problems

.6. (TCO 6) Assume that three objects of the class Inductor have been instantiated: L1, L2, and L3. Write the overloaded operator prototypes that would be required to perform the following operation. You are only required to write the prototypes, not the implementation code.

L3 = L1 + L2;

7. (TCO 7) Define what is meant by the term run-time binding, and list two other terms that are also used to describe it.

8. (TCO 8) Describe and define what the preprocessor statement is, how it is used, what part of the development environment it interacts with, and provide a syntactically correct example that describes what it does

more...
No comment yet.
Scooped by CeliaAlexander
Scoop.it!

CIS 407 Final Exam (Set 2)

http://www.devryexams.com/product/cis-407-final-exam-set-2/

CeliaAlexander's insight:

http://www.devryexams.com/product/cis-407-final-exam-set-2/

 

1. (TCO 1) The foundation for _____ was laid in 1989 by researchers seeking an information system that would make it easy for their colleagues to locate and share data

2. (TCO 2) _____ is a generic block-level element

3. (TCO 3) A _____ language is a language that describes the content and structure of a document.

4. (TCO 10) Darrell’s Web Design wants to create a navigational menu using a picture that Darrell created in MS Paint. The picture includes text names of the various websites for which he would like to create links. No section of the picture he wants to make into links is regularly shaped; instead each is more like a trapezoid. Which shape would best suit the hotspots Darrell would like to create?

5. (TCO 3) A hypertext link allows you to select to view the _____ of the link

6. (TCO 3) All web page URLs begin with the letters _____.

7. (TCO 4) Which of the following is an extended color name in HTML?

8. (TCO 4) _____ GIFs are an effective way to compose slide shows or to simulate motion.

9. (TCO 5) The main style sheet standard is _____.

10. (TCO 2) The Yoga Club has a website that consists of a picture of the yoga room along with the definition of yoga on the left. On the right is a list of upcoming events, the company logo, and then yoga teacher training dates. The web designer Mary needs some help with CSS to make sure the pages print correctly. To cause the definition of yoga to print at the top of the page like a list, you could use _____.

11. (TCO 5) _____ express the location of an element within the hierarchy of elements

12. (TCO 3) _____ determines which style to apply when one or more styles conflict

13. (TCO 5) When you have defined a rectangular region using the appropriate style, which value matches the specified edge of the region to the edge of the parent element?

14. (TCO 3) To control the space between the table text and the cell borders, add the _____ attribute to the table tag

15. (TCO 3) A _____ cell occupies more than one row or column in a table

16. (TCO 2) With the frame value _____, a border is drawn on the left and right sides of the table.

17. (TCO 6) The item marked 7 in the accompanying figure is a _____ area

18. (TCO 6) You can specify an access key for an input element by using the _____ attribute.

19. (TCO 6) A _____ should be used to provide visual indication that option buttons belong in the same group

20. (TCO 6) Because it is more flexible, the _____ method is considered the preferred way of sending data to a web server

21. (TCO 5) _____ are programs that enable the browser to work with an embedded object.

22. (TCO 8) A Java program is stored in an executable file called a(n) _____ file

23. (TCO 4) If you use a frame, you should also provide a _____ version

24. (TCO 2) In the <frame> tag, if scrolling is set to _____, the scroll bars will display

25. (TCO 4) Use the _____ target to open external sites in the full browser window, replacing the current frameset

26. (TCO 4) To allow your website to be viewable using browsers that do not support frames, as well as by those that do, you can use the _____ tag to create a section of your HTML file containing code for browsers incapable of viewing frames

27. (TCO 9) XHTML _____ is a reduced version of XHTML 1.1 geared toward mobile applications.

28. (TCO 8) Which of the following is part of CSS3?

29. (TCO 9) Under the Sea is a scuba shop that sells new wave scuba gear to hip urban teens and young adults. The web developer, Mary, wants the pages to be designed for use on cell phones and other hand-held devices their young audiences carry. Which element should Mary not use in her web pages to avoid violating the strict DTD rules?

30. (TCO 7) Variable declarations should be placed at the _____ of your program to make your code easier to interpret

31. (TCO 10) What are the two ways in which multimedia can be added to a web page? What are the advantages and disadvantages of each?

32. (TCO 6) Provide five tips for creating effective forms

33. (TCO 7) What is the use of functions? Write the general syntax of a JavaScript function

34. (TCOs 1, 2, and 3) What are six tips for creating effective links?

35. (TCO 9) There are two main, significant problems with HTML that led to the development of XHTML. Explain both of these

36. (TCOs 5 and 6). What is the MIDI format? What are the advantages and disadvantages of MIDI?

more...
No comment yet.
Scooped by CeliaAlexander
Scoop.it!

CIS 336 Final Exam (Set 3)

http://www.devryexams.com/product/cis-336-final-exam-set-3/

CeliaAlexander's insight:

http://www.devryexams.com/product/cis-336-final-exam-set-3/

 

1. (TCO 2) Explain what physical independence means

2. (TCO 8) Sally wants to query the EMP table and determine how many of the employees live in each of the cities the company has factories in. She writes the following query but it does not work. What is wrong with the way the query is constructed?

3. (TCO 3) Explain in what two specific cases presented in the text composite primary keys are particularly useful.

4. (TCO 7) How are comparisons done on character string data in a queries WHERE clause, and why would this be especially useful in comparing certain attributes?

6.  (TCO 6) Oracle will not allow the changing of a column’s data type unless the column is empty, and even then it may still be prohibited. Discuss why?

1. (TCO 7) Write a join query using NATURAL JOIN that for every order in the ORDERS table will list the order number and order date along with the cusnumber, last name, and first name of the customer who placed the order.

2. (TCO 8) Write a query that will list the part number, part description, and on-hand value (units on hand * unit price) for each part in item class AP. Give the expression an alias of “On Hand Value”.

3. (TCO 8) Write a query that will display the customer number, first name, and last name for every customer with a balance greater than $50. Display the first and last name as a single column and provide an alias for the column

4. (TCO 7) Write a query that will list the customer number, last name, and first name for every customer represented by sales rep 03 or sales rep 12

5. (TCO 7) Write a query that will list the customer first and last name and the sales rep commission rate using JOIN ON

more...
No comment yet.
Scooped by CeliaAlexander
Scoop.it!

CIS 336 Final Exam

http://www.devryexams.com/product/cis-336-final-exam/

CeliaAlexander's insight:

http://www.devryexams.com/product/cis-336-final-exam/

 

1. (TCO 1) Most DBMS are referred to as _____________database management systems.

2. (TCO 1) Data constitutes the building blocks of _____________.

3. (TCO 2) If a foreign key contains either matching values or nulls, the table(s) that make use of such a foreign key is/are said to exhibit __________ integrity

4. (TCO 2) In a “one-to-many” relationship, which constraint is usually added to the “many” table?

5. (TCO 3) A ____ occurs when a relationship is improperly or incompletely identified and, therefore, is represented in a way that is not consistent with the real world

6. (TCO 3) All of the following are true about a prime attribute except_____________.

7. (TCO 3) The conflicts between design efficiency, information requirements, and processing speed are often resolved through_____________.

8. (TCO 4) When a constraint is created at the ______ level with the CREATE TABLE command, the constraint definition is simply included as part of the column definition

1. (TCO 4) In Oracle, the CONSTRAINT clause is used to ___________________.

2. (TCO 4) The SQL command that lets you list the table contents is

3. (TCO 5) The Crow’s Foot model is more ___________-oriented than the Chen model

4. (TCO 5) The ___________ model is both software and hardware dependent

5. (TCO 6) Which of the following commands will add a new column named FIRSTORDERDATE to the CUSTOMERS table to store the date that the customer first placed an order with the company

6. (TCO 6) When modifying the data characteristics of a column in Oracle, which of the following is correct

7. (TCO 6) Which of the followig SQL commands would alter the table DEVRY and add a foreign key that references the CITY table?

8. (TCO 7) Given a table named EMPLOYEE, the SQL command to sort records in a specific order would be

1. (TCO 7) Which of the following subqueries returns more than one row of results to the outer query?

2. (TCO 7) Which of the following keywords can be used to join two tables that do not contain a commonly named and defined column?

3. (TCO 8) Based upon the contents of the BOOKS table shown below, which of the following SQL statements will return the number of categories contained in the table?

4. (TCO 8) The _____________ function can be used to display upper-case characters in lower-case

5. (TCO 8) Which of the following statements will produce the value 21.1?

6. (TCO 9) The column to be updated by the UPDATE command is specified in the ______ clause

7. (TCO 9) If the INSERT INTO command is used to insert data values that violate an existing constraint in a table, which of the following will happen

8. (TCO 10) Which of the following commands is used to establish a user account

9. (TCO 10) Which command will grant a system privilege to a user?

more...
No comment yet.
Scooped by CeliaAlexander
Scoop.it!

COMP 230 Final Exam

http://www.devryexams.com/product/comp-230-final-exam/

CeliaAlexander's insight:

http://www.devryexams.com/product/comp-230-final-exam/

 

1. (TCO 7) The general syntax of an SQL select statement is _____.

2. (TCO 7) In a VBScript SQL Query statement, what Boolean operator can be used to test a set of conditions whereby all conditions must be true?

3. (TCO 7) The _____ in a table is the column that makes each record different from all others

4. (TCO 7) What task(s) are involved in designing a database table?

5. (TCO 1) Which of the following Windows commands will shutdown and restart the computer FileServer in 2 minutes?

6. (TCO 1) Which Windows shutdown command switch is used to shutdown and turn off a local or a remote computer?

7. (TCO 1) Which one of the following Windows NET commands options is not used to control services with the NET ?????ServiceName?

8. (TCO 1) The NETSH command that will set the IP address of the interface name NIC to a DHCP-supplied IP address is _____.

9. (TCO 6) The following VBScript statement will open a text file

10. (TCO 6) In creating a VBScript Scripting.FileSystemObject, you must start the code line with

11. (TCO 6) The following VBScript statement will open a text file.

12. (TCO 2) What is the problem with the following statement? average = (60 + 75) /100

13. (TCO 2) What is the multiplication operator?

14. (TCO 2) What is the assignment operator?

15. (TCO 2) What is the best choice for a variable name representing an interest rate

16. (TCO 2) If a variable holds the value “Ferrari,” what is its data type?

17. (TCO 5) In what way do VBScript named constants differ from variables?

18. (TCO 5) Variables declared in the main section of a VBScript program have what scope?

19. (TCO 3) What characters can be used to force operator precedence?

20. (TCO 3) What produces the same result as the following pseudocode?

21. (TCO 3) What VBScript Boolean operator could be used to replace the nested selection structure in this pseudocode?

22. (TCO 3) In VBScript, when you combine Boolean operators, the _____ operators take precedence, meaning their values are evaluated first

23. (TCO 3) A decision that is inside of another decision is known as a _____ decision

24. (TCO 4) What is the problem with the following VBScript Do While loop?

25. (TCO 4) The number of elements in an array is called the _____ of the array

26. (TCO 4) How many times will the following VBScript Do While loop execute the loop body?

27. (TCO 4) VBScript arrays are most efficiently processed using _____.

28. (TCO 4) In VBScript, the array declaration dim data(10) indicates the array data can have a maximum of _____ elements or components

1. (TCO 1) Write the Windows CLI commands that will Clear the screen; Turn off Command echo; and display the current IP address, Subnet Mask, and Default Gateway

2. (TCO 1) Write the Windows CLI NET commands that will turn the Spooler service OFF and then ON

3. (TCO 2) Write the VBScript code lines that define a constant TAXRATE that is 25%, a variable basePay that is $1000, and a variable bonusPay that is $500. Calculate the net pay, and assign that value to netPay. Then, calculate the taxes, and assign that value to taxWithheld

4. (TC0 3) Given the variables hoursWorked and payRate, write the VBScript code that will calculate grossPay such that all hoursWorked 40 will be paid at time and a half

1. (TCO 4) Write the VBScript code that uses a Do Until loop to display all of the integer values stored in the array numArray(100)

2. (TCO 5) Write a VBScript function called MaxNum that accepts two numbers and returns the largest to the two numbers

3. (TCO 6) Write the VBScript code that defines the Scripting.FileSystemObject and the file C:\Data\DataFile.txt for writing. Make sure the file will be created if it doesn’t exist, and ensure that the format is ASCII

4. (TCO 7) Assuming that you are connected to a database called Computers.mdb with the fields Computer, Hostname Room_Num, CPU_Type, Num_CPUs, Bit_Size, OS_Type, Memory, Speed and HDD_Size, write the SQL Query String sqlStr such that all the fields will be displayed for the records that indicate a speed less than two and a memory value less than four. The returned records should be sorted by Room_Num

 

more...
No comment yet.
Scooped by CeliaAlexander
Scoop.it!

COMP 129 Final Exam

http://www.devryexams.com/product/comp-129-final-exam/

CeliaAlexander's insight:

http://www.devryexams.com/product/comp-129-final-exam/

 

1. (TCO 1) The HAL and executive services are elements of the __________.

2. (TCO 1) Information on installed hardware, software, system configuration, and current running programs can be accessed using ________.

3. (TCO 2) The ____ is a measure of resistance to electricity

4. (TCO 2) A system might have up to ____ types of ribbon cables

5. (TCO 2) When should a soft boot be used on your computer?

6. (TCO 3) What type of RAM do most motherboards use today?

7. (TCO 3) To help secure a computer, you can set a startup or “power-on” password so that the startup BIOS will ask for the password during the boot process. This password is stored in _______.

8. (TCO 3) The term form factor in regards to a motherboard refers to the ______ layout of the components on the board

9. (TCO 9) When you first purchase a notebook, make sure you have a ____ CD containing the installed OS so you can recover from a failed hard drive

10. (TCO 9) ____ let you specify which devices are to be loaded on startup for a particular user or set of circumstances

11. (TCO 9) What types of SO-DIMMS can NOT be used in a notebook PC?

12. (TCO 4) The sector on the disk drive that keeps track of the location of where the partitions are located is called the ___________.

13. (TCO 4) What is the minimum amount of RAM required for a Windows 7 installation?

14. (TCO 4) What is the minimum processor speed required for a Windows 7 installation?

15. (TCO 7) Normally, the name of the access point (called the ____) is broadcast so that anyone with a wireless computer can see the name and use the network

16. (TCO 7) This command allows you to find a NIC Card’s IP Address

17. (TCO 7) For dynamic IP addressing, if the PC cannot reach the ____ server, then it assigns itself an IP address.

18. (TCO 6) A _____ is a USB device replacing floppies as a means of transporting data from one computer to another

19. (TCO 6) The connector on a video card that has fifteen connectors in three rows is used for _____.

20. (TCO 6) Some storage devices use memory chips to store data instead of spinning disks. Examples include which of the following

21. (TCO 6) Another name for a FireWire port is ____ port

22. (TCO 5) A(n) ______ allows you to set up a second operating system without disturbing the existing operating system

(TCO 5) What is the minimum hard drive size for Windows Vista?

more...
No comment yet.
Scooped by CeliaAlexander
Scoop.it!

CIS 407 Final Exam

http://www.devryexams.com/product/cis-407-final-exam/

CeliaAlexander's insight:

http://www.devryexams.com/product/cis-407-final-exam/

 

1. (TCO 1) In order to design Web forms in Visual Studio.NET, we use the _______.

2. (TCO 1) Many of the Web server controls have a _______ menu, which allows developers options to perform common tasks and settings

3. (TCO 1) The starting page for the website can be changed by _______.

4. (TCO 2) _______ allow users to select controls by keyboard shortcuts

5. (TCO 2) You can use the ________ to specify the maximum amount of characters that can be entered in a textbox

6. (TCO 2) The CheckedChanged Event for a radio button occurs _________.

7. (TCO 3) You can use ________ to track the state of each user in the application.

8. (TCO 3) The ________ control displays the navigation as menu options

9. (TCO 3) ________ variables are maintained while the browser is opened

10. (TCO 4) To create an SQLDataSource from the Designer, developers can _______.

11. (TCO 5) _______ is the ability for the GridView to display data one page at a time.

12. (TCO 5) The ________ layer is used to contain the data for the application.

13. (TCO 6) Transaction objects in .NET contain methods to

14. (TCO 6) _________ starts the transaction process

15. (TCO 6) _________ reverts the changes in the database

16. (TCO 6) _________, in transaction processing, means that managed resources survive failures

1. (TCO 7) You need _______ in order to add one or more Views to a control

2. (TCO 7) A _________ control can be implemented to allow users to step through a process

3. (TCO 7) The _________ part of ASP.NET Web pages can contain a combination of Web controls, user controls, and HTML syntax

4. (TCO 9) SMTP sends e-mails in _______ format.

5. (TCO 9) A _______ is a web page that can be easily customized by users.

6. (TCO 9) The ________ file controls the configuration of the ASP.Net Web application.

7. (TCO 1) An absolute URL is _______.

8. (TCO 1) When you bind a dropdown list to a data grid, the system will _______.

9. (TCO 1) A _________ is a website that is located on your local computer

10. (TCO 2) You can use the ________ to specify the maximum amount of characters that can be entered in a textbox

11. (TCO 2) The CheckedChanged Event for a radio button occurs _________.

12. (TCO 2) The Rows and SelectionMode properties apply to _______.

13. (TCO 3) You can use ________ to track the state of each user in the application

14. (TCO 3) ________ values are stored in the memory of the ASP.NET process.

15. (TCO 9) In IIS, you can create a _____ directory, which points to a location other then (THAN) the directory you create for the project

1. (TCO 1) Describe three components found in the Application Layer

2. (TCO 2) Describe one item that needs to be kept in mind when designing web forms for the Presentation Layer of an N-Tier Architecture

3. (TCO 3) Describe the ASP.NET session state object and give one example of what it can be used for in a web application

4. (TCO 4) Describe two advantages of using stored procedures instead of inline SQL.

5. (TCO 5) List the seven general steps involved in creating a Web-based data-driven application that uses a bound control to display data from a database

more...
No comment yet.
Scooped by CeliaAlexander
Scoop.it!

CIS 336 Final Exam (Set 2)

http://www.devryexams.com/product/cis-336-final-exam-set-2/

CeliaAlexander's insight:

http://www.devryexams.com/product/cis-336-final-exam-set-2/

 

1. (TCO 1) Most DBMS are referred to as _____________database management systems.

2. (TCO 1) A relational DBMS provides protection of the _______________________ through security, control, and recovery facilities.

3. (TCO 2) If a foreign key contains either matching values or nulls, the table(s) that make use of such a foreign key is/are said to exhibit __________ integrity.

4. (TCO 2) A field that consists of integer values is a _________ type field.

5. (TCO 3) The PK must uniquely identify each entity instance. A primary key must be able to guarantee unique values. It cannot contain nulls. This rationale belongs to ____.

6. (TCO 3) A table that is in 1NF and includes no partial dependencies only is said to be in_____________.

7. (TCO 3) A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key, is said to be in_____________.

8. (TCO 4) In Oracle, the DEFAULT constraint is used to ____________________.

1. (TCO 4) Which of the following is not considered a database object

2. (TCO 4) Which of the following SQL statements would you use to create a table named DEVRY?

3. (TCO 5) The ____ constraint requires that a specific condition be met before a record can be added to a table

4. (TCO 5) The ___________ model is both software and hardware dependent

5. (TCO 6) The _________________________ statement can be used to enable or disable a constraint

6. (TCO 6) When using the ALTER TABLE…DROP COLUMN command, which of the following is not correct?

7. (TCO 6) Which of the following keywords can be used to change the size, datatype, and/or default value of an existing column?

8. (TCO 7) Any type of subquery can be used in the _________ clause of a SELECT statement

1. (TCO 7) Using the BOOK_CUSTOMER and BOOK_ORDER tables shown below for references, which SQL statement will return the same results as the following SQL statement?

2. (TCO 7) If a Cartesian join is used to link table A which contains five rows to table B which contains eight rows, there will be _______ rows in the results

3. (TCO 8) Based upon the contents of the BOOK_ORDER table shown below, which of the following SQL statements will display the ship date for order 1006 as April 2, 2002?

4. (TCO 8) Based upon the contents of the BOOK_ORDER table shown below, which of the following SQL statements will display only those orders shipped to the zip code zone that begins with 323

5. (TCO 8) Which of the following functions determines the number of characters in a character string?

6. (TCO 9) Which of the following is not a valid SQL command?

7. (TCO 9) Using the promotion table shown below, which of the following SQL statements will insert a new row into the PROMOTION table?

8. (TCO 10) A ____ is a uniquely identifiable object that allows a given person to log on to the database

9. (TCO 10) Which command will delete a user account from Oracle9i?

1. (TCO 2) What is Character data?

2. (TCO 3) Explain the term “second normal form”.

3. (TCO 7) Sally needs to find all employees who have a date-of-hire between 01-JAN-2003 and 01-JAN-2005. She writes and executes the following query:

4. (TCO 8) In using group functions we cannot place a group function in a WHERE clause. Explain how the WHERE clause and HAVING clause are similar and why you can use the HAVING with a group function but not a WHERE clause

5. (TCO 6) Write the SQL statement that will remove the database table EMPLOYEE

1. (TCO 7) Write a join query using NATURAL JOIN that for every order in the ORDERS table will list the order number and order date along with the cusnumber, last name, and first name of the customer who placed the order.

2. (TCO 8) Write a query that will list the part number, part description, and on-hand value (units on hand * unit price) for each part in item class AP. Give the expression an alias of “On Hand Value”.

3. (TCO 8) Write a sub query that will list the part number, part description, and units on hand of all parts where the number of units on hand is greater than the average of units on hand for all parts.

4. (TCO 7) Using the BETWEEN operator, write a query that will list all details about all orders that were placed during the period of September 3rd thru September 5th of 1998.

5. (TCO 7) Write a query that will list the part number and part description for all parts in the PART table.

more...
No comment yet.
Scooped by CeliaAlexander
Scoop.it!

BUSN 427 Final Exam

http://www.devryexams.com/product/busn-427-final-exam/

CeliaAlexander's insight:

http://www.devryexams.com/product/busn-427-final-exam/

 

(TCO 1) Which are factors that move the world toward more globalization?

(TCO 2) What is the difference between communists and social democrats?

(TCO 3) What is probably more important than culture in explaining the differences in economic growth between countries?

(TCO 3) Which theory deals with competitive advantage for countries?

(TCO 4) FDI tends to flow

(TCO 5) Which of the following is not a member of the Asia-Pacific Economic Cooperative?

(TCO 6) What common good is used in most nations to create an index for measuring purchase power parity in various nations?

(TCO 8) What are the various types of countertrade available?

(TCO 8) In distribution strategy, what are the four main differences between countries?

(TCO 3) When McDonald’s initially entered China, it was confident that its success in other parts of the world would facilitate its success in China, but they quickly found out that the relationships and connections implied by guanxi are an essential to business success in China. McDonald’s lost an attractive store location near Tiananmen Square to a Hong Kong developer who, thanks to relationships and connections developed over the years, was able to persuade city officials to overlook the lease McDonald’s held for the property.

Explain the concept of guanxi. Why is it so important to businesses operating in China? How did McDonald’s lack of guanxi raise its costs of doing business in China?

(TCO 3) In 2006, two Chinese journalists reported that the working conditions at Hongfujin Precision Industries where Apple’s iPods are produced were substandard. According to the report, not only were workers at the plant poorly paid, but they were also forced to work overtime. Apple immediately responded to the allegations and audited the factory in question. However, managers at the factory filed a defamation lawsuit against the two journalists. Despite the fact that Apple’s audit did indeed show substandard working conditions at the factory, Hongfujin did not withdraw the lawsuit. Eventually the Reporters Without Borders group took up the case for the two reporters and the lawsuit was dropped.

Should Apple be responsible for ensuring that its suppliers are safeguarding the basic rights and dignity of its employees? How can Apple be sure that its suppliers do not employ sweatshop labor?

(TCO 3) Exports are largely responsible for China’s recent rapid economic growth. The country, capitalizing on its cheap labor force, has focused on converting raw materials into products that are exported to developed countries such as the United States. In 2008, China’s trade surplus was a record $280 billion, and its holdings of foreign exchange reserves were over $1.95 trillion. Some critics have suggested that China is following a neomercantilist policy.
Are the claims that China is following a neomercantilist policy valid? Why or why not?

(TCO 4) For years, Japan has been relatively closed to significant foreign direct investment, but more recently the government has changed its policy and actually now encourages inward investment. Wal-Mart, taking advantage of this shift in policy, acquired a large Japanese retailer in 2002. Wal-Mart’s initial venture into Japan has been challenging and has forced the company to change its approach to better compete with local retailers and meet the needs of Japanese consumers.

Why did Japan change its position on inward foreign direct investment? How will Wal-Mart’s investment benefit Japan?

(TCO 7) Which of the following are true about the International Monetary Fund?

(TCO 5) Concerning European Union’s progress toward creating a single financial market, the quest started in 1999 was to have been completed by 2005, however, progress has been slowed by various factors related to the tradition of each member country operating autonomously. By 2007, significant progress had been made. Some 41 measures designed to create a single market were in place and others were in the pipeline. The current issue facing the EU revolves around the enforcement of the rules that have been established as law. Some experts believe that it will be at least another decade before the benefits of the new rules become apparent. Discussion of this feature can begin with the following questions.
What are the benefits of creating a single financial market in the European Union for companies? Does it make sense for consumers?

(TCO 6) In the 1980s, Caterpillar was negatively affected by a strong dollar and lost significant market share to Japanese competitor Komatsu. The situation prompted Caterpillar to revise its global strategy and by the 2000s, the company was in a much better position to deal with volatile currency values. More recently, a strong dollar has actually helped boost Caterpillar’s bottom line.

In the 1980s, a stronger dollar hurt Caterpillar’s competitive position, but in 2008 a stronger dollar did not seem to have the same effect. What had changed?

(TCO 7) After joining the European Union in 2004, Latvia established a currency board system that pegged the value of its currency to the euro. This system came under significant pressure when the effects of the financial crisis that began in the United States in 2008 spilled over into the country. Latvia was eventually forced to ask the International Monetary Fund and the European Union for assistance in order to get its financial system and economy back on track. As part of the assistance package, Latvia was required to make significant changes in its economic policy.

Why did the initial effort by Latvia’s government to stabilize the country’s currency fail? Was the government attempting to stop a banking crisis or a foreign debt crisis?

(TCO 8) Vellus Products is a small company that produces personal care products for dogs. Vellus Products initially began exporting when a Taiwanese business placed an order for its dog shampoo. Since then, Vellus Products has expanded its export business and today, international sales account for about half its total sales. Vellus Products now sells in 28 countries around the world.

Can other small companies learn from the experiences of Vellus Products? Reflect on the tips of Vellus Products’ founder Sharon Doherty for beginning the export process.

(TCO 8) By 2012, India is expected to export half a million vehicles a year. South Korea’s Hyundai is leading the charge, exporting over one third of its Indian production. Suzuki and Nissan have both entered the Indian market more recently. Both companies see the Indian market as an important component in their future production and marketing strategies.
Why did Hyundai and other global automakers choose India as a production location? What makes India attractive to auto producers?

(TCO 8) Microsoft is meeting the challenges of expanding into the potentially lucrative Indian market, a market where currently most people cannot afford a computer nor the Microsoft programs to run it. Microsoft has changed its highly standardized approach to markets to develop products specifically designed to meet the needs of the Indian market. In addition, the company has established local R & D operations that it hopes will generate new products for the market.
How does Microsoft vary the marketing mix of its existing product offerings to gain traction with Indian customers? What else has Microsoft done to make headway in India?

more...
No comment yet.