Sawaal
  • Home/
  • Searching for US

 Searching for "US"

Q:

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

A) drop the primary key. B) drop the table containing the foreign key..
C) drop the foreign key constraint. D) All of the above must be done.
 
Answer & Explanation Answer: C) drop the foreign key constraint.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

A) LIKE only. B) IN only.
C) NOT IN only. D) Both IN and NOT IN.
 
Answer & Explanation Answer: D) Both IN and NOT IN.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

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

A) ONLY B) DISTINCT
C) UNIQUE D) SINGLE
 
Answer & Explanation Answer: B) DISTINCT

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 The HAVING clause does which of the following?

A) Acts like a WHERE clause but is used for groups rather than rows. B) Acts like a WHERE clause but is used for rows rather than columns.
C) Acts like a WHERE clause but is used for columns rather than groups. D) Acts EXACTLY like a WHERE clause.
 
Answer & Explanation Answer: A) Acts like a WHERE clause but is used for groups rather than rows.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

Using OQL, you may do which of the following?

A) Return an entire collection of elements including duplicates. B) Return a collection of elements without duplicates.
C) Return a specific subset of elements using a given criteria. D) All of the above.
 
Answer & Explanation Answer: D) All of the above.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 A distributed database can use which of the following strategies?

A) Totally centralized one location and accessed by many sites B) Partially or totally replicated across sites
C) Partitioned into segments at different sites D) All of the above
 
Answer & Explanation Answer: D) All of the above

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 A report generated by a reporting system is delivered to the appropriate users via a user-accessed Web site. This system uses which of the following report modes?

A) Push B) Pull
C) RFM D) OLAP
 
Answer & Explanation Answer: B) Pull

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

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

A) Dirty data B) Inconsistent data
C) Too much data D) Non-integrated data
 
Answer & Explanation Answer: C) Too much data

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database