Introduction To Database Questions and Answers

Q: Which command is the fastest among the following ?

The fastest of the four is COPY STRUCTURE TO <NEW FILE>.It copies only the structure of the table, that is the field names, types and widths, and no records, so it has the least data to write. COPY TO <NEW FILE> (A) copies the whole table with all its records, COPY FILE (C) copies the full file at the operating system level, and COPY TO ... DELIMITED (D) copies every record and converts it into a text file, so the last is the slowest. The time taken rises with the amount of data written.

Q: Which are the two ways in which entities can participate in a relationship?

Correct answer: Total and partialParticipation is total when every entity of the set must take part in the relationship - every loan must have a borrower - and partial when only some need to. In an E-R diagram total participation is drawn with a double line.

Q: Microsoft Access is an enterprise-class database product.

Correct answer: FalseAccess is a personal or workgroup product: it bundles a small DBMS with an application generator in a single file, which suits one user or a handful. Enterprise-class products - SQL Server, DB2, Oracle - run as separate servers and are built for many concurrent users, large volumes and serious administration.

Q: Conceptual design

Correct answer: Involves modelling independent of the DBMSConceptual design captures what the organisation needs to record - entities, attributes and relationships - without reference to any particular product. Choosing tables and types is logical design, and sizing and tuning belong to physical design; keeping them separate is what lets the same conceptual model be implemented on any DBMS.

Q: The relational database model was created by E.F. Codd.

Correct answer: TrueE. F. Codd, at IBM, set out the relational model in his 1970 paper “A Relational Model of Data for Large Shared Data Banks”. It replaced navigation through pointers with operations on sets of tuples, and every relational product since rests on it.

11.

In DML, RECONNCT command cannot be used with

A.OPTIONAL Set
B.FIXED Set
C.MANDATOR Set
D.All of the above

Exam Year(s)

UGC NET - 2012,

Answer: B

In the CODASYL DML the RECONNECT command moves a member record from one set occurrence to another, and it cannot be used with a FIXED set, because in a FIXED retention class a member cannot be removed from its owner once it has been connected.

OPTIONAL set membership allows a member to be disconnected and reconnected, and MANDATORY allows it to be moved to another owner but not to be left unconnected, so RECONNECT works with these. So 'All of the above' is wrong.

Discuss in Forum

12.

The User Work Area (UWA) is a set of Program variables declared in the host program to communicate the contents of individual records between

A.DBMS & the Host record
B.Host program and Host record
C.Host program and DBMS
D.Host program and Host language

Exam Year(s)

UGC NET - 2012,

Answer: C

The User Work Area (UWA) is a set of program variables declared in the host program, used to exchange the contents of individual records between the host program and the DBMS. When a record is read the DBMS places its values in the UWA, and when a record is stored the program places them there.

It does not carry data between the DBMS and a 'host record', nor between the host program and a host record or the host language, since the host program and DBMS are the two sides that communicate through it.

Discuss in Forum

13.

Which level of Abstraction describes how data are stored in the data base ?

A.Physical level
B.View level
C.Abstraction level
D.Logical level

Exam Year(s)

UGC NET - 2012,

Answer: A

The physical level of abstraction describes how the data are actually stored in the data base, in terms of files, blocks and index structures. The logical level describes what data are stored and the relationships among them, and the view level describes only the part of the data base that a user sees. 'Abstraction level' is not one of the three levels. The keyed answer is the physical level.

Discuss in Forum

14.

What deletes the entire file except the file structure ?

A.ERASE
B.DELETE
C.ZAP
D.PACK

Exam Year(s)

UGC NET - 2012,

Answer: C

The command that deletes all the records but keeps the file structure is ZAP.

In dBase and FoxPro, ZAP removes every record from the open table at once and leaves the empty structure in place, with no way back. DELETE (B) only marks records for deletion, PACK (D) then removes the marked records, and ERASE (A) deletes the whole file from the disk, structure included.

Discuss in Forum

15.

Which command is the fastest among the following ?

A.COPY TO \(\lt\)NEW FILE\(\gt\)
B.COPY STRUCTURE TO \(\lt\)NEW FILE\(\gt\)
C.COPY FILE \(\lt\)FILE 1\(\gt\) \(\lt\)FILE 2\(\gt\)
D.COPY TO MFILE-DAT DELIMITED

Exam Year(s)

UGC NET - 2012,

Answer: B

The fastest of the four is COPY STRUCTURE TO <NEW FILE>.

It copies only the structure of the table, that is the field names, types and widths, and no records, so it has the least data to write. COPY TO <NEW FILE> (A) copies the whole table with all its records, COPY FILE (C) copies the full file at the operating system level, and COPY TO ... DELIMITED (D) copies every record and converts it into a text file, so the last is the slowest. The time taken rises with the amount of data written.

Discuss in Forum

16.

Which level of Abstraction describes what data are stored in the Database ?

A.Physical level
B.View level
C.Abstraction level
D.Logical level

Exam Year(s)

UGC NET - 2012,

Answer: D

The three levels of abstraction in a database are the physical level, which describes how the data are stored, the logical level, which describes what data are stored and the relationships among them, and the view level, which describes the part of the database one user group sees. The question asks which level describes what data are stored, so it is the logical level, option (D). The physical level describes how, not what, and 'abstraction level' is not one of the levels.

Discuss in Forum

17.

Which are the two ways in which entities can participate in a relationship?

A.Passive and active
B.Total and partial
C.Simple and Complex
D.All of the above

Answer: B

Correct answer: Total and partial

Participation is total when every entity of the set must take part in the relationship - every loan must have a borrower - and partial when only some need to. In an E-R diagram total participation is drawn with a double line.

Discuss in Forum

18.

Microsoft Access is an enterprise-class database product.

A.True
B.False
C.None of the Above.
D.All of the Above.

Answer: B

Correct answer: False

Access is a personal or workgroup product: it bundles a small DBMS with an application generator in a single file, which suits one user or a handful. Enterprise-class products - SQL Server, DB2, Oracle - run as separate servers and are built for many concurrent users, large volumes and serious administration.

Discuss in Forum

19.

Conceptual design

A.Is a documentation technique.
B.Needs data volume and processing frequencies to determine the size of the database.
C.Involves modelling independent of the DBMS
D.Is designing the relational model.

Answer: C

Correct answer: Involves modelling independent of the DBMS

Conceptual design captures what the organisation needs to record - entities, attributes and relationships - without reference to any particular product. Choosing tables and types is logical design, and sizing and tuning belong to physical design; keeping them separate is what lets the same conceptual model be implemented on any DBMS.

Discuss in Forum

20.

The relational database model was created by E.F. Codd.

A.True
B.False
C. None of the Above.
D.All of the Above.

Answer: A

Correct answer: True

E. F. Codd, at IBM, set out the relational model in his 1970 paper “A Relational Model of Data for Large Shared Data Banks”. It replaced navigation through pointers with operations on sets of tuples, and every relational product since rests on it.

Discuss in Forum

Loading…

Topics

Other Subjects

Tags: Introduction To Database Questions and Answers || Introduction To Database MCQ Questions and Answers || Introduction To Database GK Questions and Answers || Introduction To Database GK MCQ Questions || Introduction To Database Multiple Choice Questions and Answers || Introduction To Database GK || GK on Introduction To Database || Database Questions and Answers || Database MCQ Questions and Answers || Database GK Questions and Answers || GK on Database

Introduction To Database Questions and Answers

Topics

Other Subjects

About Us

Stay informed about all important Dates & Notifications