SST Past Paper SPSC Science Category 2024 – Morning/Evening

With which network type will OSPF establish route adjacencies but not perform the DR/BDR election process?

1. Point-to-point
2. Backbone area 0
3. Broadcast multi-access
4. Non-broadcast multi-access

The HAVING clause does which of the following?

1. Acts like a WHERE clause but is used for groups rather than rows
2. Acts like a WHERE clause but is used for columns rather than groups
3. Acts EXACTLY like a WHERE clause
4. Acts like a clause but is used for rows rather than columns

The context in which the privilege “CREATE TABLESPACE” applies in?

1. Views
2. Tables
3. Stored routines
4. Server administration

What is the primary purpose of data pipeline in data modeling?

1. To visualize data relationships
2. To calculate summary statistics
3. To define data attributes and properties
4. To prepare and transform data for analysis

Business Intelligence (BI) reporting system cannot do which of the following?

1. Filter data
2. Group data
3. Modify data
4. Both filter and group data

Phenomena in which signal transmitted in one circuit creates undesired effect in other circuit is known as?

1. Crosstalk
2. Signal attenuation
3. Sampling
4. Cross linking

The SI unit of magnetic flux is?

1. Reluctance
2. Resistance
3. Permeance
4. Weber

Force due to magnetic field and velocity is?

1. At right angles to each other
2. At acute angles with each other
3. At obtuse angle with each other
4. Anti parallel to each other

Force on a moving charge in a uniform magnetic field depends upon?

1. Magnetic flux density
2. The charge on the particle
3. The speed of particle
4. All of the above

The clouds float in atmosphere because of?

1. Low Temperature
2. Low Velocity
3. Low Pressure
4. Less Density