CIS 111 Week 11 Final Exam 2020 (A Grade) – Strayer University | CIS 111 Week 11 Final Exam 2020 (A Grade)

Document Content and Description Below

CIS 111 Week 11 Final Exam 2020 (A Grade) – Strayer University 
Week 11 Final Exam Status Completed Attempt Score 98 out of 100 points   Time Elapsed 54 minutes out of 2 hours. Instruct... ions This final exam consists of 50 multiple choice questions and covers the material in Chapters 7 through 10 and Chapters 13 through 15. • Question 1 2 out of 2 points Which of the following is used to select partial table contents? Answer    SELECT <column(s)>
     FROM <Table name>
          WHERE <Conditions>;    SELECT <column(s)>
     FROM <Table name>
          WHERE <Conditions>; • Question 2 2 out of 2 points The SQL command that lets you permanently save data changes is ____. Answer    COMMIT    COMMIT • Question 3 2 out of 2 points The special operator used to check whether a subquery returns any rows is ____. Answer    EXISTS    EXISTS • Question 4 2 out of 2 points To list all the contents of the PRODUCT table, you would use ____. Answer    SELECT * FROM PRODUCT;    SELECT * FROM PRODUCT; • Question 5 2 out of 2 points The SQL character data format(s) is(are) ____. Answer    CHAR and VARCHAR    CHAR and VARCHAR • Question 6 2 out of 2 points Which query will output the table contents when the value of P_PRICE is less than or equal to 10? Answer    SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
        FROM PRODUCT
              WHERE P_PRICE <= 10;    SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
        FROM PRODUCT
              WHERE P_PRICE <= 10; • Question 7 2 out of 2 points A table can be deleted from the database by using the ____ command. Answer    DROP TABLE    DROP TABLE • Question 8 2 out of 2 points The SQL command that lets you insert rows into a table is ____. Answer    INSERT    INSERT • Question 9 2 out of 2 points The ____ query combines rows from two queries and excludes duplicates. Answer    UNION    UNION • Question 10 2 out of 2 points In Oracle, ____ make(s) it possible to merge SQL and traditional programming constructs, such as variables, conditional processing (IF-THEN-ELSE), basic loops (FOR and WHILE loops,) and error trapping. Answer    procedural SQL    procedural SQL - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The primary objective of database design is ____. Answer    to create complete, normalized, nonredundant, and fully integrated conceptual, logical, and physical database models    to create complete, normalized, nonredundant, and fully integrated conceptual, logical, and physical database models • Question 20 2 out of 2 points A(n) ____ condition occurs when two or more transactions wait for each other to unlock data. Answer    deadlock    deadlock • Question 21 2 out of 2 points A transaction is a ____ unit of work that must be either entirely completed or aborted. Answer    logical    logical • Question 22 2 out of 2 points A ____ lock prevents the use of any tables in the database from one transaction while another transaction is being processed. Answer    database-level    database-level • Question 23 2 out of 2 points All transactions must display ____. Answer    atomicity, durability, consistency, and isolation    atomicity, durability, consistency, and isolation • Question 24 2 out of 2 points A ____ lock allows concurrent transactions to access different rows of the same table. Answer    row-level    row-level • Question 25 2 out of 2 points A ____ lock locks the entire table preventing access to any row by a transaction while another transaction is using the table. Answer    table-level    table-level • Question 26 2 out of 2 points A(n) ____ specifically reserves access to the transaction that locked the object. Answer    exclusive lock    exclusive lock • Question 27 2 out of 2 points The ____ schema is designed to optimize data query operations rather than data update operations. Answer    star    star • Question 28 2 out of 2 points ____ are in charge of presenting the data to the end user in a variety of ways. Answer    Data visualization tools    Data visualization tools • Question 29 2 out of 2 points A data mart is part of the “____” section of the business intelligence framework. Answer    Governance    Governance • Question 30 2 out of 2 points Data ____ implies that all business entities, data elements, data characteristics, and business metrics are described in the same way throughout the enterprise. Answer    integration    integration • Question 31 2 out of 2 points From the data analyst’s point of view, decision support data differ from operational data in three main areas: time span, granularity, and ____. Answer    dimensionality    dimensionality • Question 32 0 out of 2 points A characteristic of decision support data is ____. Answer    highly normalized    high query activity • Question 33 2 out of 2 points The ____ contains business data extracted from the operational database and from external data sources. Answer    data store    data store • Question 34 2 out of 2 points The basic star schema has four components: facts, ____, attributes, and attribute hierarchies. Answer    dimensions    dimensions - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - In the ____ category, the cloud service provider offers the capability to build and deploy consumer-created applications using the provider’s cloud infrastructure. Answer    Platform as a Service (PaaS)    Platform as a Service (PaaS) • Question 43 2 out of 2 points A ____ is a named collection of database access privileges that authorize a user to connect to the database and use the database system resources. Answer    role    role • Question 44 2 out of 2 points The person responsible for the control of the centralized and shared database is the database ____. Answer    administrator    administrator • Question 45 2 out of 2 points ____ CASE tools provide support for the planning, analysis, and design phases. Answer    Front-end    Front-end • Question 46 2 out of 2 points Classifying users into ____ according to common access needs facilitates the DBA’s job of controlling and managing the access privileges of individual users. Answer    user groups    user groups • Question 47 2 out of 2 points ____ are more detailed and specific than policies and describe the minimum requirements of a given DBA activity. Answer    Standards    Standards • Question 48 2 out of 2 points ____ are written instructions that describe a series of steps to be followed during the performance of a given activity. Answer    Procedures    Procedures • Question 49 2 out of 2 points The ____ is responsible for ensuring database security and integrity. Answer    database security officer    database security officer • Question 50 2 out of 2 points The DBA’s ____ role covers activities involving the use of the DBMS. Answer    technical    technical [Show More]

Last updated: 1 year ago

Preview 1 out of 17 pages