Kopieren und bearbeiten

C175 Alternate Practice Test

Beschreibung

Database Foundations
Craig Willey
Quiz von Craig Willey, aktualisiert more than 1 year ago
Craig Willey
Erstellt von Craig Willey vor etwa 5 Jahre
832
2
0

Zusammenfassung der Ressource

Frage 1

Frage
A record consists of a ____
Antworten
  • character
  • collection of related records
  • set of one or more field
  • group of files

Frage 2

Frage
A DBMS performs several important functions that guarantee the integrity and consistency of the data in the database. Which of the following is NOT one of those functions?
Antworten
  • Data integrity management
  • Data storage management
  • Data reports
  • Security management

Frage 3

Frage
Which item is unstructured data
Antworten
  • A record representing one student
  • A video
  • A table that holds student data
  • A relational database that hold course registration data

Frage 4

Frage
Data is/are
Antworten
  • information
  • raw facts
  • processed information
  • DBMS

Frage 5

Frage
Which classification is correct for the box marked “Registration” in the given E-R Diagram?
Image:
1 (binary/octet-stream)
Antworten
  • Intersection data
  • Modality data
  • Cardinality data
  • Student data

Frage 6

Frage
Which type of relationship exists between Student and Course
Image:
2 (binary/octet-stream)
Antworten
  • One-to-many binary
  • Many-to-many binary
  • One-to-many unary
  • Many-to-many unary

Frage 7

Frage
What is the E-R Diagram about an online pet food vendor showing?
Image:
3 (binary/octet-stream)
Antworten
  • An Invoice Line can include many Items
  • An item can only be included in one Invoice Line
  • One Invoice Line must include a minimum of one and a maximum of one Item.
  • The relationship between Item and Invoice Line is many-to-many.

Frage 8

Frage
A pet owner can have many pets; a specific pet is linked to one pet owner.
Antworten
  • One-to-one
  • One-to-many
  • Many-to-many
  • Associative

Frage 9

Frage
Database models were developed to ____
Antworten
  • model real-world events or conditions
  • deposit data within a single file
  • keep data within multiple data repositories
  • allow DBMSs to maintain loose control over the database activities

Frage 10

Frage
What is the correct way to read the modality on the right side of the association?
Image:
4 (binary/octet-stream)
Antworten
  • A maximum of one activity
  • A maximum of zero activities
  • A minimum of zero activities
  • A maximum of many activities

Frage 11

Frage
What is the modality of Volunteer?
Image:
5 (binary/octet-stream)
Antworten
  • Two or more
  • Two
  • Dependent on registration date
  • At least one

Frage 12

Frage
What type of relationship is expressed with the phrase “A Painter paints one or more Paintings”?
Antworten
  • 1:M
  • 1:1
  • M:1
  • M:N

Frage 13

Frage
The entity integrity rule requires that ____
Antworten
  • all primary key entries are unique
  • a part of the key may be null
  • foreign key values do not reference primary key values
  • duplicate object values are allowed

Frage 14

Frage
What does the ‘refer’ in referential integrity mean ?
Antworten
  • The relationships between entities and attributes, also called referrals
  • Reference points that databases place in each record during backups
  • A foreign key in a table must refer to a valid primary key in another table.
  • You delete a row in one table whose primary key does not have a matching foreign key value in another table

Frage 15

Frage
A table is perceived as a ____
Antworten
  • flat structure
  • two-dimensional structure
  • linked structure
  • graph

Frage 16

Frage
Another word for the term “relation” is _____
Antworten
  • datafile
  • data index
  • table
  • data query

Frage 17

Frage
DISTINT filters the results to remove duplicates. ORDER BY _____
Antworten
  • does the same thing.
  • alters the order of the rows in a table.
  • modifies the presentation by changing the order of the result set.
  • removes duplicates in the table.

Frage 18

Frage
A primary key ____.
Antworten
  • is a minimal superkey
  • is always the first field in each table
  • must be numeric
  • must be unique

Frage 19

Frage
A table can be logically connected to another table by defining a ____
Antworten
  • hyperlink
  • common attribute
  • primary key
  • logic key

Frage 20

Frage
A relational operator that allows for the combination of information from two or more tables is known as the ____ operator
Antworten
  • SELECT
  • PROJECT
  • JOIN
  • DIFFERENCE

Frage 21

Frage
Which of the following statements concerning the primary key is true?
Antworten
  • All primary key entries are unique.
  • The primary key may be null.
  • The primary key is not required for all tables.
  • The primary key data do not have to be unique.

Frage 22

Frage
We can describe a link by observing that ____
Antworten
  • a primary key of one table appears again as a primary key in a related table
  • a foreign key of one table appears again as a foreign key in a related table
  • a primary key of one table appears again as a foreign key in a related table
  • a foreign key of one table appears again as a primary key in a related table

