Upgrade to remove ads Show Only ₩37,125/year
Terms in this set (39)Which of the following would not be considered a database data type? SELECT Which database data type is a collection of binary data stored in a single field of a database? BLOB
One of the ways that databases are classified is by their structure. True The entire Internet contains about a zettabyte of data. False __________ are the most commonly used database clients. Browsers __________ refers to a branch of data mining that analyzes current and historical data to predict future trends. Predictive analytics An efficiently designed database uses computed fields whenever possible because they do not require manual data entry. True It is not possible to extract analytical data from operational databases. False In a case-sensitive database, uppercase letters are equivalent to their lowercase counterparts. False A(n) _____________ is a specification that the database designer sets up to filter data entered into a particular field. Field validation rule FileMaker Pro and Microsoft Access are DBMSs. True SQL statements contain command words but do not contain data. False A(n) ________________ is a software tool for specifying the content and format for a database report. Report generator Which of the
following is not considered to be type of database client? all of the above Spreadsheet software offers database capabilities for establishing relationships between different record types. False In a relational database, relationships are specified by joining common data stored in records from different tables. True Which of the following is not one of the main activities associated with operational databases? providing an executive dashboard for decision makers A __________ solution for data storage adds resources to a single device, while a __________ solution adds more devices to a system. scale up, scale out The relationship between record types can be depicted graphically with a(n) _________. ERD Which database tool is best for simple flat files that involve calculations? Spreadsheet software A(n) _________ database is used to collect, modify, and maintain data on a daily basis. operational Modern database tools support ________________, which entails separating data from the programs that manipulate data. data independence The SQL ________ command allows you to temporarily join and simultaneously access the data in more than one table. JOIN The acronym ____________ refers to software that manages data stored in a database. DBMS The goal of normalization is to minimize data redundancy. True 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(n) __________ is the column of data in a database that is used as the basis for rearranging the data. sort key In a database, a(n) __________ contains the smallest unit of meaningful information field A table's physical sort order is the order in which records are arranged on storage devices. True Dynamic scaling for database servers can be a challenge because the additional sharding has to be handled on the fly by the DBMS. True A DBMS feature known as __________ ensures that transactions are updated in an orderly manner by establishing update rules. Serializability __________ is a data analysis technique used by decision makers to quickly get answers to complex queries that encompass multiple factors, such as locations, revenue, time periods, and employee status. OLAP SQL keywords must be entered in all uppercase letters because they are case-sensitive. False A(n) _________ sort uses one field, to arrange records. A(n) _________ sort arranges information by more than one field. single-level, multi-level A filing cabinet full of folders and papers would be classified as a structured file because every document has a unique structure. False A lookup routine validates an entry by checking data in an in-house or third-party database. True Dedicated enterprise database applications may allow cosmetic changes, but they do not encourage modifications of core data structures. True In a key-value database, each data item has a key that is a unique identifier similar to a relational database key True Programmers insert documentation called facts into the program code. False Recommended textbook solutionsIntroduction 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 Engineering Electromagnetics8th EditionJohn Buck, William Hayt 483 solutions Sets with similar termsComputer applications Chapter 1021 terms markyd87 1032 terms Ariyle12345 concepts 1030 terms banfillj Computer Concepts Unit 1031 terms vickilush Sets found in the same folderComputer Concepts for End Users: Unit 11120 terms taylor_ann_rebidoux Computer Concept for End Users: Unit 9121 terms taylor_ann_rebidoux Final Review (Unit 8)30 terms sarah_rehman82PLUS Final Review (Unit 11)37 terms sarah_rehman82PLUS Other sets by this creatorMucosal Exam41 terms sarah_rehman82PLUS Ethical Issues5 terms sarah_rehman82PLUS Local Anesthetic8 terms sarah_rehman82PLUS Perm Teeth Calcification and Root Completion51 terms sarah_rehman82PLUS Verified questions
COMPUTER SCIENCE Can we use the tail-call optimization in this function? If no, explain why not. If yes, what is the diff erence in the number of executed instructions in f with and without the optimization? Verified answer
COMPUTER SCIENCE Let CFG G be the following grammar. $S \rightarrow a S b|b Y| Y a$, $Y \rightarrow \mathrm{b} Y|\mathrm{a} Y| \varepsilon$. Give a simple description of L(G) in English. Use that description to give a CFG for $\overline{L(G)}$, the complement of L(G). Verified answer COMPUTER SCIENCE For the set of {1, 4, 5, 10, 16, 17, 21} of keys, draw binary search trees of heights 2, 3, 4, 5, and 6. Verified answer
COMPUTER SCIENCE Suppose that a dynamic set S is represented by a direct-address table T of length m. Describe a procedure that finds the maximum element of S. What is the worst-case performance of your procedure? Verified answer Other Quizlet setsUnit 5 Civil war20 terms JackieB730 Exams 1, 2 , and 396 terms richardson_mary1 American Political Controversies Final #330 terms kiararayls History40 terms cayleynicole93PLUS Related questionsQUESTION An explicit cursor must return two or more rows. (T/F) 3 answers QUESTION Which XML method is used to determine if the query returns a nonempty result? 4 answers QUESTION When creating a new Generic Object, you want to add a field that references a Legal Entity object. How do you configure this? 2 answers QUESTION 6.2 What is the relationship between entities and tables? Between attributes and columns? 6 answers Is a single category of data to be stored in a database?A single category of data to be stored in a database, such as customer names or employee telephone numbers. Also called a column. A field in a database. A collection of related fields in a database.
What is data type as used in database?A data type is a description of the kind of data in a table column. Each database system recognises its own set of datatypes, although some are common to many. Typical examples will be Integer or Text.
What kinds of data is typically stored in a database?Computer databases typically store aggregations of data records or files that contain information, such as sales transactions, customer data, financials and product information. Databases are used for storing, maintaining and accessing any sort of data. They collect information on people, places or things.
What is relational data type?A relational database is a type of database that stores and provides access to data points that are related to one another. Relational databases are based on the relational model, an intuitive, straightforward way of representing data in tables.
|