CIT843
1. The__________ is the simplest type of query and because of that, it is also the most commonly used one in Microsoft Access databases.
—>> select query
reject query
delete query
create query
2. A________ is a collection of data about a specific topic. There can be multiple tables in a database.
—>> table
relation
entity
attribute
3. ______________ is the main file that encompasses the entire database.
metadata
relation
—>> Database file
SQL
4. _____________ can be used to search for and grab data from one or more tables.
—>> Queries
field
database
table
5. ___________ are the different attributes of a Table.
column
—>> field
row
entity
6. Database transaction management is a crucial issue in order to maintain data __________.
processing
storage
—>> consistency
management
7. Which of the options is not a kind of action queries?
Append Query
Delete Query
—>> Create query
Update Query
8. _________ are the properties of each field. A field only has one data type.
dataset
database
—>> Data types
datagram
9. A _____________ performs some type of arithmetic on one or more fields in a database to come up with a completely new field.
calculated row
—>> calculated field
aggregation
update query
10. _________________ is a powerful program to create and manage your databases.
Microsoft excel
—>> Microsoft Access
relational table
table
JOIN OUR TELEGRAM ON VIP NOUN UPDATES – FOR FREE CIT843 PAST QUESTIONS AND EXAMS SUMMARIES