1.Tell me about ur self?2.Casting?
Ans:-
CAST and CONVERT. SQL Server 2000. Explicitly converts an expression of one data type to another
3. Normalization uses?
Ans:-
1.saves network bandwidth
2.save disk space and data integrity
3.Faster sorting and index creation.
4.A larger number of clustered indexes.....
5.Narrower and more compact indexes.
6.Fewer indexes per table. This improves the performance of the INSERT, UPDATE, and DELETE statements.
7.Fewer null values and less opportunity for inconsistency. This increases database compactness.
4.How many column can be in sql server table?
Ans:-
1024
5.Oracle NVL function and its substitute in Sqlserver?
Ans:-
Isnull (exp1,exp2)
6.Type of constraints?
Ans:-
1.isnull
2.primary key
3.foreign key
4.check
5.unique key
7.Database process?
Ans:-
ITIL Process:-
It is a step by step process in which the IT tools is going to used with the business project.
8. Temporary tablespace and temporary table one example?
Ans:-
Temporary tablespace and temporary table used to store the temporary data like sorting.
Which not ging for the long period and recovery of this thing is not possible.
We mainly used it to save the main memory of the system(SGA).
9. Normalization,real example and its syntax?
10.Cursor use and how to apply cursor one example?
Ans:-
When a query returns multiple rows, you can explicitly define a cursor to:
* process beyond the first row returned by the query
* keep track of which row is currently being processed.
Cursors allow the designer precise control of the multiple values returned
by the cursor's SELECT statement.
11.Constraints?
Ans:-
1.isnull
2.primary key
3.foreign key
4.check
5.unique key
12.Difference between primary and unique key?
Ans:-
primary key cant be null but unique key can be null.
Primary key can apply only once in table but unique can be many times.
13.Stored procedure?
Ans:-
You can store PL/SQL code inside the database this process called stored process.
Syntex:-
create or replace procedure p_hello
is
v_string_tx varchar2(256):=’Hello, World!’;
begin
dbms_output.put_line(v_string_tx);
end;
14.joins and explain abt this.
Ans:-
Joins:-
Is used to fetch columns from two or more tale as well as in single column.
exaple:-
Select a.name,b.ename from emp a, emp b where a.mgr=b.empno;
15.User creation and privilege and time required to give access the user.
Ans:-
create user a identified by abc;
grant connect,resource to a;
or using oem we can grant roles and privilege.
Time required its depends on the organisation standard and rules.
in our cases it was within 24 hour.
