Organizations can collect many types of data from a wide variety of sources, but typically they only collect structured data that fits neatly into traditional relational database management systems.

A(n) _____ is a field or set of fields in a record that uniquely identifies the record.

87271 primary key primary key primary key primary key exact_answer none 27827476 87271 margin of error +/-

As this is your first job working with databases, your manager wants you to familiarize yourself with all of the tables in the database. Therefore, he asks you to produce a query for each table that displays all of the columns (fields) and all of the rows (records) using a separate SELECT query for each table. Write a SQL query to display all the data in the Categories table. Run the query and answer the following questions. In answering these question you must provide the responses exactly as they appear in the results. These are Case Sensitive. For example, if the field name is FirstName that is the only correct answer. (First Name, firstname, Firstname are all incorrect) What is the Number of Records: Reading from left to right--the first field name is: Reading from left to right--the second field name is: Reading from left to right--the last field name is

8
CategoryID
CategoryName
Description

Your boss wants to know the total quantity of Boston Crab Meat that has ever been ordered. [Hint: You will have to join the OrderDetails and Products tables. Your WHERE clause should contain the criterion ProductName = "Boston Crab Meat", and you will have to use the SUM function in your SELECT clause.] How many records did your query reveal?

As this is your first job working with databases, your manager wants you to familiarize yourself with all of the tables in the database. Therefore, he asks you to produce a query for each table that displays all of the columns (fields) and all of the rows (records) using a separate SELECT query for each table. Write a SQL query to display all the data in the OrderDetails table. Run the query and answer the following questions. In answering these question you must provide the responses exactly as they appear in the results. These are Case Sensitive. For example, if the field name is FirstName that is the only correct answer. (First Name, firstname, Firstname are all incorrect) What is the Number of Records: Reading from left to right--the first field name is: Reading from left to right--the second field name is: Reading from left to right--the last field name is

518
OrderDetailID
OrderID
Quantity

A database is a collection of integrated and related _____.

98711 fields fields fields fields exact_answer none 27692836 98711 margin of error +/-
7925 attributes attributes attributes attributes exact_answer none 27692836 7925 margin of error +/-
66624 records records records records exact_answer none 27692836 66624 margin of error +/-
57045 files files files files exact_answer none 27692836 57045 margin of error +/-

As this is your first job working with databases, your manager wants you to familiarize yourself with all of the tables in the database. Therefore, he asks you to produce a query for each table that displays all of the columns (fields) and all of the rows (records) using a separate SELECT query for each table. Write a SQL query to display all the data in the Productss table. Run the query and answer the following questions. In answering these question you must provide the responses exactly as they appear in the results. These are Case Sensitive. For example, if the field name is FirstName that is the only correct answer. (First Name, firstname, Firstname are all incorrect) What is the Number of Records: Reading from left to right--the first field name is: Reading from left to right--the third field name is: Reading from left to right--the last field name is

77

As this is your first job working with databases, your manager wants you to familiarize yourself with all of the tables in the database. Therefore, he asks you to produce a query for each table that displays all of the columns (fields) and all of the rows (records) using a separate SELECT query for each table. Write a SQL query to display all the data in the OrderDetails table. Run the query and answer the following questions. In answering these question you must provide the responses exactly as they appear in the results. These are Case Sensitive. For example, if the field name is FirstName that is the only correct answer. (First Name, firstname, Firstname are all incorrect) What is the Number of Records: Reading from left to right--the first field name is: Reading from left to right--the second field name is: Reading from left to right--the last field name is

518
OrderDetailID
OrderID
Quantity

The Accounting department manager requests a list of all of the suppliers, contacts, and phone numbers of the suppliers in Japan How many records did your query reveal?

To double check your results from the previous question, you decide to run a query that returns all of the rows and columns from the Orders table sorted in descending order. If you see that the order ID of the first record in your output equals the answer you obtained in your previous question, you know you were correct. How many records did your query reveal?

