Description : For a database relation R(a, b, c, d) where the domains of a, b, c, d include only the atomic values. The functional dependency a → c, b → d holds in the following relation (A) In 1NF not in 2NF (B) In 2NF not in 3NF (C) In 3NF (D) In 1NF
Last Answer : (A) In 1NF not in 2NF
Description : Select the ‘False’ statement from the following statements about Normal Forms: (A) Lossless preserving decomposition into 3NF is always possible (B) Lossless preserving decomposition into BCNF is always possible (C) Any relation with two attributes is in BCNF (D) BCNF is stronger than 3NF
Last Answer : (B) Lossless preserving decomposition into BCNF is always possible
Description : Consider the following statements regarding relational database model: (a) NULL values can be used to opt a tuple out of enforcement of a foreign key. (b) Suppose that table T has only one candidate key. If Q is in 3NF, then it is ... true. (C) (b) and (c) are true. (D) (a), (b) and (c) are true.
Last Answer : (D) (a), (b) and (c) are true.
Description : Which normal form is considered as adequate for usual database design? (A) 2NF (B) 3NF (C) 4NF (D) 5NF
Last Answer : (B) 3NF
Description : What is Fully Functional dependency?
Last Answer : It is based on concept of full functional dependency. A functional dependency X Y is full functional dependency if removal of any attribute A from X means that the dependency does not hold any more.
Description : When is a functional dependency F said to be minimal?
Last Answer : ∙ Every dependency in F has a single attribute for its right hand side. ∙ We cannot replace any dependency X A in F with a dependency Y A where Y is a proper subset of X and still have a set ... F. ∙ We cannot remove any dependency from F and still have set of dependency that is equivalent to F.
Description : What is Functional Dependency?
Last Answer : A Functional dependency is denoted by X Y between two sets of attributes X and Y that are subsets of R specifies a constraint on the possible tuple that can form a relation state r of R. The ... [Y]. This means the value of X component of a tuple uniquely determines the value of component Y.
Description : What is BCNF (Boyce-Codd Normal Form)?
Last Answer : A relation schema R is in BCNF if it is in 3NF and satisfies an additional constraint that for every FD X A, X must be a candidate key.
Description : What is 2NF?
Last Answer : A relation schema R is in 2NF if it is in 1NF and every non-prime attribute A in R is fully functionally dependent on primary key.
Description : What is 3NF?
Last Answer : A relation schema R is in 3NF if it is in 2NF and for every FD X A either of the following is true ∙ X is a Super-key of R. ∙ A is a prime attribute of R. In other wo
Description : What do you understand by dependency preservation?
Last Answer : Given a relation R and a set of FDs F, dependency preservation states that the closure of the union of the projection of F on each decomposed relation Ri is equal to the closure of F. i.e ... ))+ = F+ if decomposition is not dependency preserving, then some dependency is lost in the decomposition
Description : What is join dependency and inclusion dependency?
Last Answer : Join Dependency: A Join dependency is generalization of Multivalued dependency.A JD {R1, R2, ,Rn} is said to hold over a relation R if R1, R2, R3, , Rn is a lossless-join ... columns of a relation are contained in other columns. A foreign key constraint is an example of inclusion dependency.
Description : What is Multivalued dependency?
Last Answer : Multivalued dependency denoted by X Y specified on relation schema R, where X and Y are both subsets of R, specifies the following constraint on any relation r of R: if two tuples t1 and t2 exist in r such that t1[X] = t2[X] then t3 ... ∙ t3[Z] = t2[Z] and t4[Z] = t1[Z] where [Z = (R-(X U Y)) ]
Description : In RDBMS, the constraint that no key attribute (column) may be NULL is referred to as: (A) Referential integrity (B) Multi-valued dependency (C) Entity Integrity (D) Functional dependency
Last Answer : (C) Entity Integrity
Description : Consider a schema R(MNPQ) and functional dependencies M→N, P→Q. Then the decomposition of R into R1(MN) and R2(PQ) is ............. (1) Dependency preserving but not lossless ... and lossless join (3) Lossless join but not dependency preserving (4) Neither dependency preserving nor lossless join.
Last Answer : Answer: 1
Description : Explain functional dependency with example.
Last Answer : A functional dependency occurs when one attribute in a relation uniquely determines another attribute. OR Consider a relation say R(X,Y), where X and Y are one or more than one attribute, ... sscper. That is, given rollno of a student, the name and sscper can be determined or searched.
Description : What are attributes of cursor?
Last Answer : %FOUND , %NOTFOUND , %ISOPEN,%ROWCOUNT
Description : What are cursor attributes?
Last Answer : %ROWCOUNT -%NOTFOUND -%FOUND -%ISOPEN
Description : What are the cursor attributes used in PL/SQL ?
Last Answer : %ISOPEN - to check whether cursor is open or not % ROWCOUNT - number of rows fetched/updated/deleted. % FOUND - to check whether cursor has fetched any row. True if rows are ... featched. These attributes are proceeded with SQL for Implicit Cursors and with Cursor name for Explicit Cursors.
Description : What are visual attributes?
Last Answer : Visual attributes are the font, color, pattern proprieties that you set for form and menu objects that appear in your application interface.
Description : In mapping of ERD to DFD a) entities in ERD should correspond to an existing entity/store in DFD b) entity in DFD is converted to attributes of an entity in ERD c) relations in ERD has 1 to 1 correspondence to processes in DFD d) relationships in ERD has 1 to 1 correspondence to flows in DFD
Last Answer : a) entities in ERD should correspond to an existing entity/store in DFD
Description : A relation R={A,B,C,D,E,F,G} is given with following set of functional dependencies: F={AD→E, BE→F, B→C, AF→G} Which of the following is a candidate key? (A) A (B) AB (C) ABC (D) ABD
Last Answer : Answer: D
Description : What is Functional Setup Manager or FSM as it is more commonly known as?
Last Answer : Oracle Fusion Functional Setup Manager (FSM) is an application that provides an end to-end guided process for managing your functional implementation projects throughout the entire implementation life cycle.
Description : If an attribute of a composite key is dependent on an attribute of the other composite key, a normalization called ................ is needed. A) DKNF B) BCNF C) Fourth D) Third
Last Answer : B) BCNF
Description : The Relation Vendor Order (V_no, V_ord_no, V_name, Qty_sup, unit_price) is in 2NF because : (A) Non key attribute V_name is dependent on V_no which is part of composite key (B) ... Qty_sup is dependent on primary_key unit price (D) key attribute V_ord_no is dependent on primary_key unit price
Last Answer : (A) Non key attribute V_name is dependent on V_no which is part of composite key
Description : Which one of the following non-functional quality attributes is not highly affected by the architecture of the software ? (A) Performance (B) Reliability (C) Usability (D) Portability
Last Answer : (C) Usability
Description : Which of the following is the employer-employee authority relationship that follows the chain of command? (a) Staff authority ; (b) Referent power ; (c) Line authority ; (d) Functional authority
Last Answer : (c) Line authority ;
Description : Feeling hesitant to take an over-the-counter drug because I know I will develop dependency...do you have any advice?
Last Answer : If you can don’t take it, it’s simple as that.
Description : What is sliding into dependency on alcohol or other substances like?
Last Answer : answer:It began in college for me. It was the first time I was away from home, and the drinking age was 18 in my state at the time. I could march into any liquor store and by a bottle of ... me freedom from the fears that once plagued me. I sleep at night, and I'm relatively sane most days.
Description : Ladies - Are you or would you be comfortable with a relationship that put you in total dependency of your partner?
Last Answer : answer:My sister did it. “So currently. She is out of work.” Pretty sure the outcome would be the same if she picked the job.
Description : Are you interested in what the Director of the CIA has to say about OPEC and America's dependency on foreign oil?
Last Answer : Well at least with foreign oil when there’s a spill it screws up someone elses country.
Description : Why is the dependency ratio higher in rural areas than in urban areas ? State two reasons. -Geography
Last Answer : Dependency ratio is higher in rural areas because : 1. Birth rates are higher in rural areas. 2. Large numbers of adults migrate to urban areas in search of jobs. 3. Adults who migrate return to their rural homes after retirement.
Description : The dependency ratio is higher in rural areas than in urban areas. Give two reasons to explain why. -Geography
Last Answer : The following are the reasons for higher dependency ratio in the rural areas as compared to urban areas: 1. Birth rates are higher in the rural areas as compared to those in the urban areas. 2. ... . Adults who migrate to urban areas in search of jobs come back to their rural homes in old age.
Description : How do i figure Child dependency ratio?
Last Answer : It is usually calculated as the number of children (aged under15 years) as a ratio of people of working age (ages 15 to 64). Thisratio is currently in a state of flux because the pension age isbeing raised in many countries so that the denominator of the ratiocovers a bigger age range.
Description : What are some therapies used for chemical dependency treatment programs?
Last Answer : There are several treatment options for chemical dependency. There are 48 hours treatments, counseling, and group meetings for individuals to meet with people with similar chemical dependencies.
Description : What is the success rate of patients who complete chemical dependency rehab?
Last Answer : The answer to this question will ultimately depend on the particular program in question. Some rehab centers prove to be better than others. Here are a few tips to evaluate the success rate of ... dependency rehab is between 2% to 20%, depending on the particular chemical the person is dependent on.
Description : According to Arrhenius equation of temperature dependency of rate constant for an elementary reaction (A) k ∝ √T (B) k ∝ e -E/RT (C) k ∝ T e -E/RT (D) None of these
Last Answer : (B) k ∝ e -E/RT
Description : DIP stands for: a) Domain Inversion Principle b) Diodic Inversion Principle c) Dependency Inversion Principle d) None of These
Last Answer : c) Dependency Inversion Principle
Description : . At the Melting Moments, an ice cream parlour, customers place their orders, watch their ice- cream sundaes being prepared, and then quickly eat the sundaes in the store before the ice cream ... known as A. Inseparability B. Intangibility C. Heterogeneity D. Perishability E. Dependency
Last Answer : D. Perishability
Description : Which of the following is not a part of the characteristic of 4G network? a) Multirate management b) Fully converged services c) Software dependency d) Diverse user devices
Last Answer : a) Multirate management
Description : What was the theory of Immanual Wallerstein? (a) Capitalist theory (b) World system theory (c) Dependency theory (d) Devil theory
Last Answer : (b) World system theory
Description : Dependency theory was introduced by ____. (a) Andre Gunder Frank (b) Fanon (c) Samir Amin (d) Edward Said
Last Answer : (a) Andre Gunder Frank
Description : Which of the following is a knowledge representation technique used to represent knowledge about stereotype situation? (A) Semantic network (B) Frames (C) Scripts (D) Conceptual Dependency
Last Answer : (C) Scripts
Description : s it possible to set a filter condition in a cross product group in matrix reports?
Last Answer : No
Description : If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?
Last Answer : Only for 10 records.
Description : Can u set default font in forms?
Last Answer : Yes. Change windows registry(regedit). Set form45_font to the desired font.
Description : which system variables can be set by users?
Last Answer : SYSTEM.MESSAGE_LEVEL SYSTEM.DATE_THRESHOLD SYSTEM.EFFECTIVE_DATE SYSTEM.SUPPRESS_WORKING
Description : What is the built-in used to get and set lov properties during run-time?
Last Answer : Get_lov_property Set_lov_property Record Group
Description : What database events can be set? (for DBA
Last Answer : The following events are frequently used by DBAs and Oracle Support to diagnose problems: " 10046 trace name context forever, level 4 Trace SQL statements and show bind variables in trace output. " 10046 ... . On Unix, you can type "oerr ora 10053" from the command prompt to get event details.
Description : What is a database EVENT and how does one set it? (for DBA
Last Answer : Oracle trace events are useful for debugging the Oracle database server. The following two examples are simply to demonstrate syntax. Refer to later notes on this page for an explanation of what these ... changes to the INIT.ORA file will affect all sessions once the database has been restarted.