Question 1

List the activities Structure Query Language enables you to perform on a relational database.

Accepted Answer

Search
Ins

Question 2

The third main clause of an SQL statement is the

Accepted Answer

A) Table name 
B) Field name 
C) Criteria 
D) Action 
A) Table name 
B) Field name 
C) Criteria 
D) Action

Question 3

Query builder tools may be referred to as

Accepted Answer

A) Query-by-code 
B) Query-by-icons 
C) Query-by-example 
D) Query-by-patterns 
A) Query-by-code 
B) Query-by-icons 
C) Query-by-example 
D) Query-by-patterns

Question 4

Which tier translates the SQL statement into action?

Accepted Answer

A) User tier 
B) Application tier 
C) Interface tier 
D) Database tier 
A) User tier 
B) Application tier 
C) Interface tier 
D) Database tier

Question 5

What are the four main clauses in SQL statements? Provide an example of each clause.

Accepted Answer

Clause 1 - Action; example, SE

Question 6

Use the database tables below to answer the following questions.  
-Write the SQL query to retrieve customer's addresses.

Accepted Answer

SELECT CUSTOMER.[First Name],

Question 7

Each SQL statement contains the following EXCEPT

Accepted Answer

A) Field name 
B) Database name 
C) Action 
D) Table name 
A) Field name 
B) Database name 
C) Action 
D) Table name

Question 8

Query builder tools

Accepted Answer

A) Generate SQL programming code 
B) Increase an accountant's dependance on IT developers 
C) Complicate the process of writing SQL programming code 
D) Require the ability the write RDBMS programming code 
A) Generate SQL programming code 
B) Increase an accountant's dependance on IT developers 
C) Complicate the process of writing SQL programming code 
D) Require the ability the write RDBMS programming code

Question 9

Queries are questions you ask about

Accepted Answer

A) Information in a report 
B) Data provided in the search results 
C) Data stored in a database 
D) None of the above 
A) Information in a report 
B) Data provided in the search results 
C) Data stored in a database 
D) None of the above

Question 10

Queries may be used with ________ to update data in the database.

Accepted Answer

A) navigation 
B) forms 
C) reports 
D) tables 
A) navigation 
B) forms 
C) reports 
D) tables

Question 11

A relational database is searched and data is retrieved using ________.

Accepted Answer

structured

Question 12

You are an intern in a large company. The company would like to improve the communications between the accountants and IT. Because of your background in AIS, you are asked to explain to the accountants how a data base query would be used with a database to update the address information of a company's vendor.

Accepted Answer

Queries can be used with database forms

Question 13

The fourth main clause of an SQL statement is the

Accepted Answer

A) Table name 
B) Field name 
C) Criteria 
D) Action 
A) Table name 
B) Field name 
C) Criteria 
D) Action

Question 14

What is a query builder tool?

Accepted Answer

A query builder tool allows yo

Question 15

What are cyberattacks increasingly using to extract confidential data?

Accepted Answer

A) Relational databases 
B) SQL programming code 
C) Database reports 
D) GAAP programming code 
A) Relational databases 
B) SQL programming code 
C) Database reports 
D) GAAP programming code

Question 16

The ________ translates the query statement into action.

Accepted Answer

RDBMS (Rel

Question 17

Write the SQL query to retrieve the sales orders for all customer with a zip code of 63011.

Accepted Answer

SELECT CUSTOMER.[First Name], CUSTOMER.[

Question 18

For relational databases, queries are usually written in

Accepted Answer

A) SQL 
B) RDBMS 
C) QBL 
D) RQL 
A) SQL 
B) RDBMS 
C) QBL 
D) RQL

Question 19

You are an intern in a large company. The company would like to improve the communications between the accountants and IT. Because of your background in AIS, you are asked to explain to the accountants how a data base query would be used with a database to update the address information of a company's customer.

Accepted Answer

Queries can be used with database forms

Question 20

Query builder tools may be referred to as ________.

Accepted Answer

query-by-e

List the activities Structure Query Language enables you to perform on a relational database.

The third main clause of an SQL statement is the

Query builder tools may be referred to as

Which tier translates the SQL statement into action?

What are the four main clauses in SQL statements? Provide an example of each clause.

Use the database tables below to answer the following questions. -Write the SQL query to retrieve customer's addresses.

Each SQL statement contains the following EXCEPT

Query builder tools

Queries are questions you ask about

Queries may be used with ________ to update data in the database.

A relational database is searched and data is retrieved using ________.

The fourth main clause of an SQL statement is the

What is a query builder tool?

What are cyberattacks increasingly using to extract confidential data?

The ________ translates the query statement into action.

Write the SQL query to retrieve the sales orders for all customer with a zip code of 63011.

For relational databases, queries are usually written in

Query builder tools may be referred to as ________.

Accounting Systems Insights

Accounting Databases

Accounting Systems and Business Processes

Business Processes: Purchasing, Sales, and Payroll Cycles

Integrated Enterprise Systems and Cloud Computing

Accounting and Business Intelligence

Accounting and Sustainability Intelligence

XBRL: Intelligent Business Reporting

Fraud and Internal Control

Cybersecurity

The Risk Intelligent Enterprise: Enterprise Risk Management

Accounting System Development

Database Design: ERD, REA, and SQL

Filters

Exam 3: Accounting Interface: Database Forms, Queries, and Reports

List the activities Structure Query Language enables you to perform on a relational database.

The third main clause of an SQL statement is the

Query builder tools may be referred to as

Which tier translates the SQL statement into action?

What are the four main clauses in SQL statements? Provide an example of each clause.

Use the database tables below to answer the following questions. -Write the SQL query to retrieve customer's addresses.

Each SQL statement contains the following EXCEPT

Query builder tools

Queries are questions you ask about

Queries may be used with ________ to update data in the database.

A relational database is searched and data is retrieved using ________.

The fourth main clause of an SQL statement is the

What is a query builder tool?

What are cyberattacks increasingly using to extract confidential data?

The ________ translates the query statement into action.

Write the SQL query to retrieve the sales orders for all customer with a zip code of 63011.

For relational databases, queries are usually written in

Query builder tools may be referred to as ________.

Accounting Systems Insights

Accounting Databases

Accounting Systems and Business Processes

Business Processes: Purchasing, Sales, and Payroll Cycles

Integrated Enterprise Systems and Cloud Computing

Accounting and Business Intelligence

Accounting and Sustainability Intelligence

XBRL: Intelligent Business Reporting

Fraud and Internal Control

Cybersecurity

The Risk Intelligent Enterprise: Enterprise Risk Management

Accounting System Development

Database Design: ERD, REA, and SQL

Filters