BANA 570 Final Questions and answers correct

BANA 570 Final Questions and answers correct ___ is the result of revealing the meaning of raw facts. Information ___ provide a description of the data characteristics and the set of relationships that link the data found within the database. Metadata ___ serve as the intermediary between the user and the database. DBMSs Which of the following is information? The average time of driving from Corvallis to Portland is 1 hour and 45 minutes Which of the following is NOT a problem of a file system? Lack of application programs Which of the following is NOT a function of DBMS? Generate information from data Which of the following is NOT an issue of data quality? Security Which of the following is information? We issued 3,512 invoices in the last 3 months One disadvantage of the DBMS is that it increases the risk of data security breaches. False What are the problems associated with file systems? How do they challenge the types of information that can be created from the data as well as the accuracy of the information? File systems have problems such as lengthy development times, difficulty in getting quick answers, a complex system administration, the lack of security and limited data sharing, as well as extensive programming. Lengthy development times challenge the types of information that can be created from the data as well as the accuracy of the information due to any simple task needing to be completed requires extensive amounts of time, especially if the file system is older and therefore slower overall as well. The difficulty in getting quick answers also requires extensive time in which the accuracy of the information may not be relevant once it is ready in comparison to when it needed to be. A complex system administration presents challenges such as increasing the numbers of files and information, which then creates issues such as adding, sending, modifying, or deleting such files. This problem also relates to increased time requirements. The lack of security and limited data sharing creates challenges in such that there is no security and all information can be tampered with. Extensive programming issues relates to all challenges listed above. Which of the following is metadata? IP addresses consists of 4 numbers between 0 and 255 and are usually displayed with a period between each number as in 10.222.255.1 Discuss any three functions performed by the DBMS that guarantee the integrity and consistency of the data in the database. Data Storage Management, Security Management, and Backup and Recovery Management all relate to the integrity and consistency of the data in the database. This is because without performance tuning in which allows for efficient performance, storage and access speed, the data will not process in the time it is needed. Security management is needed to keep the integrity of the data otherwise it may be tampered with and lose its integrity and consistency from outside sources. Lastly, recovery management is needed in case of a database failure or crash in which all data could be lost if it were unable to be backed up and recovered. This would overall diminish the consistency and integrity of the data in case only half of the data were to be saved and the rest to be lost. Data and information are essentially the same thing. False Metadata describe the data characteristics and the set of relationships that links the data found within the database. True Each table _____represents an attribute. Column In the relational database, ____are important because they are used to ensure that each row in a table is uniquely Keys A is an attribute or combination of attributes that is selected to uniquely identifies each row in a table. Primary Key The CUSTOMER table's primary key is CUS_CODE. The CUSTOMER primary key column has no null entries, and all entries are unique. This is an example of ____ Entity Integrity In SQL, the _____constraint assigns a value to an attribute when a new row is added to a table. DEFAULT Entity integrity is enforced automatically when the primary key is specified in the CREATE TABLE command True _____dictates that the foreign key must contain values that match the primary key in the related table, or must contain null. Referential Integrity Which SQL format would be best used for customer code? CHAR(L) The CREATE TABLE command lets you define constraints when you use the CONSTRAINT keyword, known as a(n) _____ constraint. Table When writing SQL table-creating command sequences, the entire table definition is enclosed in _____. Parentheses A _____ is the primary key of one table that has been placed into another table to create a common attribute. Foreign Key A _____ is any key that uniquely identifies each row. Superkey All changes in a table structure are made using the _____ TABLE command, followed by a keyword that produces the specific changes a user wants to make. ALTER The SQL command that allows a user to list the contents of a table is ____. SELECT When a user issues the DELETE FROM tablename command without specifying a WHERE condition, . All rows will be deleted Which of the following queries will output the table contents when the value of V_CODE is NOT equal to 21344? SELECT * FROM PRODUCT WHERE V_CODE <> 21344; Which of the following queries will list all the rows in which the inventory stock dates occur on or after January 20, 2016? SELECT * FROM PRODUCT WHERE P_INDATE >= '20-JAN-2016'; The special operator used to check whether an attribute value is within a range of values is_____. BETWEEN Which of the following queries is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another? SELECT DISTINCT V_CODE FROM PRODUCT; In the statement SELECT * FROM PRODUCT WHERE P_CODE="1546-QQ2", we use quotation marks for 1546-QQ2 is because: P_Code is string Which query is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another? SELECT DISTINCT V_CODE FROM PRODUCT; The SQL command that allows a user to permanently save data changes is _____. COMMIT Which comparison operator indicates a value is not equal? <> The special operator used to check whether an attribute value is within a range of values is _____. BETWEEN The conditional LIKE must be used in conjunction with wildcard characters False A(n) _____ is an alternate name given to a column or table in any SQL statement. Alias Some RDBMSs, such as Microsoft Access, automatically make the necessary conversions to eliminate case sensitivity. True The _____ command defines a default value for a column when no value is given. DEFAULT The purpose of an ERD is to: Depict a conceptual database design Lines between boxes in ERD's: Depict that a relationship exists between entities A University wants to keep track of students who take tests. Recommended: draw a simple ERD representing the relationship between these two entity types (student and test) on a piece of paper before you try to answer the question. How would the relationship between test and student entities be represented on an ERD? (Choose all that apply) The end of the line touching the student would have a 0 and a crow's foot The end of the line touching the test would have a 0 and a crow's foot