ICT-225: Pre-Assessment Quiz

Which of the following is often considered to be the first high-level programming language? a. C b. C++ c. Java d. Visual Basic

a. C x

In Microsoft Access, what data type would you most likely assign to a field containing price values? a. Currency b. Number c. Price d. Short Text

a. Currency

Which of the following would probably be the best primary key for an Employees table? a. EmployeeNum b. SSN c. EmployeeLast d. BirthDate

a. EmployeeNum

Which of the following clauses joins the Products and Orders tables on a field named ProductID that is common to both? a. LINK Products.ProductID to Orders.ProductID b. FROM Products, Orders ON ProductID c. UNION Products.ProductID = Orders.ProductID d. WHERE Products.ProductID = Orders.ProductID

a. LINK Products.ProductID to Orders.ProductID x

Which of the following Microsoft Access tools provides information about table relationships and field names? a. Navigation Pane b. Relationship report c. Options dialog box d. Table properties window

a. Navigation Pane x

Which of the following is generally considered a fundamental technical competency for a database administrator? a. SQL b. JavaScript c. Microsoft Word d. macOS

a. SQL

Which of the following is NOT true about SQL? a. SQL used in one DBMS is significantly different from SQL used in another DBMS. b. SQL is a universal language for selecting and maintaining data stored in a relational database. c. SQL is an open source language with a large community of developers. d. SQL skills are valued by many employers.

a. SQL used in one DBMS is significantly different from SQL used in another DBMS. x

Relational algebra provides foundational concepts for __________. a. Structured Query Language (SQL) b. Standard Query Criteria (SQC) c. Database Query Calculus (DQC) d. Select Query Language (SQL)

a. Structured Query Language (SQL)

If you can determine an employee's last name based on the EmpID field, what can you say about the EmpLast and EmpID fields? a. The EmpLast field is functionally dependent on the EmpID field. b. The EmpID field is functionally dependent on the EmpLast field. c. The EmpLast field is not related to the EmpID field. d. Either field could be the primary key field.

a. The EmpLast field is functionally dependent on the EmpID field.

Which of the following is NOT a task a data scientist would typically perform? a. back up and recover data b. apply programming algorithms to big data c. analyze trends in customer preferences d. conduct large-scale research to produce better products

a. back up and recover data

Which of the following type of information is NOT typically maintained in an organization's internal, centralized database? a. blogging comments b. billing c. payroll d. inventory

a. blogging comments

In the contemporary version of a centralized architecture, a traditional mainframe is often represented by a(n) __________. a. cloud computing data center b. token ring network of personal computers c. smartphone d. Al network

a. cloud computing data center

As you convert lists of data into third normal form, what other task must you perform to build a healthy relational database? a. connect tables in correct one-to-many relationships b. modify user views c. design meaningful reports d. create metadata

a. connect tables in correct one-to-many relationships

Being able to change a field property without changing associated programs dependent on that data is an example of __________. a. data independence b. key integrity constraints c. record-level locking d. data integrity

a. data independence

Besides the primary key field, which other keys should probably be indexed in a table? a. every other field b. Boolean fields c. secondary key fields d. memo fields

a. every other field x

Besides one-to-many relationships, what else does an entity-relationship model (ERM) display? a. many-to-many relationships b. sample data c. redundant data d. suer views

a. many-to-many relationships

Information about tables and fields in a database is commonly called __________. a. metadata b. data integrity c. indexed data d. data conventions

a. metadata

A __________ is typically responsible for detailed technical knowledge of an existing database management system, indexes, and SQL so that improvements can be made in speed and response times. a. performance analyst b. database architect c. data modeler d. research analyst

a. performance analyst

Two tables have a one-to-one relationship when one record in the first table __________. a. relates to no more than one record in the other table. b. relates to one, none, or many records in the other table. c. relates to no records in the other table. d. relates only to another record in the same table.

a. relates to no more than one record in the other table.

A column that uniquely identifies a row in a table is often called a(n) __________. a. relation b. attribute c. foreign key d. primary key

a. relation x

A(n) __________ is a common name for a unique value that identifies each person and is generally a combination of characters that reflect a person's name or employee number. a. user ID b. encryption key c. biometric ID d. alternate key

a. user ID

In SQL, how could you find the name and description of the products that have a Price field value greater than ProductID 124? a. Create a query that uses the MAX aggregate function. b. Create a union query. c. Create a query with a subquery. d. Create a query that uses the LIKE operator.

b. Create a union query. x

Which of the following is NOT a characteristic of first normal form? a. Each table has a single-field primary key field b. Each column contains consistent values c. Each column contains atomic values d. No duplicate records

b. Each column contains consistent values x

Which of the following is a service that specifically helps to analyze data collected from an organization's website? a. JSON b. Google Analytics c. Tableau d. Ruby on Rails

b. Google Analytics

