🗃️ Database MCQs and Exam Questions

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

43 solved MCQs

Delimiting and synchronization of data exchange is provided byAnswer: Session layer Slum test of concrete is a of itsAnswer: Consistency In Tuple Relational Calculus, to express the query "Find the set of all tuples S such that F(S) is true", how an we write this?Answer: {S | F(S)} Which of the following is the Best Case Time Complexity of the Bubble Sort algorithm?Answer: O(n) Which of the underlying network is a network with a size between a LAN and a WAN? It normally covers the area inside a town or a city. It is designed for customers who need high-speed connectivity, normally to the Internet, and have endpoints spread over a city or part of the city.Answer: MAN (Metropolitan Area Networks) Which of the following is the Best Case Time Complexity Quicksort algorithm?Answer: O(n log n) What is a Candidate Key in Database?Answer: The minimal set of attributes that unique identifies each occurrence of an entity type. What is the worst case time complexity of a quick sort algorithm?Answer: O(N₂) Testing method used for combining old and new systems → ?Answer: Parallel Testing / Parallel Running Rows in a database are called → ?Answer: Records Which is NOT a type of testing? Unit Testing, Integration Testing, System Testing, Compilation TestingAnswer: Compilation Testing A collection of related data is called ____?Answer: Database Which of the following is the correct SQL query to display all columns from the “STUDENT” table?Answer: SELECT * FROM STUDENT;