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