Q.1
A ternary relationship involves how many entities?
  • 3 or less
  • 3
  • More than 3
  • 3 or more
Q.2
The benefits of object-oriented modeling are which of the following?
  • The ability to tackle more challenging problems
  • Reusability of analysis, design, and programming results
  • Improved communication between users, analysts, etc.
  • All of the above.
Q.3
The ODBC core API consists of which of the following functions?
  • Commit or rollback transactions only
  • Connect to data sources only
  • Connect to data sources with driver-specific information only
  • Both 1 and 2 above are in the OBDC core API.
Q.4
The ODBC core API consists of which of the following functions?
  • Commit or rollback transactions only
  • Connect to data sources only
  • Connect to data sources with driver-specific information only
  • Both 1 and 2 above are in the OBDC core API.
Q.5
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.6
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.7
For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?
  • Two
  • Three
  • Four
  • Six
Q.8
A shared database should:
  • be accurate and available.
  • provide for backup and recovery.
  • be secure.
  • All of the above.
Q.9
A shared database should:
  • be accurate and available.
  • provide for backup and recovery.
  • be secure.
  • All of the above.
Q.10
A collection of interrelated records is called a
  • Datasheet
  • Spreadsheet
  • Database
  • Utility File
Q.11
A collection of interrelated records is called a
  • Datasheet
  • Spreadsheet
  • Database
  • Utility File
Q.12
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.13
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.
Q.14
The capacity to change the conceptual schema without having to change external schemas or application programs is called
  • Physical Data Independence
  • Logical Data Independence
  • Both A and B
  • None
Q.15
Legacy data is which of the following?
  • Data contained in a newly-installed system
  • Data rejected during the installation of a new system
  • Data contained in a file system
  • Data contained by a system used prior to the installation of a new system
Q.16
In the relational model, relationships between relations or tables are created by using:
  • composite keys.
  • determinants.
  • candidate keys.
  • foreign keys.
Q.17
If a table has been normalized so that all determinants are candidate keys, then that table is in:
  • 1NF
  • 2NF
  • 3NF
  • BCNF
Q.18
To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
  • ONLY
  • DISTINCT
  • UNIQUE
  • SINGLE
Q.19
A proxy server is used for which of the following?
  • To provide security against unauthorized users
  • To process client requests for Web pages
  • To process client requests for database access
  • To provide TCP/IP
Q.20
A proxy server is used for which of the following?
  • To provide security against unauthorized users
  • To process client requests for Web pages
  • To process client requests for database access
  • To provide TCP/IP
0 h : 0 m : 1 s