As this is your first job working with databases, your manager wants you to familiarize yourself with all of the tables in the database. Therefore, he asks you to produce a query for each table that displays all of the columns (fields) and all of the rows (records) using a separate SELECT query for each table. Write a SQL query to display all the data in the Productss table. Run the query and answer the following questions. In answering these question you must provide the responses exactly as they appear in the results. These are Case Sensitive. For example, if the field name is FirstName that is the only correct answer. (First Name, firstname, Firstname are all incorrect) What is the Number of Records: Reading from left to right--the first field name is: Reading from left to right--the third field name is: Reading from left to right--the last field name is

77
ProductID
SupplierID
Price

As this is your first job working with databases, your manager wants you to familiarize yourself with all of the tables in the database. Therefore, he asks you to produce a query for each table that displays all of the columns (fields) and all of the rows (records) using a separate SELECT query for each table. Write a SQL query to display all the data in the Suppliers table. Run the query and answer the following questions. In answering these question you must provide the responses exactly as they appear in the results. These are Case Sensitive. For example, if the field name is FirstName that is the only correct answer. (First Name, firstname, Firstname are all incorrect) What is the Number of Records: Reading from left to right--the first field name is: Reading from left to right--the third field name is: Reading from left to right--the last field name is

29
SupplierID
ContactName
ContactName

As this is your first job working with databases, your manager wants you to familiarize yourself with all of the tables in the database. Therefore, he asks you to produce a query for each table that displays all of the columns (fields) and all of the rows (records) using a separate SELECT query for each table. Write a SQL query to display all the data in the Orders table. Run the query and answer the following questions. In answering these question you must provide the responses exactly as they appear in the results. These are Case Sensitive. For example, if the field name is FirstName that is the only correct answer. (First Name, firstname, Firstname are all incorrect) What is the Number of Records: Reading from left to right--the first field name is: Reading from left to right--the third field name is: Reading from left to right--the last field name is

196
OrderID
EmployeeID
ShipperID

A database is a collection of integrated and related _____.

98711 fields fields fields fields exact_answer none 27692836 98711 margin of error +/-
7925 attributes attributes attributes attributes exact_answer none 27692836 7925 margin of error +/-
66624 records records records records exact_answer none 27692836 66624 margin of error +/-
57045 files files files files exact_answer none 27692836 57045 margin of error +/-

As this is your first job working with databases, your manager wants you to familiarize yourself with all of the tables in the database. Therefore, he asks you to produce a query for each table that displays all of the columns (fields) and all of the rows (records) using a separate SELECT query for each table. Write a SQL query to display all the data in the Customers table. Run the query and answer the following questions. In answering these question you must provide the responses exactly as they appear in the results. These are Case Sensitive. For example, if the field name is FirstName that is the only correct answer. (First Name, firstname, Firstname are all incorrect) What is the Number of Records: Reading from left to right--the first field name is: Reading from left to right--the third field name is: Reading from left to right--the last field name is

91
CustomerID
ContactName
Country

Speedy Express, one of your shippers, wants to know how many orders it has ever shipped for you. [Hint: You need to join the Shippers and Orders tables and include ShipperName = "Speedy Express" in the WHERE clause. Remember to use an aggregate operator to receive full credit for this question.] How many records did your query reveal?

The manager of Human Resources wants a list of all of the employees who work at the company. He only wants to see the employees’ last name and first name. [You may assume that everyone who works at the company is included in the Employees table]. How many records did your query reveal?

Just out of curiosity, you want to produce a listing of the products (product name only) that are supplied by SupplierID 1 and are in CategoryID 1. How many records did your query reveal?

Your manager asks you for a list of the product names that the company sells. He does not want everything related to each product – only each product’s name. He wants them sorted alphabetically (in descending order from Z-A). [The Products table contains all of the products that are sold by the company.] How many records did your query reveal?

One of the employees in the IT department asks for the highest order ID that is in the Orders table. [Hint: To receive credit for this question, you must use the MAX function to perform this task.] How many records did your query reveal?

The Human Resources department requests a list that contains the number (i.e. count) of orders taken on each date, grouped by the order date. [Be sure to use an aggregate operator in your query to receive credit for this question.] How many records did your query reveal?

