Quiz
C175 Alternate Practice Test
Crie uma conta grátis para terminar este quiz
Salve seu progresso e veja sua nota final.
Já tem uma conta? Inicie sessão
Perguntas do quiz (75)
1A record consists of a ____
- Acharacter
- Bcollection of related records
- Cset of one or more field
- Dgroup of files
2A 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?
- AData integrity management
- BData storage management
- CData reports
- DSecurity management
3Which item is unstructured data
- AA record representing one student
- BA video
- CA table that holds student data
- DA relational database that hold course registration data
4Data is/are
- Ainformation
- Braw facts
- Cprocessed information
- DDBMS
5Which classification is correct for the box marked “Registration” in the given E-R Diagram?
- AIntersection data
- BModality data
- CCardinality data
- DStudent data
6Which type of relationship exists between Student and Course
- AOne-to-many binary
- BMany-to-many binary
- COne-to-many unary
- DMany-to-many unary
7What is the E-R Diagram about an online pet food vendor showing?
- AAn Invoice Line can include many Items
- BAn item can only be included in one Invoice Line
- COne Invoice Line must include a minimum of one and a maximum of one Item.
- DThe relationship between Item and Invoice Line is many-to-many.
8A pet owner can have many pets; a specific pet is linked to one pet owner.
- AOne-to-one
- BOne-to-many
- CMany-to-many
- DAssociative
9Database models were developed to ____
- Amodel real-world events or conditions
- Bdeposit data within a single file
- Ckeep data within multiple data repositories
- Dallow DBMSs to maintain loose control over the database activities
10What is the correct way to read the modality on the right side of the association?
- AA maximum of one activity
- BA maximum of zero activities
- CA minimum of zero activities
- DA maximum of many activities
11What is the modality of Volunteer?
- ATwo or more
- BTwo
- CDependent on registration date
- DAt least one
12What type of relationship is expressed with the phrase “A Painter paints one or more Paintings”?
- A1:M
- B1:1
- CM:1
- DM:N
13The entity integrity rule requires that ____
- Aall primary key entries are unique
- Ba part of the key may be null
- Cforeign key values do not reference primary key values
- Dduplicate object values are allowed
14What does the ‘refer’ in referential integrity mean ?
- AThe relationships between entities and attributes, also called referrals
- BReference points that databases place in each record during backups
- CA foreign key in a table must refer to a valid primary key in another table.
- DYou delete a row in one table whose primary key does not have a matching foreign key value in another table
15A table is perceived as a ____
- Aflat structure
- Btwo-dimensional structure
- Clinked structure
- Dgraph
16Another word for the term “relation” is _____
- Adatafile
- Bdata index
- Ctable
- Ddata query
17DISTINT filters the results to remove duplicates. ORDER BY _____
- Adoes the same thing.
- Balters the order of the rows in a table.
- Cmodifies the presentation by changing the order of the result set.
- Dremoves duplicates in the table.
18A primary key ____.
- Ais a minimal superkey
- Bis always the first field in each table
- Cmust be numeric
- Dmust be unique
19A table can be logically connected to another table by defining a ____
- Ahyperlink
- Bcommon attribute
- Cprimary key
- Dlogic key
20A relational operator that allows for the combination of information from two or more tables is known as the ____ operator
- ASELECT
- BPROJECT
- CJOIN
- DDIFFERENCE
21Which of the following statements concerning the primary key is true?
- AAll primary key entries are unique.
- BThe primary key may be null.
- CThe primary key is not required for all tables.
- DThe primary key data do not have to be unique.
22We can describe a link by observing that ____
- Aa primary key of one table appears again as a primary key in a related table
- Ba foreign key of one table appears again as a foreign key in a related table
- Ca primary key of one table appears again as a foreign key in a related table
- Da foreign key of one table appears again as a primary key in a related table
23When designing a new database, it is a good idea to ____
- Aminimize data redundancy
- Binclude redundant fields
- Cinclude a common field in all tables
- Duse composite keys
24An attribute (or combination of attributes) that uniquely identifies each entity in a table is called a ____
- Asuperkey
- Bforeign key
- Cmaster key
- Dsecondary key
25A foreign key must ____.
- Abe numeric
- Bbe unique
- Cbe defined in all tables within the database
- Dmatch the value of a primary key in a related table
26The ERD is used to graphically represent the ____ database model.
- Acondensed
- Bphysical
- Clogical
- Dconceptual
27A derived attribute ____.
- Amust be stored physically within the database
- Bneed not be physically stored within the database
- Chas many values
- Dmust be based on the value of three or more attributes
28A relationship is an association between ____
- Aobjects
- Bentities
- Cdatabases
- Dfields
29A ____ key is a key that consists of more than one attribute.
- Aprimary
- Bforeign
- Ccomposite
- Ddomain
30A ____ attribute is one that cannot be subdivided.
- Acomposite
- Batomic
- Csingle-valued
- Dmultivalued
31If an entity can exist apart from one or more related entities, it is said to be ____-independent
- Aexistence
- Brelationship
- Cbusiness
- Dweak
32A ____ relationship exists when three entities are associated
- Aunary
- Bbinary
- Cternary
- Dweak
33The set of possible values for an attribute is a ____
- Adomain
- Brange
- Cset
- Dkey
34Which attribute(s) make up the primary key in the table definition:
CLASS (CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM, PROF_NUM)- ACRS_CODE
- BCLASS_SECTION
- CCRS_CODE and CLASS_SECTION
- DThere is no primary key
35A 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 ____
- A1NF
- B2NF
- C3NF
- D4NF
36A table that is in 2NF and contains no transitive dependencies is said to be in ____
- A1NF
- B2NF
- C3NF
- D4NF
37Data redundancy produces ____
- Aslower lookups
- Brobust design
- Cefficient storage use
- Ddata integrity problems
38Normalization works through a series of normal ____
- Aschemas
- Bentities
- Cdatabases
- Dforms
39Dependencies based on only a part of a composite primary key are called ____ dependencies
- Aprimary
- Bpartial
- Cincomplete
- Dcomposite
40Given 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?
- APROJ_NUM --> PROJ_NAME
- BJOB_CLASS --> CHG_HOUR
- CPROJ_NUM, EMP_NUM --> HOURS
- DPROJ_NUM, EMP_NUM --> CHG_HOURS
41A relation is not in 1NF if
- Ait has multiple candidate keys
- Ball of the key attributes are defined
- Cthere are repeating groups in the table
- Dall attributes are dependent on the primary key
42The SQL command that lets you insert data into a table, one row at a time, is ____
- AINSERT
- BSELECT
- CCOMMIT
- DUPDATE
43The SQL command that enables you to make changes in the data is ____
- AINSERT
- BSELECT
- CCOMMIT
- DUPDATE
44To list all the contents of the PRODUCT table, you would use ____.
- ALIST * FROM PRODUCT;
- BSELECT * FROM PRODUCT;
- CDISPLAY * FROM PRODUCT;
- DSELECT ALL FROM PRODUCT;
45Which command would you use when making corrections to the PRODUCT table?
- ACHANGE PRODUCT
SET P_INDATE = '01/18/2004'
WHERE P_CODE = '13-Q2/P2'; - BROLLBACK PRODUCT
SET P_INDATE = '01/18/2004'
WHERE P_CODE = '13-Q2/P2'; - CEDIT PRODUCT
SET P_INDATE = '01/18/2004'
WHERE P_CODE = '13-Q2/P2'; - DUPDATE PRODUCT
SET P_INDATE = '01/18/2004'
WHERE P_CODE = '13-Q2/P2';
- ACHANGE PRODUCT
46Which command would be used to delete the table row where the P_Code = '2238/QPD'?
- ADELETE FROM PRODUCT
WHERE P_CODE = '2238/QPD'; - BREMOVE FROM PRODUCT
WHERE P_CODE = '2238/QPD' - CERASE FROM PRODUCT
WHERE P_CODE = '2238/QPD'; - DROLLBACK FROM PRODUCT
WHERE P_CODE = '2238/QPD';
- ADELETE FROM PRODUCT
47Which command is used to select partial table contents?
- ASELECT <column(s)>
FROM <Table name>
WHERE <Item>; - BLIST <column(s)>
FROM <Table name>
WHERE <Conditions>; - CSELECT <column(s)>
FROM <Table name>
WHERE <Conditions>; - DLIST<column(s)>
FROM <Table name>
WHERE <Item>;
- ASELECT <column(s)>
48Which query will output the table contents when the value of V_CODE is less than or equal to 21344?
- ASELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE <> 21344; - BSELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE <=21344; - CSELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE => 21344; - DSELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE = 21344;
- ASELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
49Which query will list all the rows in which the inventory stock dates occur on or after January 20, 2006?
- ASELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE
FROM PRODUCT
WHERE P_INDICATE >= '01/20/2006' - BSELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE
FROM PRODUCT
WHERE P_INDICATE >= #01/20/2004# - CSELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE
FROM PRODUCT
WHERE P_INDICATE >= '20-JAN-2004' - DSELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE
FROM PRODUCT
WHERE P_INDICATE >= {01-20-2004}
- ASELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE
50What is the SQL syntax requirement to list the table contents for either V_CODE = 21344 or V_CODE = 24288?
- ASELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE = 21344
OR V_CODE <= 24288 - BSELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE = 21344
OR V_CODE => 24288 - CSELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE = 21344
OR V_CODE > 24288 - DSELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE = 21344
OR V_CODE = 24288
- ASELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
51What 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?
- ASELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
FROM PRODUCT, VENDOR
WHERE PRODUCT.V_CODE <> VENDOR.V_CODE; - BSELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
FROM PRODUCT, VENDOR
WHERE PRODUCT.V_CODE = VENDOR.V_CODE - CSELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
FROM PRODUCT, VENDOR
WHERE PRODUCT.V_CODE <= VENDOR.V_CODE; - DSELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
FROM PRODUCT, VENDOR
WHERE PRODUCT.V_CODE => VENDOR.V_CODE;
- ASELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
52SQL allows the use of special operators in conjunction with the WHERE clause. A special operator used to check for similar character strings is ____.
- ABETWEEN
- BIS NULL
- CLIKE
- DIN
53A table can be deleted from the database by using the ____ command.
- ADROP
- BDELETE
- CMODIFY
- DERASE
54UPDATE tablename
*****
[WHERE conditionlist];
What command replaces the ***** in the above statement?- ASET columnname = expression
- Bcolumnname = expression
- Cexpression = columnname
- DLET columnname = expression
55A ____ join returns rows with matching values and includes all rows from both tables (T1 and T2) with unmatched values.
- Anatural
- Bcross
- Cfull outer
- Dleft outer
56During which step in the extract, transform, load (ETL) process are raw data sets aggregated?
- ATransformation
- BExtraction
- CLoading
- DDenormalization
57Which is an important issue associated with the loading component of extract, transform, load (ETL)?
- AMapping keys from one system to another
- BMonitor refreshing volume and frequency
- CDetermining the content of the data
- DDenormalizing and renormalizing data
58A 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)?
- ACombine the FirstName and LastName columns into a single column.
- BCombine the Campus, Address, City, State, Country, and PostalCode columns into a single column.
- CCreate 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.
- DCreate 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.
59Which 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?
- ADELETE Materials
WHERE Status = ‘Obsolete’ OR VendorID IS NULL - BDELETE
FROM Materials
WHERE Status = ‘Obsolete’ AND VendorID IS NULL - CDELETE MaterialID, Description, Status, VendorID
FROM Materials
WHERE Status = ‘Obsolete’ AND VendorID IS NULL - DDELETE FROM Materials
WHERE Status = ‘Obsolete’
WHERE VendorID IS NULL
- ADELETE Materials
60The 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?
- AStudentID, Date
- BStudentID, Test, Date, InstructorID
- CStudentID, Test, and Date
- DTest
61You 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?
- ACreate a new column in the Instructor table.
- BCreate new columns in the Instructors table for each course taught
- CCreate a new table that includes two columns.
- DCreate a new column in the Course table
62Which of the following is structured data?
- AImages
- BEmail Attachments
- CRecords in a database
- DAudio/Video
63Which kind of relationship does the diagram depict?
- AUnary one-to-many
- BBinary many-to-many
- CUnary many-to-many
- DBinary one-to-many
64Which kind of relationship does the diagram depict?
- AUnary one-to-many
- BBinary many-to-many
- CUnary one-to-one
- DBinary one-to-many
65What is the modality of appointment?
- AAt least one
- BDependent on the quantity
- CTwo
- DTwo or more
66What form is this table in?
- AUnnormalized
- BFirst normal form
- CSecond normal form
- DThird normal form
67What form is this table in?
- AUnnormalized
- BFirst normal form
- CSecond normal form
- DThird normal form
68What form is this table in?
- AUnnormalized
- BFirst normal form
- CSecond normal form
- DThird normal form
69What form is this table in?
- AUnnormalized
- BFirst normal form
- CSecond normal form
- DThird normal form
70Affinity grouping question – Where does affinity grouping occur in data mining?
- ABetween objects
- BAmong clusters
- CAmong entities and target applications
- DBetween entity group names
71How is prediction distinguished from estimation in data mining?
- AEstimation assumptions do not need to be tested.
- BPrediction is used to look at historical data only.
- CEstimation divides small collections of entities into smaller groups of similar entities.
- DPrediction classifies objects according to an expected future behavior.
72During which step in the extract, transform, load (ETL) process are raw data sets aggregated?
- AConversion
- BLoading
- CExtraction
- DTransformation
- EDenormalization
73Which issues is focused on the loading component of extract, transform, load (ETL)?
- AMonitor refreshing volume and frequency
- BMapping keys from one system to another
- CDetermining the content of the data
- DDenormalizaing and renormalizing the data
74How can a data warehouse assist in an organization’s data analysis?
- ABy serving as the primary source of information that feeds analytical processing
- BBy storing data that is no longer in use but may be needed for future analyses
- CBy providing a place where unnormalized data can reside before it is processed
- DBy providing a physical space where groups of servers can process data on a large scale
75Which set of results should a company expect from implementing a business intelligence system?
- AReduced hardware redundancy and decreased workloads
- BRiskier capital and asset investments and increased throughput
- CIncreased profitability and reduced hardware redundancy
- DIncreased profitability and increased throughput.
Informações
- Descrição
- Database Foundations
- Autor
- Craig Willey
- Idioma
- English
- Visualizações
- 858
- Etiquetas
- Avaliação
- Ainda sem avaliações Avalie este quiz