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 constraint is for any two tuples t1 and t2 in r if t1[X] = t2[X] then they have t1[Y] = t2[Y]. This means the value of X component of a tuple uniquely determines the value of component Y.
What is sql JOIN?
What command is used to create a table by copying the structure of another table?
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
What are privileges that can be granted on a table by a user to others?
What is the use of the DROP option in the ALTER TABLE command?
What command is used to get back the privileges offered by the GRANT command?
What is the value of comm and sal after executing the following query if the initial value of ‘sal’ is 10000 UPDATE EMP SET SAL = SAL + 1000, COMM = SAL*0.1;?
Which Oracle supplied package can you use to output values and messages from database triggers, stored procedures and functions within SQL*Plus?
How to implement ISNUMERIC function in SQL *Plus ?
What will be the output of the following query?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
