D426 DATA MANAGEMENT FOUNDATIONS EXAM

PDF Download

D426 DATA MANAGEMENT FOUNDATIONS EXAM

QUESTIONS

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

-Format: Multiple-choice / Flashcard

Question 1: a single object (ie a person, place, product, or activity)

Answer:

in a relational database, all data in a row represents...

Question 2: DATE

Answer:

data type that stores year, month, and day

Question 3: 1. Analysis

• Logical design
• Physical design

Answer:

The design process for complex databases has these three phases

Question 4: database application

Answer:

software that helps business users interact with database systems

Question 5: MongoDB is the only one that is NoSQL. The others are relational

Answer:

Of the top five leading database products, which are NoSQL? What are the others?

Question 6: numeric, textual, or complex

Answer:

data types can be one of these three things

Question 7: ten significant digits, including three after the decimal point

Answer:

what would data type DECIMAL(10,3) indicate?

Question 8: user interface, business logic, and interfaces to other systems

Answer:

an information management system usually includes a database system as well as other components, such as these three items

Question 9: analog

Answer:

historically, most data was ____, encoded as continuous variations on various physical media

Question 10: scope, format, and access

Answer:

• ways data can vary

Question 11: Analysis Phase

Answer:

phase of the database design process that specifies database requirements without regard to a specific database system

Question 12: open source

Answer:

Software that allows programmers to inspect and modify source code

Question 13: format

Answer:

In a relational database, all data in a column has the same ____

Question 14: relational database

Answer:

stores data in tables, columns, and rows, similar to a spreadsheet

Question 15: SELECT

Answer:

query that retrieves information from the database

Question 16: NoSQL

Answer:

newer non-relational systems that are optimized for big data Question 17: False (query optimization ensures the most efficient instructions are sent to the storage manager, but the storage manager can still retrieve the data either way)

Answer:

T/F: without query optimization, the storage manager cannot retrieve the database data

Question 18: query

Answer:

a request to retrieve or change data in a database

Question 19: INT

Answer:

data type that stores integer values

Question 20: DATETIME

Answer:

data type that stores a date and a time

Question 21: Create, Read, Update, and Delete

Answer:

What does CRUD stand for?

Question 22: database programmer

Answer:

role that writes applications that combine database query languages and general-purpose programming languages.

Question 23: data type

Answer:

each column of a data table is assigned a _____, which indicates the format of column values

Question 24: database design

Answer:

a specification of database objects such as tables, columns, data types, and indexes

Question 25: log

Answer:

a file containing a complete record of all inserts, updates, and deletes processed by the database

Question 26: database programmer

Answer:

role that develops the computer programs that utilize a database.Question 27: Databases that require an accurate record of every transaction (ie: banking, airline reservation systems, student records)

Answer:

What type of databases are relational databases ideal for?

Question 28: data

Answer:

Numeric, textual, visual, or audio information that describes real-world systems