WGU C175 quizzes/. Top exam questions with accurate answers, rated A+ One disadvantage of the DBMS is t

Document Content and Description Below

WGU C175 quizzes/. Top exam questions with accurate answers, rated A+ One disadvantage of the DBMS is that it increases the risk of data security breaches. - ✔✔-False Accurate, relevant, and t... imely information is the key to____. - ✔✔-good decision making _____ relates to the activities that make the database execute transactions more efficiently in terms of storage and access speed. - ✔✔-Performance tuning The response of the DBMS to a query is the ______. - ✔✔-query result set Field refers to a collection of related records. - ✔✔-False The DBMS uses the ________ to look up the required data component structures and relationships, thus relieving programmers from having to code such complex relationships in each program. - ✔✔-data dictionary A(n) ________ is a collection of programs that manages the database structure and controls access to the data stored in the database. - ✔✔-database management system A _____ is a character or group of characters that has a specific meaning. - ✔✔-field Data warehouse contains historical data obtained from the_____. - ✔✔-operational databases The database structure in a DBMS is stored as a ______. - ✔✔-collection of files The DBMS reveals much of the database's internal complexity to the application programs and users. - ✔✔-False _____ exists when different versions of the same data appear in different places. - ✔✔-Data inconsistency A _____ contains at least all of the attribute names and characteristics for each table in the system. - ✔✔-data dictionary A(n) _____ might be written by a programmer or it might be created through a DBMS utility program. - ✔✔-application _____ is the body of information and facts about a specific subject. - ✔✔-Knowledge An XML database supports the storage and management of _____ XML data. - ✔✔-semistructured The only way to access the data in a database is through the DBMS. - ✔✔-True Metadata describe the data characteristics and the set of relationships that links the data found within the database. - ✔✔-True A data warehouse can store data derived from many sources. - ✔✔-True A workgroup database is a(n) _____ database. - ✔✔-multiuser Data is said to be verifiable if_____ - ✔✔-the data always yields consistent results. A desktop database is a _____ database. - ✔✔-single-user _____ is defined as the condition in which all of the data in the database are consistent with the realworld events and conditions. - ✔✔-Data integrity Corporations use only structured data. - ✔✔-False ________ is a special language used to represent and manipulate data elements in a textual format. - ✔✔-Extensible Markup Language (XML) Data processing can be as simple as organizing data to reveal patterns. - ✔✔-True Data is the result of processing raw facts to reveal its meaning. True False - ✔✔-False ________ is data about data through which the end-user data are integrated and managed. - ✔✔- Metadata One disadvantage of a database system over previous data management approaches is increased costs. - ✔✔-True ________ relates to activities that make a database operate more efficiently in terms of storage and access speed. - ✔✔-Performance tuning ________ is the result of processing raw data to reveal its meaning. - ✔✔-Information Structural dependence exists when it is possible to make changes in the file structure without affecting the application program's ability to access the data. - ✔✔-False Data constitute the building blocks of information. - ✔✔-True An operational database is sometimes referred to as an enterprise database. - ✔✔-False ________ exists when the same data are stored unnecessarily at different places. - ✔✔-Data redundancy _____ serve as the intermediary between the user and the database. - ✔✔-DBMSs One advantage of a database system over previous data management approaches is that the database system is considerably less complex. - ✔✔-False The organization of data within folders in a manual file system is determined by _____. - ✔✔-its expected use ________ databases focus primarily on storing data used to generate information required to make tactical or strategic decisions. - ✔✔-Analytical What refers to the situation where the same data is stored unnecessarily at different places? - ✔✔-Data redundancy Information is produced by processing ________ . - ✔✔-data A(n) ________ is a specific request issued to the DBMS for data manipulation. - ✔✔-query An advantage of database systems is that you needn't perform frequent updates and apply latest patches. - ✔✔-False Raw data must be properly ________ for storage, processing and presentation. - ✔✔-formatted A _____ is a logically connected set of one or more fields that describes a person, place, or thing. - ✔✔- record A(n) ________ develops when all required changes in the redundant data are not made successfully. - ✔✔-data anomaly _____ are the result of formatting disorganized data in order to facilitate storage, use and generation of information. - ✔✔-Structured data The same data might be simultaneously structured and unstructured depending on the intended processing. - ✔✔-True _____ data exist in the format in which they were collected. - ✔✔-Unstructured _____ is the result of revealing the meaning of raw facts. - ✔✔-Information Data and information are essentially the same thing. - ✔✔-False To reveal meaning, information requires ________ . - ✔✔-context _____ data exist in a format that does not lend itself to processing that yields information. - ✔✔- Unstructured End-user data is ______. - ✔✔-raw facts of interest to the end user Data anomaly is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions. - ✔✔-False A(n) ________ is a spur-of-the-moment question. - ✔✔-ad hoc query ______ provide a description of the data characteristics and the set of relationships that link the data found within the database. - ✔✔-Metadata A(n) ______ database is used by an organization and supports many users across many departments. - ✔✔-enterprise A _____ is a collection of related records. - ✔✔-file Most data that can be encountered are best classified as _____ . - ✔✔-semistructured A(n) _____ database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization. - ✔✔-workgroup What enhances the user's ability to understand data? - ✔✔-spreadsheet applications The term _____ refers to an organization of components that define and regulate the collection, storage, management and use of data within a database environment. - ✔✔-database system The term ________ refers to scattered locations storing the same basic data. - ✔✔-islands of information _____ refer to a type of database that stores most of its data in RAM rather than in hard disks. - ✔✔-Inmemory databases Database programming languages receive all application requests and translate them into the complex operations required to fulfill those requests. - ✔✔-False ________ exists when it is possible to make changes in the data storage characteristics without affecting an application program's ability to access data. - ✔✔-Data independence ________ exists when different and conflicting versions of the same data appear in different places. - ✔✔-Data inconsistency One of the limitations of the _______ model is that there is a lack of standards. - ✔✔-hierarchical A(n) _______ represents a particular type of object in the real world. - ✔✔-entity Even when a good database blueprint is available, an applications programmer's view of the data should match that of the manager and the end user. - ✔✔-False A data model is usually graphical. - ✔✔-True In object oriented terms, a(n) ________ defines an object's behavior. - ✔✔-method M:N relationships are not appropriate in a relational model. - ✔✔-True The _______ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text. - ✔✔-entity relationship _______ are normally expressed in the form of rules. - ✔✔-Constraints What type of HDFS nodes stores all the metadata about a file system? - ✔✔-Name node MySQL is an example of the _______. - ✔✔-relational data model The _______ data model is said to be a semantic data model. - ✔✔-object-oriented A(n) ________ is a relatively simple representation of more complex real-world data structures. - ✔✔- data model The _______ model uses the term connectivity to label the relationship types. - ✔✔-entity relationship The hierarchical model is software-independent. - ✔✔-False In an SQL-based relational database, each table is dependent on every other table. - ✔✔-False VMS/VSAM is an example of the _______. - ✔✔-file system data model A disadvantage of the relational database management system (RDBMS) is its inability to hide the complexities of the relational model from the user. - ✔✔-False You can think of a table as a persistent representation of a logical relation. - ✔✔-True Character data can contain any character or symbol intended for mathematical manipulation. - ✔✔- False In the _______ model, the user perceives the database as a collection of records in 1:M relationships, where each record can have more than one parent. - ✔✔-network Within the database environment, a data model represents data structures with the purpose of supporting a specific problem domain. - ✔✔-True In an SQL-based relational database, rows in different tables are related based on common values in common attributes. - ✔✔-True A(n) ________ defines the environment in which data can be managed and is used to work with the data in the database. - ✔✔-data manipulation language (DML) NoSQL are not based on the relational model. - ✔✔-True A(n) ________ is a brief, precise, and unambiguous description of a policy, procedure, or principle within a specific organization. - ✔✔-business rule Each table in a relational database must have a primary key. - ✔✔-True An implementation-ready data model needn't necessarily contain enforceable rules to guarantee the integrity of the data. - ✔✔-False NoSQL databases provide ___ - ✔✔-fault tolerance. A(n) _______ is a restriction placed on the data. - ✔✔-constraint Each row in a relation is called a(n) ________ . - ✔✔-tuple From a database point of view, the collection of data becomes meaningful only when it reflects properly defined _______ . - ✔✔-business rules Database designers determine the data and information that yield the required understanding of the entire business. - ✔✔-False The relational model is hardware-dependent and software-independent. - ✔✔-False The network model has structural level dependence. - ✔✔-True The object-oriented data model was developed in the _______ . - ✔✔-1980s In the context of data models, an entity is a person, place, thing, or event about which data will be collected and stored. - ✔✔-True What type of HDFS nodes acts as the interface between the user application and the HDFS? - ✔✔-Client node Only a single attribute, not multiple attributes, can define functional dependence. - ✔✔-False In ________ , a three pronged symbol represents the "many" side of the relationship. - ✔✔-Crow's Foot notatio [Show More]

Last updated: 1 year ago

Preview 1 out of 32 pages