QUESTION 16

1. Which factor can mitigate the problems of increased complexity that come with using a DBMS?

	a.	sound database design
	b.	using large file sizes
	c.	using no integrity constraints
	d.	writing complex access rules

2 points

QUESTION 17

1. Which of the following is true about big data?

	a.	all big data can be handled with traditional DBMS tools
	b.	big data may be structured or unstructured
	c.	unstructured big data doesn't contain metadata
	d.	a Twitter tweet is an example of structured big data

2 points

QUESTION 18

1. What should an administrator use to more easily assign database access permissions to multiple users?

	a.	clusters
	b.	attributes
	c.	groups
	d.	classes

2 points

QUESTION 19

1. Which database property lets you change the structure of the database without requiring you to change the programs that access the database?

	a.	data independence
	b.	data dependence
	c.	database design
	d.	integrity constraint

2 points

QUESTION 20

1. Which of the following is considered a disadvantage of a database system?

	a.	reduced integrity
	b.	reduced productivity
	c.	data dependence
	d.	a larger file size

2 points

QUESTION 21

1. What uniquely identifies a row in a table?

	a.	attribute
	b.	primary key
	c.	field
	d.	column

2 points

QUESTION 22

1. Which term is another word for a row in a table?

	a.	relation
	b.	field
	c.	tuple
	d.	group

2 points

QUESTION 23

1. Which of the following is NOT true about a relation in a two-dimensional table?

	a.	The entries in the table are single-valued.
	b.	All values in a column are values of the same attribute.
	c.	Two or more columns can share the same name.
	d.	The order of rows is immaterial.

2 points

QUESTION 24

1. How do you refer to a column named State in a table named Client?

	a.	State(Client)
	b.	Client(State)
	c.	State.Client
	d.	Client.State

2 points

QUESTION 25

1. Which of the following is the column or collection of columns that uniquely identifies a given row in that table?

	a.	primary key
	b.	minor key
	c.	foreign key
	d.	secondary key

2 points

QUESTION 26

1. The compound criteria (conditions) are created by using which of the following two keywords?

	a.	OR, NOT
	b.	AND, NOR
	c.	AND, OR
	d.	NOT, ONLY

2 points

QUESTION 27

1. What type of functions are Count, Sum, Avg, Max, and Min?

	a.	accumulation
	b.	allowed
	c.	primary
	d.	aggregate

2 points

QUESTION 28

1. If you are sorting records by more than one field, which field is the more important field?

	a.	minor sort key
	b.	secondary sort key
	c.	primary sort key
	d.	maximum sort key

2 points

QUESTION 29

1. What type of query changes data?

	a.	addition
	b.	update
	c.	select
	d.	update

2 points

QUESTION 30

1. What type of query creates a new table using the query results?

	a.	merge-table
	b.	new-table
	c.	create-table
	d.	make-table