You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
23 lines
9.2 KiB
23 lines
9.2 KiB
id&qtp&qim&qil&qtx&qca&qia&qrm&qnxt&qprv&qalb&subj&wght&pts&flr&ded
|
|
mmtas4.001&mcs&0&N&Which one of the following statements is <B><I>false </B></I&Regarding internal organization, there are dozens of types of databases.&Databases help keep data organized and accessible.;Query means 'ask.';Relational databases are very powerful.;&The false statement is 'Regarding internal organization, there are dozens of types of databases. 'There are only a few types, such as flat file, relational, multi-dimensional, and hierarchical databases.&&&a&Database.0&&&&0
|
|
mmtas4.002&mcs&0&N&Database software is essential for:&providing reliable access to key information.&using machine language to diagnose programs.;keeping the operating system logic intact.;allowing desktops to provide GUIs.;&Databases are essential for accessing key information stored in files.&&&a&Database.0&&&&0
|
|
mmtas4.003&tf&0&N&Database Management has long been a key part of transaction processing.&TRUE&FALSE&This is true.&&&&Database.0&&&&0
|
|
mmtas4.004&mcs&0&N&Which of the following statements about database technology is <B><I>not</B></I> true? &The most popular type of database structure is the flat file database.&Database technology is important to web-based electronic transaction processing (eTP) applications. ;Database technology is one of the most successful and productive business applications of all time.;Many vendors have recognized that database management is crucial to business.;&Sorry, this statement is true. The correct answer is the false statement, 'The most popular type of database structure is the flat file database.'&&&a&Database.0&&&&0
|
|
mmtas4.005&tf&0&&A relational database consists of one table that can be examined in many different ways or relations.&FALSE&TRUE&No! Relational databases can consist of multiple tables.&&&&Database&&&No! Relational databases can consist of multiple tables.&0
|
|
mmtas4.006&mcs&0&&Which one of the following statements is <B><U>false</B></U>?&Flat file databases are powerful databases that compress data (or flatten) so more data can be stored in a small area.&Relational databases are versatile because relationships can be established for a cross section of the data stored.;Subsets of data in tables can be merged to create new tables.;Hierarchical databases use pointers with objects linked beneath and beside each other forming a pyramid.;&Sorry! The correct answer is 'Flat file databases are powerful databases that compress data (or flatten) so more data can be stored in a small area.'&&&a&Database&&&Sorry! The correct answer is 'Flat file databases are powerful databases that compress data (or flatten) so more data can be stored in a small area.'&0
|
|
mmtas4.007&mcs&0&N&Which one of the following statements is <B><U>false</B></U>?&Meta-data consists of large files of actual business data.&A database organizes data.;Organization is key so data can be retrieved quickly when requested by a user.;A query can be submitted by a person or an application program.;&No, this is true. The false statement and correct answer is 'Meta-data consists of large files of data.'&&&a&Database.0&&&&0
|
|
mmtas4.008&tf&0&N&In form view, database records are viewed one at a time, whereas in table or column view, multiple records can be seen simultaneously.&TRUE&FALSE&This one is true.&&&&Database.0&&&&0
|
|
mmtas4.009&mcs&0&&Which list is associated with database files and the entities that hold data?&fields, records and tables&pointers, queries and requests;subsets, archives and warehouses;meta-data, holders and indexes;&Wrong! The correct answer is 'fields, records and tables.'&&&a&Database&&&Wrong! The correct answer is 'fields, records and tables.'&0
|
|
mmtas4.010&tf&0&N&A field is a place where a single piece of information is stored, such as a 'name' field that would serve as a holder for people's names.&TRUE&FALSE&The statement is indeed true!&&&&Database.0&&&&0
|
|
mmtas4.011&mcs&0&&When speaking in database terms, what is a record?&A database record is a complete set of related fields.&A database record is a group of files that are related.;A database record is a table with multiple database files.;A database record is a set of queries that search for specific files.;&No, the correct answer is 'A database record is a complete set of related fields.'&&&a&Database&&&No, the correct answer is 'A database record is a complete set of related fields.'&0
|
|
mmtas4.012&tf&0&&A user always needs to view files as tables. Looking at individual records serves no purpose.&FALSE&TRUE&Wrong! Sometimes a user will want to work with one record at a time.&&&&Database&&&Wrong! Sometimes a user will want to work with one record at a time.&0
|
|
mmtas4.013&mcs&0&N&Which one of the following statements is <B><U>false</B></U>?&You can thank Oracle for inventing Structured Query Language (SQL).&English is the business language of the world.;Structured Query Language (SQL) is how users can access relational databases on mainframes and UNIX servers.;There are many database vendors in today's marketplace.;&The false statement is 'You can thank Oracle for inventing Structured Query Language (SQL).' SQL came from IBM.&&&a&Database.0&&&&0
|
|
mmtas4.014&tf&0&N&SQL (Structured Query Language) was designed for programmers and database managers and is not very user friendly.&FALSE&TRUE&This statement is false. SQL was designed to be user-friendly.&&&&Database.0&&&&0
|
|
mmtas4.015&mcs&0&N&Why is SQL so popular and widely used?&It has an English-like syntax, and it is available on PC and mainframe database systems.&It is easily converted to COBOL for use in other applications.;It is mainly used in the mainframe environment.;It is run from an internet-based server.;&No, the best answer is 'It has an English-like syntax and it is available on PC and mainframe database systems.'&&&a&Database.0&&&&0
|
|
mmtas4.016&tf&0&N&Since its initial release, there have been several new versions of SQL that add new features to make the language more powerful and easier to use.&TRUE&FALSE&This is true.&&&&Database.0&&&&0
|
|
mmtas4.017&mcs&0&N&Which one of the following statements is <B><U>false</B></U> about BI (Business Intelligence (Also called DM or Data Mining)&BI is a very simple process because it takes various data from different sources and easily predicts trends.&BI solutions provide new insights related to customer buying habits and market opportunities.;BI applications often help companies find new ways of serving and interacting with their customers.;BI is an all-encompassing term used to describe the use of data to help with decision making in business.;&No. This statement is true. The correct answer is 'BI is a very simple process because it takes various data from different sources and easily predicts trends.' In fact, BI is very complex, and source data must be 'cleansed' of duplications, errors, inconsistancies and other quality problems before trends can be established.&&&a&Database.0&&&&0
|
|
mmtas4.018&tf&0&Y&Retailer Toys 'R' Us has the largest data warehouse on record. This helps with both on-line e-business and restocking stores nationwide.&FALSE&TRUE&Not true! Wal-Mart has the largest data warehouse on record.&&&&Database.0&&&&0
|
|
mmtas4.019&tf&0&Y&Data warehousing is a difficult and expensive technology, but it can provide enormous rewards because it can enable business decision makers to predict buying patterns.&TRUE&FALSE&This is a true statement.&&&&Database.0&&&&0
|
|
mmtas4.020&mcs&0&N&Which statement is <B><U>true</B></U> when speaking about data mining?&Data mining refers to the ability to drill down and look for patterns and matches within the raw data.&Data mining is only useful for companies who do all their business on mainframes. ;Data mining is not a complex process.;Data mining was developed to help dig out information from another company's files.;&The correct answer is 'Data mining refers to the ability to drill down and look for patterns and matches within the raw data.'&&&a&Database.0&&&&0
|
|
mmtas4.021&mcs&0&&What is considered the most expensive component of data warehousing?&Cleansing data of the inconsistencies in syntax, semantics and the different ways the data is stored.&Creating subsets of data or 'data marts' that specialize in more detailed analysis of the information gathered.;The computer hardware, especially the tape drives and optical disks for storage of data.;Scattered sources of information that come from a variety of formats and from numerous vendors.;&Sorry, that's wrong! The correct answer is 'Cleansing data of the inconsistencies in syntax, semantics and the different ways the data is stored.' Some estimates suggest up to 80% of a data warehousing budget should be dedicated to data cleansing.&&&a&Database&&&Sorry, that's wrong! The correct answer is 'Cleansing data of the inconsistencies in syntax, semantics and the different ways the data is stored.' Some estimates suggest up to 80% of a data warehousing budget should be dedicated to data cleansing.&0
|
|
mmtas4.022&tf&0&N&Since building a data warehouse usually means crossing different political domains within an organization, the implied loss of control can make data owners less than cooperative. This needs to be addressed early on to avoid political repercussions.&TRUE&FALSE&This is true. Politics in an organization almost always figures in when information has to be shared by many different departments.&&&&Database.0&&&&0
|