Frage 23

Frage
When designing a new database, it is a good idea to ____
Antworten
  • minimize data redundancy
  • include redundant fields
  • include a common field in all tables
  • use composite keys

Frage 24

Frage
An attribute (or combination of attributes) that uniquely identifies each entity in a table is called a ____
Antworten
  • superkey
  • foreign key
  • master key
  • secondary key

Frage 25

Frage
A foreign key must ____.
Antworten
  • be numeric
  • be unique
  • be defined in all tables within the database
  • match the value of a primary key in a related table

Frage 26

Frage
The ERD is used to graphically represent the ____ database model.
Antworten
  • condensed
  • physical
  • logical
  • conceptual

Frage 27

Frage
A derived attribute ____.
Antworten
  • must be stored physically within the database
  • need not be physically stored within the database
  • has many values
  • must be based on the value of three or more attributes

Frage 28

Frage
A relationship is an association between ____
Antworten
  • objects
  • entities
  • databases
  • fields

Frage 29

Frage
A ____ key is a key that consists of more than one attribute.
Antworten
  • primary
  • foreign
  • composite
  • domain

Frage 30

Frage
A ____ attribute is one that cannot be subdivided.
Antworten
  • composite
  • atomic
  • single-valued
  • multivalued

Frage 31

Frage
If an entity can exist apart from one or more related entities, it is said to be ____-independent
Antworten
  • existence
  • relationship
  • business
  • weak

Frage 32

Frage
A ____ relationship exists when three entities are associated
Antworten
  • unary
  • binary
  • ternary
  • weak

Frage 33

Frage
The set of possible values for an attribute is a ____
Antworten
  • domain
  • range
  • set
  • key

Frage 34

Frage
Which attribute(s) make up the primary key in the table definition: CLASS (CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM, PROF_NUM)
Antworten
  • CRS_CODE
  • CLASS_SECTION
  • CRS_CODE and CLASS_SECTION
  • There is no primary key

Frage 35

Frage
A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key, is said to be in ____
Antworten
  • 1NF
  • 2NF
  • 3NF
  • 4NF

Frage 36

Frage
A table that is in 2NF and contains no transitive dependencies is said to be in ____
Antworten
  • 1NF
  • 2NF
  • 3NF
  • 4NF

Frage 37

Frage
Data redundancy produces ____
Antworten
  • slower lookups
  • robust design
  • efficient storage use
  • data integrity problems

Frage 38

Frage
Normalization works through a series of normal ____
Antworten
  • schemas
  • entities
  • databases
  • forms

Frage 39

Frage
Dependencies based on only a part of a composite primary key are called ____ dependencies
Antworten
  • primary
  • partial
  • incomplete
  • composite

Frage 40

Frage
Given the table EMP_PROJ (PROJ_NUM, EMP_NUM, PROJ_NAME, EMP_NAME, JOB_CLASS, CHG_HOURS, HOURS), which of the following is a partial dependency?
Antworten
  • PROJ_NUM --> PROJ_NAME
  • JOB_CLASS --> CHG_HOUR
  • PROJ_NUM, EMP_NUM --> HOURS
  • PROJ_NUM, EMP_NUM --> CHG_HOURS

Frage 41

Frage
A relation is not in 1NF if
Antworten
  • it has multiple candidate keys
  • all of the key attributes are defined
  • there are repeating groups in the table
  • all attributes are dependent on the primary key

Frage 42

Frage
The SQL command that lets you insert data into a table, one row at a time, is ____
Antworten
  • INSERT
  • SELECT
  • COMMIT
  • UPDATE

Frage 43

Frage
The SQL command that enables you to make changes in the data is ____
Antworten
  • INSERT
  • SELECT
  • COMMIT
  • UPDATE

Frage 44

Frage
To list all the contents of the PRODUCT table, you would use ____.
Antworten
  • LIST * FROM PRODUCT;
  • SELECT * FROM PRODUCT;
  • DISPLAY * FROM PRODUCT;
  • SELECT ALL FROM PRODUCT;

Frage 45

Frage
Which command would you use when making corrections to the PRODUCT table?
Antworten
  • CHANGE PRODUCT SET P_INDATE = '01/18/2004' WHERE P_CODE = '13-Q2/P2';
  • ROLLBACK PRODUCT SET P_INDATE = '01/18/2004' WHERE P_CODE = '13-Q2/P2';
  • EDIT PRODUCT SET P_INDATE = '01/18/2004' WHERE P_CODE = '13-Q2/P2';
  • UPDATE PRODUCT SET P_INDATE = '01/18/2004' WHERE P_CODE = '13-Q2/P2';

