CIS 336 DeVry Final Exam

Downloading is very simple, you can download this Course here:

http://wiseamerican.us/product/cis-336-devry-final-exam/

Or

Contact us at:

SUPPORT@WISEAMERICAN.US

CIS 336 DeVry Final Exam

CIS336

CIS 336 DeVry Final Exam

 

  1. (TCO 1)Most DBMS are referred to as _____________database management systems. (Points : 4)
  • elemental
  • linked
  • hierarchical
  • relational

 

  1. (TCO 1)Data constitutes the building blocks of _____________. (Points : 4)
  • information
  • processing
  • applications
  • programming

 

  1. (TCO 2)If a foreign key contains either matching values or nulls, the table(s) that make use of such a foreign key is/are said to exhibit __________ integrity. (Points : 4)
  • referential
  • restrictive
  • secondary
  • redundant

 

  1. (TCO 2) In a “one-to-many” relationship, which constraint is usually added to the “many” table? (Points : 4)
  • UNIQUE
  • PRIMARY KEY
  • FOREIGN KEY
  • NOT NULL

 

  1. (TCO 3)A ____ occurs when a relationship is improperly or incompletely identified and, therefore, is represented in a way that is not consistent with the real world. (Points : 4)
  • surrogate primary keys
  • time-variant data
  • design trap
  • fan trap

 

  1. (TCO 3)All of the following are true about a prime attribute except_____________. (Points : 4)
  • it is a key attribute
  • it is at least part of a key
  • it is not a key attribute
  • it may be part of a composite key

 

  1. (TCO 3)The conflicts between design efficiency, information requirements, and processing speed are often resolved through_____________. (Points : 4)
  • conversion from 1NF to 2NF
  • conversion from 2NF to 3NF
  • compromises that include denormalization
  • conversion from 3NF to 4NF

 

  1. (TCO 4)When a constraint is created at the ______ level with the CREATE TABLE command, the constraint definition is simply included as part of the column definition.(Points : 4)
  • table
  • column
  • database
  • row

 

Page 2 – Multiple Choice

 

  1. (TCO 4)In Oracle, the CONSTRAINT clause is used to ___________________. (Points : 4)
  • create only referential constraints
  • define and name any constraint
  • create a short cut so the constraint does not have to be named
  • create only entity entegrity constraints

 

  1. (TCO 4)The SQL command that lets you list the table contents is (Points : 4)
  • insert.
  • select.
  • commit.
  • update.
  • rollback.

 

  1. (TCO 5)The Crow’s Foot model is more ___________-oriented than the Chen model. (Points : 4)
  • object
  • user
  • implementation
  • processor

 

  1. (TCO 5)The ___________ model is both software and hardware dependent. (Points : 4)
  • conceptual
  • logical
  • condensed
  • physical

 

  1. (TCO 6)Which of the following commands will add a new column named FIRSTORDERDATE to the CUSTOMERS table to store the date that the customer first placed an order with the company? (Points : 4)
  • CREATE COLUMN firstorderdate, DATE TO customers;
  • ALTER TABLE customers ADD COLUMN firstorderdate DATE;
  • ALTER TABLE customers ADD firstorderdate DATE;
  • ALTER TABLE customers ADD (firstorderdate DATE);

 

  1. (TCO 6)When modifying the data characteristics of a column in Oracle, which of the following is correct? (Points : 4)
  • The column size can be increased.
  • The size of the column can be decreased.
  • Changing the default value of a column will change the values of data already in a table.
  • If a NUMBER column is empty, its precision and scale cannot be changed.

 

  1. (TCO 6)Which of the followig SQL commands would alter the table DEVRY and add a foreign key that references the CITY table? (Points : 4)
  • ALTER table DEVRY ADD CONSTRAINT devry_studentcity_fk references city;
  • ALTER table DEVRY ADD CONSTRAINT devry_studentcity_fk FOREIGN KEY references city;
  • ALTER table DEVRY ADD CONSTRAINT devry_studentcity_fk FOREIGN KEY (student_city) references city;
  • ALTER table DEVRY ADD CONSTRAINT FOREIGN KEY (student_city) references city;

 

  1. (TCO 7)Given a table named EMPLOYEE, the SQL command to sort records in a specific order would be: (Points : 4)

 

  • SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE LIST BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
  • SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE ORDER BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
  • SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE DISPLAY BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
  • SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE SEQUENCE BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;

 

Page 3 – Multiple Choice

 

  1. (TCO 7)Which of the following subqueries returns more than one row of results to the outer query? (Points : 4)
  • multiple-column subquery
  • single-row subquery
  • multiple-row subquery
  • correlated subquery

 

  1. (TCO 7)Which of the following keywords can be used to join two tables that do not contain a commonly named and defined column? (Points : 4)
  • NATURAL JOIN
  • JOIN…ON
  • JOIN…USING
  • JOIN…WHERE

 

  1. (TCO 8)Based upon the contents of the BOOKS table shown below, which of the following SQL statements will return the number of categories contained in the table? (Points : 4)
  • SELECT COUNT(DISTINCT category) FROM books;
  • SELECT DISTINCT COUNT(category) FROM books;
  • SELECT DISTINCT (COUNT(category)) FROM books;
  • SELECT DISTINCT COUNT(category) FROM books;

 

  1. (TCO 8)The _____________ function can be used to display upper-case characters in lower-case. (Points : 4)
  • CONVERT
  • MIN
  • LESS
  • LOWER

 

  1. (TCO 8)Which of the following statements will produce the value 21.1? (Points : 4)
  • SELECT ROUND(21.12, 1) FROM dual;
  • SELECT ROUND(21.12, -1) FROM dual;
  • SELECT ROUND(21.12, 0) FROM dual;
  • SELECT ROUND(21.12, 0+) FROM dual;

 

  1. (TCO 9)The column to be updated by the UPDATE command is specified in the ______ clause. (Points : 4)
  • UPDATE
  • SET
  • WHERE
  • COL

 

  1. (TCO 9) If the INSERT INTO command is used to insert data values that violate an existing constraint in a table, which of the following will happen. (Points : 4)
  • Oracle will raise an error and you will have to go update the incorrect data.
  • Oracle will raise an error and the entire row will be rejected.
  • Oracle will raise an error and the invalid piece of data will be rejected.
  • Oracle will raise and error and all current transactions will be rolled back.

 

  1. (TCO 10)Which of the following commands is used to establish a user account? (Points : 4)
  • CREATE NEW USER username
  • IDENTIFIED BY password;
  • CREATE USERNAME username
  • IDENTITY password;
  • CREATE USER username PASSWORD password;
  • CREATE USER username IDENTIFIED BY password;

 

  1. (TCO 10)Which command will grant a system privilege to a user? (Points : 4)
  • GRANT systemprivilege USERNAME username
  • GRANT PRIVILEGE systemprivilege TO username
  • GRANT systemprivilege TO username
  • GRANT systemprivilege ON username