Computer Basics
This test consists of 20 questions about the basics of computer like data structure, database, operating system and computer languages etc.
Questions
Which of the following necessary and sufficient condition of deadlock shows that the resources are used in the processes must be non-sharable?
- Hold and wait
- Mutual exclusion
- Non-preemptive
- Circular wait
- None of these
Which of the following services is not provided by the operating system?
- Resource allocation
- I/O operations
- Error detection
- Communication
- None of these
Which of the following CPU scheduling algorithms can be preemptive as well as non-preemptive?
- Shortest Job First (SJF)
- First Come First Serve (FCFS)
- Round Robin
- Both (1) and (3)
- None of these
Which of the following statements is/are false?
- Processes are heavy weight.
- Process switching needs to interact with the operating system.
- Thread switching needs to interact with the operating system.
- Both (2) and (3)
- None of these
Which of the following is/are called program threats in operating system?
- Trojan horse
- Virus
- Worm
- All of the above
- Only (1) and (2)
Which of the following is/are the disadvantage(s) of the time-sharing operating systems?
- It reduces CPU idle time.
- Multi-channel conversation.
- Integrity and security of the data is very less.
- All of the above
- None of the above
Which of the following is the task of spooling in operating system?
- It is the process in which the data is stored in the buffers while the data is transferred between the two devices and an application.
- It is the process in which two peripheral devices such as hard disk and magnetic tape or hard disk and CD- ROM etc. accesses the data directly and utilizes the main memory for temporary storage of the data. Spooling is done with the help of spool programs.
- It is the process in which the CPU can execute multiple tasks simultaneously by switching the process.
- It is the property in which a processor can share two or more process simultaneously.
- None of the above
Which of the following is/are non-linear data structures?
- Arrays
- Queues
- Binary search trees
- Stacks
- Both (3) and (4)
Which of the following is not a reserved word in C++ language?
- typedef
- unsigned
- union
- mutable
- none of the above
Which of the following layers in OSI model provides congestion control in networking?
- Network layer
- Physical layer
- Application layer
- Session layer
- None of the above
Which of the following is an example of a single user computer system?
- Workstation
- Mini computer
- Mainframe computer
- All of the above
- Both (1) and (2)
Which of the following database transactions ensures that the effect of the transaction will persist despite of system crashes or power loss, if the transaction is committed?
- Atomicity
- Consistency
- Isolation
- Durability
- None of the above
Which of the following SQL (Structured Query Language) commands is used to remove the table structure form the database?
- Drop
- Delete
- Truncate
- Both (1) and (3)
- None of the above
Which of the following statements is/are not true?
- Intranet uses the internet protocols.
- Intranet is restricted as compared to internet.
- Intranet is less safe as compared to internet.
- All of the above
- None of these
Which of the following is/are true statement(s)?
- Indexes are used to retrieve the rows of the database table quickly.
- Indexes are not useful for the tables having less data.
- The check constraints in SQL defines the business rules that should be follow by all the rows of the database.
- Both (1) and (3) are true.
- All (1), (2) and (3) are true.
Which of the following SQL clauses is used to place a condition while arranging identical data into a group?
- Group By clause
- Having clause
- Distinct clause
- Like clause
- None of the above
Which of the following commands in transaction control in SQL is used to save the changes in the database by the transaction?
- SAVEPOINT
- COMMIT
- SET TRANSACTION
- ROLLBACK
- None of the above
Which of the following is not related to stack data structure?
- LIFO
- Push and pop
- Front and rear
- Both (1) and (3)
- None of these
Which of the following statements is false?
- Array is a collection of homogeneous elements.
- Quick sort is based on the divide and conquer method.
- Array is an index based data structure.
- The worst case complexity of quick sort is O(n^2).
- None of the above
Which of the following statements is/are true?
- Static data structures have a fixed size.
- Insertion/deletion occurs fast in static data structure.
- Stack is a dynamic data structure.
- All of the above
- Only (1) and (3) are true.