1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Multiple choice questions in RDBMS

Discussion in 'Database' started by shabbir, Jul 20, 2004.

  1. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,287
    Likes Received:
    364
    Trophy Points:
    83
    Question Number 1

    STUDENT
    =======
    STUDENT ID
    STUDENT Name
    COURSE ID


    COURSES
    ============
    Course ID
    Course Name

    What type of relationship exists between the Student table and the Course table?

    Choice 1
    Product - Many
    Manufacturer - Many
    Choice 2
    Product - One or Many
    Manufacturer - One or Many
    Choice 3
    Product - Many
    Manufacturer - One
    Choice 4
    Product - One
    Manufacturer - One
    Choice 5
    Product - One
    Manufacturer - Many
    ------------------------------------------------------------
    Question Number 2
    If you do not want your developers to view the table structures but still allow update operations what type of structure will you deploy?

    Choice 1
    Cursor table
    Choice 2
    Table filter
    Choice 3
    Dynamic procedure
    Choice 4
    View
    Choice 5
    Summary table
    ------------------------------------------------------------
    Question Number 3

    What Does ACID stand for?

    Choice 1
    atomicity, constant, isolation, durability
    Choice 2
    atomicity, consistency, isolation, duration
    Choice 3
    atomicity, consistency, isolation, durability
    Choice 4
    atomicity, consistency, indexing, durability
    Choice 5
    atomicity, constant, indexing, durability
    ------------------------------------------------------------
    Question Number 4

    In a Left Outer Join what will be the output when there is NO match between the tables?

    Choice 1
    The left table will return ALL rows.
    Choice 2
    The left table will return NULL.
    Choice 3
    Both tables will return NULL.
    Choice 4
    The right table will return ALL rows.
    Choice 5
    The right table will return NULL.
    ------------------------------------------------------------
    Question Number 5

    What is tuple?

    Choice 1
    Database Structure
    Choice 2
    A record in table
    Choice 3
    Table Structure
    Choice 4
    Operation on Table
    Choice 5
    Table's Unique Key
    ------------------------------------------------------------
    Question Number 6

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

    Choice 1
    Data about data
    Choice 2
    Describes a data dictionary
    Choice 3
    Self-describing
    Choice 4
    Includes user data
    Choice 5
    Supports its own structure
    ------------------------------------------------------------
    Question Number 7

    What capabilities do you expect in an RDBMS?

    Choice 1
    Encryption key management
    Choice 2
    Graphical User Interface Widgets
    Choice 3
    Thread creation, execution, & coordination
    Choice 4
    Network socket creation/operation
    Choice 5
    If/Then, for, do/while statements
    ------------------------------------------------------------
    Question Number 8

    What one to one relationship indicate?

    Choice 1
    More entities are needed.
    Choice 2
    The model should be denormalized.
    Choice 3
    The tables are not properly indexed.
    Choice 4
    The model cannot be implemented physically.
    Choice 5
    More attributes are needed.
    ------------------------------------------------------------
    Question Number 9

    For de-normalization you have implemented redundant columns. Which RDBMS feature you should implement to prevent repeated columns from getting out of sync?

    Choice 1
    Cursors
    Choice 2
    Constraints
    Choice 3
    Views
    Choice 4
    Stored procedures
    Choice 5
    Trigger
    ------------------------------------------------------------
    Question Number 10

    What clause or command you should use in the query to avoid a costly tablescan?

    Choice 1
    GROUP BY clause
    Choice 2
    INDEX command
    Choice 3
    HAVING clause
    Choice 4
    FROM clause
    Choice 5
    WHERE clause
     
    Last edited: Jul 20, 2004
  2. sundeep

    sundeep New Member

    Joined:
    May 18, 2006
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
  3. coderzone

    coderzone Super Moderator

    Joined:
    Jul 25, 2004
    Messages:
    734
    Likes Received:
    37
    Trophy Points:
    0
    Try it yourself.
     
  4. santhosh krishna

    santhosh krishna New Member

    Joined:
    Jul 28, 2009
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    Friend ,validate the answers..if any mistakes, let me know...Answers are given in Red color:

    Question Number 1

    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?

    Choice 1
    Product - Many
    Manufacturer - Many
    Choice 2
    Product - One or Many
    Manufacturer - One or Many
    Choice 3
    Product - Many
    Manufacturer - One
    Choice 4
    Product - One
    Manufacturer - One
    Choice 5
    Product - One
    Manufacturer - Many
    ------------------------------------------------------------
    Question Number 2
    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?

    Choice 1
    Cursor table
    Choice 2
    Table filter
    Choice 3
    Dynamic procedure
    Choice 4
    View
    Choice 5
    Summary table
    ------------------------------------------------------------
    Question Number 3

    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?"

    Choice 1
    OS requirement
    Choice 2
    User analysis
    Choice 3
    Performance monitoring
    Choice 4
    Data dictionary specification
    Choice 5
    System requirement
    ------------------------------------------------------------
    Question Number 4

    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?

    Choice 1
    The right table will return ALL rows.
    Choice 2
    The right table will return NULL.
    Choice 3
    Both tables will return NULL.
    Choice 4
    The left table will return ALL rows.
    Choice 5
    The left table will return NULL.
    ------------------------------------------------------------
    Question Number 5

    Which phase of the data modeling process contains security review?

    Choice 1
    Structure
    Choice 2
    Design issue
    Choice 3
    Data source
    Choice 4
    Storage issue
    Choice 5
    Operational process
    ------------------------------------------------------------
    Question Number 6

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

    Choice 1
    Data about data
    Choice 2
    Describes a data dictionary
    Choice 3
    Self-describing
    Choice 4
    Includes user data
    Choice 5
    Supports its own structure
    ------------------------------------------------------------
    Question Number 7

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

    Choice 1
    Encryption key management
    Choice 2
    Graphical User Interface Widgets
    Choice 3
    Thread creation, execution, & coordination
    Choice 4
    Network socket creation/operation
    Choice 5
    If/Then, for, do/while statements
    ------------------------------------------------------------
    Question Number 8

    What can a mandatory one to one relationship indicate?

    Choice 1
    More entities are needed.
    Choice 2
    The model should be denormalized.
    Choice 3
    The tables are not properly indexed.
    Choice 4
    The model cannot be implemented physically.
    Choice 5
    More attributes are needed.
    ------------------------------------------------------------
    Question Number 9

    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?

    Choice 1
    Cursors
    Choice 2
    Constraints
    Choice 3
    Views
    Choice 4
    Stored procedures
    Choice 5
    Trigger
     

Share This Page