🗃️ Database MCQs and Exam Questions

Practice 43 approved 🗃️ Database MCQs and exam questions from the 🖥️ Software Engineering subject.

43 solved MCQs

A collection of interrelated files in a computer is _____?Answer: Database Database Use in Android--------?Answer: SQLite A collection of related data is called ______.Answer: database The candidate key that is not selected as primary key is known as _____?Answer: Alternate key In DBMS _____ level is closest to the physical storage.Answer: Internal DBMS stands for ______?Answer: Database Management System A collection of related data is called _____ .Answer: Database Which of the following best describes polymorphism in OOP?Answer: The ability of an object to take on many forms What is the format of entering date into a database while inserting data into it?Answer: ‘YYYY-MM-DD’ What SQL command can be used to delete columns from a table?Answer: ALTER TABLE TableName DROP COLUMN ColumnName What operator tests the column for the absence of data?Answer: IS NULL operator The user IDs can be added or removed using which of the following fixed roles?Answer: db_accessadmin Why the following statement is erroneous? SELECT dept_name, ID, avg (salary) FROM instructor GROUP BY dept_name;Answer: Dept_id should not be used in group by clause Which of the following is not an example of DBMS?Answer: Google In Prototyping______?Answer: 4GLs are used Which of the following is NOT a type of NoSQL database?Answer: Relational How communication is established with MySQL?Answer: SQL The HAVING clause does which of the following?Answer: Acts like a WHERE clause but is used for groups rather than rows During global warming, the percentage of carbon dioxide has ______?Answer: Increased in atmosphere The strictest transaction isolation level provided by SQL Server is?Answer: SERIALIZABLE What is the advantage of using SPSS over calculating statistics by hand?Answer: All of these A table in a database must have ______?Answer: Primary key A person who is responsible for the design, implementation, maintenance and repair of entire database is called ______ administrator.Answer: Database In order to create tables, storing, retrieving or updating data in a database the specific language used is _____?Answer: Structured Query Language A database model that has a general appearance like an organizational chart is called ______ model.Answer: Hierarchical Which of the following is NOT an objective of a database?Answer: Data acquisition Collection of logically related data sets or files is called _______?Answer: A database A person who researches problems, plans solutions, recommends software and systems and coordinates development to meet requirements is _____?Answer: A system analyst The common name for the crime of stealing passwords is ______?Answer: Spoofing A(n) ________ is dynamic mathematical calculation that displays a single value for a specific field.Answer: Aggregate function