What is Functional Dependency ? or What is Auditing ?

What is Functional Dependency ?

Given a relation R, attribute Y of R is functionally dependent on attribute X of R if and only if each X-value has associated with it precisely one -Y value in R

What is Auditing ?
The database has the ability to audit all actions that take place within it.
a) Login attempts, b) Object Accesss, c) Database Action Result of Greatest(1,NULL) or Least(1,NULL) NULL

While designing in client/server what are the 2 imp. things to be considered ?
Network Overhead (traffic), Speed and Load of client server

When to create indexes ?
To be created when table is queried for less than 2% or 4% to 25% of the table rows.

How can you avoid indexes ?
TO make index access path unavailable - Use FULL hint to optimizer for full table scan - Use INDEX or AND-EQUAL hint to optimizer to use one index or set to indexes instead of another. - Use an expression in the Where Clause of the SQL.

What is the result of the following SQL :
Select 1 from dual
UNION
Select 'A' from dual;
Error

Can database trigger written on synonym of a table and if it can be then what would be the effect if original table is accessed.
Yes, database trigger would fire.

Can you alter synonym of view or view ?
No

Can you create index on view ?
No

What is the difference between a view and a synonym ?
Synonym is just a second name of table used for multiple link of database. View can be created with many tables, and with virtual columns and with conditions. But synonym can be on view.

What is the difference between alias and synonym ?
Alias is temporary and used with one query. Synonym is permanent and not used as alias.

What is the effect of synonym and table name used in same Select statement ?
Valid

What's the length of SQL integer ?
32 bit length