• ( 1 ) We indicate roles in E-R diagrams by labeling the lines that connect ___________ to __________.

    • 1) Diamond , diamond
    • 2) Rectangle, diamond
    • 3) Rectangle, rectangle
    • 4) Diamond, rectangle
    • Discussion in forum
      Answer : 4) Diamond, rectangle
      Solution : Diamond represents a relationship set and rectangle represents a entity set.








      discussion


      Answer : 4) Diamond, rectangle

    • ( 2 ) The RAID level which mirroring is done along with stripping is

    • 1) RAID 1+0
    • 2) RAID 0
    • 3) RAID 2
    • 4) Both a and b
    • Discussion in forum
      Answer : 4) Both a and b
      Solution : Mirroring without striping can also be used with arrays of disks, to give the appearance of a single large, reliable disk








      discussion


      Answer : 4) Both a and b

    • ( 3 ) By default sql server has ___________ isolation level

    • 1) READ COMMITTED
    • 2) READ UNCOMMITTED
    • 3) SERIALIZABLE
    • 4) REPEATABLE READ
    • Discussion in forum
      Answer : 1) READ COMMITTED
      Solution : Read committed is used to commit the default read operation.








      discussion


      Answer : 1) READ COMMITTED

    • ( 4 ) ........ data type can store unstructured data

    • 1) RAW
    • 2) CHAR
    • 3) NUMERIC
    • 4) VARCHAR
    • Discussion in forum
      Answer : 1) RAW
      Solution : Raw data type can store unstructured data. Which is collection of data in any form.








      discussion


      Answer : 1) RAW

    • ( 5 ) A data type that creates unique numbers for key columns in Microsoft Access is:

    • 1) ) Sequential number
    • 2) Sequential key
    • 3) Boolean
    • 4) Autonumber
    • Discussion in forum
      Answer : 4) Autonumber
      Solution : This can be taken as a primary key .








      discussion


      Answer : 4) Autonumber

    • ( 6 ) The view of total database content is

    • 1) Conceptual view
    • 2) Internal view
    • 3) External view
    • 4) Physical view
    • Discussion in forum
      Answer : 1) Conceptual view
      Solution : The view of total database content is conceptual view. (Conceptual view represents the global view of the data)








      discussion


      Answer : 1) Conceptual view

    • ( 7 ) Execution of a transaction in isolation preserve ____________ of the database

    • 1) consistency
    • 2) isolation
    • 3) durability
    • 4) atomicity
    • Discussion in forum
      Answer : 1) consistency
      Solution : Execution of a transaction in isolation preserve consistency of the database








      discussion


      Answer : 1) consistency

    • ( 8 ) A relational algebra operation annotated with instructions on how to evaluate it is called ____________.

    • 1) evaluation primitive
    • 2) query execution plan
    • 3) query evaluation plan
    • 4) query processing
    • Discussion in forum
      Answer : 1) evaluation primitive
      Solution : A relational algebra operation annotated with instructions on how to evaluate it is called evaluation primitive.








      discussion


      Answer : 1) evaluation primitive

    • ( 9 ) What is a relationship called when it is maintained between two entities?

    • 1) Unary
    • 2) Binary
    • 3) Ternary
    • 4) Quaternary
    • Discussion in forum
      Answer : 2) Binary
      Solution : Binary word usually represents two attributes.








      discussion


      Answer : 2) Binary

    • ( 10 ) Which is a join condition contains an equality operator:

    • 1) Equijoins
    • 2) Cartesian
    • 3) Natural
    • 4) Left
    • Discussion in forum
      Answer : 1) Equijoins
      Solution : An equijoin is a join with a join condition containing an equality operator. An equijoin combines rows that have equivalent values for the specified columns.








      discussion


      Answer : 1) Equijoins





Top