151. A 100 km long cable runs at the T1 data rate. The propagation speed in the cable is half the speed of light. How many bits is in the cable ?
A. 572
B. 672
C. 772
D. 873

152. How much bandwidth is there in 0.1 micron of spectrum at a wavelength of 1 micron ?
A. 20,000 GHz
B. 25,000 GHz
C. 30,000 GHz
D. None of these

153. Select the right statement to insert values to the student table.
A. INSERT student VALUES (
B. INSERT VALUES (
C. INSERT INTO student VALUES (
D. INSERT VALUES INTO student (

154. …………. joins two or more tables based on a specified column value not equaling a specified column value in another table.
A. EQUIJOIN
B. NON-EQUIJOIN
C. OUTER JOIN
D. NATURAL JOIN

155. In SQL, which command is used to change a table’s storage characteristics?
A. ALTER TABLE
B. MODIFY TABLE
C. CHANGE TABLE
D. None of these

156. In SQL, which of the following is not a data definition language commands?
A. REVOKE
B. RENAME
C. UPDATE
D. GRANT

157. ‘AS’ clause is used in SQL for
A. Selection operation.
B. Rename operation.
C. Join operation.
D. Projection operation.

158. Count function in SQL returns the number of
A. values.
B. distinct values.
C. groups.
D. columns.

159. Which of the following is a valid SQL type?
A. CHARACTER
B. NUMERIC
C. FLOAT
D. All of the above

160. NULL is
A. the same as 0 for integer
B. the same as blank for character
C. the same as 0 for integer and blank for character
D. not a value

Leave a Reply