Sawaal

 Database Questions

Popular Latest Rated
Q:

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

A) Used to develop logical schemas B) A data definition language for OODB
C) A method to implement a logical schema D) All of the above.
 
Answer & Explanation Answer: D) All of the above.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 3462
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

0 3414
Q:

 The ODBC Level 1 API contains which of the following functions?

A) Browse possible connections and data sources only B) Connect to data sources with driver-specific information only
C) Process a scrollable cursor only D) Both 1 and 3 above are in the OBDC Level 1 API.
 
Answer & Explanation Answer: B) Connect to data sources with driver-specific information only

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

1 3336
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

0 3321
Q:

To eliminate definition duplication, XML Schemas define:

A) an intersection table. B) global elements.
C) a normalized definition table. D) None of the above is correct.
 
Answer & Explanation Answer: B) global elements.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

2 3304
Q:

A subset of the database which contain virtual data that is derived from the database files but is not explicitly stored is called

A) Touple B) View
C) Relation D) Key
 
Answer & Explanation Answer: B) View

Explanation:

A view may be a subset of the database or it may contain virtual data that is derived from the database files but is not explicitly stored .

 

 

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

0 3246
Q:

Of the three ways to create an Oracle database, which one is the easiest and most recommended?

A) Using the Oracle Database Configuration Assistant. B) Using the Oracle-supplied database creation procedures.
C) Using the SQL CREATE DATABASE command. D) None of the above is correct.
 
Answer & Explanation Answer: A) Using the Oracle Database Configuration Assistant.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 3242
Q:

 Which of the following improves a query's processing time?

A) Write complex queries. B) Combine a table with itself.
C) Query one query within another. D) Use compatible data types.
 
Answer & Explanation Answer: D) Use compatible data types.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 3213