Warning: Undefined array key 1 in /home/acaproso/public_html/._System/._Template/.Main.php on line 116
Database design and implementation questions.

Database design and implementation questions.

Find Database design and implementation university examination questions in acaproso.com

# Question
1

The concept of a DBMS environment include all of the following except

  • People
  • Hardware
  • Data
  • Attribute
  • Procedure

Multiple choices
2

What is the relationship called when it is maintained  between three entity types

  • Unary
  • Binary
  • Ternary
  • Quaternary

Multiple choices
3

In a relation ,

  • No  two rows are identical
  • The ordering of rows is insignificant
  • (A) and (B) are true
  • None of these

 


Multiple choices
4

An entity set that does no have sufficient attributes to form a primary key is a

  • Strong entity set
  • Weak entity set
  • Simple entity set
  • Primary entity set

Multiple choices
5

In the relational modes cardinality is termed as

  • Number of tuples
  • Number of attributes
  • Number of tables
  • Number of constraints

Multiple choices
6

In the architecture of a database system conceptual level is the

  • Physical level
  • Logical level
  • External level
  • View level

Multiple choices
7

In case of entity integrity , the primary key may be

  • Not null
  • Null
  • Both Null and not Null

Multiple choices
8

An advantage of the database management approach is

  • Data is dependent on programs
  • Data redundancy increases
  • Data is integrated and can be accessed by multiple programs
  • None of the above.

Multiple choices
9

E-R model uses this symbol to represent weak entity set?

  • Dotted rectangle
  • Diamond
  • Doubly outlined rectangle
  • None of these

Multiple choices
10

Briefly describe the following types of keys as used in DATABASES

  1. Super Key
  2. Partial Key
  3. Primary Key
  4. Candidate Key
  5. Alternate Key
  6. Surrogate Key
  7. Foreign Key

Multiple choices