Free Database Systems MCQs with Answers
49 Database Systems MCQs from Software Engineering, each with the correct answer and a written explanation of why it is correct. Free and unlimited, with no account needed.
Last updated
49 questions · page 1 of 3
- A. DML(Data Manipulation Langauge)
- B. DDL(Data Definition Langauge)
- C. Query
- D. Relational Schema
Explanation: DDL defines database structures such as relations and schemas, and includes commands for creating, altering, and deleting them.
Correct answer: DDL(Data Definition Langauge)- A. Manual, electronic
- B. Electronic, manual
- C. Transforming
- D. None of the above
Explanation: Manual processing includes physically duplicating, sorting, and filing data.
Correct answer: Manual, electronic3. ___________ systems help to a analyze historical and current data either on demand or periodically?
- A. Data access system
- B. Data analysis system
- C. Fore cast-oriented data analysis system
- D. System based on accounting models
Explanation: A data analysis system examines stored historical data and current data either when requested or at scheduled intervals.
Correct answer: Data analysis system- A. external report
- B. summary report
- C. detailed report
- D. exception report
Explanation: A summary report presents grouped totals rather than listing each student's individual record; grade counts by A, B, C, D, and F are…
Correct answer: summary report- A. database management system
- B. decision support system
- C. expert system
- D. management information system
Explanation: A DBMS is a software tool for managing data, whereas MIS, DSS, and expert systems are commonly classified as information-system…
Correct answer: database management system- A. information to data to knowledge
- B. knowledge to data to information
- C. data to knowledge to information
- D. data to information to knowledge Engineering & Technology
Explanation: Data is first processed into information, and information is then interpreted to produce knowledge.
Correct answer: data to information to knowledge Engineering & Technology- A. Similar
- B. Different
- C. Complementary
- D. None of these
Explanation: Humans and computers are complementary: computers can filter and store large volumes of data quickly, while humans provide judgment…
Correct answer: Complementary- A. data hidden
- B. data display
- C. data processing
- D. data transfer
Explanation: Encryption converts readable data into an encoded form so unauthorized parties cannot understand it during transmission.
Correct answer: data transfer- A. information system
- B. Knowledge system
- C. Database system
- D. Computer system
Explanation: An information system combines processes and procedures that collect and transform data into useful information and knowledge.
Correct answer: information system- A. created in XML
- B. structured information
- C. normal information
- D. unstructured information
Explanation: Most Internet content is unstructured, such as free-form text, images, audio, and video, rather than data arranged in a fixed schema.
Correct answer: unstructured information11. Which of the following reports presents information with little or no filtering or restrictions ?
- A. non-filtered
- B. summary
- C. external
- D. none of the above
Explanation: A report showing information with little or no filtering is normally called a detailed report, but that option is missing.
Correct answer: none of the above- A. detailed report
- B. summary report
- C. exception report
- D. external report Civil Engineering
Explanation: An exception report identifies records that meet an unusual or specially defined condition, such as customers who bought only one product.
Correct answer: exception report- A. is a discipline limited to digitised paper documents.
- B. is a discipline limited to library books.
- C. is a discipline limited to paper documents.
- D. none of the above
Explanation: Records management covers the controlled creation, storage, retrieval, retention, and disposal of records in many formats, including…
Correct answer: none of the above- A. java.util.Date
- B. java.util.Time
- C. java.sql.Time
- D. None of above
Explanation: `java.sql.Timestamp` is a date-and-time type that extends `java.util.Date`, adding nanosecond precision for SQL timestamps.
Correct answer: java.util.Date- A. Singlethreaded
- B. Multithreaded
- C. Both of above
- D. None of above
Explanation: The JDBC-ODBC bridge driver is designed to support multiple threads making database calls, so it is classified as multithreaded.
Correct answer: Multithreaded- A. executeUpdate()
- B. executeQuery()
- C. execute()
- D. None of above
Explanation: JDBC's executeUpdate() is conventionally used for DML operations such as INSERT, UPDATE, and DELETE, and it returns the affected-row…
Correct answer: executeUpdate()- A. int
- B. byte
- C. char
- D. bollean
Explanation: Binary or raw data is commonly represented as a byte array before being read from or uploaded to a database, since each byte stores a unit…
Correct answer: byte- A. Type-1 driver
- B. Type-2 driver
- C. Type-3 driver
- D. Type-4 driver
Explanation: The Type-4 JDBC driver is called the thin driver because it is written entirely in Java and communicates directly with the database…
Correct answer: Type-4 driver- A. 6
- B. 2
- C. 5
- D. 3
Explanation: JDBC defines five isolation levels: NONE, READ_UNCOMMITTED, READ_COMMITTED, REPEATABLE_READ, and SERIALIZABLE.
Correct answer: 5- A. Type-1 driver
- B. Type-2 driver
- C. Type-3 driver
- D. Type-4 driver
Explanation: A Type-4 JDBC driver is written entirely in Java and communicates directly with the database, avoiding native libraries or an intermediate…
Correct answer: Type-4 driverDatabase Systems MCQs: common questions
Are these Database Systems MCQs free?
Yes. All Database Systems MCQs from Software Engineering are free on TestUstad, with unlimited attempts and no account needed. Nothing on this page is a sample or a trial.
How many Database Systems MCQs are on this page?
There are 49 Database Systems MCQs in the Software Engineering bank, shown 20 to a page with the correct answer and an explanation on each.
Does every Database Systems MCQ have an explanation?
Yes. Each Database Systems question shows the correct option and a written explanation of why it is correct, so a wrong answer teaches you something rather than just being marked wrong.
Can I take a timed Database Systems test?
Yes. The practice button on this page starts a free Database Systems test drawn from the Software Engineering bank. It marks each answer instantly, gives you a score at the end, and can be retaken as many times as you like.