DBMS is software used for the following purpose: Creation of databases All of the above Insertion,...

 

   

Transcribed Image Text:

DBMS is software used for the following purpose: Creation of databases All of the above Insertion, storage, retrieval, update, and deletion of the data in the database Maintenance of databases QUESTION 2 Database implementation involves using. Front-end applications DBMS Database system Indirect interaction QUESTION 3 End users can vary in: Their level of technical sophistication The amount of data they need The frequency with which they access the database system All of the above. QUESTION 4 FirstNome is an example of MDBMS to implement the database model as an actual database. Metadata elearning.kctcs.edu/webapps/assessment/take/launch.jsp?course Project Free Tv Tasks Kentucky Basketball Question Completion Status: arch QUESTION 4 FirstName is an example of: DBMS Metadata Data Data Type QUESTION 5 Front-end applications facilitate: ● Direct use Indirect use Both direct and indirect use Neither direct nor indirect use QUESTION 6 Implicit changes of requirements are permitted during: Implicit changes of requirements are not permitted Database use Logical modeling Database deployment QUESTION 7 Information can be used for: Operational purposes only Analvtical purposes only assessment_id=_1928476_18course_id=_493459- 1948-1979 Ford Truck HC Truck Parts and Feed2all p2p4u Wizi 4 Click Save and Submit to save and submit. Click Save All Answers to save all answers, ек ps://elearning.kctcs.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_1928476_1&course_id=_4934595 Project Free Tv Tasks Kentucky Basketball L Feed2all p2p4u Wizi Question Completion Status: o search QUESTION 7 Information can be used for: Operational purposes only ● Analytical purposes only Operational and analytical purposes Neither for operational nor for analytical purposes QUESTION 8 Joe is an example of: Metadata Data Type Data DBMS QUESTION 9 Requirements can be refined and/or expanded following: Database deployment All of the above Logical modeling Database use QUESTION 10 The difference in the scope of databases is reflected in the Number of the development steps Cost in time and resources required for each of the development steps Level of importance of each of the development steps Click Save and Submit to save and submit. Click Save All Answers to save all answers, 1 1948-1979 Ford Truck Truck Parts and T R -aming.kctcs.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_1928476_1&course_id- 493 Feed2all p2p4u Wizi 1948-1979 Ford Truck LHC Truck Parts ject Free Tv Tasks Kentucky Basketball Question Completion Status: QUESTION 10 The difference in the scope of databases is reflected in the: Number of the development steps Cost in time and resources required for each of the development steps Level of importance of each of the development steps Order of the development steps search QUESTION 11 "How many entities are depicted by the following requirements? School XYZ keeps track of its 100 students, 10 tem OA) 3 B) 4 C) 115 D) 116 QUESTION 12 A multivalued composite attribute can be used to depict which of the following weak entity concepts? A) Partially unique attribute B) Identifying relationship C) A regular (non-identifying) one-to-many relationship between a weak entity and a regular entity D) A regular (non-identifying) many-to-many relationship between a weak entity and a regular entity QUESTION 13 A regular entity must have at least one of the following attributes: A) Unique attribute B) Composite attribute C) Multivalued attribute D) Derived attribute QUESTION 14 Click Save and Submit to save and submit. Click Save All Answere to save all answers. 1 8 1 d... 13 स B mttps://elearning.kctcs.edu/webapps/assessment/take/launch.jsp?course assessment_id=_1928476_1&course_id= Project Free Tv Tasks Kentucky Basketball 1948-1979 Ford Truck Truck I Question Completion Status: QUESTION 14 An M:N relationship that can have multiple occurrences between the same instances of involved entities OA) Weak entity with one owner OB) Multivalued composite attribute C) Unary M:N relationship D) Weak entity with two owners Feed2all p2p4u Wizi QUESTION 15 An associative entity is used as an alternative way of depicting: OA) 1:M relationships B) 1:1 relationships C) M:N relationships D) Multivalued attributes QUESTION 16 FirstN, MiddleN, and LastN make up a person's name in the DB. This is an example of: A) Composite attribute B) Multivalued attribute C) Derived attribute D) Unique composite attribute QUESTION 17 Which of the following is a legitimate exact minimum and maximum cardinality if you are speaking of a tournament with A) (10. 101" "B) (10, 1) *) (1.10) Click Save and Submit to save and submit. Click Save Al Answers to save all answers https://elearning.kctcs.edu/webapps/assessment/take/launch.jsp?course A Project Free Tv assessment_id=_1928476_1&course_id=4 Tasks Kentucky Basketball Feed2all p2p4u Wizi 1948-1979 Ford Truck Truck Pas Question Completion Status: QUESTION 17 Which of the following is a legitimate exact minimum and maximum cardinality if you are speaking of a tou "A) (10, 10)" "B) (10, 1)" "C) (1.10)" "D) (5, 4)" QUESTION 18 Which of the following is a possible type of relationship (maximum cardinality-wise)? A) One-to-one B) Zero-to-zero C) Zero-to-one D) Zero-to-many QUESTION 19 Which of the following is NOT a possible cardinality constraint? A) Optional one OB) Optional zero. C) Optional many D) Mandatory one QUESTION 20 Relationship attributes may be necessary in a relationship of what type? A) One-to-one B) One-to-many C) Zero-to-many D) Many-to-many Click Save and Submit to save and submit. Click Save All Anteers to save all answers 1 X zure | https://elearning.kctcs.edu/webapps/assessment/take/launch.jsp?course assessment_id=_1928476_1&cou are | USA Project Free Tv Tasks Kentucky Basketball 1948-1979 Ford Truck Question Completion Status: QUESTION 20 Relationship attributes may be necessary in a relationship of what type? A) One-to-one B) One-to-many C) Zero-to-many D) Many-to-many QUESTION 21 The following attribute represents a collection of attributes: A) Unique attribute B) Composite attribute C) Multivalued attribute D) Derived attribute Feed2all p2p4u Wizi QUESTION 22 The values of the following attribute are NOT permanently stored in a database. A) Unique attribute B) Composite attribute C) Multivalued attribute OD) Derived attribute QUESTION 23 "A restriction specifying that no salary entered in the salary column can be higher than $300.000 is an example True False https://elearning.kctcs.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_1928476_1&course_id=49 Project Free Tv Tasks Kentucky Basketball L * Question Completion Status: SA ype here to search C)2 D) 3 Feed2all p2p4u Wizi QUESTION 23 "A restriction specifying that no salary entered in the salary column can be higher than $300,000 is an exam True False QUESTION 24 "If an entity has three unique attributes, how many primary keys will its mapped relation have?" A)O B) 1 1948-1979 Ford Truck QUESTION 25 A foreign key column must have the same name as the primary key column it refers to. True False QUESTION 26 A relation resulting from a weak entity has a non-composite primary key when the identifying relationship is: A) Optional on both sides B) 1:1 C) 1:M D) MIN 8 LMC Truck Parts QUESTION 27 An ER diagram that contains two entities involved in two separate M:N relationships will be mapped as how many relatie A) 1 8) 2 Click Save and Submit to save and submit. Click Save All Answers to save all answers. @ mttps://elearning.kctcs.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_1928476_1&course_id=_493459 Project Free Tv Tasks Kentucky Basketball L Feed2all p2p4u Wiz *Question Completion Status: e here to search QUESTION 27 An ER diagram that contains two entities involved in two separate M:N relationships will be mapped as how many A) 1 B) 2 93 -D) 4 QUESTION 28 Which of the following is NOT true? In a relational database: A) Two tables can be a part of the same database B) Two tables can have the same number of columns C) Two tables can have the same number of rows D) Two tables can have the same names QUESTION 29 Which of the following best describes a business model? Typically a graphical depiction of the essential business process information. A sequence of business activities. An evaluation of potential business process improvements. None of the above. QUESTION 30 Two columns of a relational table can have the same values. True False 1948-1979 Ford Truck Truck Parts and " Click Save and Submit to save and submit. Click Save All Answers to save all anners. 0 @ e WE USA Project Free Tv Webapps/assessment/take/launch.jsp?course_assessment_id=_1928476_1&course_id=_4934 Tasks Kentucky Basketball Feed2all p2p4u Wizi Question Completion Status: None of the above. ype here to search QUESTION 30 Two columns of a relational table can have the same values. True False QUESTION 31 Two columns of a relational table can have the same names. True False QUESTION 32 it typically the best way to start creating your database? A) ERD ⒸB) AR C) Schema D) None of these answers QUESTION 33 Every relation contains: A) Full key functional dependency B) Partial functional dependency C) Transitive functional dependency D) All of the above Click Save and Submit to save and submit. Click Save All Answers to save all answers. 3 1948-1979 Ford Truck Truck Parts a e DBMS is software used for the following purpose: Creation of databases All of the above Insertion, storage, retrieval, update, and deletion of the data in the database Maintenance of databases QUESTION 2 Database implementation involves using. Front-end applications DBMS Database system Indirect interaction QUESTION 3 End users can vary in: Their level of technical sophistication The amount of data they need The frequency with which they access the database system All of the above. QUESTION 4 FirstNome is an example of MDBMS to implement the database model as an actual database. Metadata elearning.kctcs.edu/webapps/assessment/take/launch.jsp?course Project Free Tv Tasks Kentucky Basketball Question Completion Status: arch QUESTION 4 FirstName is an example of: DBMS Metadata Data Data Type QUESTION 5 Front-end applications facilitate: ● Direct use Indirect use Both direct and indirect use Neither direct nor indirect use QUESTION 6 Implicit changes of requirements are permitted during: Implicit changes of requirements are not permitted Database use Logical modeling Database deployment QUESTION 7 Information can be used for: Operational purposes only Analvtical purposes only assessment_id=_1928476_18course_id=_493459- 1948-1979 Ford Truck HC Truck Parts and Feed2all p2p4u Wizi 4 Click Save and Submit to save and submit. Click Save All Answers to save all answers, ек ps://elearning.kctcs.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_1928476_1&course_id=_4934595 Project Free Tv Tasks Kentucky Basketball L Feed2all p2p4u Wizi Question Completion Status: o search QUESTION 7 Information can be used for: Operational purposes only ● Analytical purposes only Operational and analytical purposes Neither for operational nor for analytical purposes QUESTION 8 Joe is an example of: Metadata Data Type Data DBMS QUESTION 9 Requirements can be refined and/or expanded following: Database deployment All of the above Logical modeling Database use QUESTION 10 The difference in the scope of databases is reflected in the Number of the development steps Cost in time and resources required for each of the development steps Level of importance of each of the development steps Click Save and Submit to save and submit. Click Save All Answers to save all answers, 1 1948-1979 Ford Truck Truck Parts and T R -aming.kctcs.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_1928476_1&course_id- 493 Feed2all p2p4u Wizi 1948-1979 Ford Truck LHC Truck Parts ject Free Tv Tasks Kentucky Basketball Question Completion Status: QUESTION 10 The difference in the scope of databases is reflected in the: Number of the development steps Cost in time and resources required for each of the development steps Level of importance of each of the development steps Order of the development steps search QUESTION 11 "How many entities are depicted by the following requirements? School XYZ keeps track of its 100 students, 10 tem OA) 3 B) 4 C) 115 D) 116 QUESTION 12 A multivalued composite attribute can be used to depict which of the following weak entity concepts? A) Partially unique attribute B) Identifying relationship C) A regular (non-identifying) one-to-many relationship between a weak entity and a regular entity D) A regular (non-identifying) many-to-many relationship between a weak entity and a regular entity QUESTION 13 A regular entity must have at least one of the following attributes: A) Unique attribute B) Composite attribute C) Multivalued attribute D) Derived attribute QUESTION 14 Click Save and Submit to save and submit. Click Save All Answere to save all answers. 1 8 1 d... 13 स B mttps://elearning.kctcs.edu/webapps/assessment/take/launch.jsp?course assessment_id=_1928476_1&course_id= Project Free Tv Tasks Kentucky Basketball 1948-1979 Ford Truck Truck I Question Completion Status: QUESTION 14 An M:N relationship that can have multiple occurrences between the same instances of involved entities OA) Weak entity with one owner OB) Multivalued composite attribute C) Unary M:N relationship D) Weak entity with two owners Feed2all p2p4u Wizi QUESTION 15 An associative entity is used as an alternative way of depicting: OA) 1:M relationships B) 1:1 relationships C) M:N relationships D) Multivalued attributes QUESTION 16 FirstN, MiddleN, and LastN make up a person's name in the DB. This is an example of: A) Composite attribute B) Multivalued attribute C) Derived attribute D) Unique composite attribute QUESTION 17 Which of the following is a legitimate exact minimum and maximum cardinality if you are speaking of a tournament with A) (10. 101" "B) (10, 1) *) (1.10) Click Save and Submit to save and submit. Click Save Al Answers to save all answers https://elearning.kctcs.edu/webapps/assessment/take/launch.jsp?course A Project Free Tv assessment_id=_1928476_1&course_id=4 Tasks Kentucky Basketball Feed2all p2p4u Wizi 1948-1979 Ford Truck Truck Pas Question Completion Status: QUESTION 17 Which of the following is a legitimate exact minimum and maximum cardinality if you are speaking of a tou "A) (10, 10)" "B) (10, 1)" "C) (1.10)" "D) (5, 4)" QUESTION 18 Which of the following is a possible type of relationship (maximum cardinality-wise)? A) One-to-one B) Zero-to-zero C) Zero-to-one D) Zero-to-many QUESTION 19 Which of the following is NOT a possible cardinality constraint? A) Optional one OB) Optional zero. C) Optional many D) Mandatory one QUESTION 20 Relationship attributes may be necessary in a relationship of what type? A) One-to-one B) One-to-many C) Zero-to-many D) Many-to-many Click Save and Submit to save and submit. Click Save All Anteers to save all answers 1 X zure | https://elearning.kctcs.edu/webapps/assessment/take/launch.jsp?course assessment_id=_1928476_1&cou are | USA Project Free Tv Tasks Kentucky Basketball 1948-1979 Ford Truck Question Completion Status: QUESTION 20 Relationship attributes may be necessary in a relationship of what type? A) One-to-one B) One-to-many C) Zero-to-many D) Many-to-many QUESTION 21 The following attribute represents a collection of attributes: A) Unique attribute B) Composite attribute C) Multivalued attribute D) Derived attribute Feed2all p2p4u Wizi QUESTION 22 The values of the following attribute are NOT permanently stored in a database. A) Unique attribute B) Composite attribute C) Multivalued attribute OD) Derived attribute QUESTION 23 "A restriction specifying that no salary entered in the salary column can be higher than $300.000 is an example True False https://elearning.kctcs.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_1928476_1&course_id=49 Project Free Tv Tasks Kentucky Basketball L * Question Completion Status: SA ype here to search C)2 D) 3 Feed2all p2p4u Wizi QUESTION 23 "A restriction specifying that no salary entered in the salary column can be higher than $300,000 is an exam True False QUESTION 24 "If an entity has three unique attributes, how many primary keys will its mapped relation have?" A)O B) 1 1948-1979 Ford Truck QUESTION 25 A foreign key column must have the same name as the primary key column it refers to. True False QUESTION 26 A relation resulting from a weak entity has a non-composite primary key when the identifying relationship is: A) Optional on both sides B) 1:1 C) 1:M D) MIN 8 LMC Truck Parts QUESTION 27 An ER diagram that contains two entities involved in two separate M:N relationships will be mapped as how many relatie A) 1 8) 2 Click Save and Submit to save and submit. Click Save All Answers to save all answers. @ mttps://elearning.kctcs.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_1928476_1&course_id=_493459 Project Free Tv Tasks Kentucky Basketball L Feed2all p2p4u Wiz *Question Completion Status: e here to search QUESTION 27 An ER diagram that contains two entities involved in two separate M:N relationships will be mapped as how many A) 1 B) 2 93 -D) 4 QUESTION 28 Which of the following is NOT true? In a relational database: A) Two tables can be a part of the same database B) Two tables can have the same number of columns C) Two tables can have the same number of rows D) Two tables can have the same names QUESTION 29 Which of the following best describes a business model? Typically a graphical depiction of the essential business process information. A sequence of business activities. An evaluation of potential business process improvements. None of the above. QUESTION 30 Two columns of a relational table can have the same values. True False 1948-1979 Ford Truck Truck Parts and " Click Save and Submit to save and submit. Click Save All Answers to save all anners. 0 @ e WE USA Project Free Tv Webapps/assessment/take/launch.jsp?course_assessment_id=_1928476_1&course_id=_4934 Tasks Kentucky Basketball Feed2all p2p4u Wizi Question Completion Status: None of the above. ype here to search QUESTION 30 Two columns of a relational table can have the same values. True False QUESTION 31 Two columns of a relational table can have the same names. True False QUESTION 32 it typically the best way to start creating your database? A) ERD ⒸB) AR C) Schema D) None of these answers QUESTION 33 Every relation contains: A) Full key functional dependency B) Partial functional dependency C) Transitive functional dependency D) All of the above Click Save and Submit to save and submit. Click Save All Answers to save all answers. 3 1948-1979 Ford Truck Truck Parts a e

Answer rating: 100% (QA)

The detailed answer for the above question is provided below 1 Ans All of the above sol Database Management System DBMS are the software systems used to store retrieve and run queries on data A DBMS s... View the full answer