Physical Database Design

Steps of Logical Database Design...
View Complete Description

Topic Summary

Steps of Logical Database Design Methodology, Design file organizations and indexes
Topic Questions:
13 6 6 8
Question Type Legends




Multiple Choice Questions for Physical Database Design

  • 1 Number of options in the < select > element can be found by the property:
    1. No additional updates on adding indexed record
    2. No additional updates on updating indexed record
    3. Increases disk space
    4. No performance penalties

  • 2 Number of options in the < select > element can be found by the property:
    1. Primary indexing
    2. Clustering indexing
    3. Secondary indexing
    4. None

  • 3 During physical database design, the physical arrangement of data in a file into records and pages on secondary storage is called
    1. Data Organizaiton
    2. File Organization
    3. Database organization
    4. Information Management

  • 4 Attributes whose value can be found by examining the values of other attributes are known as _____?
    1. Derived Attributes
    2. Calculated Attributes
    3. Both a & b
    4. None

  • 5 What is the best data type definition when a field is alphanumeric and has a length that can vary?
    1. VARCHAR
    2. CHAR
    3. LONG
    4. NUMBER

  • 6 Which type of join includes, not only those matched rows from the left side table, but also those rows of the right table that are unmatched with rows from the first (left) table.
    1. Left outer Join
    2. Right Outer Join
    3. Inner Join
    4. Join

  • 7 Which of the following multiple row functions are not supported by SQL Server 2008?
    1. AVG
    2. SUM
    3. COUNT
    4. LAST

  • 8 To display the standard price after increased by 10% for every product, we will multiply the price by:
    1. 10
    2. 1.1
    3. 10.1
    4. 1.01

  • 9 A subquery may occur in:
    1. A SELECT clause
    2. A FROM clause
    3. A WHERE clause
    4. All of above

  • ×

    Hidden Questions!

    Some MCQs are not visible. Usually teachers hides the visibility if they are few in number. Subject Expert recommends them to have more than 70+ questions against the topic and make them public.

Contact Us
Write to Us View Help
Subject Expert Logo

Subject Expert

Learn and Evaluate

Follow Us
© 2020 - Subject Expert