Sawaal

 Database Questions

Popular Latest Rated
Q:

A data dictionary is a special file that contains

A) The width of all fields in all files B) The data type of all fields in all file
C) The name of all fields in all files D) All of the above
 
Answer & Explanation Answer: D) All of the above

Explanation:

A data dictionary is a special file that contains a set of information describing the contents, format, and structure of a database and the relationship between its elements, used to control access to and manipulation of the database.

Report Error

View Answer Report Error Discuss

Filed Under: Database
Exam Prep: Bank Exams
Job Role: Analyst , Bank Clerk , Database Administration , IT Trainer

6 3237
Q:

Does the minimum spanning tree of a graph give the shortest distance between any 2 specified nodes?

A) Yes B) No
C) May be Yes or No D) None
 
Answer & Explanation Answer: B) No

Explanation:

No.Minimal spanning tree assures that the total weight of the tree is kept at its minimum. But it doesn’t mean that the distance between any two nodes involved in the minimum-spanning tree is minimum.

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

1 3198
Q:

 The expression FOR XML RAW tells SQL Server to:

A) place the values of the columns as attributes in the resulting XML document. B) place the values of the columns into elements rather than attributes.
C) place some columns into elements and others into attributes. D) None of the above is correct.
 
Answer & Explanation Answer: A) place the values of the columns as attributes in the resulting XML document.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 3178
Q:

 A distributed database is which of the following?

A) A single logical database that is spread to multiple locations and is interconnected by a network B) A loose collection of file that is spread to multiple locations and is interconnected by a network
C) A single logical database that is limited to one location. D) A loose collection of file that is limited to one location.
 
Answer & Explanation Answer: A) A single logical database that is spread to multiple locations and is interconnected by a network

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

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

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

0 3090
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 3078
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 3067