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
Question
Based on the tables below, which of the following ANSI SQL commands would return the average customer balance grouped by SalesRepNo?GENERAL SALES DATABASE:
SALESREP
| SalesRepNo | RepName | HireDate |
| 654 | Jones | 01/02/2005 |
| 734 | Smith | 02/03/2007 |
| 345 | Chen | 01/25/2004 |
| 434 | Johnson | 11/23/2004 |
CUSTOMER
| CustNo | CustName | Balance | SalesRepNo |
| 9870 | Winston | 500 | 345 |
| 8590 | Gonzales | 350 | 434 |
| 7840 | Harris | 800 | 654 |
| 4870 | Miles | 100 | 345 |
A) SELECT AVG (Balance)
FROM CUSTOMER
WHERE SalesRepNo;
B) SELECT AVG (Balance)
FROM CUSTOMER
GROUP BY SalesRepNo;
C) SELECT AVG (Balance)
FROM CUSTOMER, SALESREP
WHERE SALESREP.SalesRepNo = CUSTOMER.SalesRepNo;
D) SELECT AVG (Balance)
FROM CUSTOMER
ORDER BY SalesRepNo;
Answer
This answer is hidden. It contains 1 characters.
Related questions
Q:
The MySQL keyword used to retrieve a row of data while the cursor is operating is ________.
A) DECLARE CURSOR {CursorName}
B) OPEN {CursorName}
C) FETCH
D) CLOSE {CursorName}
Q:
To insert non-sequential data into a MySQL table that uses AUTO_INCREMENT ________.
A) Disable AUTO_INCREMENT
B) Temporarily remove AUTO_INCREMENT
C) Use the AUTO_INCREMENT_INSERT command
D) Both A and C are correct
Q:
The active MySQL database is specified using ________.
A) the Set Schema command
B) the Set Database command
C) the Make Default Schema command
D) the Set as Default Schema command
Q:
DBMS objects are displayed ________.
A) in the Navigation Pane
B) in the Object Browser
C) in the tabbed database window
D) in the tabbed document window
Q:
MySQL backups are run on the Administration - Data Export tab of the Data Export page.
Q:
MySQL users may be granted MySQL server administrative roles.
Q:
MySQL concurrency options include four scopes for the transaction isolation level: GLOBAL, LOCAL, SESSION and TRANSACTION.
Q:
The default transaction isolation level in MySQL is REPEATABLE READ.
Q:
Triggers that have been created in MySQL are displayed as objects in the Object Browser of the MySQL Workbench.
Q:
To display an existing SQL script, click the "Open an SQL script file (in new query tab)" button.
Q:
A new MySQL database is created using the New Database dialog box.
Q:
MySQL Community Edition uses only operating system authentication.
Q:
The spreadsheet data must first be highlighted (selected) in order to be imported using the MySQL for Excel Add-In.
Q:
In Oracle Database, indexes are created using the ALTER command.
Q:
When using Oracle Database, a sequence is an object that generates a sequential series of unique numbers.
Q:
The default file extension for text files created for SQL Developer is .sql.
Q:
In Oracle Database security, a Role can have many system privileges.
Q:
Briefly explain the different types of files used by the Oracle Database recovery facilities.
Q:
Briefly describe how Oracle Database implements serializable transaction isolation. Include an example.
Q:
Explain the Oracle Database PL/SQL Block Structure.
Q:
What is the Oracle Enterprise Manager Database Express?
Q:
What is SQL Developer?
Q:
Which of the following Oracle Database ReDo files are stored on disk and contain the rollback segments from recent database changes?
A) OnLine ReDo files
B) Active ReDo files
C) OffLine ReDo files
D) Archive ReDo files
Q:
Which of the following is true about stored procedures in Oracle Database?
A) They cannot invoke other procedures.
B) They must include the data type and length of parameters.
C) They can raise exceptions.
D) They do not contain variables.
Q:
The Oracle Database PL/SQL statement used to define a set of PL/SQL statements is ________.
A) DECLARE
B) BEGIN
C) IF...THEN...ELSE...END IF
D) LOOP
Q:
The Oracle Database PL/SQL block structure begins with ________.
A) DECLARE
B) BEGIN
C) IF...THEN...ELSE...END IF
D) LOOP
Q:
One limitation of the Oracle Data Import Wizard is that it ________.
A) does not allow addition of a new primary key column
B) does not allow data to be imported into an existing table
C) does not allow import of "date" type data
D) only allows import of data from Microsoft Excel, no other formats
Q:
Which of the following tasks cannot be done using the Oracle SQL Developer GUI features?
A) See the structure of a table
B) Add and remove columns from a table
C) Insert and delete data from a table
D) Create a new tablespace
Q:
Which of the following statements would cause Oracle Database to include a new column named C5, which is a two-digit whole number, to a table named T2?
A) UPDATE TABLE T2 ADD COLUMN C5 NUMBER (2);
B) ALTER TABLE T2 ADD C5 NUMBER (2);
C) UPDATE TABLE T2 INSERT C5 NUMBER (2,0);
D) ALTER TABLE T2 INSERT COLUMN C5 NUMBER (2,0);
Q:
Which of the following Oracle Database structures is a logical subdivision of an Oracle Database database instance that is used to group related tables, views, and other similar objects?
A) Namespace
B) Filespace
C) Tablespace
D) Dataspace