Q1. DBMS is a set of programs, which allows a DBA to:
(a) maintain a database
(b) connect to an application
(c) create an application
(d) create data
(e) None of these
Show Answer
S1. Ans.(a)
Sol. A Database Management System (DBMS) allows a database administrator to maintain a database, which includes various operations, such as creating a database, deleting it, creating tables, and updating records in the database tables.
Q2. Which of the following is not a database type?
(a) Flat-file database
(b) Relational database
(c) Distributed database
(d) Simple database
(e) None of these
Show Answer
S2. Ans.(d)
Sol. Depending on the pattern in which data is stored, databases are classified into three types, namely flat-file database, relational database, and distributed database.
Q3.IBM was provided software for PC DOS by which of the following company?
(a) Microsoft
(b) Sony
(c) Google
(d) Apple
(e) None of the above
Show Answer
S3. Ans.(a)
Sol. Microsoft provided Operating System to IBM PC DOS.
Q4. Which of the following was used to program the first computer?
(a) Assembly language
(b) Machine language
(c) Source code
(d) Object code
(e) ASCII code
Show Answer
S4. Ans.(b)
Sol. Earliest computers used Machine language.
Q5.Charles Babbage is known to have conceived which of the following earliest Computing machine?
(a) Analytical engine
(b) ENIAC
(c) UNIVAC
(d) All of the above
(e) None of the above
Show Answer
S5. Ans.(a)
Sol. The Analytical Engine was a proposed mechanical general-purpose computer designed by English mathematician and computer pioneer Charles Babbage. It was first described in 1837 as the successor to Babbage's difference engine, a design for a mechanical computer.
Q6.In second generation, which type of primary memory was used to store data?
(a) Paper tapes
(b) IC
(c) Magnetic core
(d) Magnetic tape
(e) Magnetic disk
Show Answer
S6. Ans.(c)
Sol. In second generation, magnetic cores were used as primary memory. In this generation assembly language and high-level programming languages like FORTRAN, COBOL were used.
Q7. Which of the following entities is called a strong entity?
(a) Entity having foreign key
(b) Entity having primary key
(c) Entity having alternate key
(d) Entity having candidate key
(e) None of these
Show Answer
S7. Ans.(b)
Sol. An entity set containing a primary key is called a strong entity set. A strong entity set has key attributes.
Q8. Which of the following is not a type of SQL statement?
(a) Data manipulation language
(b) Data definition language
(c) Data standard language
(d) Data control language
(e) None of these
Show Answer
S8. Ans.(c)
Sol. Common categories of SQL statements include DML, DCL, DDL, TCL, etc. DDL statements are used to define a database structure, DML statements are used for the management of data within database objects and DCL statements are used for setting privileges to access data.
Q9. Which of the following characteristics is used to compute dynamically the results from Excel data?
(a) Go to
(b) Table
(c) Chart
(d) Diagram
(e) Formula and Function
Show Answer
S9. Ans. (e)
Sol. Functions are predefined formulas and are already available in Excel. They are used to compute dynamically the results from Excel data
Q10. =Sum (S3 : S10) is an example of a
(a) function
(b) formula
(c) cell address
(d) value
(e) None of these
Show Answer
S10. Ans. (b)
Sol. It is a formula to get sum of the data from cell number S3 to S10.
No comments:
Post a Comment