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.
27 lines
5.9 KiB
27 lines
5.9 KiB
id&qtp&qim&qil&qtx&qca&qia&qrm&qnxt&qprv&qalb&subj&wght&pts&flr&ded&layout&qfixed&qptsbyans&flags
|
|
dbtp1.001&tf&0&N&True or False:<br>
|
|
;Database fields can hold six different types of data:
|
|
;TEXT, NUMBER, DATE, TIME, GRAPHIC, or COMPUTED.&TRUE&FALSE&The statement is true.<br>&&&&undefined.0&&&&&1&&&N.
|
|
dbtp1.002&tf&0&Y&True or False? <br><br>A multidimensional database organizes data by dependency.&FALSE&TRUE&A hierarchical database organizes data by dependency. &&&&undefined.0&&&&&1&&&N.
|
|
dbtp1.003&tf&0&Y&True or False? <br><br>Hierarchical databases involve the use of multiple tables and clustered groups.&TRUE&FALSE&&&&&undefined.0&&&&&1&&&N.
|
|
dbtp1.004&tf&0&Y&True or False? A form view is used to view one record at a time.&TRUE&FALSE&&&&&undefined.0&&&&&1&&&N.
|
|
dbtp1.005&tf&0&Y&True or False? A table view allows fast access to data.&FALSE&TRUE&An index allows fast access to data.&&&&undefined.0&&&&&1&&&N.
|
|
dbtp1.006&tf&0&Y&True or False? In a table view multiple records can be viewed at once.&TRUE&FALSE&&&&&undefined.0&&&&&1&&&N.
|
|
dbtp1.007&tf&0&Y&True or False? The data administrator is mainly concerned with the technical aspects of managing corporate databases.&FALSE&TRUE&&&&&undefined.0&&&&&1&&&N.
|
|
dbtp1.008&tf&0&Y&True or False? DB2 is IBM's premier relational-database system, designed to help people easily access text on IBM mainframe computers.&FALSE&TRUE&&&&&undefined.0&&&&&1&&&N.
|
|
dbtp1.009&mcs&0&Y&Which one of the following statements is the most accurate?&All of the above statements are false.&In the future, Net.Data will allow users to view and access data through Web browsers.;DataJoiner allows different vendors' databases to access each other, as long as they are all relational.;IBM's DB2 family of products is designed for IBM hardware and software.;&&&&a&undefined.0&&&&&1:v&&&N.
|
|
dbtp1.010&mcs&0&Y&Which of the following is not a TP monitor?&UNIX&TxSeries;CICS;IMS;&&&&a&undefined.0&&&&&1:v&&&N.
|
|
dbtp1.011&esa&0&Y&Transaction processing characteristics include flawless execution, the fulfillment of user expectations, qualities of service, middleware known as ____________, and programming techniques.&TP monitors;TP Monitor&&&&&&undefined.0&&&&&1&&&N.
|
|
dbtp1.012&tf&0&Y&True or False? Transaction processing is an essential part of an on-demand software infrastructure.&TRUE&FALSE&&&&&undefined.0&&&&&1&&&N.
|
|
dbtp1.013&esa&0&&Businesses need some type of system to keep their data organized, accessible, and _________.&protected&&Businesses need some type of system to keep their data organized, accessible, and protected.&&&&undefined.0&&&&&1&&&N.
|
|
dbtp1.014&esa&0&N&Databases allow people to find, organize, sort, view, protect, and print ______.&data&&Databases allow people to find, organize, sort, view, protect, and print data.&&&&undefined.0&&&&&1&&&N.
|
|
dbtp1.015&esa&0&N&A flat file is usually defined as a one-dimensional or two-dimensional array or as a list or table of
|
|
;items. However, a flat file is also a simple __________ structure.&database&&A flat file is usually defined as a one-dimensional or two-dimensional array or as a list or table of
|
|
;<br>;items. However, a flat file is also a simple database structure.&&&&undefined.0&&&&&1&&&N.
|
|
dbtp1.016&esa&0&&In database terminology, each completed form is called a __________.&record&&In database terminology, each completed form is called a record.&&&&undefined.0&&&&&1&&&N.
|
|
dbtp1.017&esa&0&&The collection of fields in a flat-file database is called a_______.&table&&The collection of fields in a flat-file database is called a table.&&&&undefined.0&&&&&1&&&N.
|
|
dbtp1.018&esa&0&&Information in tables can be viewed two ways: ______ view or column/table view.&form&&Information in tables can be viewed two ways: form view or column/table view.&&&&undefined.0&&&&&1&&&N.
|
|
dbtp1.019&esa&0&N&Flat-file databases usually work well for small, self-contained units of data such as customer names,
|
|
;addresses, and phone numbers. In larger enterprise settings, however, a more _________ type of database is
|
|
;required.&powerful&&In larger enterprise settings, however, a more powerful type of database is required.&&&&undefined.0&&&&&1&&&N.
|
|
dbtp1.020&esa&0&&A relational database stores data in multiple _____, which are made up of rows and columns.&tables&&A relational database stores data in multiple tables, which are made up of rows and columns.&&&&undefined.0&&&&&1&&&N.
dbtp1.021&esa&0&N&A hierarchical database is organized like a __________, with each row of objects linked to another row of
;objects directly beneath it.&pyramid&&A hierarchical database is organized like a pyramid.&&&&undefined.0&&&&&1&&&N.
dbtp1.022&tf&0&N&True or False:<br><br>Multidimensional databases are designed for analyzing large groups of records grouped
;by an additional dimension, such as time.&TRUE&FALSE&True. Time is just one of many dimensions that can be specified for a multidimensional database.&&&&undefined.0&&&&&1&&&N.
dbtp1.023&tf&0&&On-line analytical processing (OLAP) was created because relational databases were too slow or too
;inflexible to provide the reports that the business needed.&TRUE&FALSE&True. The relational database queries were too slow and not flexible enough to navigate the data.&&&&undefined.0&&&&&1&&&N.
dbtp1.024&esa&0&N&A critical goal of an OLAP product is to minimize the "on-the-fly" processing needed while the user is
;trying to navigate the ______.&data&&...minimizing "on-the-fly" processing while the user is trying <br>to navigate the data.&&&&undefined.0&&&&&1&&&N.
dbtp1.025&esa&0&N&OLAP products are faster by performing _____________ and storing every possible combination of dimensions,
;measures, and hierarchies before the user starts an analysis.&pre-processing&&OLAP products perform pre-processing which gives them a speed advantage.&&&&undefined.0&&&&&1&&&N.
dbtp1.026&esa&0&&OLAP is the processing used in decision __________.&support. &&Decision Support Systems (DSS) is a classification of software that covers a wide spectrum including OLAP.&&&&undefined.0&&&&&1&&&N.
|
|
|