Introduction To Database System(Engineering > Computer Science And Engineering > Database System ) Questions and answers for exam Preparation

Question 1. A report generator is used to

data entry
all of the listed here
update files
print files on paper

Explanation:-

Answer: Option D. -> print files on paper

Question 2. Each of data files has a _____ that describe the way the data is stored in the file.

Records
Fields
File structure
Database

Explanation:-

Answer: Option C. -> File structure

Question 3. Which of the following is a database administrator's function?

All of the listed here
backing up the database
database design
performance monitoring

Explanation:-

Answer: Option A. -> All of the listed here

Question 4. Which of the following is not a logical data-base structure?

network
relational
chain
tree

Explanation:-

Answer: Option C. -> chain

Question 5. Primitive operations common to all record management systems include

Look-up
Print
Sort
All of the listed here

Explanation:-

Answer: Option A. -> Look-up

Question 6. Periodically adding, changing and deleting file records is called file

upgrading
restructuring
Updating
renewing

Explanation:-

Answer: Option C. -> Updating

Question 7. After you _____ a record, many data management the environments require you to issue a command to save the changes you made.

Delete
Sort key
Update
Index

Explanation:-

Answer: Option C. -> Update

Question 8. In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?

COMMIT
SAVE
ZIP
PACK

Explanation:-

Answer: Option A. -> COMMIT

Question 9. What is the language used by most of the DBMSs for helping their users to access data?

SQL
4GL
Query language
High level language

Explanation:-

Answer: Option C. -> Query language

Question 10. Data item characteristics that are important in data management include

language
width
punctuation
spelling

Explanation:-

Answer: Option B. -> width