Question 1
Answer
Question 1
Name any two models of SDLC (Software Design Life Cycle) ?
a) Water Fall Mode
b) Spiral Model
c) a and b
d) none of these
Answer
c) a and b
Question 2
Answer
Question 2
Word alignment is
a) alligning the address to the next word boundary of the machine
b) alligning to even boundary
c) alligning to word boundary
d) none of the above
Answer
a) alligning the address to the next word boundary of the machine
Question 3
Answer
Question 3
To send a packet data using datagram, connection will be established..
a) before data transmission
b) connection is not establshed before data transmission
c) no connection required
d) none of the above
Answer
c) no connection required
Question 4
Answer
Question 4
A 2 mb PCM (Pulse Code Modulation) has
a) 32 voice channels
b) 30 voice channels and 1 signalling channel
c) 31 voice chanels and 1 signalling channel
d) 32 channels out of which 30 voice channels, 1 signalling channel and 1 syncronization channel.
Answer
c) 31 voice chanels and 1 signalling channel
Question 5
Answer
Question 5
The status of the kernel is?
a) task
b) process
c) not defined
d) none of the above
Answer
b) process
Also Checkout: TCS NQT Sample Question Paper
Question 6
Answer
Question 6
Explain the use of the WHERE clause.
Answer
It directs SQL to extract data from rows where the value of the column is the same as the current value of the WHERE clause variable.
Question 7
Answer
Question 7
What are the reasons for adding an index to a table ?
Answer
To increase lookup performance. For a unique key to guarantee the uniqueness of the values for a column on a table.
Question 8
Answer
Question 8
What is PL/SQL ?
Answer
A programming language available in Oracle. It is a way of wrapping SQL with 3GL constructs such as IF..THEN..ELSE, WHILE etc.
Question 9
Answer
Question 9
What technique is used to retrieve data from more than one table in a single SQL statement?
Answer
The Join statement combines data from more that two tables
Question 10
Answer
Question 10
What is a foreign key?
Answer
It identifies a related row in another table and establishes a logical relationship between rows in two tables.
Question 11
Answer
Question 11
What happens if a tablespace clause is left off of a primary key constraint clause?
Answer
This results in the index that is automatically generated being placed in the users default tablespace. Since this will usually be the same tablespace as the table is being created in, this can cause serious performance problems.
Question 12
Answer
Question 12
What is locking and what is it used for ?
Answer
Locking is a mechanism to restrict access to data. It prevents one user updating data whilst another user is looking at it.
Question 13
Answer
Question 13
What types of locking are available with Oracle?
Answer
Row locking and table locking.
Question 14
Answer
Question 14
In 8085 microprocessor READY signal does.which of the following is incorrect statements
a) It is input to the microprocessor
b) It sequences the instructions
c) It sequences the ouput of the microprocessor
d) None
Answer
b) It sequences the instructions
Question 15
Answer
Question 15
Virtual memory size depends on
a) address lines
b) data bus
c) disc space
d) a & c
Answer
a) address lines
Also Checkout