Q&A Hero

Question

Based on the tables below, which of the following SQL commands would create an SQL view named CustomerSalesRep that could be used to display CustNo, CustName, RepName?
GENERAL SALES DATABASE:
SALESREP
SalesRepNo RepName HireDate
654 Jones 01/02/1999
734 Smith 02/03/2000
345 Chen 01/25/1998
434 Johnson 11/23/1998

CUSTOMER
CustNo CustName Balance SalesRepNo
9870 Winston 500 345
8590 Gonzales 350 434
7840 Harris 800 654
4870 Miles 100 345

A) SELECT CustNo, CustName, RepName
FROM SALESREP, CUSTOMER;
B) SELECT CustNo, CustName, RepName
FROM SALESREP, CUSTOMER
WHERE CustNo=*;
C) SELECT CustNo, CustName, RepName
FROM SALESREP, CUSTOMER
WHERE SALEREP, SalesRepNo = CUSTOMER, SalesRepNo;
D) CREATE VIEW CustomerSalesRep AS
SELECT CustNo, CustName, RepName
FROM SALESREP, CUSTOMER
WHERE CustNo=*;
E) CREATE VIEW CustomerSalesRep AS
SELECT CustNo, CustName, RepName
FROM SALESREP, CUSTOMER
WHERE SALEREP, SalesRepNo = CUSTOMER, SalesRepNo;

Answer

This answer is hidden. It contains 1 characters.

Related questions

Q: What are the elements of a graph database?
Q: What is an XML DTD?
Q: What is XML, and why is it significantly better than HTML?
Q: Graph databases are composed of ________.
Q: XML documents that conform to their DTD are said to be ________.
Q: The CAP theorem defines the three properties of ________, ________, and ________.
Q: The document type declaration for an XML document begins with the keyword ________. A) XML B) DTD C) TYPE D) DOCTYPE E) TYPEDECL
Q: An example of a document database is ________. A) Dynamo B) Couchbase Server C) Bigtable D) Neo4j E) MySQL
Q: Graph databases are composed of three elements, one of which is the edge.
Q: In XML Schema, there are two types of elements, simple and composite.
Q: XML documents and XML Schemas are created in different languages.
Q: XML documents that conform to an XML Schema are validated against that schema.
Q: XML documents that do not conform to their DTD are said to be non-type-valid XML documents.
Q: JSON stands for Jason Script Object Notation.
Q: The CAP theorem defines the three properties, one of which is authorization.
Q: What is data mining application?
Q: Market basket analysis, as described in the text, uses the statistical technique of ________.
Q: A report that is sent to users on a predetermined schedule is called a(n) ________ report.
Q: Refer to the table above. What is the confidence of Drug B being purchased given that Drug A has been purchased? A) .200 B) .250 C) .333 D) .400 E) .500
Q: Refer to the table above.What is the support for Drug A and Drug B? A) .025 B) .075 C) .100 D) .125 E) .200
Q: A report generated by a reporting system is delivered to the appropriate users via a printed report. This system uses which of the following report modes? A) Push B) Pull C) Query D) OLAP E) None of the above
Q: A BI reporting system: A) creates meaningful information from disparate data sources. B) delivers information to users on a timely basis. C) uses statistical procedures to predict future events. D) Both A and B E) All of the above
Q: In unsupervised data mining, explanations are created after patterns are found.
Q: A report that is sent to users only upon the users' request is called an on-demand report.
Q: A report that is sent to users on a predetermined schedule is called a push report.
Q: Reports that rely on the most current data when they are prepared are called dynamic reports.
Q: Report modes include dynamic and static.
Q: Below installing the NetBeans IDE, we have to install ________. A) the Java JRE B) the Java SDK C) the Java JDK D) the Java SRE E) Any of the above will work.
Q: There is only one way to install PHP.
Q: When running the NetBeans IDE for the first time, use a file workspace named NetBeansProjects.

Subjects

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