DATA MANAGEMENT - FOUNDATIONS - D426 WGU EXAM

PDF Download

DATA MANAGEMENT - FOUNDATIONS - D426 WGU EXAM

QUESTIONS

Actual Qs and Ans - Expert-Verified Explanation -Guaranteed passing score -99 Questions and Answers

-Format: Multiple-choice / Flashcard

Question 1: CREATE DATABASE DatabaseName

Answer:

creates a new database.

Question 2: Rename

Answer:

changes a table name.

Question 3: DQL

Answer:

Select all rows from table Product.

Question 4: relational rules

Answer:

part of the relational model and govern data in every relational database

Question 5: PostgreSQL database

Answer:

type: relational

license : open source

Question 6: database designer

Answer:

determines the format of each data element and the overall database structure

Question 7: Aggregate

Answer:

computes functions over multiple table rows, such as sum and count.

Question 8: MySQL Command-Line Client

Answer:

a text interface included in the MySQL Server download

Question 9: Keywords

Answer:

Words with special meaning.

SELECT , FROM , WHERE

Question 10: data query language (DQL)

Answer:

Enables users to retrieve, sort, and display specific data from the database

Question 11: NoSQL

Answer:

A new generation of database management systems that is not based on the traditional relational database model.

Question 12: Union

Answer:

selects all rows of two tables.

Question 13: database model

Answer:

Describes the relationship between the data elements and provides a framework for organizing the data.contains 3 parts data structures operations rules

Question 14: Data Manipulation Language (DML)

Answer:

A specific language, provided with a DBMS, which allows users to access and modify the data, to make queries, and to generate reports.

Question 15: 3RD OPERATER PRECEDENCE

Answer:

• / %

Question 16: SQL Server

Answer:

type: relational

license : Commercial

Question 17: SELECT

Answer:

Retrieves data from a table

Question 18: in-memory database

Answer:

A database management system that stores the entire database in random access memory (RAM).

Question 19: primary key

Answer:

a column or group of columns that identifies a unique row in a table

Question 20: The SQL standard is published jointly by the...

Answer:

American National Standards Institute (ANSI) and the International Organization for Standardization (ISO)

Question 21: Oracle Database

Answer:

type: relational

license : commercial

Question 22: CHANGE (ALTER TABLE CLAUSE)

Answer:

Modifies a column ALTER TABLE TableName CHANGE CurrentColumnName NewColumnName NewDataType;

Question 23: MySQL Enterprise

Answer:

a paid edition for managing commercial databases.

Question 24: replica

Answer:

a cop of an entire database

Question 25: DTL

Answer:

Rollback database changes.

Question 26: query

Answer:

command for a database that typically inserts, retrieves, updates and deletes data from the database.

Question 27: UPDATE

Answer:

modifies data in a table

Question 28: ER diagrams

Answer:

Rectangles represent entities. Entity names appear at the top of rectangles.Lines between rectangles represent relationships.Text inside rectangles and below entity names represent attributes.

Question 29: Comments

Answer:

Statement intended only for humans and ignored by the database when parsing an SQL statement.-- single line comment /* multi-line Comment */