IBPS/SBI SO – IT Officer 2017 – Important Mock Interview questions
prepared by Mr.L.R.Kumar IT Security Consultant
-
What is FATCA?
-
Who is impacted by FATCA?
-
Overview of FATCA?
-
Date of effect of FATCA?
-
What is FRMB Act, 2003?
-
What is FRMB Act, 2003?
-
What is CAPTCHA?
-
What is reCAPTCHA?
-
What is NFC?
-
What is a packet-filtering firewalls?
-
What is a dual-homed Host Firewall?
-
What is CSMA/CD? IEE – 802.3 Standard
-
What is CSMA/CA? IEE-802.11 Standard
-
Explain about Authentication Protocols?
-
What is ARP?
-
What is RARP?
-
What is ICMP?
-
What is Digital Signature and whether it protects Confidentiality?
-
What is DHCP?
-
How many DHCP packets are exchanged between client and server?
-
Why does Active FTP not work with Network Firewalls?
-
Which feature on a network switch can be used to prevent rogue DHCP servers?
-
Name one secure network protocol which can be used instead of telnet to manage a router ?
-
Provides a reason as to why HTTPS should be used instead of HTTP?
-
How can you prevent a brute force attack on a windows login page?
-
Which protocol on HTTPS uses as the transport layer for sending and receiving data?
-
What is NAT?
-
Name one instance where static NAT is used in a real world deployment?
-
Why does Active FTP not work with NAT in an internet environment?
-
How many times can NAT can be applied on a packet before it reaches the destination?
-
Give a good reason as to why a NAT router is preferred over a Proxy for sharing internet connection?
-
Does TCP checksum change after NAT is applied?
-
What is a protocol?
-
Can you explain the OSI layers?
-
What are the types of dialogs between two communication entities?
-
Can you explain what an IP address is ?
-
How many IP addresses are there in IPv4?
-
What is Unicast IP address?
-
What is Multicast IP address?
-
Why do we need class and how many different types of class exists?
-
How many network ID and host ID are there in each class?
-
What are common setting with regard to IP Address?
-
What is a Classful and Classless IP Addresses?
-
Why subnetting is required?
-
Can you explain what is supernetting?
-
What is routing?
-
What is Static routing?
-
What is Dynamic routing?
-
What is a Firewall?
-
What are different types of firewalls?
-
What is DNS?
-
What is spamming?
-
What is a Role Based Access Control – RBAC?
-
What are the three principles of Identification and Authentication?
-
Background Checks are Administrative type of control
-
What is DAC – Discretionary Access Control?
-
What are the centralized authentication process?
-
What is MAC – Mandatory Access Control?
-
What is spoofing?
-
What are Cost of Software Engineering?
-
What are the type of Architecture available?
-
What is Remote Journaling?
-
What is Database Shadowing?
-
What is a Warm Site?
-
What is a Cold Site?
-
What is stegnography?
-
What is a SSL?
-
What is IpSec?
-
What is Internet Telephony?
-
What are the protocol used in email?
-
What is IPv6 and its advantages?
-
What is a cognitive password?
-
What is a QR Code?
-
What is a Digital Signature and its advantages?
-
What are the methods of attaining CIA to a message?
-
What is the difference between Digital Signature & Digital Certificate?
-
What are the steps involved in Database Startup?
-
What is a Log Switch?
-
What is on-line redo log?
-
What are the different types of Shutdown available?
-
What are the advantages of operating a database in ARCHIVELOG mode over operating it on NO-ARCHIVELOG mode?
-
What are the components of logical database structure of oracle database?
-
What is a Data Dictionary?
-
What is a Data File?
-
Can an integrity constraint be enforced on a table if some existing table data does not satisfy the constraint?
-
Can Objects of the same schema reside in different tablespace?
-
What is self-referential integrity constraint?
-
What are the different type of integrity constraint supported by oracle?
-
What is a System Tablespace?
-
Do view contains data?
-
What is the maximum number of Check constraints that can be defined on a column?
-
What is the difference between UNIQUE constraint and PRIMARY KEY constraint?
-
What is a rollback segment?
-
What is row chaining?
-
What are the different types of Segments?
-
What is an index?
-
What does COMMIT do?
-
Define a Transaction?
-
What is a Save Point?
-
What does a rollback do?
-
Different types of table joins?
-
What are roles? How can we implement roles?
-
Difference between DBMS and RDBMS?
