1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ?
10 18197why jobstep can't be more than 255 and for GDG has max limit 255 . Is there any relation between the two
1 78011). What are the situation in process is duplicate is linux box.? 2) Give me 5 situation to kill a process?
1 4721Post New Perot Systems Interview Questions
how does the run() method in runnable work? : Java thread
Is c procedural or functional?
Roads concatenation Problem
Consider we have some GIS (Geo Information System) operating
over some road network. Each road represented as array of
two-dimensional geographical points. Road network is a set
of roads.
System has function called Concatenate(). This function
takes raw road network and should return optimized road
network. Optimization lies in concatenating roads with
matching start or end points, i.e. if road AB end point
matches road BC start point, then optimized network should
contain concatenated road AC. Optimized network shouldn’t
contain two roads which can be concatenated.
Your task is to suggest set of test cases for Concatenate()
function in order to make sure it works correctly.
public interface IPoint
{
double Lat { get; }
double Lon { get; }
}
public Road : List
Highlight the key features of Union Budget 2017
If o/p power is doubled by how much does the sound increase
Are the nsmanagedobjectcontext queues serial or concurrent?
115mm thickness brick work how to required mortar
What is better than microsoft word?
How can we export multiple test cases from td in a single go?
What is Distributed Training in TensorFlow ?
What are the type of models available in yii framework ?
Which is better c++ or java or python?
Why is sizeof () an operator and not a function?
How do I delete a worksheet in excel 2016?
Can all the instances in my rds account sample metrics at an equivalent granularity?