Frage 46

Frage
Which command would be used to delete the table row where the P_Code = '2238/QPD'?
Antworten
  • DELETE FROM PRODUCT WHERE P_CODE = '2238/QPD';
  • REMOVE FROM PRODUCT WHERE P_CODE = '2238/QPD'
  • ERASE FROM PRODUCT WHERE P_CODE = '2238/QPD';
  • ROLLBACK FROM PRODUCT WHERE P_CODE = '2238/QPD';

Frage 47

Frage
Which command is used to select partial table contents?
Antworten
  • SELECT <column(s)> FROM <Table name> WHERE <Item>;
  • LIST <column(s)> FROM <Table name> WHERE <Conditions>;
  • SELECT <column(s)> FROM <Table name> WHERE <Conditions>;
  • LIST<column(s)> FROM <Table name> WHERE <Item>;

Frage 48

Frage
Which query will output the table contents when the value of V_CODE is less than or equal to 21344?
Antworten
  • SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE <> 21344;
  • SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE <=21344;
  • SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE => 21344;
  • SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344;

Frage 49

Frage
Which query will list all the rows in which the inventory stock dates occur on or after January 20, 2006?
Antworten
  • SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDICATE >= '01/20/2006'
  • SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDICATE >= #01/20/2004#
  • SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDICATE >= '20-JAN-2004'
  • SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDICATE >= {01-20-2004}

Frage 50

Frage
What is the SQL syntax requirement to list the table contents for either V_CODE = 21344 or V_CODE = 24288?
Antworten
  • SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE <= 24288
  • SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE => 24288
  • SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE > 24288
  • SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE = 24288

Frage 51

Frage
What is the command to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME, V_AREACODE, V_PHONE, and V_CONTACT fields from the VENDOR table where the value of V_CODE match?
Antworten
  • SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE <> VENDOR.V_CODE;
  • SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE
  • SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE <= VENDOR.V_CODE;
  • SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE => VENDOR.V_CODE;

Frage 52

Frage
SQL allows the use of special operators in conjunction with the WHERE clause. A special operator used to check for similar character strings is ____.
Antworten
  • BETWEEN
  • IS NULL
  • LIKE
  • IN

Frage 53

Frage
A table can be deleted from the database by using the ____ command.
Antworten
  • DROP
  • DELETE
  • MODIFY
  • ERASE

Frage 54

Frage
UPDATE tablename ***** [WHERE conditionlist]; What command replaces the ***** in the above statement?
Antworten
  • SET columnname = expression
  • columnname = expression
  • expression = columnname
  • LET columnname = expression

Frage 55

Frage
A ____ join returns rows with matching values and includes all rows from both tables (T1 and T2) with unmatched values.
Antworten
  • natural
  • cross
  • full outer
  • left outer

Frage 56

Frage
During which step in the extract, transform, load (ETL) process are raw data sets aggregated?
Antworten
  • Transformation
  • Extraction
  • Loading
  • Denormalization

Frage 57

Frage
Which is an important issue associated with the loading component of extract, transform, load (ETL)?
Antworten
  • Mapping keys from one system to another
  • Monitor refreshing volume and frequency
  • Determining the content of the data
  • Denormalizing and renormalizing data

Frage 58

Frage
A database includes the table shown above in the exhibit. Each teacher is associated with exactly one campus. The address in the table is the address for the campus where the teacher teaches. What change would you need to make to normalize the database to the third normal form (3NF)?
Image:
1 (binary/octet-stream)
Antworten
  • Combine the FirstName and LastName columns into a single column.
  • Combine the Campus, Address, City, State, Country, and PostalCode columns into a single column.
  • Create a separate table for campus address information. Use the Campus as the primary key. Add a TeacherID column to the table and relate it to the Teacher ID column in the Teachers table.
  • Create a separate table for campus address information. Use Campus as the primary key for the table. Create a foreign key in the Teachers table that relates teacher to the campus.

Frage 59

Frage
Which statement will remove all rows from the Materials table that have a Status value of ‘Obsolete’ but do not have a value for the VendorID column?
Antworten
  • DELETE Materials WHERE Status = ‘Obsolete’ OR VendorID IS NULL
  • DELETE FROM Materials WHERE Status = ‘Obsolete’ AND VendorID IS NULL
  • DELETE MaterialID, Description, Status, VendorID FROM Materials WHERE Status = ‘Obsolete’ AND VendorID IS NULL
  • DELETE FROM Materials WHERE Status = ‘Obsolete’ WHERE VendorID IS NULL

Frage 60

