Question 1 of 10 1.0 Points A. Backup the database B. Do performance tuning C. S

Question

Question 1 of 10

1.0 Points

A. Backup the database

B. Do performance tuning

C. Set up user authentication

D. Determine data confidentiality

Question 2 of 10

1.0 Points

A. attribute

B. relation

C. tuple

D. element

Question 3 of 10

1.0 Points

A. Keys

B. Attributes

C. Fields

D. Tables

Question 4 of 10

1.0 Points

A. data replication

B. horizontal partitioning

C. vertical partitioning

D. synchronization

Question 5 of 10

1.0 Points

A. An application server

B. A database management system

C. A programming language compiler

D. A Web server

Question 6 of 10

1.0 Points

A. first

B. second

C. third

D. fourth

Question 7 of 10

1.0 Points

A. columns

B. foreign keys

C. rows

D. values

Question 8 of 10

1.0 Points

A. first

B. second

C. third

D. fourth

Question 9 of 10

1.0 Points

A. application programmer

B. database management system

C. operating system

D. user

Question 10 of 10

1.0 Points

A. Low-level process management

B. Direct query processor

C. Application program interface processor

D. Administrative interface

Question 1 of 10

1.0 Points

Which is NOT one of the responsibilities of the database administrator?

A. Backup the database

B. Do performance tuning

C. Set up user authentication

D. Determine data confidentiality

Reset Selection

Mark for Review What's This?

Question 2 of 10

1.0 Points

One column of a table in a relational database is called a(n) ____.

A. attribute

B. relation

C. tuple

D. element

Reset Selection

Mark for Review What's This?

Question 3 of 10

1.0 Points

____ are a critical element of relational database design because they are the bases for representing relationships among tables.

A. Keys

B. Attributes

C. Fields

D. Tables

Reset Selection

Mark for Review What's This?

Question 4 of 10

1.0 Points

In a distributed database when the data is divided so that separate columns of the same table are at distinct locations that is referred to as _________.

A. data replication

B. horizontal partitioning

C. vertical partitioning

D. synchronization

Reset Selection

Mark for Review What's This?

Question 5 of 10

1.0 Points

Microsoft SQL Server is an example of what?

A. An application server

B. A database management system

C. A programming language compiler

D. A Web server

Reset Selection

Mark for Review What's This?

Question 6 of 10

1.0 Points

A relational database table is in ____ normal form if every non-key field is functionally dependent on the primary key.

A. first

B. second

C. third

D. fourth

Reset Selection

Mark for Review What's This?

Question 7 of 10

1.0 Points

All ____ in a table are guaranteed to be unique if the table's primary key is guaranteed to be unique.

A. columns

B. foreign keys

C. rows

D. values

Reset Selection

Mark for Review What's This?

Question 8 of 10

1.0 Points

A relational database table is in ____ normal form if no non-key field is functionally dependent on any other non-key field.

A. first

B. second

C. third

D. fourth

Reset Selection

Mark for Review What's This?

Question 9 of 10

1.0 Points

Referential integrity is normally enforced by the ____.

A. application programmer

B. database management system

C. operating system

D. user

Reset Selection

Mark for Review What's This?

Question 10 of 10

1.0 Points

Which of the following is NOT a component or function of a typical database management system (DBMS)?

A. Low-level process management

B. Direct query processor

C. Application program interface processor

D. Administrative interface

Reset Selection

Mark for Review What's This?

Explanation / Answer

1.

Option d correct.

Determine data confidentiality one of the responsibilities of the database administrator

2.

Option a correct.

One column of a table in a relational database is called an attribute.

3.

Option a correct.

Keys are a critical element of relational database design because they are the bases for representing relationships among tables.

4.

Option b correct.

In a distributed database when the data is divided so that separate columns of the same table are at distinct locations that is referred to as horizontal partitioning.

5.

Option b correct.

A database management system a database management system.

6.

Option b correct.

A relational database table is in second normal form if every non-key field is functionally dependent on the primary key.

7.

Option c correct.

All rows in a table are guaranteed to be unique if the table's primary key is guaranteed to be unique.

8.

Option c correct.

A relational database table is in third normal form if no non-key field is functionally dependent on any other non-key field.

9.

Option b correct.

Referential integrity is normally enforced by the database management system.

10.

Option a correct.

low level process management NOT a component or function of a typical database management system

Please rate my answer

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.