Introduction to Information Technology Test
Preparation
Course Introduction
Introduction to Information Technology provides students with a foundational understanding of how computers, networks, software, and digital systems are used to process, store, and communicate information. The course covers key concepts including computer hardware and software components, operating systems, databases, the Internet, cybersecurity basics, and the societal impact of IT. Students will explore emerging technologies and their real-world applications, gaining practical skills in productivity software, digital collaboration, and information literacy, preparing them for further study or entry-level roles in the evolving field of information technology.
Recommended Textbook
Concepts of Database Management 8th Edition by Philip J. Pratt
Available Study Resources on Quizplus
9 Chapters
525 Verified Questions
525 Flashcards
Source URL: https://quizplus.com/study-set/1756
Page 2
Chapter 1: Introduction to Database Management
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/34985
Sample Questions
Q1) Which of the following statements is correct?
A) In a nondatabase, file-oriented environment, data is often partitioned into several disjointed systems with each system having its own collection of files.
B) User data cannot be combined and shared among authorized users.
C) Database users should not have access to the same information.
D) The elimination of redundancy is always possible.
Answer: A
Q2) An attribute is known as a row in most databases.
A)True
B)False Answer: False
Q3) A database file requires a large amount of disk space and internal
Answer: memory
Q4) Programs created with Visual Basic,Java,Perl,PHP,or C++ can access the database directly,rather than having to access it through the DBMS. A)True
B)False Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: The Relational : Introduction, QBE, and Relational Algebra
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/34986
Sample Questions
Q1) Multiple entries in tables are often called ____________________.
Answer: repeating groups
Q2) When duplicate column names exist in a database and you need to indicate the column to which you are referring,____.
A) do not use these two tables together
B) do not use the column names in the same statement
C) write both the table name and the column name, separated by a period
D) write the table name only
Answer: C
Q3) Which operation will allow you to extract data from more than one table?
A) Select
B) Merge
C) Project
D) Join
Answer: D
Q4) QBE is a visual approach to writing queries.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: The Relational : SQL
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/34987
Sample Questions
Q1) ____________________ means creating groups of records that share some common characteristics.
Answer: Grouping
Q2) Based on the code above,list the number,name,credit limit,and balance for all customers with credit limits that exceed their balances.
A) SELECT CustomerNum, CustomerName FROM Customer WHERE CreditLimit>Balance ;
B) SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer WHERE CreditLimit>Balance ;
C) SELECT CustomerNum, CustomerName, Balance FROM Customer WHERE CreditLimit>Balance ;
D) SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer ; Answer: B
Q3) You can save the results of a query as a table by including the ____ clause in the query.
A) UPDATE
B) INSERT C) INTO
D) DELETE
Answer: C
To view all questions and flashcards with answers, click on the resource link above.
Page 5
Chapter 4: The Relational : Advanced Topics
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/34988
Sample Questions
Q1) Referential integrity is specified using the FOREIGN KEY clause in the SELECT command.
A)True
B)False
Q2) One advantage of a view is that different users can view the same data in different ways.
A)True
B)False
Q3) A stored procedure is placed on a client computer.
A)True
B)False
Q4) Within relational model systems on both mainframes and personal computers,the main mechanism for increasing the efficiency with which data is retrieved from the database is the ____________________.
Q5) The CHECK clause can be included in the ____ command.
A) SELECT TABLE
B) ALTER TABLE
C) DROP TABLE
D) DELETE TABLE
Q6) Discuss what are validation rules and validation text.
Page 6
To view all questions and flashcards with answers, click on the resource link above.
Chapter 5: Database Design 1: Normalization
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/34989
Sample Questions
Q1) An alternate key is a ____.
A) foreign key
B) primary key
C) column that could be a primary key but was not chosen
D) row that could be a primary key but was not chosen
Q2) A column is a nonkey column if it is ____.
A) in first normal form
B) in second normal form
C) a part of the primary key
D) not a part of the primary key
Q3) ____ normal form has an additional condition that the only determinants the table contains are candidate keys.
A) First
B) Second
C) Third
D) Fourth
Q4) Describe the procedure for converting a table to the third normal form.
Q5) Any column or collection of columns that determines another column is called a(n)
Q6) Explain what normalization is,including the goal of normalization.
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Database Design 2: Design Method
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/34990
Sample Questions
Q1) ____ means that an entity has a minimum cardinality of one.
A) The entity is required in the relationship.
B) The entity is not required in the relationship.
C) The entity should not be in the relationship as an attribute.
D) The entity must be listed with all ones in the data fields.
Q2) On an E-R diagram,____________________ entities have rounded corners.
Q3) To obtain information about ____________________ you might ask users questions such as: "If you know a particular employee number,can you establish other information,such as employee name?"
Q4) The style of E-R diagram used in the text is ____________________.
Q5) It is through foreign keys that you can create relationships among tables and enforce certain types of ____________________ constraints in a database.
Q6) You can recognize entity subtypes by the fact the primary key is also a(n)____________________.
Q7) The information-level design methodology involves representing the individual user view as a collection of tables,refining them to eliminate any problems,and then merging them into a cumulative design.
A)True
B)False
Page 8
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: Dbms Functions
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/34991
Sample Questions
Q1) ____________________ key constraints are governed by entity integrity and enforce the uniqueness of the primary key.
Q2) Additional storage and memory space are not required to store timestamp values.
A)True
B)False
Q3) ____________________ integrity constraints consist of primary key constraints and foreign key constraints.
Q4) ____________________ is the prevention of unauthorized access,either intentional or accidental.
Q5) In some database systems,such as Microsoft Access,users can access and update metadata about fields,tables,relationships,and indexes.
A)True
B)False
Q6) In order to accomplish serial processing of updates,many DBMSs use ____.
A) backups
B) locking
C) encryption
D) biometrics
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Database Administration
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/34992
Sample Questions
Q1) Which of the following DBMS evaluation categories does the following question relate to: How many files can you open at the same time?
A) Concurrent update
B) Security
C) Integrity
D) Limitations
Q2) The CEO of the company determines the database access privileges for all users.
A)True
B)False
Q3) Which of the following DBMS evaluation categories does the following question relate to: What is the unit that may be locked and are exclusive locks the only ones permitted?
A) Concurrent update
B) Data recovery
C) Data dictionary
D) Security
Q4) If a DBMS lacks essential security features,the _________________________ might create or purchase special security programs that provide the missing features.
Q5) What is the DBA's role with regard to access privileges?
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Database Management Approaches
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/34993
Sample Questions
Q1) What is the purpose of the following UML diagrams: class,use case,sequence,and activity?
Q2) A(n)____ consists of rows that contain consolidated and summarized data.
A) class
B) data model
C) fact table
D) object
Q3) A ____ is a subject-oriented,integrated,time-variant,nonvolatile collection of data in support of management's decision-making process.
A) data warehouse
B) thin client
C) back-end processor
D) fat client
Q4) ____ refers to the association of an operation to actual program code.
A) Attaching
B) Matching
C) Linking
D) Binding
Q5) A(n)____________________ DDBMS is a database that has the same local DBMS at each site.
11
To view all questions and flashcards with answers, click on the resource link above.