Microprocessor

1. How many bytes does a computer that has a 32k memory represent?
K=1024
32*1024
32768

Questions from Hard Disk

1.A hard disk divide iniot tracks which are furthert subdivieded in
Ans: Sectors
2.The tracks on a disk which can be accessed without repositioning the R/W head is
Ans: Cylinder
3.FAT
Ans: File Allocation Table
4.The average time is required to reach a storage location memory and obtain its content is called
Ans:  Access time.
5.In magnetic disks data is organized in concentric set of rings is called
Ans Track
6.The average time necessary for the correct sector of a disk to arrive at the read write head is 
Ans:Rotational Delay 

Question From Database Kerala PSC Computer Science

1.A function that has no partial functional dependencies is in ------------------ form

 Ans : 2nd  normal Form

First Normal Form –singled valued attribute.

That means it allows only one value in an attribute 

For eg : phone number of a patient. He/she may have 2 phone numbers one is Jio number and other is BSNL . so we will store it as multiple records .

A relation is in 2NF if it has No Partial Dependency

Explanation: 2 NF should satisfy 1 st normal form . 

and there it should not satisfy partial dependency 

2. Minimal super key is Candidate key
  {Repeated Question Kerala PSC}

3. A relation schema R is in ------------, if whenever a nontrivial functional dependency X->A holds in R, Then  X is a super key of R
Ans  BCNF
{Repeated Question Kerala PSC}
https://www.geeksforgeeks.org/database-normalization-normal-forms/

4. Which of the following is true for Atomicity ?
A: Smallest unit of transaction
B:Either all of its operations are executed or none
C:Atleast one of the operations should be executed
D:None of the above
Answer is B:Either all of its operations are executed or none
 (Kerala PSC System analyst post 2019)
Explanation : To maintain consistency in transaction DBMS Follows ACID properties.
in Acid property first one is Atomicity it means ALL or Nothing Rule . 
For Eg: Bank Transaction
5. The Sql aggregate function that returns no of values in a given column is
(Question asked for Kerala PSC System Analyst Post 2019)
A.Count()
B.count(*)
C.Sum()
D.All of the above
Ans is :Option A :Count()
explanation : if want to fetch the repeated visit of a patient we can query
SELECT count(hospitalno),hospitalno FROM table name  group by hospitalno;
Result will be:
Count and patient id

1	2009485
2	2009668
2	2010131
1	2011869
3	2011912

6. Consider a relation A with m rows and relation B with n rows. How many rows will be generated if AXB is performed?
A.m
B.m+n
C.m-n
D.m*n
Ans is m*n
Explanation
7. The command used to add a column in table
  Question from Instructor VHSE 2015
A. Add
B. Update
C. Alter
D. Add
Ans : Alter
Explanation: Alter is Data Definition Language (DDL)
8.In SQL, which command is used to make permenant change in database
Question from Instructor VHSE 2015
A. Save
B. Exit
C. Done
D. Commit
Ans: D, Commit
9. What is tuple in dbms?
Question from Instructor VHSE 2015
A. Number of tables
B. Number of rows
C. Number of columns
D. Number of database
Ans: B. Number of rows
Explanation : Tuple is record
10.Foreign key is
Question from Instructor VHSE 2015
A. Primary key of another table
B. Primary key of the same table
C. Any column other than primary key of another table
D. Any column other than primary key of same table
Ans: A. Primary key of another table

Computer Science Repeating Questions

1.Firmware is
Ans. Software on hardware
2. Routing performed in which layer of OSI model
(Question from computer networks)
Ans. Routing in network layer
3. The operation which is commutative but not associative.
(Question from Digital electronics)
(GATE and PSC Cat No: 72/2014)
Ans. NAND
Explanation : Every logic gate is commutative (AND,OR, EXOR, EXNOR but not associative)
Associatve are NAND ,NOR)
4. SNMP is prootcol used for
Ans. Network Management
Explanation : SNMP (Simple network management protocol)
5. the average time necessary for the correct sector of a disk to arrive at the read write head is
Ans. Rotational Delay
6.What is the post fix form of the following expression
A+(B*C-(D/E∧F)*G)*H
A)ABC*DEF∧/G*-H*+
Explantion: Refer https://www.youtube.com/watch?v=EE2me3EPMzA
7. Which of the following is the minima super key?
A. Candicate Key
B. Super Key
C. Primary Key
D. None
Ans: Option a Candidate key
Reffer:  https://www.geeksforgeeks.org/dbms-keys-candidate-super-primary-alternate-and-foreign/
8. FPI Stands for
And Frames Per Inch
9. Which of the following logic families is well suited for high speed operation
A. TTL
B. MOS
C. ECL
D. CMOS
Ans. Option D  CMOS( have low power and high speed )

10. The tag used to link one page to another page(Programmer KPSC 2015)

Ans. <a>

11. If x and y are real number then max (X,Y)+ min(X,Y) is equal to (Programmer KPSC 2015)

Ans. X+Y

Explanation 

Take 2 numbers (6, 5)

Max(X,Y)=Max(6,5)

Max=6

Min(X,Y)=Min(6,5)

Min=5

∴Max (X,Y)+ Min(X,Y)=6+5