Frage
The TestScores table is shown in the exhibit and has these characteristics: Each student has a unique StudentID that references the Students table. A specific test can be taken more than once. Each instructor has a unique InstructorID that references the Instructors table Each student may take multiple tests on the same date. Each student may take tests on multiple dates. What column or columns should you use for the primary key?
Image:
2 (binary/octet-stream)
Antworten
  • StudentID, Date
  • StudentID, Test, Date, InstructorID
  • StudentID, Test, and Date
  • Test

Frage 61

Frage
You are creating a relational database to store information about instructors and the courses that each instructor teaches. Each course is taught by a single instructor. You have created an Instructor table and a Course table as shown above. You need to create a relationship between the Instructor table and the Course table. You need to keep duplicate data to a minimum. What should you do?
Image:
3 (binary/octet-stream)
Antworten
  • Create a new column in the Instructor table.
  • Create new columns in the Instructors table for each course taught
  • Create a new table that includes two columns.
  • Create a new column in the Course table

Frage 62

Frage
Which of the following is structured data?
Antworten
  • Images
  • Email Attachments
  • Records in a database
  • Audio/Video

Frage 63

Frage
Which kind of relationship does the diagram depict?
Image:
4 (binary/octet-stream)
Antworten
  • Unary one-to-many
  • Binary many-to-many
  • Unary many-to-many
  • Binary one-to-many

Frage 64

Frage
Which kind of relationship does the diagram depict?
Image:
5 (binary/octet-stream)
Antworten
  • Unary one-to-many
  • Binary many-to-many
  • Unary one-to-one
  • Binary one-to-many

Frage 65

Frage
What is the modality of appointment?
Image:
6 (binary/octet-stream)
Antworten
  • At least one
  • Dependent on the quantity
  • Two
  • Two or more

Frage 66

Frage
What form is this table in?
Image:
7 (binary/octet-stream)
Antworten
  • Unnormalized
  • First normal form
  • Second normal form
  • Third normal form

Frage 67

Frage
What form is this table in?
Image:
1 (binary/octet-stream)
Antworten
  • Unnormalized
  • First normal form
  • Second normal form
  • Third normal form

Frage 68

Frage
What form is this table in?
Image:
2 (binary/octet-stream)
Antworten
  • Unnormalized
  • First normal form
  • Second normal form
  • Third normal form

Frage 69

Frage
What form is this table in?
Image:
3 (binary/octet-stream)
Antworten
  • Unnormalized
  • First normal form
  • Second normal form
  • Third normal form

Frage 70

Frage
Affinity grouping question – Where does affinity grouping occur in data mining?
Antworten
  • Between objects
  • Among clusters
  • Among entities and target applications
  • Between entity group names

Frage 71

Frage
How is prediction distinguished from estimation in data mining?
Antworten
  • Estimation assumptions do not need to be tested.
  • Prediction is used to look at historical data only.
  • Estimation divides small collections of entities into smaller groups of similar entities.
  • Prediction classifies objects according to an expected future behavior.

Frage 72

Frage
During which step in the extract, transform, load (ETL) process are raw data sets aggregated?
Antworten
  • Conversion
  • Loading
  • Extraction
  • Transformation
  • Denormalization

Frage 73

Frage
Which issues is focused on the loading component of extract, transform, load (ETL)?
Antworten
  • Monitor refreshing volume and frequency
  • Mapping keys from one system to another
  • Determining the content of the data
  • Denormalizaing and renormalizing the data

Frage 74

Frage
How can a data warehouse assist in an organization’s data analysis?
Antworten
  • By serving as the primary source of information that feeds analytical processing
  • By storing data that is no longer in use but may be needed for future analyses
  • By providing a place where unnormalized data can reside before it is processed
  • By providing a physical space where groups of servers can process data on a large scale

Frage 75

Frage
Which set of results should a company expect from implementing a business intelligence system?
Antworten
  • Reduced hardware redundancy and decreased workloads
  • Riskier capital and asset investments and increased throughput
  • Increased profitability and reduced hardware redundancy
  • Increased profitability and increased throughput.
Zusammenfassung anzeigen Zusammenfassung ausblenden

Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.

ähnlicher Inhalt

Aufklärung und Sturm & Drang
Cassibodua
Stochastik Grundbegriffe
steffen_1411
STEP 1
astrid.
IKA-Theoriefragen Serie 03 (15 Fragen)
IKA ON ICT GmbH
ALDI SUISSE PLU: Kernsortiment 01 - 99
Sarah Huber
Methoden der Stratigraphie
Weltraumkatze Fanroth
Tierhaltung und -hygiene 2016
Juliane Arendt
Vetie Histopatho 2009
Carolina Heide
Vetie-Chirurgie 2017
Ju Pi
STADA Jörg Matthes 2021
Julia W.
Vetie Geflügelkrankheiten Altfragen
Tropsi B
Bibliothek durchsuchen