Data Management Foundation Part 2

Using the float keyword, which statement will return all digits for the value 3.5872?

Float(5, 4)

What is the correct format for TIME?

HH:MM:SS.[nnnnnnn]

In Structured Query Language (SQL), about how many values can INT hold?

More than 4 billion

Which of these data types allows for decimals?

NUMERIC

Which of these would likely NOT be stored using CHAR in SQL?

Names

Which of the following SELECT clauses controls the position of the entries returned?

ORDER BY

BLOBS are _____ data types

Object

What is a negative effect of having a very large dynamic SQL query?

Performance impacts

Which of these would NOT likely be stored using VARCHAR in SQL?

Phone numbers (including area codes)

What does the 'p' stand for in a DECIMAL or NUMERIC value?

Precision

Which of the following deals with grouping steps together in a unit?

Procedural Language Features

A SQL _____ can be a component of a SQL _____.

Query, Script

The results of a full outer join can be organized using an ORDER_BY clause; how would this be useful considering the examples given in the lesson?

An ORDER_BY clause is particularly useful when you expect to have a large data set returned and you want to view student names in alphabetical order.

Examine the following subquery: What is missing from this SQL statement?

An alias for the subquery

What is an abstract data model?

Something more simplified than a data model.

What do you use to create a SQL script?

Text Editor

How do data models and abstract data models differ?

The amount of provided detail and scope varies.

In terms of data models, what is abstraction?

The process of simplification.

What is the meaning of the NULL; statement in PL/SQL?

There are no commands to be executed.

How should DECIMAL and NUMERIC be used in the same database?

They should not be used together.

In the query below, how many tables are being queried?

Three (employee, wages, fica)

Which of the following best describes the purpose of an object diagram?

A point in time view of interactions between objects

The GROUP BY clause is:

A query clause

A dynamic SQL query would be beneficial in which scenario?

A query in which parameters or values may change

Given the following SQL statement, please describe what results will be given.

A table indicating the chemistry majors who have registered for courses.

What does T-SQL stand for?

Transact-SQL

What type of data can BOOLEAN hold?

True or false

Which of the following SQL commands changes information already in a database?

UPDATE

Which of these is a properly formatted CHAR example?

book_id CHAR(5)

A SQL script is a sequential list of _____ grouped together to perform _____.

commands, a task

Assuming it is not the last column in a database, what is the correct formatting for a DATE data type for the column 'enrollment_date'?

enrollment_date DATE;

hich of these is a properly formatted example of VARCHAR?

first_name VARCHAR(10)

When using the ORDER BY clause, where is it located?

following the GROUP BY clause

Which of these is properly formatted?

friend BOOLEAN;

Which shows how the column 'game_time' should be formatted using TIME, assuming it is not the last column in a database?

game_time TIME

Examine the following SQL statement. What table is the subquery querying?

orders

What values need to be entered after selecting a data type (either NUMERIC or DECIMAL)?

p and s

Examine the following snippet from a dynamic SQL statement. Which field is dynamic?

productID

What notation must be used to end a GROUP BY clause or any SQL statement?

the semicolon

To declare a BLOB in SQL Server, the following statement is used.

varbinary(MAX);

An INNER JOIN is also called a(n) _____

Simple join

How are data models and abstract data models similar?

All of these answers are correct.

Which of the following is a characteristic of a data model?

All of these answers are correct.

Which of these CANNOT be stored in VARCHAR or CHAR records?

All of these can be stored in either type of data.

What is the meaning of the following delimiter in PL/SQL? --

Single line comment

Which of the following best describes a backup?

A duplicate of the information formatted in a way that allows it to be easily restored

In Structured Query Language (SQL), how many bytes of information does SMALLINT store?

2

If you used the statement Float(5, 3) for the value 22.0009, what would SQL return?

22.001

In Structured Query Language (SQL), how many potential values can be held by TINYINT?

2^8

How many possible choices can be used in a BOOLEAN data type?

3

In most database management systems, a BLOB can hold up to _____

4 gigabytes

In Structured Query Language, how many bytes does each BIGINT entry permit?

8

Which of the following capabilities is typically provided by a database management tool?