How can you change the Field Size property of a field in an Access database? a. In Table Design View, select the field then change its Name. b. In Table Design View, select the field, click the Field Size property, and then enter a new value. c. In Table Datasheet View, resize the width of the column heading for the field. d. In Table Design View, double-click the field, then enter a new value in the Field Size dialog box.

b. In Table Design View, select the field, click the Field Size property, and then enter a new value.

How do you use Microsoft Access to view SQL code? a. Open a query in Query Design View b. Open a query in SQL View c. Open a query in Query Datasheet View d. You cannot use Access to view SQL code

b. Open a query in SQL View x

In SQL, which of the following aggregate functions would you use to subtotal the values in a numeric field? a. SUBTOTAL b. TOTAL c. GROUP d. SUM

b. TOTAL x

Microsoft Access is probably NOT appropriate in which of the following cases? a. Few people use the database at the same time. b. The database is distributed over a large area network. c. Only trusted users work with the database. d. Data is organized in related tables.

b. The database is distributed over a large area network.

Which of the following SQL WHERE statements selects records with a PostalCode value of 53726 if PostalCode is created as field that contains text? a. WHERE PostalCode = 53726 b. WHERE PostalCode = '53726' c. WHERE 53726 = PostalCode d. WHERE PostalCode = [53726]

b. WHERE PostalCode = '53726'

Which of the following people would most likely apply an algorithm to project future sales based on data gathered about current product sales? a. data entry specialist b. data analyst c. sales assistant d. sales associate

b. data analyst

A database administrator (DBA) is generally NOT responsible for which of the following areas? a. database design b. end-user training c. performance tuning d. SQL and views

b. end-user training

A relational database provides data integrity features through data integrity constraints and __________. a. data export features b. key integrity constraints c. queries d. metadata analysis

b. key integrity constraints x

What type of chart is generally best to illustrate trends over a period of time such as sales over several months or years? a. pie chart b. line chart c. 3D chart d. map chart

b. line chart

Which of the following is a primary goal of data normalization? a. to remove lengthy field values b. to minimize redundant data c. to simplify the creation of new tables d. to identify and remove outdated data

b. to minimize redundant data

In Microsoft Access, which of the following criteria selects records from a Price currency field with a value less than 250? a. <=250 b. <"250" c. <250 d. >250

c. <250 x

Which of the following is NOT an atomic value? a. Los Angeles b. Star Wars c. Edgar F. Codd d. 25.75

c. Edgar F. Codd

In a client/server system, the database resides on a computer called the __________, and a user accesses the database through a __________. a. database manager, user manager b. server, peer c. client, server d. server, client

c. client, server x

A query that retrieves fields and records from the database is commonly called a __________. a. select query b. datasheet query c. composite query d. retrieval query

c. composite query x

Which of the following is NOT a task a data analyst would typically perform? a. compile statistics on sales figures b. create data visualizations c. create and maintain indexes d. develop charts of key performance indicators

c. create and maintain indexes x

Which of the following is NOT a type of data modification anomaly? a. update b. deletion c. creation d. insertion

c. creation

The Microsoft Access Relationships window displays a type of __________. a. Database Design Language (DBDL) diagram b. information-level design c. entity-relationship (E-R) diagram d. user view

c. entity-relationship (E-R) diagram

How can you help prevent unauthorized users from opening an Access database file? a. lock all the records in the database b. close the database in exclusive mode c. set a password on the database d. back up the database

c. set a password on the database

What does the expression Max([Salary]) in the query grid of Microsoft Access Query Design View return? a. the number of values in the Salary field b. the sum of the values in the Salary field c. the highest value in the Salary field d. the most common value in the Salary field

c. the highest value in the Salary field

Which field in the following Professors table is the foreign key field that connects to the Departments Table? Professors (ProfID, LastName, FirstName, OfficeNum, DeptNum) Departments (DeptNum, DeptName, DeptOffice) a. LastName b. ProfID c. OfficeNum d. DeptNum

d. DeptNum x

Which of the following expressions in the query grid of Microsoft Access Query Design View creates a field named Discount that subtracts $15.00 from the Price field? a. Discount = Price - 15 b. Price - 15 = Discount c. Discount: "Price" - "15" d. Discount: [Price] - 15

d. Discount: [Price] - 15 x

What type of database system stores data in a set of descriptive documents rather than traditional columns, rows, tables, and relationships? a. neural network database management system b. linear data warehouse c. distributed analog database d. NoSQL database system

d. NoSQL database system

A database __________ contains a collection of persons, places, events, items, or other similar transactions for which you want to store and process data. a. field b. row c. property d. entity

d. entity

Which of the following is NOT a common example of big data created by social media activities? a. blog postings b. tweets c. images d. order transactions

d. order transactions

Which of the following symbols indicates a record is currently being edited in Microsoft Access? a. infinity symbol b. padlock symbol c. key symbol d. pencil symbol

d. pencil symbol

If you create a copy of a database and distribute it to other computers or locations, the copy is called a(n) __________. a. dupe b. synch c. decoy d. replica

d. replica