Database Administration Questions

Q:

Which among the following are the capabilities of the Cursor?

A) It reads every row one by one. B) It can be parameterised and hence are flexible
C) It can be positioned to specific rows D) All the above
 
Answer & Explanation Answer: D) All the above

Explanation:

All the above listed actions are the functions of cursor

Report Error

View Answer Workspace Report Error Discuss

0 594
Q:

What does coalescing a tablespace do?

Answer

Coalescing is only valid for dictionary-managed tablespaces and de-fragments space by combining neighboring free extents into large single extents.

Report Error

View answer Workspace Report Error Discuss

0 281
Q:

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

Answer

Disable the foreign key constraint to the parent, drop the table, re-create the table, enable the foreign key constraint.

Report Error

View answer Workspace Report Error Discuss

0 269
Q:

What is the difference between OLE Server & OLE Container?

Answer

An OLE server application creates ole Objects that are embedded or linked in OLE Containers ex. OLE servers are ms_word & ms_excel. OLE containers provide a place to store, display and manipulate objects that are created by ole server applications. Ex. oracle forms is an example of an OLE Container.

Report Error

View answer Workspace Report Error Discuss

0 263
Q:

What is database clusters?

Answer

Group of tables physically stored together because they share common columns and are often used together is called Cluster.

Report Error

View answer Workspace Report Error Discuss

0 238