DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q241
What are the tasks which database administrators may be called upon to specifically perform?
  • A To enter and/or delete data in the database
  • B Performance monitoring and maintenance
  • C Deciding the Graphical User Interface (GUI) necessary for data entry
  • D Enhancing the SQL queries
Answer: Option B
Q242
Which of the following is an/are incorrect statement(s)?
  • A Seek-time = The time taken to extend/retract the read/write head.
  • B Rotational delay is also called Latency.
  • C Block transfer time is the time to locate and transfer an arbitrary block, given its address.
  • D The seek time and rotational delay when added is equal to Block transfer time.
Answer: Option D
Q243
A data processing system is
  • A a system that uniquely identifies a record in a file.
  • B an automated system, which organizes data to produce information.
  • C information on organized or summarized data.
  • D an automated system for processing the data of an organization.
Answer: Option D
Q244
Which of the following is an/are incorrect statement(s)? a. Pointer
  • A a,b and d
  • B a,b and c
  • C a,b,c and e
  • D a,b,c,d and e
Answer: Option A
Q245
Data transfer time refers to the
  • A amount of time required in transferring data from/to the disk to/from primary memory.
  • B expected time to access a disk address and transfer a block of data.
  • C time required activating a read/write head.
  • D time required for the disk to rotate the sought-for record under the read-write head.
Answer: Option B
Q246
The functions of a database administrator include(s): a. Defining database schema. b. Defining backup and recovery procedures. c. Granting authorization for data access. d. Managing storage structures and access methods.
  • A a,b
  • B b and c
  • C a,b,c and d
  • D a,b,c,
Answer: Option C
Q247
Which of the following statement(s) is/are true related to data, information and databases? a. A database is designed, built and populated with data or information for a specific purpose. b. A list of students who have scored more than fifty can be recognised as a set of data. c. Meta data allow database designers and users to understand what data exist, what the data mean, and their limitations. d. A sales person may include in his database, photographic images of customers and video clip
  • A a,b
  • B a,b and c
  • C c, d
  • D a,c and d
Answer: Option D
Q248
A database management software (DBMS) includes:
  • A Automated tools (CASE) used to design databases and application programs
  • B A software application that is used to define, create, maintain and provide controlled access to user databases.
  • C Application programs that are used to provide information to users.
  • D Database that contains occurrences of logically organised data or information.
Answer: Option B
Q249
Which of the following closely describe the limitations of traditional file processing systems? a. File descriptions of files are stored within each application program that accesses those files. b. A duplication of certain columns of a file used by one department may appear in another file used by another department of the organisation. c. Different application programs used in different departments can easily have inter- program communication to share data. d. Addition of a new attribut
  • A a,b and d
  • B a,b and c
  • C c, d
  • D b,d
Answer: Option A
Q250
In addition to the database management software, the other possible types of software a database system will have are a. languages used for coding user interfaces and application programs. b. presentation software for documenting the design of the database. c. computer-aided software engineering tools (CASE). d. a fourth generation language such as Embedded Structured Query Language.
  • A .) a,c and d
  • B a,b and c
  • C c, d
  • D b,d
Answer: Option A

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test