Q.1
Which of the following is not a database object in MS Access?
  • Reports
  • Relationships
  • Tables
  • Queries
Q.2
A DBMS that combines a DBMS and an application generator is ________ .
  • Microsoft's SQL Server
  • Microsoft's Access
  • IBM's DB2
  • Oracle Corporation's Oracle
Q.3
________ is an open source DBMS product that runs on UNIX, Linux and Windows.
  • MySQL
  • JSP/SQL
  • JDBC/SQL
  • Sun ACCESS
Q.4
If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?
  • First normal form
  • Second normal form
  • Third normal form
  • Fourth normal form
Q.5
Which of the following is not true about cloud computing?
  • Cloud-based management platforms cannot support internally hosted server platforms
  • Cloud-based management platforms can support multiple cloud-virtual server vendors
  • Cloud-based management platforms can support multiple cloud-virtual server operating systems
  • Cloud-based management platforms can support change management methodologies
Q.6
A composite attribute is which of the following?
  • An attribute that can be broken into components
  • An attribute that cannot be broken into components
  • Multiple attributes
  • An identifier
Q.7
What are the notations used in Evaluation of Arithmetic Expressions using prefix and postfix forms?
  • Polish
  • Reverse Polish
  • Both A and B
  • None of the above
Q.8
When mapping a supertype/subtype relationship which of the following is true?
  • The supertype primary key is assigned to each subtype.
  • The subtype primary key is assigned to each supertype.
  • There is no link between the supertype/subtype entities.
  • There is no primary key/foreign key relationship between a supertype/subtype.
Q.9
With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.
  • READ_ONLY
  • SCROLL_LOCK
  • OPTIMISTIC
  • PESSIMISTIC
Q.10
The different classes of relations created by the technique for preventing modification anomalies are called:
  • normal forms.
  • functional dependencies.
  • referential integrity constraints.
  • None of the above is correct.
Q.11
The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ;
  • Equi-join
  • Natural join
  • Outer join
  • Cartesian join
Q.12
It is necessary to sort a file before searching a particular item
  • True
  • False
  • May or may not be true
  • None of the above
Q.13
When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
  • LIKE only.
  • IN only.
  • NOT IN only.
  • Both IN and NOT IN.
Q.14
Which of the following products implemented the CODASYL DBTG model?
  • IDMS
  • DB2
  • dBase-II
  • R:base
Q.15
When assessing the table structure of an acquired set of tables with data, accessing the validity of possible referential integrity constraints on foreign keys is (part of) the:
  • first step.
  • second step.
  • third step.
  • fourth step.
Q.16
Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity?
  • Supertype entity
  • Subtype entity
  • Archetype entity
  • Instance entity
Q.17
A data dictionary is a special file that contains
  • The width of all fields in all files
  • The data type of all fields in all file
  • The name of all fields in all files
  • All of the above
Q.18
A reason for using an SQL view to hide columns is:
  • to simplify a result only.
  • to prevent the display of sensitive data only.
  • to accomplish both of the above.
  • None of the above are reasons for using an SQL view.
Q.19
Which of the following indicates the maximum number of entities that can be involved in a relationship?
  • Minimum cardinality
  • Maximum cardinality
  • ERD
  • Greater Entity Count (GE
Q.20
A transitive dependency is which of the following?
  • A functional dependency between two or more key attributes.
  • A functional dependency between two or more nonkey attributes.
  • A relation that is in first normal form.
  • A relation that is in second normal form.
0 h : 0 m : 1 s