Speedy Express, one of your shippers, wants to know how many orders it has ever shipped for you. [Hint: You need to join the Shippers and Orders tables and include ShipperName = "Speedy Express" in the WHERE clause. Remember to use an aggregate operator to receive full credit for this question.] How many records did your query reveal?

As this is your first job working with databases, your manager wants you to familiarize yourself with all of the tables in the database. Therefore, he asks you to produce a query for each table that displays all of the columns (fields) and all of the rows (records) using a separate SELECT query for each table. Write a SQL query to display all the data in the Suppliers table. Run the query and answer the following questions. In answering these question you must provide the responses exactly as they appear in the results. These are Case Sensitive. For example, if the field name is FirstName that is the only correct answer. (First Name, firstname, Firstname are all incorrect) What is the Number of Records: Reading from left to right--the first field name is: Reading from left to right--the third field name is: Reading from left to right--the last field name is

29

As this is your first job working with databases, your manager wants you to familiarize yourself with all of the tables in the database. Therefore, he asks you to produce a query for each table that displays all of the columns (fields) and all of the rows (records) using a separate SELECT query for each table. Write a SQL query to display all the data in the Orders table. Run the query and answer the following questions. In answering these question you must provide the responses exactly as they appear in the results. These are Case Sensitive. For example, if the field name is FirstName that is the only correct answer. (First Name, firstname, Firstname are all incorrect) What is the Number of Records: Reading from left to right--the first field name is: Reading from left to right--the third field name is: Reading from left to right--the last field name is

196

Another customer calls in requesting all of your seafood products. Note that he only wants the name of the product in his report – not all of the fields. [Hint: You will need to join the Products table to the Categories table to get this information. Your WHERE clause should include the criterion “WHERE CategoryName = "Seafood".] How many records did your query reveal?

As this is your first job working with databases, your manager wants you to familiarize yourself with all of the tables in the database. Therefore, he asks you to produce a query for each table that displays all of the columns (fields) and all of the rows (records) using a separate SELECT query for each table. Write a SQL query to display all the data in the Customers table. Run the query and answer the following questions. In answering these question you must provide the responses exactly as they appear in the results. These are Case Sensitive. For example, if the field name is FirstName that is the only correct answer. (First Name, firstname, Firstname are all incorrect) What is the Number of Records: Reading from left to right--the first field name is: Reading from left to right--the third field name is: Reading from left to right--the last field name is

91

The president of the company wants a list of all orders ever taken. He wants to see the customer name, the last name of the employee who took the order, the shipper who shipped the order, the product that was ordered, the quantity that was ordered, and the date on which the order was placed. [Hint: You will need to join the following tables: Customers, Employees, Shippers, Orders, OrderDetails, Products, and to get all of the necessary information.] How many records did your query reveal?

A customer calls in and wants a list of all of your products and their prices. Your results should be sorted in alphabetical order from A-Z. How many records did your query reveal?

The Accounts Receivable clerk needs a list of all the customers (including customer names, addresses, city, country, and postal codes) who are located in Germany, France, or Spain. [Hint: You must use the IN operator in your WHERE clause to receive credit for this question.] How many records did your query reveal?

Your friend has a Mac that runs OS X. If she needs to run a Windows app on it, she can set it to run Windows also.

53947 True True exact_answer none 27580710 53947 margin of error +/-

An example of a common hardware function performed by the operating system is presenting information on a monitor or printer.

93454 True True exact_answer none 27528853 93454 margin of error +/-

All of the following are examples of someone using personal productivity software EXCEPT _________.

70464 Callie entering a customer's order into a restaurant's ordering system Callie entering a customer's order into a restaurant's ordering system Callie entering a customer's order into a restaurant's ordering system Callie entering a customer's order into a restaurant's ordering system exact_answer none 27528947 70464 margin of error +/-

The _____ is the heart of the operating system and controls its most critical processes.

74236 kernel kernel kernel kernel exact_answer none 27528857 74236 margin of error +/-

