A schematic of the entire database that describes the relationships in a database is called a(n):

intersection relationship diagram

physical database available for different logical views

relational database available for different analytical views

logical database available for different analytical views

physical database available for different relational views

relational database available for different physical views

The logical view of a database:

presents data as they would be perceived by end users

shows how data are organized and structured on the storage media

presents an entry screen to the user

allows the creation of supplementary reports

shows the relationships between entities and attributes

Which of the following is a drawback of flat files?

Data partitioned into several separate files can be difficult to summarize

Several users can access the same information at the same time

Flat files ensure that users enter data in a consistent format

Data is organized to meet all integrity constraints

Which of the following is a problem that data redundancy causes?

increased data errors and inconsistencies

Which of the following is a reason to store business data in a database rather than a spreadsheet?

Spreadsheets have limited data sharing and security features

Spreadsheets have limited text-formatting features

Spreadsheets cannot be backed up

Spreadsheets have strict rules about data consistency

An ad-hoc query is ____.

a question that can be answered from the database using SQL

a question about the data that requires a program to be written

a question that can be answered only by combining several SQL queries

never useful in Business Intelligence scenarios

Given a table with the structure: Employee (EmpNo, Name, Salary, HireDate), which of the following would find all employees whose name begins with the letter "S" using Microsoft Access?

SELECT * FROM EMPLOYEE WHERE Name LIKE 'S';

Select * FROM EMPLOYEE WHERE Name IN ['S'];

SELECT EmpNo FROM EMPLOYEE WHERE Name LIKE 'S';

SELECT * FROM EMPLOYEE WHERE Name LIKE 'S%';

In an SQL query, the built-in functions SUM and AVG work with columns containing data of which of the following data types?

Both Integer and Numeric are correct

Given a table with the structure: Employee (EmpNo, Name, Salary, HireDate), which of the following is not a valid ANSI SQL command?

SELECT HireDate, COUNT(*) FROM EMPLOYEE WHERE Salary < 30000;

Select * FROM EMPLOYEE WHERE Name LIKE 'Ja%';

SELECT COUNT(*) FROM EMPLOYEE WHERE Salary < 30000;

SELECT HireDate, COUNT(*) FROM EMPLOYEE GROUP BY HireDate;

Based on the SQL shown, for each sales rep, which query lists the rep number, the number of customers assigned to the rep, and the average balance of the rep's customers? Group and order the records by rep number. Customers (CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum)

SELECT RepNum, COUNT(*) AVG(Balance) FROM Customers GROUP BY RepNum ORDER BY RepNum;

SELECT RepNum, AVG(Balance) FROM Customers GROUP BY RepNum ORDER BY RepNum;

SELECT RepNum, COUNT(RepNum) AVG(Balance) FROM Customers GROUP BY RepNum ORDER BY RepNum;

SELECT RepNum, COUNT(*) FROM Customers GROUP BY RepNum ORDER BY RepNum;

Based on the SQL shown, which query lists the last names and bonuses of employees who have a Bonus field value greater than Juliana Suarez, EmployeelD 14? Employees (EmployeelD, LastName, FirstName, HireDate, JobTitle, Bonus)

