Sawaal

 Database Questions

Popular Latest Rated
Q:

 The load and index is which of the following?

A) A process to reject data from the data warehouse and to create the necessary indexes B) A process to load the data in the data warehouse and to create the necessary indexes
C) A process to upgrade the quality of data after it is moved into a data warehouse D) A process to upgrade the quality of data before it is moved into a data warehouse
 
Answer & Explanation Answer: B) A process to load the data in the data warehouse and to create the necessary indexes

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

1 8258
Q:

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 ;

A) Equi-join B) Natural join
C) Outer join D) Cartesian join
 
Answer & Explanation Answer: D) Cartesian join

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

7 7374
Q:

It is necessary to sort a file before searching a particular item 

A) True B) False
C) May or may not be true D) None of the above
 
Answer & Explanation Answer: C) May or may not be true

Explanation:

If less work is involved in searching a element than to sort and then extract, then we don’t go for sort

If frequent use of the file is required for the purpose of retrieving specific element, it is more efficient to sort the file.

Thus it depends on situation

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

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

2 7210
Q:

Which of the following products implemented the CODASYL DBTG model?

A) IDMS B) DB2
C) dBase-II D) R:base
 
Answer & Explanation Answer: A) IDMS

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 6991
Q:

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

A) New modules can be built to support specific business needs B) Performance improves for compiled SQL statements
C) Results in a thinner client and database server D) All of the above.
 
Answer & Explanation Answer: A) New modules can be built to support specific business needs

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

1 6886
Q:

 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:

A) first step. B) second step.
C) third step. D) fourth step.
 
Answer & Explanation Answer: C) third step.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

2 6539
Q:

Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity?

A) Supertype entity B) Subtype entity
C) Archetype entity D) Instance entity
 
Answer & Explanation Answer: A) Supertype entity

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

2 6385