On a modern home computer, one can set up accounts for many users and be able to control what resources a user may access.

44198 True True exact_answer none 27528851 44198 margin of error +/-

Operating systems provide a measure of security by allowing users to access to those resources they've been cleared to use as well as other users' resources if those resources are beneficial.

70995 False False exact_answer none 27699689 70995 margin of error +/-

The _____ is the heart of the operating system and controls its most critical processes.

74236 kernel kernel kernel kernel exact_answer none 27528857 74236 margin of error +/-

New cars come with an onboard computer that controls anti-lock brakes, air bag deployment, fuel injection, etc. The software is known as ____.

60007 an embedded system an embedded system an embedded system an embedded system exact_answer none 27580122 60007 margin of error +/-

Symbian is an operating system used in special-purpose computers.

52476 True True exact_answer none 27528940 52476 margin of error +/-

One of the advantages of off-the-shelf software is that ________________.

9286 the initial cost is lower because the software firm can spread the development costs over many customers the initial cost is lower because the software firm can spread the development costs over many customers the initial cost is lower because the software firm can spread the development costs over many customers the initial cost is lower because the software firm can spread the development costs over many customers exact_answer none 27528860 9286 margin of error +/-

You cannot boot a computer from ____________.

79228 a wireless network a wireless network a wireless network a wireless network exact_answer none 27699656 79228 margin of error +/-

An operating system with _____ capabilities allows a user to run more than one program concurrently.

74459 multitasking multitasking multitasking multitasking exact_answer none 27699588 74459 margin of error +/-

The primary function of application software is to apply the power of the computer to enable people, workgroups, and the entire enterprise to solve problems and perform specific tasks.

43321 True True exact_answer none 27568882 43321 margin of error +/-

Proprietary software is mass-produced by software vendors to address needs that are common across businesses, organizations, or individuals.

33294 True True exact_answer none 27528852 33294 margin of error +/-

When an organization hires another firm in another country to perform a specific function on its behalf, it is known as offshoring.

True

When an organization hires another firm in another country to perform a specific function on its behalf, it is known as offshoring.

True

The role of a systems analyst is narrowly defined and seldom involves communications with others.

False

Disk mirroring is a method of storing data that generates extra bits of data from existing data, allowing the system to create a "reconstruction map" so that if a hard drive fails, it can rebuild lost data.

False

For someone to be a good CIO, technical ability is the most important characteristic.

False

When organizational learning occurs, what is revealed can be small, incremental adjustments known as continuous improvement.

True

In most large organizations, the IS department is divided into the following functions __________.

operations, development, and support

All of the following are potential drawbacks to outsourcing EXCEPT:

greater focus on core business

In a supply chain, _____ involve the transformation, movement, and storage of supplies and raw materials.

physical flows

According to Lewin's Change Model, an organization must deliberately change old habits, learn new work methods, and accept the new work methods as parts of the job.

True

You might be an information systems worker if you _________.

enjoy learning new techniques and enjoy working with people

_____ is a visa program that allows skilled employees from foreign lands into the United States.

H-1B

The need for additional data storage capacity is one of the factors driving the growth in data centers.

True

To date, semiconductor fabricators have been able to make ICs (integrated circuits) that hold up to several million electronic components in an area the size of a fingernail.

True

Carson's supervisor has asked him to review a variety of portable computers for possible purchase for their company's employees. Which of the following should Carson NOT consider buying?

nettops

A friend's computer came with Windows 8 operating system. Which of the following years was the computer most likely bought in?

2012

Thin client computers are a type of portable single-user computers.

False

_____ are used in standardized tests, including the SAT and GMAT tests, and to record votes in elections.

Optical mark recognition (OMR) systems

Helen is 72 years old and is a retired school teacher on a fixed income. She would like to buy a new computer so that she can communicate via email, follow friends and family on social media, and occasionally access recipes and gardening tips from the Web. An important thing to consider is that Helen has arthritis in her hands, making it difficult for her to work with small buttons and gadgets. So, of the following options, her best choice is probably a(n) ________.

