MIS 336 - Chapters 2 & 3 || Questions and 100% Accurate Answers.
0 view 0 purchase
Course
MIS 336
Institution
MIS 336
Business Intelligence (BI) systems are information systems that are used to support management decisions. correct answers True
Ad-hoc queries are questions that can be answered using database data. correct answers True
Online Transaction Processing (OLTP) are systems are the backbone of busin...
MIS 336 - Chapters 2 & 3 || Questions and 100% Accurate
Answers.
Business Intelligence (BI) systems are information systems that are used to support management
decisions. correct answers True
Ad-hoc queries are questions that can be answered using database data. correct answers True
Online Transaction Processing (OLTP) are systems are the backbone of businesses as they
operate today. correct answers True
SQL queries only work with SQL Server (not used in Access). correct answers False
Data Definition Language (DDL) is used for querying, inserting, modifying, and deleting data.
correct answers False
The SELECT clause specifies which columns are to be listed in the query. correct answers True
The WHERE clause specifies which tables are to be used in the query. correct answers False
Column order may NOT be changed when building a query. correct answers False
To run a query in SQL server, click the run button (!). correct answers False
The DISTINCT keyword will eliminate duplicates in query output. correct answers True
Business Intelligence (BI) systems typically store their data in data warehouses. correct answers
True
In addition to being a data sublanguage, SQL is also a programming language, like Java or C#.
correct answers False
The SQL keyword SELECT is used to specify the columns to be listed in the query results.
correct answers True
The SQL keyword FROM is used to specify the table to be used. correct answers True
An ad-hoc query is ________. correct answers a question that can be answered from the database
using SQL
The WHERE clause contains the condition that specifies which rows are to be selected. correct
answers True
The result of an SELECT operation can contain duplicate rows. correct answers True
, Sorting is specified using the SORT BY phrase. correct answers False
To sort the rows of the result table, the ORDER BY clause is specified. correct answers True
Columns can be sorted in descending sequence by using the DESC keyword. correct answers
True
All relations are tables, but not all tables are relations. correct answers True
The domain integrity constraint requires all values in a column to be the same datatype. correct
answers True
In a relation, the order of the rows and the order of the columns is material. correct answers False
As defined by Codd, the columns of a relation are called tuples. correct answers False
A functional dependency exists when one or more attributes determines the value of another
attribute. correct answers True
A composite determinate must have only one attribute. correct answers False
A candidate key is a determinant that determines all of the other columns in a relation. correct
answers True
A surrogate key is manually entered by the user. correct answers False
A relation is in 2NF if it is in 1NF and all non-key attributes are determined by the entire primary
key. correct answers True
If a relation is in 3NF, does not have a composite primary key, or have overlapping composite
candidate keys, it is in BCNF. correct answers True
All relations are tables, but not all tables are relations. correct answers True
A characteristic of a relation is that the cells of the relation hold a single value. correct answers
True
A tuple is a column of a relation. correct answers False
A functional dependency is a relationship between attributes such that if we know the value of
one attribute, we can determine the value of the other attribute. correct answers True
The functional dependency noted as A → B means that the value of A can be determined from
the value of B. correct answers False
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller FullyFocus. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.79. You're not tied to anything after your purchase.
