⟩ What is normalization?
It is a process of analysing the given relation schemas based on their Functional Dependencies (FDs) and primary key to achieve the properties
► Minimizing redundancy
► Minimizing insertion, deletion and update anomalies.
It is a process of analysing the given relation schemas based on their Functional Dependencies (FDs) and primary key to achieve the properties
► Minimizing redundancy
► Minimizing insertion, deletion and update anomalies.
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?
Which Oracle supplied package will enable this feature?