Tag: databases

Questions Related to databases

PRODUCT ======= Product ID Product Description Manufacturer ID MANUFACTURER ============ Manufacturer ID Manufacturer Name Referring to the above table, what type of relationship exists between the Product table and the Manufacturer table?
technology databases

  1. Product - Many,Manufacturer - Many

  2. Product - One or Many,Manufacturer - One or Many

  3. Product - Many,Manufacturer - One

  4. Product - One,Manufacturer - One

  5. Product - One,Manufacturer - Many

Show answer
Correct Option: B

You are writing a database application to run on your DBMS. You do not want your users to be able to view the underlying table structures. At the same time you want to allow certain update operations. Referring to the above scenario, what structure will you deploy?
technology databases

  1. Cursor table

  2. Table filter

  3. Dynamic procedure

  4. View

  5. Summary table

Show answer
Correct Option: D

You are defining the operational process of your RDBMS. Referring to the scenario above, which one of the following is a valid ongoing "operational process?"
technology databases

  1. OS requirement

  2. User analysis

  3. Performance monitoring

  4. Data dictionary specification

  5. System requirement

Show answer
Correct Option: C

You have been asked to construct a query in the company's RDBMS. You have deployed a Right Outer Join operation. Referring to the scenario above, what will happen to the final results when there is NO match between the tables?
technology databases

  1. The right table will return ALL rows.

  2. The right table will return NULL.

  3. Both tables will return NULL.

  4. The left table will return ALL rows.

  5. The left table will return NULL.

Show answer
Correct Option: D

Which phase of the data modeling process contains security review?
technology databases

  1. Structure

  2. Design issue

  3. Data source

  4. Storage issue

  5. Operational process

Show answer
Correct Option: B

Which one of the following is NOT a characteristic of metadata?
technology databases

  1. Data about data

  2. Describes a data dictionary

  3. Self-describing

  4. Includes user data

  5. Supports its own structure

Show answer
Correct Option: D

Which one of the following capabilities do you expect to see in a majority of RDBMS extensions to ANSI SQL-92?
technology databases

  1. Encryption key management

  2. Graphical User Interface Widgets

  3. Thread creation, execution, & coordination

  4. Network socket creation/operation

  5. If/Then, for, do/while statements

Show answer
Correct Option: E

What can a mandatory one to one relationship indicate?
technology databases

  1. More entities are needed.

  2. The model should be denormalized.

  3. The tables are not properly indexed.

  4. The model cannot be implemented physically.

  5. More attributes are needed.

Show answer
Correct Option: E

For performance, you denormalize your database design and create some redundant columns. Referring to the scenario above, what RDBMS construct can you use to automatically prevent the repeated columns from getting out of sync?
technology databases

  1. Cursors

  2. Constraints

  3. Views

  4. Stored procedures

  5. Trigger

Show answer
Correct Option: E

You are running a query against a relational database. Referring to the scenario above, what clause or command do you use in the query to help avoid a costly tablescan?
technology databases

  1. GROUP BY clause

  2. INDEX command

  3. HAVING clause

  4. FROM clause

  5. WHERE clause [/quote]

Show answer
Correct Option: B