Thursday, 23 March 2017


Q1. Which of the following hardware components is the most important to the operation of a database management system?
(a) High-resolution video display
(b) Printer
(c) High speed, large-capacity disk
(d) Plotter
(e) Mouse

Q2. Database management systems are intended to:
(a) eliminate data redundancy
(b) establish relationships among different records in different files
(c) manage file access
(d) maintain data integrity
(e) all of the above

Q3. A banking system consists of user accounts, money transfers, withdrawal, deposits, etc.
These all represent tables or entities that can be manipulated with SQL. What is full form of SQL?
(a) Shortcut query language
(b) Structured query language
(c) Simple query language
(d) Sorted query language
(e) None of the above

Q4. Which of the following gives a logical structure of the database graphically?
(a) Entity-relationship diagram
(b) Entity diagram
(c) Database diagram
(d) Architectural representation
(e) None of the above

Q5. Legacy systems are one of the biggest barriers keeping banks from imitating the digital experiences. Which of the following should come under these systems?
(a) Bit coins
(b) Block chain
(c) Crypto currency
(d) Artificial Intelligence
(e) Stand alone Computers

Q6. Big Data and Analytics can be effective in collecting information about financial fraud. Which of the following is a characteristics of Big data?
(a) Volume
(b) Variety
(c) Velocity
(d) Veracity
(e) All of the above

Q7. Siri, Cortana, Alexa become hugely popular in this decade.Which of the following are related technology?
(a) Artificial Intelligence
(b) Robotics
(c) Cloud Technology
(d) Reality 4D
(e) All of the above

Q8. Data mining evolves as a mechanism to cater the limitation of ____ systems to deal massive data sets with high dimensionality, new data type, multiple heterogeneous data resource etc.
(a) OLTP
(b) OLAP
(c) DSS
(d) DWH
(e) None of these

Q9. Which type of the following is used to for controlling, monitoring, or assisting the operation of equipment?
(a) Business software
(b) Embedded Software
(c) Personal/Entertainment Software
(d) System Software
(e) None of these

Q10. Which of the following is not a DBMS?
(e) None of the above

Q11. SQL can be used to:
(a) Create database structures only.
(b) Query database data only.
(c) Modify database data only.
(d) All of the above
(e) none of the above

Q12.Bluetooth makes use of Personal Area Network for wireless communication using Frequency hoping spread spectrum. Bluetooth supports –
(a) Point to point connections
(b) Point to Multipoint connection
(c) Both  (a) and (b)
(d) None of the  above
(e) Multipoint to point connection

Q13.Where it is likely to find an embedded operating system?
(a) Distributed PC
(b) Mainframe
(c) Networked pc
(d) On a PDA
(e) On a operating system

Q14.Software programs that close potential security breaches in an operating system :
(a) Refresh patches
(b) Security breach fixes
(c) Security patches
(d) Fresh patches
(e) Security repairs

Q15.The _______ translates internet domain and host names to IP address.
(a) DNS
(b) Routing Information Protocol
(c) Network Time Protocol
(d) Internet Relay chat
(e) File transfer protocol

S1. Ans.(c)
Sol. Database is stored in high capacity disc.

S2. Ans.(e)
Sol. All of the above  are objective of DBMS.

S3. Ans.(b)
Sol. Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems.

S4. Ans.(a)
Sol. An entity relationship model, also called an entity-relationship (ER) diagram, is a graphical representation of entities and their relationships to each other, typically used in computing in regard to the organization of data within databases or information systems.

S5. Ans.(e)
Sol. A desktop or laptop computer that is used on its own without requiring a connection to a local area network (LAN) or wide area network (WAN). Although it may be connected to a network, it is still a stand-alone PC as long as the network connection is not mandatory for its general use.

S6. Ans.(e)
Sol. The data that is provided by banks can be easily analyzed to find out if there is unusual activity in currency flow at an end point or the person using the currency, no matter whether it is happening at individual or regional level.

S7. Ans.(a)
Sol. Speech recognition (SR) is the inter-disciplinary sub-field of Artificial Intelligence.

S8. Ans.(d)
Sol. Data mining automates the process of finding predictive information in large databases.

S9. Ans.(b)
Sol. Embedded software is computer software, written to control machines or devices that are not typically thought of as computers. It is typically specialized for the particular hardware that it runs on and has time and memory constraints.

S10. Ans.(e)
Sol. SQL SERVER and MS ACCESS is Microsoft's DBMS to take on rivals Oracle.

S11. Ans.(d)
Sol. SQL (Structured Query Language) is a standard interactive and programming language for getting information from and updating a database. Although SQL is both an ANSI and an ISO standard, many database products support SQL with proprietary extensions to the standard language.

S12. Ans.(c)
Sol. The Bluetooth system supports both point-to-point and point-to-multi-point connections

S13. Ans.(d)
Sol. These operating systems are designed to be compact, efficient at resource usage, and reliable.

S14. Ans.(c)
Sol. A patch is a piece of software designed to update a computer program or its supporting data, to fix or improve it.

S15. Ans.(a)
Sol. The Domain Name System (DNS) is a hierarchical decentralized naming system for computers, services, or any resource connected to the Internet or a private network. It associates various information with domain names assigned to each of the participating entities.