Oracle Database Foundations

False

Each column in a relation is called an entity. True or False?

True

If a table already contains rows when a column is added, the new column is initially null or takes the default value for all the rows. True or False?

A well designed conceptual model

If information requirements are clearly communicated during conceptual modeling the following will result:

True

In APEX SQL Workshop and Object Browser options, you can view table layouts.

True

In Oracle SQL Data Modeler, the attribute that you assign as primary UID is automatically set to a mandatory attribute and will be engineered to a primary key in the relational model.

names

In a relationship, ________ are used to help describe the meaning of the connection between the entities.

False

Primary key constraints should have a suffix of PKEY.

Spaces.

Table names can contain all of the following except:

Right click Logical model, select Create Glossary from Logical Model

The steps to create a glossary from an existing Logical model are:

Microsoft Access

The technical software requirements for this course include all of the following except:

Primary keys, Foreign keys

The transformation from an ER diagram to a physical design involves changing terminology. Primary Unique Identifiers in the ER diagram become ________ and relationships become ________.

table

A ________ is a collection of records.

There are no duplicate rows and There is only one data value.

A table is in a 1NF if...

Replacing spaces with underscores

Attribute names are converted to column names by ________.

glossary

A ________ in Oracle Developer Data Modeler is a set of accepted terms that can be used in the design.

NONEQUIJOIN

A ________ is a join condition containing something other than an equality operator.

Relational

A ___________ model describes a database in terms of tables, columns, and joins between tables.

Hiring a programmer to create additional programming code to verify no goods are shipped until the account has been settled in full.

A business rule such as "We only ship goods after customers have completely paid any outstanding balances on their account" is best enforced by:

All of the above.

A database interacts with the data and provides the following facilities:

True

A database is a centralized and structured set of data stored on a computer system and provides facilities for retrieving, adding, modifying, and deleting the data when required.

True

A flat file may contain many fields, often, with duplicate data that are prone to data corruption.

a calculation

A literal can be all of the following except:

True

A logical condition combines the result of two component conditions to produce a single result based on those conditions or it inverts of a single condition.

can not

A non-transferable relationship means the detail ________ be changed to a point to a new master.

Cannot be determined without more information.

A recursive relationship has cardinality of ________.

False

A unique identifier must be made up of more than one attribute. True or False?

False

All Business Rules can be modeled.

must

All instances of the subtype ________ be an instance of one of the subtypes.

All of the above options are stages of SQL processing.

All of the following are stages of SQL Processing exept:

null

Arithmetic expressions containing a null value evaluate to ________.

False

As a database designer, you do not need to worry about where in the datamodel you store a particular attribute; as long as you get it onto the ERD, your job is done. True or False?

Composite Attribute

Attributes that can be divided into smaller subparts are called ________.

True

Business rules help you understand the standardization procedure an organization follows when handling huge data.

Data Definition Language

DDL means:

True

Documenting Business Requirements helps developers control the scope of the system and prevents users from claiming that the new system does not meet their business requirements. True or False?

Soft Boxes

Entity Boxes are drawn on an ERD using what type of shape?

True

If a relationship is mandatory, there must be at least one instance of the corresponding entity related to it.

True

In Oracle SQL Developer Data Modeler, you can select how you want to map your subtypes.

links

In a hierarchical database model the data is stored as records that are connected to one another through ________.

With a crow's foot and With a single toe

In an ERD diagram, how is cardinality represented?

solid or dashed lines

In an ERD, optionality is depicted using ________.

schema

In the APEX application, a ________ is a collection of logical structures of data. A ________ is owned by a database owner and has the same name as that user.

True

It is not mandatory to specify the column list in the INSERT statement. True or False?

Equi-join and INNER

Joining tables with the NATURAL JOIN, USING, or ON clauses results in an ________ join.

True

Modeling historical data can produce a unique identifier that includes dates. True or False?

False

SQL *Plus is being used in the Oracle Academy courses to run SQL code. True or False?

