Option A. TRUE Option B. FALSE Option C. Option D. True Answer A
Consider the following two-process synchronization solution Process 0 --------- Entry: loop while (turn == 1); (critical section) Exit: turn = 1; Process 1 ----------- Entry: loop while (turn == 0); (critical section) Exit: turn = 0; The shared variable turn is initialized to zero. Which one of the following is TRUE?
Option A. This is a correct two-process synchronization solution. Option B. This solution violates mutual exclusion requirement. Option C. This solution violates progress requirement. Option D. This solution violates bounded wait requirement. True Answer C
What will be the output of the following Python code?
x = 'abcd' for i in range(len(x)): print(i.upper())
Option A. a b c d Option B. 0 1 2 3 Option C. error Option D. 1 2 3 4 True Answer C
Option A. Media Address Control Option B. Media Axis Control Option C. Media Access Control Option D. None True Answer C
How many tuples does the result of the following SQL query contain?
SELECT A.Id FROM A WHERE A.Age > ALL (SELECT B.Age FROM B WHERE B.Name = ‘Arun’)
Option A. 4 Option B. 3 Option C. 0 Option D. 1 True Answer B
Select A.id From A Where a, age > All (Select B, age from B where B. Name = 'Arun') Inner query will return no tuple. So all A tuple will be selected.
Option A. TRUE Option B. FALSE Option C. Option D. True Answer B
Option A. 1000 Option B. 975 Option C. 900 Option D. 225 True Answer C
Total number of students = 60 + 80 + 30 + 38 + 5 + 10 + 2 = 225
25% = 225
Option A. 1KB Option B. 526 MB Option C. 1GB Option D. None True Answer D
Option A. zentaga Option B. tagafer Option C. tagazen Option D. relffer True Answer C
Option A. 0 1 2 3 4 … Option B. 0 1 Option C. 3 4 Option D. 0 1 2 3 True Answer C
Option A. a={5,5,6,7} Option B. a={5,6,7} Option C. Error as there is no add function for set data type Option D. Error as 5 already exists in the set True Answer B
Consider the following relational schema:
Employee (empId, empName, empDept)
Customer (custId, CustName, salesRepId, rating)
SalesRepId is a foreign key referring to empId of the employee relation. Assume that each employee makes a sale to at least one customer. What does the following query return?
SELECT empName
FROM employee E
WHERE NOT EXISTS (SELECT custId
FROM customer C
WHERE C. salesRepId = E. empId
AND C. rating < > ‘GOOD’)
Option A. Names of all the employees with at least one of their customers having a ‘GOOD’ rating. Option B. Names of all the employees with at most one of their customers having a ‘GOOD’ rating. Option C. Names of all the employees with none of their customers having a ‘GOOD’ rating. Option D. Names of all the employees with all their customers having a ‘GOOD’ rating. True Answer D
The outer query will return the value (names of employees) for a tuple in relation E, only if inner query for that tuple will return no tuple (usage of NOT EXISTS).
The inner query will run for every tuple of outer query. It selects cust-id for an employee e, if rating of customer is NOT good. Such an employee should not be selected in the output of outer query.
So the query will return the names of all those employees whose all customers have GOOD rating.
Option A. Performance Option B. Reliability Option C. Security Option D. None of the above True Answer C
x=1 def cg(): global x x=x+1 cg() x
Option A. 2 Option B. 1 Option C. 0 Option D. Error True Answer A
Gulfs
Direction: Choose the singular form of the given word.
Option A. Engulf Option B. Gulp Option C. Gulf Option D. Gulv True Answer C
Singular means only one. Plural means more than one. The basic rule is to add s or es to make a noun plural. "Gulfs" is a plural noun and its singular form is "gulf". Thus, option C is correct.
Option A. Samsung Option B. Lenovo Option C. Toshiba Option D. DELL True Answer D
Option A. Deposits less than Rs.50,000/- Option B. Deposits in excess of Rs.1 lac Option C. Deposits Rs.50,000/- & above Option D. All transactions True Answer C