• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Document preview thumbnail
Preview 2 out of 15 pages
Exam (elaborations)

Database Management Chapters 1-4 fully solved 2023

Document preview thumbnail
Preview 2 out of 15 pages

Database Management Chapters 1-4The logical layer of the ANSI/SPARC model provides which of the following? A. Physical data independence B. Parent-child relationships C. Logical data independence D. Encapsulation Physical data independence The external layer of the ANSI/SPARC model provides which of the following? A. Physical data independence B. Parent-child relationships C. Logical data independence D. Encapsulation Logical data independence Which of the following is not true regarding user views? A. Application programs reference them. B. People querying the database reference them. C. They can be tailored to the needs of the database user. D. Data updates are shown in a delayed fashion. Data updates are shown in a delayed fashion The database schema is contained in the ____________ layer of the ANSI/SPARC model. logical User views are contained in the ____________ layer of the ANSI/SPARC model external When application programs use flat file systems, where do the file definitions reside? In the application programs Which of the following is true regarding the hierarchical database model? A. It was first developed by Peter Chen. B. Data and methods are stored together in the database C. Each node may have many parents. D. Records are connected using physical address pointers Records are connected using physical address pointers Which of the following is true regarding the network database model? A. It was first developed by E.F. Codd. B. Data and methods are stored together in the database. C. Each node may have many parents. D. Records are connected using common physical address pointers. Each node may have many parents. & Records are connected using common physical address pointers Which of the following is true of the relational database model? A. It was first developed by Charles Bachman. B. Data and methods are stored together in the database. C. Records are connected using physical address pointers. D. Records are connected using common data items in each record. Records are connected using common data items in each record. Which of the following is true regarding the object-oriented model? A. It was first developed by Charles Bachman. B. Data and methods are stored together in the database. C. Data is presented as two-dimensional tables. D. Records are connected using common data items in each record Data and methods are stored together in the database Which of the following is true regarding the object-relational model? A. It serves only a niche market and most experts believe it will stay that way. B. Records are connected using physical address pointers. C. It was developed by adding object-like properties to the relational model. D. It was developed by adding relational-like properties to the object-oriented model. It was developed by adding object-like properties to the relational model. According to advocates of the relational model, which of the following describe the problems with the CODASYL model? A. It is too mathematical. B. It is too complicated. C. Set-oriented queries are too difficult. D. It has no formal underpinnings in mathematical theory. It is too complicated. & Set-oriented queries are too difficult & It has no formal underpinnings in mathematical theory According to advocates of the CODASYL model, which of the following describe the problems with the relational model? A. It is too mathematical. B. Set-oriented queries are too difficult. C. Application systems need record-at-a-time processing. D. It is less efficient than CODASYL model databases. It is too mathematical & Application systems need record-at-a-time processing. & It is less efficient than CODASYL model databases The ability to add a new object to a database without disrupting existing processes is an example of ____________. logical data independence The property that most distinguishes a relational database table from a spreadsheet is the ability to present multiple users with their own _____ views of the data Examples of an entity are A. A customer B. A customer order C. An employee's paycheck D. A customer's name A customer , their order and name Examples of an attribute are A. An employee B. An employee's name C. An employee's paycheck D. An alphabetical listing of employees An employee's name Which of the following denotes the cardinality of "zero, one, or more" on a relationship line? A. A perpendicular tick mark near the end of the line and a crow's foot at the line end B. A circle near the end of the line and a crow's foot at the end of the line C. Two perpendicular tick marks near the end of the line D. A circle and a perpendicular tick mark near the end of the line A circle near the end of the line and a crow's foot at the end of the line Valid types of relationships in a relational database are A. One-to-many B. None-to-many C. Many-to-many D. One-to-one One-to-many Many-to-many One-to-one If a product can be manufactured in many plants, and a plant can manufacture many products, this is an example of which type of relationship? A. One-to-one B. One-to-many C. Many-to-many D. Recursive Many-to-many Which of the following are examples of recursive relationships? A. An organizational unit made up of departments B. An employee who manages other employees C. An employee who manages a department D. An employee who has many dependents An employee who manages other employees Examples of a business rule are A. A referential constraint must refer to the primary key of the parent table. B. An employee must be at least 18 years old. C. A database query eliminates columns an employee should not see. D. Employees below pay grade 6 are not permitted to modify orders. An employee must be at least 18 years old & Employees below pay grade 6 are not permitted to modify orders A relational table A. Is composed of rows and columns B. Must be assigned a data type C. Must be assigned a unique name D. Is the primary unit of storage in the relational model Is composed of rows and columns & Must be assigned a unique name & Is the primary unit of storage in the relational model A column in a relational table A. Must be assigned a data type B. Must be assigned a unique name within the table C. Is derived from an entity in the conceptual design D. Is the smallest named unit of storage in a relational database Must be assigned a data type & Is derived from an entity in the conceptual design & Is the smallest named unit of storage in a relational database A data type A. Assists the DBMS in storing data efficiently B. Provides a set of behaviors for a column that assists the database user C. May be selected based on business rules for an attribute D. Restricts characters allowed in a database column All the above A primary key constraint A. Must reference one or more columns in a single table B. Must be defined for every database table C. Is usually implemented using an index D. Guarantees that no two rows in a table have duplicate primary key values Must reference one or more columns in a single table & Is usually implemented using an index & Guarantees that no two rows in a table have duplicate primary key values A referential constraint A. Must have primary key and foreign key columns that have identical names B. Ensures that a primary key does not have duplicate values in a table C. Defines a many-to-many relationship between two tables D. Ensures that a foreign key value always refers to an existing primary key value in the parent table Ensures that a foreign key value always refers to an existing primary key value in the parent table


Document information

Uploaded on
October 7, 2023
Number of pages
15
Written in
2023/2024
Type
Exam (elaborations)
Contains
Questions & answers
$11.99

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
StuviaExamHub
3.7
(92)
Sold
504
Followers
356
Items
26892
Last sold
2 days ago




Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions

Whoops! We can’t load your doc right now. Try again or contact support.