SELECT LastName, Bonus FROM Employees WHERE Bonus > (SELECT Bonus FROM Employees WHERE EmployeeID = '14");

SELECT LastName, Bonus FROM Employees HAVING Bonus > EmployeelD = '14' ;

SELECT LastName, Bonus FROM Employees WHERE Bonus > UNION (SELECT LastName, Bonus FROM Employees WHERE EmployeeID = '14');

SELECT LastName, Bonus FROM Employees WHERE Bonus > UPDATE SET EmployeeID = '14';

Based on the table description and SQL shown, which query finds the description and price of the items that have a Price field value greater than Wireless charger, ItemNum W208? Items (ItemNum, Description, OnHand, Category, Storehouse, Price)

SELECT Description, Price FROM Items WHERE Price > (SELECT Price FROM Items WHERE ItemNum = "W208");

SELECT Description, Price FROM Items WHERE Price > ItemNum = W208");

SELECT Price FROM Items WHERE ItemNum > 'W208' (SELECT Description, Price FROM Items);

SELECT Description, Price FROM Items WHERE Price > (SELECT ItemNum = 'W208' FROM Items);

Based on the table description and SQL shown, which query increases the FeeAmount by 2 percent? Fees (FeeID, FeeType, FeeAmount)

UPDATE Fees SET FeeAmount = FeeAmount * 1.02;

UPDATE Fees SET FeeAmount = FeeAmount * 1.2;

UPDATE Fees SET FeeAmount = FeeAmount * 2%;

SELECT Fees WHERE FeeAmount = FeeAmount * 1.02;

Based on the table description and SQL shown, which query lists the first name and last name of all students separated by a space? Students (StudentID, FirstName, LastName, Street, City, State, PostalCode)

SELECT FirstName & ' ' & LastName AS FullName FROM Students;

SELECT FirstName & LastName AS FullName FROM Students;

SELECT FirstName ' ' LastName AS FullName FROM Students;

SELECT FirstName, LastName AS FullName FROM Students;

When do you use the & operator in an expression in Access Query Design View?

to combine values in character fields

to match a specific list of criteria

to reverse the result of the original condition

to sum values in numeric fields

Which command joins the related Customers and Orders tables based on the common CustomerID field?

WHERE Customers.CustomerID = Orders.CustomerID

WHERE CustomerID.Customers = CustomerID.Orders

JOIN Customers.CustomerID = Orders.CustomerID

SELECT Customers.CustomerID AND Orders.CustomerID

Which of the following SQL commands sorts records by ProductName within ProductType?

ORDER BY ProductType, ProductName

SORT BY ProductType, ProductName

LIST ProductName IN ProductType

ORDER BY ProductName IN ProductType

Which of the following statements selects ProductDescription and Price fields for every record in the Products table with a Price value greater than $50.00?

SELECT ProductDescription, Price FROM Products WHERE Price > 50;

SELECT ProductDescription, Price > 50 FROM Products;

SELECT ProductDescription, Price FROM Products WITH Price > 50;

SELECT ProductDescription, Price FROM Products WHERE Price < 50;

Which statement creates a table named PostalCodes with a five-character PostalCode text field and a two-character Abbrev text field?

CREATE TABLE PostalCodes (PostalCode TEXT (5), Abbrev TEXT (2));

CREATE TABLE PostalCodes (PostalCode TEXT, Abbrev TEXT);

CREATE TABLE PostalCodes (PostalCode (TEXT 5), Abbrev (TEXT 2));

CREATE TABLE (PostalCode TEXT (5), Abbrev TEXT (2));

When you use a name containing a space in Access SQL, what must you do to specify the table or column name?

Enclose it in [square brackets]

Enclose it in "quotation marks"

DSS Midterm

Quiz

•

Business

•

University

•

Practice Problem

•

Easy

Alyssa Avington

Used 1+ times

FREE Resource

50 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

A database stores......

Data

Relationships

Applications

Both data and relationships are correct

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

tuples

key field

attributes

fields

relations

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

47 questions

Midterm Examination on Research

Quiz

•

University

55 questions

Accounting Chapter 3

Quiz

•

University

50 questions

Responsi BDDM- ST168

Quiz

•

University

47 questions

E-Commerce review ka na teh

Quiz

•

University

46 questions

BBSKJNDEJDOIE

Quiz

•

2nd Grade - University

50 questions

Technopreneurship Semi-Final Exam

Quiz

•

University

45 questions

Introduction to Business Administration (ch. 10, 11, 13, 1

Quiz

•

University

54 questions

Mid Module Quiz

Quiz

•

University

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for Business

12 questions

IREAD Week 4 - Review

Quiz

•

3rd Grade - University

23 questions

Subject Verb Agreement

Quiz

•

9th Grade - University

7 questions

Force and Motion

Interactive video

•

4th Grade - University

7 questions

Renewable and Nonrenewable Resources

Interactive video

•

4th Grade - University

5 questions

Poetry Interpretation

Interactive video

•

4th Grade - University

19 questions

Black History Month Trivia

Quiz

•

6th Grade - Professio...

15 questions

Review1

Quiz

•

University

15 questions

Pre1

Quiz

•

University

DSS Midterm

50 questions

A database stores......

A program whose job is to create, process, and administer databases is called a.......

The smallest unit of data a computer can handle is called a:

In a business relational database, tables contain:

A characteristic or quality describing an entity is called a(n):

In a table for customers, the information about a single customer would reside in a single:

Relational databases organize data into two-dimensional tables, called ____ with columns and rows.

A schematic of the entire database that describes the relationships in a database is called a(n):

A DBMS makes the:

The logical view of a database:

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Business