desktop

When choosing from various types of flat panel display, choose _______ for low power consumption.

light-emitting diode (LED)

_____ is an example of a popular general purpose software suite for personal computer users.

Microsoft Office

Each programming language has a set of rules, called the program code of the language.

False

When making hardware decisions, the overriding considerations of a business should be technology cost and currency.

False

Cache memory is available in two forms: level 1, which is found on the CPU chip, and level 2, which can be accessed over a high-speed dedicated interface.

True

To develop software you need all these except ________.

personal application software

Symbian is an operating system used in special-purpose computers.

False

An information system that operates in the _____ sphere of influence supports two or more people who work together to achieve a common goal.

workgroup

Suppose a business wishes to move away from hosting its own applications, the recommended solution is to use ______.

cloud computing
software as a service

A personal area network (PAN) is a wireless network that connects information networking devices within a small area, such as an office, home, or several floors of a building.

True

Your friend has a Mac that runs OS X. If she needs to run a Windows app on it, she can set it to run Windows also.

True

The Internet is the infrastructure on which the Web exists.

True

The action of including only some columns for output while retrieving data is known as ____.

projecting

A relational model splits the information up into many two dimensional data structures.

True

Question 1 studiers recently

Organizations can collect many types of data from a wide variety of sources, but typically they only collect structured data that fits neatly into traditional relational database management systems.​

Answer

Aceify Homework Helper

Students also studied these questions

A(n) _____ is a field or set of fields in a record that uniquely identifies the record.

A database is a collection of integrated and related _____.

The Accounting department manager requests a list of all of the suppliers, contacts, and phone numbers of the suppliers in Japan How many records did your query reveal?

A database is a collection of integrated and related _____.

The manager of Human Resources wants a list of all of the employees who work at the company. He only wants to see the employees’ last name and first name. [You may assume that everyone who works at the company is included in the Employees table]. How many records did your query reveal?

Just out of curiosity, you want to produce a listing of the products (product name only) that are supplied by SupplierID 1 and are in CategoryID 1. How many records did your query reveal?

One of the employees in the IT department asks for the highest order ID that is in the Orders table. [Hint: To receive credit for this question, you must use the MAX function to perform this task.] How many records did your query reveal?

The Human Resources department requests a list that contains the number (i.e. count) of orders taken on each date, grouped by the order date. [Be sure to use an aggregate operator in your query to receive credit for this question.] How many records did your query reveal?

A customer calls in and wants a list of all of your products and their prices. Your results should be sorted in alphabetical order from A-Z. How many records did your query reveal?

Your friend has a Mac that runs OS X. If she needs to run a Windows app on it, she can set it to run Windows also.

An example of a common hardware function performed by the operating system is presenting information on a monitor or printer.​

All of the following are examples of someone using personal productivity software EXCEPT _________.

The _____ is the heart of the operating system and controls its most critical processes.

On a modern home computer, one can set up accounts for many users and be able to control what resources a user may access.

Operating systems provide a measure of security by allowing users to access to those resources they've been cleared to use as well as other users' resources if those resources are beneficial.

The _____ is the heart of the operating system and controls its most critical processes.

New cars come with an onboard computer that controls anti-lock brakes, air bag deployment, fuel injection, etc. The software is known as ____.

Symbian is an operating system used in special-purpose computers.

One of the advantages of off-the-shelf software is that ________________.

You cannot boot a computer from ____________.

An operating system with _____ capabilities allows a user to run more than one program concurrently.

The primary function of application software is to apply the power of the computer to enable people, workgroups, and the entire enterprise to solve problems and perform specific tasks.

Proprietary software is mass-produced by software vendors to address needs that are common across businesses, organizations, or individuals.

​When an organization hires another firm in another country to perform a specific function on its behalf, it is known as offshoring.

​When an organization hires another firm in another country to perform a specific function on its behalf, it is known as offshoring.

The role of a systems analyst is narrowly defined and seldom involves communications with others.

