WGU C170 OBJECTIVE ASSESSMENT EXAM AND PRACTICE EXAM /WGU C 170 DATA MANAGEMENT APPLICATIONS OA 300 QUESTIONS AND CORRECT DETAILED ANSWERS (VERIFIED ANSWERS) |ALREADY GRADED A+

1 | P a g e

WGU C170 OBJECTIVE ASSESSMENT EXAM AND PRACTICE

EXAM /WGU C 170 DATA MANAGEMENT APPLICATIONS

OA 300 QUESTIONS AND CORRECT DETAILED ANSWERS

(VERIFIED ANSWERS) |ALREADY GRADED A+

WGU C170 OBJECTIVE ASSESSMENT EXAM

What does the principle of data independence state?

a) The performance of a query is not related to the physical organization

of data.

b) Data in each row is independent of data in all other rows.

c) The result of a database query is not affected by the physical

organization of data on storage devices. - ANSWER- c- In relational

databases, query results are not dependent on physical storage. This

allows database administrators to tune storage for optimal performance

at any time.

In a table that never contains duplicate rows, non-key columns always

depend on the primary key.

True or False? - ANSWER- True

In a first normal form table, non-key columns depend only on the

primary key.

True or False? - ANSWER- False- In a first normal form table, non-key

columns may depend on other non-key columns.

In principle, all tables are in first normal form.

2 | P a g e

True or False? - ANSWER- True

A table with a simple primary key must be in what normal form?

a) First normal form only, and no higher

b) Second normal form or higher

c) Third normal form - ANSWER- b

What is DDL?

a) for defining and designing databases

b) for manipulating databases

c) for normalization

d) for DBMS - ANSWER- a- CREATE TABLE

When you are using SQL statements to create or modify the structure of

a database, what is SQL being used as?

a) DML

b) DBMS

c) DDL

d) DCL - ANSWER- c- As a Data Definition Language, SQL can be

used to create or modify the structure of database tables.

What does DDL (Data Definition Language) do with a database ?

a) manages database transactions

b) manipulates data stored in a database

3 | P a g e

c) retrieves data from the database

d) defines the structure of the database - ANSWER- d

Which SQL sublanguage inserts a data row into a table product?

a) DML

b) DQL

c) DTL

d) DDL - ANSWER- a- Data Manipulation Language inserts, updates

and deletes data in a table

What is DML?

a) for defining and designing databases

b) for manipulating databases

c) for normalization

d) for DBMS - ANSWER- b- INSERT, UPDATE, DELETE

Which of these tasks can you accomplish using SQL as a DML?

a) inserting a record into a table

b) deleting the database

c) allowing a new user access to read from a table

d) removing a column from a table - ANSWER- a

What does DML (Data Manipulation Language) do with a database ?

4 | P a g e

a) manages database transactions

b) manipulates data stored in a database

c) retrieves data from the database

d) defines the structure of the database - ANSWER- b

Which SQL sublanguage inserts a data row into a table product?

a) DML

b) DQL

c) DTL

d) DDL - ANSWER- a- Data Manipulation Language inserts, updates

and deletes data in a table

Which SQL sublanguage grants permission to user 'tester'?

a) DML

b) DQL

c) DCL

d) DDL - ANSWER- c- Data Control Language, grants and revokes

permissions to and from users.

What does DCL (Data Control Language) do with a database ?

a) manages database transactions

b) controls database user access

c) retrieves data from the database

d) defines the structure of the database - ANSWER- b