You have been asked to design the following database diagram:“We would like to store a list of user’s in the database with their corresponding network of friends, groups, as well as any messages
Explain the lifecycle regarding validating data from start to finish?
IRLM is a module of DB2 which doesA. LoggingB. Thread creationsC. Concurrency controlD. Both logging and thread creation.
Functions for error trapping are contained in which section of a PL/SQL block?
“Bigger the size of a Oracle package, the better”. Do you agree? Justify.
Latest Answer: No - I do not agreeFunctionality depends..What are you trying to do in a
package depends a lot...A Package can call Views, Functions and Triggers, Update, Insert, Delete..
Purpose of a Package, For Eg.. If you create a Month End Package for a Co. It ...
How does Export/Import feature differ from that of SQL Loader?
Latest Answer: Its Different.. For Export we are exporing the data from the Database to a Dump file..i.e EXP from user datafile buffer rows compress etcfor Imprting we are importing the data from a dump file to a database..i.e IMP fromuser touser file= commit ...
Differentiate between Controlled and Uncontrolled Redundancy
Latest Answer: Redundancy is
Direct if a value is a copy of another
Indirect if the value can be derived from other values:
Simplifies retrieval but complicates update
Conversely integration makes retrieval slow and updates easier
Data ...
Explain what are controlled and uncontrolled data redundancy?
Latest Answer: I view this as planned and unplanned. Generally planned redundancy for performance reasons has some steps taken to ensure that there is syncronicity between the data. I am not sure if there are formal definitions or the precise meaning of the terms might ...
Describe the process of converting an extended E-R model into a relational database design.
Latest Answer: ER Model->Logical schema->Normalization->Creating database with tables. ...
Explain the representation of a one-to-many strong entity relationship in a relational database design.
Latest Answer: Department-Employees Under one Department many employees are working.Project-Employees ...
View page [1] 2 3 4 5 6 7 Next >>
Go Top
