Upgrade to remove ads Show Only ₩37,125/year
Terms in this set (30)A(n) _________ database is used to collect, modify, and maintain data on a daily basis. operational A(n) _________ database is used to collect data that will be used for spotting trends that offer insights for tactical analytical Which of the following is not one of the main activities associated with operational databases? providing an executive dashboard for decision makers Data _________ refers to computer algorithms that analyze information to discover previously unknown and mining __________ is a data analysis technique used by decision makers to quickly get answers to complex queries that OLAP __________ refers to a branch of data mining that analyzes current and historical data to predict future trends. predictive analytics In a database, a(n) __________ contains the smallest unit of meaningful information field A record that contains data is referred to as a record ________. occurrence The relationship between record types can be depicted graphically with a(n) _________. ERD Modern database tools support ________________, which entails separating data from the programs that data independence Which database tool is best for simple flat files that involve calculations? spreadsheet software A(n) _________ sort uses one field, to arrange records. A(n) _________ sort arranges information by more than single level multi level The acronym ____________ refers to software that manages data stored in a database. DBMS A DBMS feature known as __________ ensures that transactions are updated in an orderly manner by establishing update rules. serializability Which of the following is not considered to be type of database client? local software _________ are the most commonly used database clients. browsers A computed ___________ is a calculation that a DBMS performs, similar to the way a spreadsheet computes a formula. field A(n) _______________ is a field that contains data unique to a record. primary key A(n) ____________ is a template that adds the correct formatting as data is entered. If
someone attempts to field format A(n) _____________ is a specification that the database designer sets up to filter data entered into a particular field validation rule Which of the following would not be considered a database data type? SELECT Which database data type is used for fields that contain whole numbers—quantities, repetitions, rankings, and so on? integer Which database data type is a collection of binary data stored in a single field of a database? BLOB A(n) __________ is the column of data in a database that is used as the basis for rearranging the data. sort key A(n) ________________ is a software tool for specifying the content and format for a database report. report generator Which of the following is not a SQL keyword? remove which SQL keyword is used to search for records? SELECT An emerging computing platform that is likely to drive innovation and disruption through the next decade called __________ has massive scale, not only in cloud-based hardware technology, but also in the vast amount of data that will be generated, consumed, and analyzed. the 3rd platform A __________ solution for data storage adds resources to a single device, while a __________ solution adds scale up, scale out In a __________ database, processing logic for the query is performed on the device that holds each database NoSQL Recommended textbook solutions
Engineering Electromagnetics8th EditionJohn Buck, William Hayt 483 solutions Introduction to Algorithms3rd EditionCharles E. Leiserson, Clifford Stein, Ronald L. Rivest, Thomas H. Cormen 720 solutions
Computer Organization and Design MIPS Edition: The Hardware/Software Interface5th EditionDavid A. Patterson, John L. Hennessy 220 solutions
Introduction to the Theory of Computation3rd EditionMichael Sipser 389 solutions Sets with similar terms1032 terms Ariyle12345 Computer Concepts Unit 1031 terms vickilush Computer applications Chapter 1021 terms markyd87 Unit 1077 terms madharbs1 Sets found in the same folderFinal Review (Unit 10)39 terms sarah_rehman82PLUS Databases15 terms annaparedes25 concepts 928 terms banfillj CI-119 Final149 terms struggleisreal Other sets by this creatorquiz 1 intro to internet20 terms banfillj quiz 3 intro to the internet30 terms banfillj quiz 2 intro to internet20 terms banfillj quiz 1 intro to internet20 terms banfillj Other Quizlet setsExam 116 terms aesicard Lab 1: Vertebrae20 terms tjcrutch2PLUS Gender and Sexuality Studies43 terms sarahmccaffrey1717 Exam 442 terms elenigiannulis Related questionsQUESTION When a value exceeds it assigned data type, a(n) "_" occurs. 2 answers QUESTION Number 21. Are used to ensure that a value in one column has to match the value in another column (usually a column in a different table, but not always). 2 answers QUESTION What is the purpose of the Form Layout Tools Arrange tab? 5 answers QUESTION You want to schedule a job to rebuild a table's indexes after a bulk insert, which must be scheduled as soon as a file containing data arrives on the system. What would you do to accomplish this? 2 answers Which database data type is a collection of binary data stored in a single field of a database?A binary large object (BLOB or blob) is a collection of binary data stored as a single entity.
What datatype stores binary values quizlet?Integers are whole numbers represented as binary values. Most programming languages provide a data type called 'integer', often called 'int' for short. You just studied 15 terms!
Which database is the most popular type used by businesses?SQL Server. SQL Server database developed by Microsoft is one of the most popular databases in the world. Initially launched in 1989 and written in C, C++, SQL Server is now widely used among major companies.
Which is the most popular type of database quizlet?The relational database is the most common type of database today. Relational databases organize data into two-dimensional tables (called relations) with columns and rows.
|