Cis 336 Course Success Begins / Tutorialrank.Com Essay

2354 Words May 8th, 2016 10 Pages
CIS 336: All iLabs Week 1 to Week 7: Devry University

For more course tutorials visit www.tutorialrank.com CIS 336: All iLabs Week 1 to Week 7: Devry University
------------------------------------------------------------------------------
CIS 336 Entire Course: Devry University

For more course tutorials visit www.tutorialrank.com CIS 336 Entire Course: Devry University
------------------------------------------------------------------------------

CIS 336 Final Exam 1

For more course tutorials visit www.tutorialrank.com 1. (TCO 1) Most DBMS are referred to as _____________database management systems. (Points : 4) elemental linked hierarchical relational
2.
…show more content…
(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
2. (TCO 4) The SQL command that lets you list the table contents is (Points : 4) insert. select. commit. update. rollback. 3. (TCO 5) The Crow's Foot model is more ___________-oriented than the Chen model. (Points : 4) object user implementation processor
4. (TCO 5) The ___________ model is both software and hardware dependent. (Points : 4) conceptual logical condensed physical
5. (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);
6. (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

Related Documents