Disk mirroring is a method of storing data that generates extra bits of data from existing data, allowing the system to create a "reconstruction map" so that if a hard drive fails, it can rebuild lost data.

For someone to be a good CIO, technical ability is the most important characteristic.

When organizational learning occurs, what is revealed can be small, incremental adjustments known as continuous improvement.​

​In most large organizations, the IS department is divided into the following functions __________.

All of the following are potential drawbacks to outsourcing EXCEPT:

In a supply chain, _____ involve the transformation, movement, and storage of supplies and raw materials.

According to Lewin's Change Model, an organization must deliberately change old habits, learn new work methods, and accept the new work methods as parts of the job.

You might be an information systems worker if you _________.

_____ is a visa program that allows skilled employees from foreign lands into the United States.

The need for additional data storage capacity is one of the factors driving the growth in data centers.

To date, semiconductor fabricators have been able to make ICs (integrated circuits) that hold up to several million electronic components in an area the size of a fingernail.

Carson's supervisor has asked him to review a variety of portable computers for possible purchase for their company's employees. Which of the following should Carson NOT consider buying?

A friend's computer came with Windows 8 operating system. Which of the following years was the computer most likely bought in?

Thin client computers are a type of portable single-user computers.

_____ are used in standardized tests, including the SAT and GMAT tests, and to record votes in elections.

When choosing from various types of flat panel display, choose _______ for low power consumption.

_____ is an example of a popular general purpose software suite for personal computer users.

Each programming language has a set of rules, called the program code of the language.

When making hardware decisions, the overriding considerations of a business should be technology cost and currency.

Cache memory is available in two forms: level 1, which is found on the CPU chip, and level 2, which can be accessed over a high-speed dedicated interface.

To develop software you need all these except ​________.

Symbian is an operating system used in special-purpose computers.

An information system that operates in the _____ sphere of influence supports two or more people who work together to achieve a common goal.

Suppose a business wishes to move away from hosting its own applications, the recommended solution is to use ______.

A personal area network (PAN) is a wireless network that connects information networking devices within a small area, such as an office, home, or several floors of a building.

Your friend has a Mac that runs OS X. If she needs to run a Windows app on it, she can set it to run Windows also.

The Internet is the infrastructure on which the Web exists.

The action of including only some columns for output while retrieving data is known as ____.

A relational model splits the information up into many two dimensional data structures.

Similar questions

Organizations can collect many types of data from a wide variety of sources, but typically they only collect structured data that fits neatly into traditional relational database management systems.​

Organizations can collect many types of data from a wide variety of sources, but typically they only collect structured data that fits neatly into traditional relational database management systems.​

Unstructured data comes from sources such as word-processing documents and scientific research.

Unstructured data comes from sources such as word-processing documents and scientific research.

The relational database model is currently the most widely used.

More questions to study

If you are going to drink alcohol at a party, you should:

A deductive argument that succeeds in providing logically conclusive support is said to be

Which is the most common type of proxy server?

​When an organization hires another firm in another country to perform a specific function on its behalf, it is known as offshoring.

Minor political parties in Texas nominate candidates in a(n) ____ ____.

Question
1 studiers recently

Organizations can collect many types of data from a wide variety of sources, but typically they only collect structured data that fits neatly into traditional relational database management systems.

An example of a common hardware function performed by the operating system is presenting information on a monitor or printer.

When an organization hires another firm in another country to perform a specific function on its behalf, it is known as offshoring.

When an organization hires another firm in another country to perform a specific function on its behalf, it is known as offshoring.

When organizational learning occurs, what is revealed can be small, incremental adjustments known as continuous improvement.

In most large organizations, the IS department is divided into the following functions __________.

To develop software you need all these except ________.

Organizations can collect many types of data from a wide variety of sources, but typically they only collect structured data that fits neatly into traditional relational database management systems.

Organizations can collect many types of data from a wide variety of sources, but typically they only collect structured data that fits neatly into traditional relational database management systems.

When an organization hires another firm in another country to perform a specific function on its behalf, it is known as offshoring.

Minor political parties in Texas nominate candidates in a(n) .