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

Document Content and Description Below

CIS 111 Final Exam 2020 (A Grade) – Strayer University • • Question 1 2 out of 2 points The ____ command is used to restore the table’s contents to their previous values. :...   ROLLBACK; :   ROLLBACK; • Question 2 2 out of 2 points Which of the following is used to select partial table contents? :   SELECT <column(s)>
     FROM <Table name>
          WHERE <Conditions>; :   SELECT <column(s)>
     FROM <Table name>
          WHERE <Conditions>; • Question 3 2 out of 2 points The SQL command that lets you select attributes from rows in one or more tables is ____. :   SELECT :   SELECT • Question 4 2 out of 2 points The SQL command that lets you insert rows into a table is ____. :   INSERT :   INSERT • Question 5 2 out of 2 points A(n) ____ is an alternate name given to a column or table in any SQL statement. :   alias :   alias • Question 6 2 out of 2 points The SQL character data format(s) is(are) ____. :   CHAR and VARCHAR :   CHAR and VARCHAR • Question 7 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? :   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 8 0 out of 2 points The ____ special operator is used to check whether an attribute value is null. :   BETWEEN :   IS NULL • Question 9 2 out of 2 points A ____ join returns rows with matching values and includes all rows from both tables (T1 and T2) with unmatched values. :   full outer :   full outer • Question 10 2 out of 2 points The PL/SQL block starts with the ____ clause. :   BEGIN :   BEGIN • Question 11 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. :   procedural SQL :   procedural SQL • Question 12 2 out of 2 points The syntax for the UNION query is ____. :   query UNION query :   query UNION query • Question 13 2 out of 2 points When using a(n) ____ join, only rows that meet the given criteria are returned. :   inner :   inner • Question 14 2 out of 2 points Installation and fine tuning are part of the ____ phase of the SDLC. :   implementation :   implementation • Question 15 2 out of 2 points There are ____ stages in the DBLC. :   six :   six • Question 16 2 out of 2 points A detailed system specification is part of the ____ phase of the SDLC. :   detailed systems design :   detailed systems design • Question 17 2 out of 2 points Evaluation, maintenance, and enhancement are part of the ____ phase of the SDLC. :   maintenance :   maintenance • Question 18 0 out of 2 points Creating the conceptual design and selecting DBMS software are part of the ____ phase of the DBLC. :   implementation and loading :   database design • Question 19 2 out of 2 points The primary objective of database design is ____. :   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 ____ are required to prevent another transaction from reading inconsistent data. :   Locks :   Locks • Question 21 2 out of 2 points A transaction is a ____ unit of work that must be either entirely completed or aborted. :   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. :   database-level :   database-level • Question 23 2 out of 2 points The implicit beginning of a transaction is ____. :   when the first SQL statement is encountered :   when the first SQL statement is encountered • Question 24 2 out of 2 points A(n) ____ condition occurs when two or more transactions wait for each other to unlock data. :   deadlock :   deadlock • Question 25 2 out of 2 points ____ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed. :   Isolation - - - - - - - - - - - - - -- - - - - -- - • Question 35 2 out of 2 points Decision support data tend to be non-normalized, ____, and pre-aggregated. :   duplicated :   duplicated • Question 36 2 out of 2 points Microsoft’s alternative to Java is ____. :   Active X :   Active X • Question 37 2 out of 2 points ____ is embedded inside an HTML page and is activated by triggering events such as clicking on a link. :   VBScript :   VBScript • Question 38 2 out of 2 points The Web browser’s job is to ____ the HTML code that it receives from the Web server. :   interpret :   interpret • Question 39 2 out of 2 points A programming language typically used for CGI scripts is ____. :   PERL :   PERL • Question 40 2 out of 2 points ____ is a collection of technologies used to access any type of data source and manage the data through a common interface. :   UDA :   UDA • Question 41 2 out of 2 points Which of the following is a well-defined Web-server interface? :   Common Gateway Interface :   Common Gateway Interface • Question 42 2 out of 2 points ODBC works on the ____ operating system. :   Windows :   Windows • Question 43 2 out of 2 points ____ deals with ensuring that data is protected against unauthorized access, and if the data are accessed by an authorized user, that the data are used only for an authorized purpose. :   Confidentiality :   Confidentiality • Question 44 2 out of 2 points Current data distribution philosophy makes it easy for ____ end users to access the database. :   authorized :   authorized • Question 45 0 out of 2 points ____ CASE tools provide support for the planning, analysis, and design phases. :   Back-end :   Front-end • Question 46 2 out of 2 points The ____ is responsible for ensuring database security and integrity. :   database security officer :   database security officer • Question 47 2 out of 2 points A(n) ____ data dictionary is automatically updated by the DBMS with every database access. :   active :   active • 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. :   Procedures :   Procedures • Question 49 2 out of 2 points ____ activities cover all tasks directly related to the day-to-day operations of the DBMS and its applications. :   System support :   System support • Question 50 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. :   role :   role [Show More]

Last updated: 1 year ago

Preview 1 out of 15 pages