Q.1

 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.2

 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.3

Cloud computing uses Server virtualization.

  • TRUE
  • FALSE
Q.4

 If a table has been normalized so that all determinants are candidate keys, then that table is in:

  • 1NF
  • 2NF
  • 3NF
  • BCNF
Q.5

 In the relational model, relationships between relations or tables are created by using:

  • composite keys.
  • determinants.
  • candidate keys.
  • foreign keys.
Q.6

An entity is a thing in the real world with an independent existence.

  • TRUE
  • FALSE
Q.7

 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.8

 To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.

  • ONLY
  • DISTINCT
  • UNIQUE
  • SINGLE
Q.9

 What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?

  • ALTER TABLE STUDENT ALTER CONSTRAINT GradeCheck (Grade > 0);
  • ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0);
  • ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);
  • None of the above is correct.
Q.10

 A supertype/subtype hierarchy has which of the following features?

  • Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype.
  • Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.
  • Attributes are assigned at the highest logical level.
  • Attributes are assigned at the lowest logical level.
Q.11

 When an entity instance may be a member of multiple subtypes or it does not have to be a member of a subtype, it is which of the following?

  • Disjoint with total specialization
  • Disjoint with partial specialization
  • Overlap with total specialization
  • Overlap with partial specialization
Q.12

 The HAVING clause does which of the following?

  • Acts like a WHERE clause but is used for groups rather than rows.
  • Acts like a WHERE clause but is used for rows rather than columns.
  • Acts like a WHERE clause but is used for columns rather than groups.
  • Acts EXACTLY like a WHERE clause.
Q.13

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.14

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.15

 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.16

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.17

 A benefit of the three-tier architecture is which of the following?

  • New modules can be built to support specific business needs
  • Performance improves for compiled SQL statements
  • Results in a thinner client and database server
  • All of the above.
Q.18

 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.19

 For what purposes are views used?

  • To hide rows only
  • To hide columns only
  • To hide complicated SQL statements only
  • All of the above are uses for SQL views.
Q.20

Which of the following is true about cloud computing?

  • Cloud computing has brought about a drop in hardware and software sales, while augmenting service revenues
  • You can access your data from any computer in the world, as long as you have an Internet connection.
  • Both A & B
  • It's always going to be less expensive and more secure than local computing.
0 h : 0 m : 1 s