1. (TCO 1) Most DBMS are referred to as _____ database management systems. (Poin

Question

1. (TCO 1) Most DBMS are referred to as _____ database management systems. (Points : 4)        elemental
       linked
       hierarchical
       relational Question 2.2. (TCO 1) A Batch Update Routine pools the transactions into a single batch to update a master table field in a(n) _____ operation. (Points : 4)        single
       user
       modern
       automatic Question 3.3. (TCO 2) In a relational database, each table must have _____ (Points : 4)        a primary key.
       a secondary key.
       a foreign key.
       a logical key. Question 4.4. (TCO 2) A _____ key is a key that is composed of more than one attribute. (Points : 4)        primary
       foreign
       composite
       domain Question 5.5. (TCO 3) Composite primary keys are particularly useful as identifiers of composite entities, where each primary key combination is allowed only once in the _____ relationship. (Points : 4)        null
       1:1
       1:M
       M:N Question 6.6. (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. Question 7.7. (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. Question 8.8. (TCO 4) Which of the following SQL statements would select data from all of the rows and columns in the DEVRY table? (Points : 4)        SELECT all FROM devry;
       SELECT * FROM devry;
       SELECT devry;
       SHOW * FROM devry; Question 1.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 integrity constraints. Question 2.2. (TCO 4) Which command is used to restore the table's contents to their default values? (Points : 4)        COMMIT; RESTORE;
       COMMIT; BACKUP;
       COMMIT; ROLLBACK;
       ROLLBACK; Question 3.3. (TCO 5) The Crow's Foot model is more _____-oriented than the Chen model. (Points : 4)        object
       user
       implementation
       processor Question 4.4. (TCO 5) Knowing the _____ number of entity occurrences is very helpful at the application software level. (Points : 4)        maximum
       minimum
       exact
       maximum and minimum Question 5.5. (TCO 6) The _____ statement can be used to enable or disable a constraint. (Points : 4)        alter table
       modify table
       create table
       update table 1. (TCO 1) Most DBMS are referred to as _____ database management systems. (Points : 4)        elemental
       linked
       hierarchical
       relational

Explanation / Answer

  
       SELECT * FROM devry;

1. (TCO 1) Most DBMS are referred to as _____ database management systems. (Points : 4)   
       relational

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.