• Falsches Dokument? Kostenlos tauschen
  • Geschrieben von Student*innen, die bestanden haben
  • Sofort verfügbar nach Zahlung
  • Online lesen oder als PDF
Verkaufen
Wo studierst du
Deine Sprache
Document preview thumbnail
Vorschau 2 aus 15 Seiten
Prüfung

Database Management Chapters 1-4 fully solved 2023

Document preview thumbnail
Vorschau 2 aus 15 Seiten

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


Dokument Information

Hochgeladen auf
7. oktober 2023
Anzahl der Seiten
15
geschrieben in
2023/2024
Typ
Prüfung
Enthält
Fragen & antworten
11,20 €

Falsches Dokument? Kostenlos tauschen Innerhalb von 14 Tagen nach dem Kauf und vor dem Herunterladen kannst du ein anderes Dokument wählen. Du kannst den Betrag einfach neu ausgeben.
Geschrieben von Student*innen, die bestanden haben
Sofort verfügbar nach Zahlung
Online lesen oder als PDF

Seller avatar
Bewertungen des Ansehens basieren auf der Anzahl der Dokumente, die ein Verkäufer gegen eine Gebühr verkauft hat, und den Bewertungen, die er für diese Dokumente erhalten hat. Es gibt drei Stufen: Bronze, Silber und Gold. Je besser das Ansehen eines Verkäufers ist, desto mehr kannst du dich auf die Qualität der Arbeiten verlassen.
StuviaExamHub
3,7
(92)
Verkauft
504
Anhänger
356
Sachen
26891
Zuletzt verkauft
2 Jahren vor




Warum sich Studierende für Stuvia entscheiden

on Mitstudent*innen erstellt, durch Bewertungen verifiziert

Geschrieben von Student*innen, die bestanden haben und bewertet von anderen, die diese Studiendokumente verwendet haben.

Nicht zufrieden? Wähle ein anderes Dokument

Kein Problem! Du kannst direkt ein anderes Dokument wählen, das besser zu dem passt, was du suchst.

Bezahle wie du möchtest, fange sofort an zu lernen

Kein Abonnement, keine Verpflichtungen. Bezahle wie gewohnt per Kreditkarte oder Sofort und lade dein PDF-Dokument sofort herunter.

Student with book image

“Gekauft, heruntergeladen und bestanden. So einfach kann es sein.”

Alisha Student

Arbeitest du an deiner Quellenangabe?

Erstelle korrekte Quellenangaben in APA, MLA und Harvard mit unserem kostenlosen Zitiergenerator.

Arbeitest du an deiner Quellenangabe?

Häufig gestellte Fragen

Ups! Dein Dokument kann gerade nicht geladen werden. Versuch es erneut oder kontaktiere den Support.