PBD_Q_2

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

• Flat file software

• ERD software

• Spreadsheet software

• DBMS software

Which of the following is NOT a relationship type?

• Some to None

• One to One

• One to Many

• Many to Many

The advantages of an object-oriented data model are:

• Reduced Maintenance

• Real-World Modeling

• Reduced Maintenance and Real-World Modeling

• Neither statement is correct.

The customer and order tables are often used in joins, thereby resulting in complex queries. To simplify the writing of queries, you must create:

• Table

• View

• Synonym

• Sequence

Schema objects can be created and manipulated with SQL and include the following types of objects, except:

• Constraints

• Sequences

• Tables

• Views

• Roles

Functions of SQL are:

• Inserting, updating, and deleting rows in a table

• Querying data stored in the database

• Both of the options are functions of SQL

• Neither of the options are functions of SQL

Which of the following is the wildcard used for any number of characters in SQL?

• &

• %

• ||

• #

The ______ operator requires either of the component conditions to be true.

• AND

• OR

• EITHER

• BETWEEN

Character strings and dates in the WHERE clause must be enclosed with single quotation marks (' ').

• True

• False

A foreign key value must match an existing primary key value otherwise, it must be null.

• True

• False