All these businesses could benefit from using a database.

Select the business or industry that would not have a need for a database.

Store application data

The Oracle SQL Data Modeler enables you to do all of the following except:

True

The TRUNCATE statement is a data definition language (DDL) statement and generates no rollback information.

WHERE

The ________ clause in a query comes immediately after the SELECT and FROM.

IS NULL

The ________ condition tests for nulls.

NATURAL JOIN

The ________ join clause is based on all the columns in the two tables that have the same name and the same datatype.

Both A and B.

The advantages of an object-oriented data model are:

TRUNCATE

The command that always removes all rows from a table, leaving the table empty and the table structure intact is...

Documents type of operating system to be used

The conceptual model does all of the following except:

*

The following statement displays all the rows in the departments table: SELECT ________ FROM departments;

True

The glossary can be used as the naming standard for your Logical Model.

True

The logical model determines relationship optionality and cardinality

Primary UID

The primary key uniquely identifies each row in a table and is based on the ________ from the logical design.

Availability of data to a diverse set of users, Integration of data for easier access and modification for complex transactions, and Reduced redundancy of data

The reason or drive for using databases rather than files has been ... (Choose 3)

DML

The type of SQL Command used to modify data is:

True

To connect to an Oracle database, you need to use a client program. True or False?

Do all of these steps.

To define naming templates in Oracle SQL Data Modeler:

CREATE TABLE

To issue a CREATE TABLE statement, you must have the ________ privilege.

True

Top-Down Modeling is the approach taken for designing a new database.

True

Top-n-analysis is used when you want to retrieve only the top number of records from a result set.

False

Transferable relationships can only be mandatory, not optional. True or False?

False

Users may view data that is in the process of being changed by another user.

True

We can apply naming abbreviations using the .csv file containing the abbreviations

Bottom-Up Modeling

When creating a database based on extracting metadata from an existing database or using the DDL code obtained from an implementation of an existing database, which data modeling approach would you choose?

True

When mapping a relationship for an ERD diagram, both sides of the relationship have to be mapped.

False

When you define a table, you can specify that a column should be given a default value by using the LITERAL option.

All of the above

Which of the following are reasons we create conceptual models?

All can be modeled.

Which of the following cannot be modeled using the Oracle SQL Data Modeler?

It does not impact the performance of the database.

Which of the following is not true regarding normalization:

Subtypes must be mutually exclusive.

Which of the following is true about subtypes?

SELECT worker.last_name emp, manager.last_name mgr FROM ON

Which of the following statements is an example of a SELF JOIN?

Cities may change their names and/or country association if the borders of a country change.

Which of the following would be a logical constraint when modeling time for a City entity?

DBMS software

Which software is used to manage reading and manipulating a relational database?

SELECT last_name, salary, 15*salary+200 FROM employees;

Which statement displays the last name, salary, and annual compensation of employees where the annual compensation is calculated by multiplying the monthly salary with 15, plus a one-time bonus of $200.

*

Which symbol is used to show that a particular attribute is mandatory?

Cloud Computing

Which transformation in computing allows for storage and delivery of applications and data over the internet?

All of the above.

Why is it important to follow the rules of normalization?

True

You can create a marker in the current transaction by using the SAVEPOINT statement.

All of the above can be used to define naming standards in Oracle SQL Data Modeler.

You can define naming standards in Oracle SQL Developer Data Modeler using ________.

SELECT

You can display selected columns of a table by listing them in the ________ clause.

SQL Scripts

You can upload and save a SQL Script from the ________ option.

substitution variables

You can use _____________ to temporarily store values, while executing a query.

Forward

________ Engineering is the process of transforming a Logical Data Model to a Relationship Model.

Select the Relationship model, Click the Engineer to Logical Model icon, Accept defaults, Click Engineer

the steps to convert a Relationship model to a Logical model using the Oracle SQL Developer Data Modeler are: