Information Technology Fundamentals
Review Questions
Course Introduction
Information Technology Fundamentals introduces students to the essential concepts and components of computing, information systems, and digital communication. The course covers the basics of computer hardware and software, operating systems, networking principles, cybersecurity, databases, and data management. Students will explore the impact of information technology on society and gain practical skills in using productivity tools, troubleshooting common issues, and understanding IT careers. Through hands-on activities and real-world scenarios, this course lays a strong foundation for further study in the field of information technology.
Recommended Textbook
Database Systems Introduction to Databases and Data Warehouses 1st Edition by Nenad Jukic
Available Study Resources on Quizplus
10 Chapters
752 Verified Questions
752 Flashcards
Source URL: https://quizplus.com/study-set/3126 Page 2
Chapter 1: Introduction
Available Study Resources on Quizplus for this Chatper
57 Verified Questions
57 Flashcards
Source URL: https://quizplus.com/quiz/61941
Sample Questions
Q1) A DBMS can be used for creation of databases.
A)True
B)False
Answer: True
Q2) Joe is an example of:
A)Data
B)Metadata
C)Data Type
D)DBMS
Answer: A
Q3) The new version of a database is created following the same development steps as the initial version.
A)True
B)False
Answer: True
Q4) List the general categories of people involved with database projects and systems.
Answer: Database analysts,designers,and developers.Front-end applications analysts and developers.Database administrators.Database end users.
To view all questions and flashcards with answers, click on the resource link above.
Page 3
Chapter 2: Database Requirements and ER Modeling
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/61942
Sample Questions
Q1) Which of the following is true according to the ABC Retailer ER diagram?
A)A promotion can be associated with many products and it has to be associated with at least one product
B)A promotion can be associated with many products but it does not have to be associated with any products
C)Each promotion is associated with exactly one product
D)A promotion is not associated with any products
Answer: A
Q2) Which of the following is true according to the ABC Retailer ER diagram?
A)We cannot keep track of promotions that are not associated with multiple products
B)We must keep track of promotions that are not associated with any products
C)We can keep track of promotions that are not associated with any products
D)We cannot keep track of promotions that are not associated with any products
Answer: D
Q3) According to the Eaglerun Trucking Dispatcher ER diagram,each driver has a unique DriverLicenseNo value.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above.
Page 4
Chapter 3: Relational Database Modeling
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/61943
Sample Questions
Q1) Two columns of a relational table can have the same names.
A)True
B)False Answer: False
Q2) An entity and its 1:M unary relationship are mapped as one relation.
A)True
B)False Answer: True
Q3) How many columns will the relation DRIVER have in the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram?
A)0 or 1
B)1 or 2
C)2 or 3
D)3 or 4 Answer: D
Q4) Attribute CustAge from the ZYX Company ER diagram will be mapped as a column of the relation CUSTOMER.
A)True
B)False Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Update Operations, update Anomalies, and Normalization
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/61944
Sample Questions
Q1) Functional dependency VehicleID --> Type exists in the table VEHICLE.
A)True
B)False
Q2) Functional dependency OwnerID --> OwnerName exists in the table VEHICLE.
A)True
B)False
Q3) When does a transitive key functional dependency occur?
Q4) Which of the following actions in the table ENROLLMENT will be prevented by an insertion anomaly?
A)Entering a new student 444,Sue
B)Entering a new student 555,Lisa
C)Entering a new record 666,Bob,E1,English
D)Entering a new class M1,Math1
Q5) Changing the name of owner O3,Pam to Pamela in the table VEHICLE will cause an occurrence of a modification anomaly.
A)True
B)False
Q6) In what two different ways is the term update operation often used?
Page 6
Q7) When does a functional dependency occur?
Q8) Give a definition of 2NF.
To view all questions and flashcards with answers, click on the resource link above.
Page 7
Chapter 5: SQL
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/61945
Sample Questions
Q1) What is the purpose of the DELETE command in SQL?
Q2) Write an SQL statement for the HAPPY INSURANCE database that creates a view that contains,for each agent,the agent name and the headquarter city of his or her area.
Q3) What is the purpose of the ORDER BY keyword?
Q4) What is the purpose of the HAVING keyword?
Q5) What is the purpose of the UPDATE command in SQL?
Q6) What is the purpose of DDL statements?
Q7) Which of the following is a part of a DDL statement?
A)CREATE
B)INSERT
C)DELETE
D)SELECT
Q8) DCL commands are used to manage database transactions.
A)True
B)False
Q9) What is the purpose of a ";" (semicolon)in the SQL statement?
Q10) Write an SQL query on the table STUDENT that lists records (all columns)for all freshman students.
Q11) Show the INSERT INTO statements for the table AREA. Page 8
To view all questions and flashcards with answers, click on the resource link above.
Page 9
Chapter 6: Database Implementation and Use
Available Study Resources on Quizplus for this Chatper
55 Verified Questions
55 Flashcards
Source URL: https://quizplus.com/quiz/61946
Sample Questions
Q1) If a DBMS enforces in the HAPPY INSURANCE database a DELETE RESTRICT option on the referential integrity constraint between AGENT and AGENT (i.e. ,circular referential integrity constraint for table AGENT)in the HAPPY INSURANCE database,and a DELETE CASCADE between AGENT and CLIENT,the second record in the table AGENT can be deleted.
A)True
B)False
Q2) If a DBMS enforces a DELETE CASCADE option on the referential integrity constraint betweenCLIENT and AGENT in the HAPPY INSURANCE database,what will be the outcome after aUser tries to delete the last record (A4,James,3,90,2010,A3)from AGENT?
A)CLIENT will have 7 records
AGENT will have 4 records
B)CLIENT will have 6 records
AGENT will have 3 records
C)CLIENT will have 7 records
AGENT will have 3 records
D)CLIENT will have 6 records
AGENT will have 4 records
Q3) What is a trigger?
To view all questions and flashcards with answers, click on the resource link above.
Page 10
Chapter 7: Data Warehousing Concepts
Available Study Resources on Quizplus for this Chatper
48 Verified Questions
48 Flashcards
Source URL: https://quizplus.com/quiz/61947
Sample Questions
Q1) Separate operational data sources cannot contain overlapping information.
A)True
B)False
Q2) Increasing the speed of a single query is always a priority,even if it requires slowing down the majority of other queries.
A)True
B)False
Q3) A data mart is a data store based on the same principles as a data warehouse but with a wider scope.
A)True
B)False
Q4) Data warehouse requirements can be refined and/or expanded following:
A)Data warehouse use
B)Data warehouse deployment
C)Creating ETL infrastructure
D)All of the above
Q5) What is the difference between developing the initial and subsequent versions of the data warehouse?
Q6) List the three major components of every data warehousing system.
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 8: Data Warehouse and Data Mart Modeling
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/61948
Sample Questions
Q1) ________ contain measures related to the subject of analysis.
A)Fact tables
B)Dimension tables
C)Both dimension and fact tables
D)None of the above
Q2) Based on the data shown in the STATEWIDE HEALTH PRESCRIPTIONS database,if we created an aggregated fact table that contains data about daily prescribed quantities of each medication,such an aggregated table would be connected to ________ dimensions.
A)2
B)3
C)4
D)5
Q3) What do timestamps indicate in slowly changing dimensions?
Q4) What are the two options for designing analytical databases in organizations where the organizational,political,or budgetary structure of the organization forces parts of the organization to undertake isolated initiatives?
Q5) Show how the Type 1 approach would implement the following change: the size of property whose ID is 111 is increased to 7000 sq ft.
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 9: Data Warehouse Implementation and Use
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/61949
Sample Questions
Q1) The set of processes that is used to populate the data warehouse tables with the appropriate relevant data retrieved from the operational databases is known as:
A)BI
B)ETL
C)OLAP
D)OLTP
Q2) What takes place during the extraction part of ETL?
Q3) A user using an OLAP query (based on the dimensionally modeled data set that contains the Generic Retailer dimension PRODUCT)can drill down from ProductBrandID to ProductCategoryID.
A)True
B)False
Q4) What is an executive dashboard?
Q5) The process of deciding what to extract during the extraction process begins after the requirements and modeling stages are completed.
A)True
B)False
Q6) What is a refresh cycle?
Q7) Illustrate a typical MOLAP architecture.
Page 13
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: Overview of Dbms Functionalities and Database Administration
Available Study Resources on Quizplus for this Chatper
42 Verified Questions
42 Flashcards
Source URL: https://quizplus.com/quiz/61950
Sample Questions
Q1) What is a complete mirrored backup?
Q2) What is the purpose of the ROLLBACK command?
Q3) If,during the use of the database system,it becomes apparent that a new relation needs to be added to the database,the decision to add the new relation to the database will rest with the:
A)Database developer
B)DBA
C)End user
D)DBMS software developer
Q4) What is update failure?
Q5) In a role-based access control system,the membership of users in roles cannot change.
A)True
B)False
Q6) The data definition component is a part of every DBMS package.
A)True
B)False
Q8) What is a query optimizer? Page 14
Q7) What is the purpose of the COMMIT command?
To view all questions and flashcards with answers, click on the resource link above.
Page 15