MIS 336 - Chapters 2 & 3 || Questions and 100% Accurate Answers.
1 keer bekeken 0 keer verkocht
Vak
MIS 336
Instelling
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
Voordelen van het kopen van samenvattingen bij Stuvia op een rij:
Verzekerd van kwaliteit door reviews
Stuvia-klanten hebben meer dan 700.000 samenvattingen beoordeeld. Zo weet je zeker dat je de beste documenten koopt!
Snel en makkelijk kopen
Je betaalt supersnel en eenmalig met iDeal, creditcard of Stuvia-tegoed voor de samenvatting. Zonder lidmaatschap.
Focus op de essentie
Samenvattingen worden geschreven voor en door anderen. Daarom zijn de samenvattingen altijd betrouwbaar en actueel. Zo kom je snel tot de kern!
Veelgestelde vragen
Wat krijg ik als ik dit document koop?
Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.
Tevredenheidsgarantie: hoe werkt dat?
Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.
Van wie koop ik deze samenvatting?
Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper FullyFocus. Stuvia faciliteert de betaling aan de verkoper.
Zit ik meteen vast aan een abonnement?
Nee, je koopt alleen deze samenvatting voor €10,45. Je zit daarna nergens aan vast.
