Latest Answer: NORMALIZATION is a body of rules addressing analysis and conversion of data structures into relations that exhibit more desirable properties of internal consistency,minimal redundancy and maximum stability.FIRST NORMAL FORM: A relation is in the first ...
Latest Answer: a user defined package can be invoked in sql only if we r using it to call public functions or variables.but packaged procedures can not be called from sql ...
What is difference between Oracle and MS Access? What are disadvantages in Oracle and MS Access? What are features&advantages in Oracle and MS Access?
There are 2 tables, Employee and Department. There are few records in employee table, for which, the department is not assigned. The output of the query should contain all th employees names and their corresponding departments, if the department is assigned otherwise employee names and null value in the place department name. What is the query?
Select emp_name, Dept_name from (Employee_table left outer join Dept_table on Employee_table.Dept_id = Dept_table.Dept_id)
Latest Answer: LIKE - string pattern matching operator % = zero or many characters _(underscore) = one character. ...
Latest Answer: i dont know what it means ...
?
Latest Answer: yes it displays all the rows and columns related to emp table ...
There is a Eno & gender in a table. Eno has primary key and gender has a check constraints for the values 'M' and 'F'. While inserting the data into the table M was misspelled as F and F as M. What is the update statement to replace F with M and M with F?
CREATE TABLE temp(eno NUMBER CONSTRAINTS pk_eno PRIMARY KEY,gender CHAR(1) CHECK (gender IN( 'M','F')));INSERT INTO temp VALUES ('01','M');INSERT INTO temp VALUES
Co-related sub query is one in which inner query is evaluated only once and from that result outer query is evaluated.Nested query is one in which Inner query is evaluated for multiple times for gatting
Latest Answer: If the evaluation of an inner querry(a sub querry) depends on a variable which gets its value in an outer querry,such a subquerry has to be evaluated for each value of the variable.Such a querry is a correlated subquerry.If no such variable is used,the ...
i want to know the answer
Latest Answer: Every database is divided into logical storage unit called Tablespace. This Tablespace is used to group related logical strutures together. ...
View page << Previous 6 7 8 9 [10] 11 12 13 14 Next >>
Go Top
