Q.1

 The process of reading a database schema and producing a data model from that schema is known as:

  • data modeling.
  • database design.
  • reverse engineering.
  • None of the above is correct.
Q.2

 The first step in database development is which of the following?

  • Enterprise data modeling
  • Logical database design
  • Physical database design and definition
  • Database Implementation
Q.3

Which of the following are goals of OLE DB?

  • Create object interfaces for DBMS functionality pieces only.
  • Increase flexibility only.
  • Object interface over any type of data only.
  • All of the above as goals of OLE DB.
Q.4

 A distributed database can use which of the following strategies?

  • Totally centralized one location and accessed by many sites
  • Partially or totally replicated across sites
  • Partitioned into segments at different sites
  • All of the above
Q.5

 Which JDBC driver Type(s) is(are) the JDBC-ODBC bridge?

  • Type 1
  • Type 2
  • Type 3
  • Type 4
Q.6

 The object definition language (ODL) is which of the following?

  • Used to develop logical schemas
  • A data definition language for OODB
  • A method to implement a logical schema
  • All of the above.
Q.7

 Stored procedures have which of the following advantages?

  • It takes a longer time to write them as compared to writing Visual Basic.
  • Data integrity improves as multiple applications access the same stored procedure.
  • Network traffic increases
  • Result in thicker client and thinner database server.
Q.8

An Oracle System Change Number (SCN):

  • is a value that is incremented whenever a dirty read occurs.
  • is incremented whenever a deadlock occurs.
  • is a value that keeps track of explicit locks.
  • is a value that is incremented whenever database changes are made.
Q.9

 A distributed database is which of the following?

  • A single logical database that is spread to multiple locations and is interconnected by a network
  • A loose collection of file that is spread to multiple locations and is interconnected by a network
  • A single logical database that is limited to one location.
  • A loose collection of file that is limited to one location.
Q.10

 ________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.

  • ASP
  • XML
  • ODBC
  • ADO
Q.11

Using OQL, you may do which of the following?

  • Return an entire collection of elements including duplicates.
  • Return a collection of elements without duplicates.
  • Return a specific subset of elements using a given criteria.
  • All of the above.
Q.12

Which of the following products implemented the CODASYL DBTG model?

  • IDMS
  • DB2
  • dBase-II
  • R:base
Q.13

Which of the following describes a relational database?

  • It retrieves data related to its queries
  • It provides a relationship between floats
  • It provides a relationship between integers
  • It consists of separate tables or related data
Q.14

The "curse of dimensionality" relates to which problem of using operational data for BI reporting?

  • Dirty data
  • Inconsistent data
  • Too much data
  • Non-integrated data
Q.15

 To drop a column that is used as a foreign key, first:

  • drop the primary key.
  • drop the table containing the foreign key..
  • drop the foreign key constraint.
  • All of the above must be done.
Q.16

 In a 1:N relationship, the foreign key is placed in:

  • the parent table.
  • the child table.
  • either table without specifying parent and child tables.
  • either the parent table or the child table.
Q.17

For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?

  • Two
  • Three
  • Four
  • Six
Q.18

A collection of interrelated records is called a

  • Datasheet
  • Spreadsheet
  • Database
  • Utility File
Q.19

A shared database should:

  • be accurate and available.
  • provide for backup and recovery.
  • be secure.
  • All of the above.
Q.20

SQL Server program code that is executed instead of an SQL command that needs to be processed is called

  • INSTEAD OF trigger.
  • BEFORE trigger.
  • AFTER trigger.
  • BEGIN trigger.
0 h : 0 m : 1 s