All of the answers are correct.

Which of the following is a characteristic of SQL?

All of the answers are correct.

Which of the following is a characteristic of an SQL script?

All of the answers are correct.

Examine the following SQL statement. What type of information will be returned?

ALL data from the books table

Examine the following query. What should be added/removed from it?

Add a WHERE clause

Examine the following tables, tblProducts and tblOrders. What is needed so that an INNER JOIN can be completed?

Add productID to the tblOrders table

Dynamic SQL can be written on _____

Any database server

In using Structured Query Language, why might a user want to limit the size of integers?

Any of these answers is correct

Real, float, and double are considered _____ numbers

Approximate

Which of the following IS a required component of the PL/SQL block?

At least one statement within the Begin and End blocks

How can an SQL script decrease errors? Choose the best answer.

By eliminating the need for manually entered commands

Which of the following is NOT a SQL command category?

DMA

Which of the following SQL command categories is concerned with auditing operations?

Data Administration

Which of the following command categories contains commands for auditing?

Data Administration

Which of the following is NOT a difference between T-SQL and SQL?

Changes to the INSERT command.

An object diagram is most closely related to a(n) _____ diagram.

Class

Which of these would be a useful BOOLEAN question?

College graduate?

Which of the following SQL script advantages concerns 'first time and every time'?

Consistent operation

Which of the following is the correct syntax for a PL/SQL statement?

DECLARE <declarations section> BEGIN <executable command(s)> EXCEPTION <exception handling> END;

Which of the following correctly completes the INNER JOIN statement?

INNER JOIN tblProducts ON tblOrders.productID = tblProducts.productID;

In SQL Server, a subquery can also be called a(n) _____

INNER SELECT

Which of the following scenarios describes a reason why you would select a full outer join?

If you ran a grocery store with multiple locations, and you want to find out which locations are out of a specific inventory.

An object diagram shows a(n) _____ at a given point in time.

Instance

An INNER JOIN returns rows of tables where the data _____

Intersects

Which of the following is true about PL/SQL?

It is a query language for Oracle databases.

Consider the following object diagram. Based on the diagram, which of the following is true of the Maple class?

It is an instance of the Tree class

What is NOT an advantage of using BOOLEAN as a data type?

It is versatile.

How does the ORDER BY clause differ from the GROUP BY clause?

It orders the data in the group based on the specified column.

In MySQL, the _____ can hold 4 gigabytes.

LONGBLOB

Which data type stores 4 bytes, or 7 digits after the decimal?

Real

Which of the following is NOT a use for an object diagram?

Replace object-oriented design

If you want to view a maximum value from a table, in which part of the SQL statement should the subquery be placed?

SELECT

The following is only the first part of an INNER JOIN query. Which of the following is the correctly-written full query?

SELECT * FROM tblEmployee, tblHealthPlan INNER JOIN tblEmployee ON tblEmployee.planCode = tblHealthPlan.planCode;

A database stores a value for vacation accrual. A sample value is 1.2533458. Which SQL statement will show a value of 1.253?

SELECT CAST(vacation_accrual as Float(4,3));

Which of the following is the correct full outer join syntax?

SELECT table.column-names FROM table1 FULL OUTER JOIN table2 ON table1.column = table2.column;

The GROUP By clause is always paired with _____ and must precede _____, if it is used.

SELECT, ORDER BY

Which of the following statements does NOT allow for subqueries?

SET

One of the security vulnerabilities of dynamic SQL is _____

SQL Injection

Which of the following is NOT a characteristic of SQL?

SQL can be used to duplicate a record

What does the 's' stand for in a DECIMAL or NUMERIC value?

Scale

Which of the following SQL script uses is concerned with current information in multiple geographic locations?

Synchronization

Which of the following is FALSE about TIMESTAMP?

TIMESTAMP must be manually entered like TIME and DATE.

Which types of data would be a good candidate for a Binary Large Object (BLOB)?

Video, Audio, Images

Which of the following keywords/elements is NOT required in an SQL query?

WHERE

Under what circumstance would you select a full outer join SQL statement?

When you need all the rows from the tables you are joining.

What is the proper format for DATE?

YYYY-MM-DD