Software Engineer

int main(){   

 int a=12,b=39;   

 printf ("%d",a&b);   

 return 0;}

(a). 468

(b). 0

(c). 4

(d). None of the above.

# include void fun(int x){    x = 30;}

 int main(){ 

 int y = 20; 

 fun(y);  

printf("%d", y); 

 return 0;}

(a) 30

(b) 20

(c) Compiler Error

(d) Runtime Error

SELECT dept_name, ID, avg (salary)FROM instructorGROUP BY dept_name;

(a) Dept_id should not be used in group by clause

(b) Group by clause is not valid in this query

(c) Avg(salary) should not be selected

(d) None

Given a number ‘N', the task is to find the total number of derangements of a set of ‘N’ elements.

A ‘Derangement’ is a permutation of 'N' elements, such that no element appears in its original position. For example, a derangement of {0, 1, 2, 3} is {2, 3, 1, 0}.

For example, 'N' = 2 , {0, 1} and {1, 0} are the only derangement therefore output will be 1.

You want to sort the results of a query by specific parts of a string. For example, you want to return employee names and jobs from table EMP and sort by the last twocharacters in the JOB field. The result set should look like the following:ENAME JOB---------- ---------KING PRESIDENTSMITH CLERKADAMS CLERKJAMES CLERKMILLER CLERKJONES MANAGERCLARK MANAGERBLAKE MANAGERALLEN SALESMANMARTIN SALESMANWARD SALESMANTURNER SALESMANSCOTT ANALYSTFORD ANALYST

Given an undirected and disconnected graph G(V, E), containing 'V' vertices and 'E' edges, the information about edges is given using 'GRAPH' matrix, where i-th edge is between GRAPH[i][0] and GRAPH[i][1]. print its DFS traversal.

V is the number of vertices present in graph G and vertices are numbered from 0 to V-1. 

E is the number of edges present in graph G.

Note :

The Graph may not be connected i.e there may exist multiple components in a graph.

What is inheritance? What is the difference between multiple inheritance and and multilevel inheritance?

What is abstraction?

What are joins and types of joins?

You want to find the highest and lowest values in a given column. For example, you
want to find the highest and lowest salaries for all employees, as well as the highest
and lowest salaries for each department.