Chapter 5 & 6

Which of the following best describes the purpose of an object diagram? A point in time view of interactions between objects Show abstract class interactions and relationships Detail states of given systems at a point in time Detail unlimited relationships and values

A point in time view of interactions between objects

A dynamic SQL query would be beneficial in which scenario? A query in which parameters or values may change A query used only by one person A query with 10000 lines A query with the same values run each time

A query in which parameters or values may change

How are data models and abstract data models similar? They simplify an idea or concept. They represent some data and the relationship between that data. They have subjects. All of these answers are correct.

All of these answers are correct.

Which of the following is a characteristic of a data model? All of these answers are correct. A specific subject, and attributes, for some data. A particular representation of some data. Groups everything together based on a relationship.

All of these answers are correct.

Dynamic SQL can be written on _____. SQL Server only MS Access or SQL Server Only Any database server MySQL and SQL Server Only

Any database server

A class diagram shows the _____ between classes. Iterations Live objects Aggravations Associations

Associations

Which of the following IS a required component of the PL/SQL block? At least one Declaration block At least one Comments block At least one statement within the Begin and End blocks At least one Exception block

At least one statement within the Begin and End blocks

A database schema is the _____ that defines the database structure. Circle Mural Circuit board Blueprint

Blueprint

Which of the following is NOT a difference between T-SQL and SQL? Procedural language features. Changes to the DELETE command. Changes to the INSERT command. Local variables.

Changes to the INSERT command.

An object diagram is most closely related to a(n) _____ diagram. Statechart E/R Class Flat-file

Class

A database is a place to store _____. Information Spare parts Family heirlooms Paper

Information

An object diagram shows a(n) _____ at a given point in time. Instance Statechart Class Prototype

Instance

Which of the following is true of a class diagram? It has many shortcomings It is a requirement for all object-oriented design It can be used as a blueprint to build a system It is only a model

It can be used as a blueprint to build a system

Which of the following is true about PL/SQL? It is a query language for all databases. It is a programming language for PL databases. It is a programming language for SQL databases. It is a query language for Oracle databases.

It is a query language for Oracle databases.

Why is it important to design a database schema before adding data into a database? It is difficult to modify the database structure once data is entered into it. Schemas are translated directly into the physical database structure. Database schemas are difficult to change before data is entered. Databases allow only one change after the schema is designed.

It is difficult to modify the database structure once data is entered into it.

You are designing a database schema and you are unsure how some of the tables will relate. What should you do? Keep one table into which you can store all the extra data Leave as-is and begin adding data to the database Join tables together no matter the field types or data List out sample data to determine the final layout

List out sample data to determine the final layout

The _____ schema defines the database structure in terms of data, fields, and tables. Physical Relational Logical ODBC

Logical

What is a negative effect of having a very large dynamic SQL query? Easy to debug Size is restricted to 1000 lines User-friendliness Performance impacts

Performance impacts

The _____ schema defines the layout of the database hardware and servers. ODBC Logical Physical Relational

Physical

Which of the following deals with grouping steps together in a unit? Local Variables String Processing Date Processing Procedural Language Features

Procedural Language Features

Which of the following is NOT a use for an object diagram? Replace object-oriented design Provide understanding for the non-technical Develop a prototype of the system Model complex data

Replace object-oriented design

One of the security vulnerabilities of dynamic SQL is _____. DNS attack IP Spoofing Wormholes SQL Injection

SQL Injection

Which of the following is NOT a characteristic of SQL? SQL can be used to change an existing record SQL can be used to add a new record SQL can be used to delete a record SQL can be used to duplicate a record

SQL can be used to duplicate a record

What is the meaning of the following delimiter in PL/SQL? - - Single line comment End of statement Multi-line comment Item separator

Single line comment

What is an abstract data model? A data model with no subject. Something more complex than a data model. Something more simplified than a data model. Something completely different than a data model.

Something more simplified than a data model.

A database table can be _____ by different fields depending on what you are looking for. Linked Sorted Timestamped Tagged

Sorted

The basic database element is the _____. Field Key Row Table

Table

How do data models and abstract data models differ? One simplifies an idea or concept, while the other doesn't. The amount of provided detail and scope varies. Abstract data models have subjects, while data models don't. Data models represent some data and the relationship between that data, while abstract data models don't.

The amount of provided detail and scope varies.

In terms of data models, what is abstraction? The process of making an idea more difficult to understand. None of these answers are correct. The process of simplification. The process of replacing concepts with details.

The process of simplification.

What is the meaning of the NULL; statement in PL/SQL? The declaration has no variables. The exception is not listed. There are no commands to be executed. The query result does not have any results.

There are no commands to be executed.

What does T-SQL stand for? Transact-SQL Transaction Structured Query Language None of the answers are correct. Transaction-SQL

Transact-SQL

Which of the following SQL commands changes information already in a database? CREATE INSERT UPDATE SELECT Next

UPDATE

Under schema theory, knowledge is organized into _____. Units Rows Tables Databases

Units