MIS 200 COMPREHENSIVE SET ANSWERS AND
QUESTIONS SET A+
✔✔Which SQL statement is used to update in a database? - ✔✔Update
✔✔What is a website that will help you measure your individual social capital? -
✔✔Klout
✔✔Which of the following statements is true about data marts? - ✔✔Data marts
address the needs of a particular department or functional area of business.
✔✔Which operator is used to select values within a range? - ✔✔Between
✔✔Which of the following is used for biometric authentication? - ✔✔Facial features
✔✔With SQL, how do you select all the records from a table named "Persons" where
the value of the column "FirstName" is "Peter"? - ✔✔SELECT * FROM Persons
WHERE FirstName = 'Peter'
✔✔The NOT NULL constraint enforces a column to not accept NULL values. - ✔✔True
✔✔IBM's Watson uses _____ or the ability of a computer system to understand spoken
human language. - ✔✔natural language process (NLP)
✔✔Which of the following is considered a computer crime? - ✔✔Hacking of information
systems.
✔✔Which SQL statement is used to create a database table called "Customers"? -
✔✔CREATE TABLE Customers
✔✔Bi servers use _____ to determine what results to send to which users and on which
to schedule. - ✔✔metadata
, ✔✔Organizations normally use one strong firewall to protect the network. - ✔✔False
✔✔Social capital can be earned and spent. - ✔✔True
✔✔Phishing is a technique for obtaining unauthorized data that uses pretexting via
email. - ✔✔True
✔✔Younger users of social media are more trusting of the organizational messages. -
✔✔False
✔✔What is a potential problem if there is a natural disaster? - ✔✔property loss
✔✔LinkedIn uses the _____ because regular users access LinkedIn for free but you
can upgrade individual upgrades ranging from $29 a month to use services such as the
ability to direct email messages to LinkedIn users outside of one's network. -
✔✔Freemium revenue model.
✔✔Data mining is the application of statistical techniques to find patters and
relationships among data for classification and prediction. - ✔✔True
✔✔A Trojan horse is a virus that masquerades as a useful program or file. - ✔✔True
✔✔Spoofing occurs when someone pretends to be someone else. - ✔✔True
✔✔All of the following is considered metadata except - ✔✔the granularity of the data.
✔✔With SQL, how do you select a column named "FirstName" from a table named
"Persons"? - ✔✔SELECT FirstName FROM Persons
✔✔All of the following are ways to avoid most malware except - ✔✔use public Wi-Fi.
✔✔_____ measures the frequency that someone who clicks on an ad makes a
purchase, "likes" a site, or takes some other action desired by the advertiser. -
✔✔Conversion rate
✔✔How are social media communities formed? - ✔✔They are formed based on mutual
interests.
✔✔A _____ is a type of virus that self-propagates using the Internet or other computer
network. - ✔✔Worm
✔✔A _____ takes data from the data manufacturers, cleans and process the date, and
locates the data on the shelves. - ✔✔data warehouse
QUESTIONS SET A+
✔✔Which SQL statement is used to update in a database? - ✔✔Update
✔✔What is a website that will help you measure your individual social capital? -
✔✔Klout
✔✔Which of the following statements is true about data marts? - ✔✔Data marts
address the needs of a particular department or functional area of business.
✔✔Which operator is used to select values within a range? - ✔✔Between
✔✔Which of the following is used for biometric authentication? - ✔✔Facial features
✔✔With SQL, how do you select all the records from a table named "Persons" where
the value of the column "FirstName" is "Peter"? - ✔✔SELECT * FROM Persons
WHERE FirstName = 'Peter'
✔✔The NOT NULL constraint enforces a column to not accept NULL values. - ✔✔True
✔✔IBM's Watson uses _____ or the ability of a computer system to understand spoken
human language. - ✔✔natural language process (NLP)
✔✔Which of the following is considered a computer crime? - ✔✔Hacking of information
systems.
✔✔Which SQL statement is used to create a database table called "Customers"? -
✔✔CREATE TABLE Customers
✔✔Bi servers use _____ to determine what results to send to which users and on which
to schedule. - ✔✔metadata
, ✔✔Organizations normally use one strong firewall to protect the network. - ✔✔False
✔✔Social capital can be earned and spent. - ✔✔True
✔✔Phishing is a technique for obtaining unauthorized data that uses pretexting via
email. - ✔✔True
✔✔Younger users of social media are more trusting of the organizational messages. -
✔✔False
✔✔What is a potential problem if there is a natural disaster? - ✔✔property loss
✔✔LinkedIn uses the _____ because regular users access LinkedIn for free but you
can upgrade individual upgrades ranging from $29 a month to use services such as the
ability to direct email messages to LinkedIn users outside of one's network. -
✔✔Freemium revenue model.
✔✔Data mining is the application of statistical techniques to find patters and
relationships among data for classification and prediction. - ✔✔True
✔✔A Trojan horse is a virus that masquerades as a useful program or file. - ✔✔True
✔✔Spoofing occurs when someone pretends to be someone else. - ✔✔True
✔✔All of the following is considered metadata except - ✔✔the granularity of the data.
✔✔With SQL, how do you select a column named "FirstName" from a table named
"Persons"? - ✔✔SELECT FirstName FROM Persons
✔✔All of the following are ways to avoid most malware except - ✔✔use public Wi-Fi.
✔✔_____ measures the frequency that someone who clicks on an ad makes a
purchase, "likes" a site, or takes some other action desired by the advertiser. -
✔✔Conversion rate
✔✔How are social media communities formed? - ✔✔They are formed based on mutual
interests.
✔✔A _____ is a type of virus that self-propagates using the Internet or other computer
network. - ✔✔Worm
✔✔A _____ takes data from the data manufacturers, cleans and process the date, and
locates the data on the shelves. - ✔✔data warehouse
