Q1. What does DBMS stand for?
(a) Data Management System
(b) Database Management System
(c) Database Management Server
(d) Database Maintenance Server
(e) Data Management Server
Q2. Which of the following diagrams graphically represents an inter-relationship among entities in a database?
(a) Entity-relationship diagram
(b) Data flow diagram
(c) Control flow diagram
(d) Sequence diagram
(e) None of these
Q3. Which of the following keys is a field in one table that is used as a primary key field in another table?
(a) Primary key
(b) Foreign key
(c) Candidate key
(d) Identity key
(e) None of these
Q4. By what name are two or more fields of a database table called when they are collectively used to specify the primary key?
(a) Composite key
(b) Primary key
(c) Foreign key
(d) Candidate key
(e) Identity key
Q5. A database table has two fields or columns that can be selected as the primary key. The first field or column will always be considered as the primary key, and the second field or column is called the _____________.
(a) Primary key
(b) Candidate key
(c) Composite key
(d) Foreign key
(e) Identity key
Q6. Which of the following is not a normal form in DBMS?
(a) First Normal Form (1NF)
(b) Second Normal Form (2NF)
(c) Third Normal Form (3NF)
(d) Ninth Normal For (9NF)
(e) Boyce-Codd Normal Form (BCNF)
Q7. Which of the following correctly describes the use of an interpreter?
(a) Convert small processes into smaller processes
(b) Convert high-level language into low-level language
(c) Convert low-level language into high-level language
(d) Manages the kernel and shell communication
(e) None of these
Q8. Which of the following statements is incorrect about the UNIQUE KEY constraint?
(a) Unique key columns do not accept duplicate values.
(b) One table can have only one unique key.
(c) By default, unique key columns accept null values unless the NOT NULL constraint is specified.
(d) The same combinations of columns should not make both unique and primary keys.
(e) None of these
Q9. Which of the following heading elements displays text with the same size as the normal text written in an HTML document?
(a) <H1>
(b) <H2>
(c) <H3>
(d) <H4>
(e) <H5>
Q10. Which of the following HTML tags is a logical style tag?
(a) <B>
(b) <I>
(c) <SMALL>
(d) <ABBR>
(e) None of these
Q11. What does DDoS stand for?
(a) Data Denial-of-Service
(b) Distributed Denial-of-Service
(c) Distributed Data of Server
(d) Distribution of Data Service
(e) None of these
Q12. Which of the following statements is incorrect about a message-switched network?
(a) It reduces traffic congestion.
(b) It allows prioritizing of messages.
(c) It allows broadcasting of messages.
(d) It is an inexpensive network.
(e) It is not compatible with videoconferencing.
Q13. Which of the following statements is false in the context of client/server network?
(a) It is expensive to set up.
(b) It requires a specialized server.
(c) It is a slow network.
(d) It is highly secure.
(e) It is a congested network.
Q14. A pathway inside a computer that carries data between hardware components is called _____________.
(a) carrier signal
(b) data bus
(c) digital signal
(d) analog signal
(e) switching
Q15. Which of the following is related to simplex communication?
(a) Single wire and two-sided communication
(b) Television
(c) Two-wire communication
(d) Walkie-talkie
(e) None of these
Solutions
S1. Ans.(b)
Sol. Database Management System (DBMS) is a software application that can be used to create and maintain databases for various types of organizations. Some widespread DBMS applications are Microsoft SQL Server, Oracle, MySQL and Microsoft Access.
S2. Ans.(a)
Sol. A relationship is an association among entities. We can use the Entity-Relationship Diagram (ERD) to represent an inter-relationship between the entities of a database.
S3. Ans.(b)
Sol. Foreign key is a field in one table that is used as the primary key in another table. Whenever a relationship is created between two tables, a common field acts as the primary key in the first table and the foreign key in the second table.
S4. Ans.(a)
Sol. Composite key is formed when two or more fields of a database table are combined together in order to uniquely identify the records stored in the table.
S5. Ans.(b)
Sol. If a table has more than one field that can be selected as the primary key, the field that is not selected as the primary key is called a candidate key.
S6. Ans.(d)
Sol. In DBMS, the commonly used normal forms are 1NF, 2NF, 3NF and BCNF.
S7. Ans.(b)
Sol. The interpreter is a computer program that helps in executing programs written in high-level languages without the need to compile them first.
S8. Ans.(b)
Sol. Since one table can have at the most one primary key to avoid duplicates in other columns of the table, unique key can be defined. We can make one or more unique keys in a single table.
S9. Ans.(d)
Sol. The text written within the H4 element has the same size as the normal plain text, whereas the text written within the H1, H2 and H3 elements are larger than the normal text. Text written within the H5 and H6 elements has smaller size than the normal text.
S10. Ans.(d)
Sol. In HTML, logical style tags specify that the enclosed text has a specific meaning, context, or usage. The <ABBR> is a logical style tag, which conveys to the Web browser that the text enclosed within this tag is an abbreviation.
S11. Ans.(b)
Sol. Distributed Denial-of-Service (DDoS) attack is a type of attack that is carried out by using multiple computers. These DDoS attacks aim at targeting computer networks of an organisation, such as Digital Subscriber Line (DSL) and cable.
S12. Ans.(d)
Sol. In a message-switched network, a packet containing the entire message is transmitted over the network. It is a more expensive network.
S13. Ans.(c)
Sol. The client/server network contains a centralized server that manages and controls all the other nodes of the network. It is expensive as it requires NOS and a specialized server system. It is highly secure and prossesses good speed. However, it becomes congested when more clients simultaneously request for a service to the server.
S14. Ans.(b)
Sol. A data bus connects internal components to the motherboard and acts as a carrier for the data.
S15. Ans.(b)
Sol. Television is an example of simplex communication.
For more Updates & Notifications for bank exams like SBI PO, SBI CLERK, IBPS PO, IBPS RRB, IBPS CLERK, IBPS SO, NIACL, SSC CHSL, SSC CGL etc. like our facebook page at :
0 comments:
Post a Comment