CS403P Lab Quiz 1

CS403P

Lab - Quiz No. 1(10 marks ) DATABASE MANAGEMENT SYSTEM (P) SYED MUZAHIR UL HASSAN

Q1. A person who is responsible for proper working of database and DBMS is known as

Answer: Database Administrator

Q2. A context Level Data Flow Diagram shows ---------------

Answer: input/ Output to and from the process and interaction with external entities

Q3. A graphical representation of system showing flow of data between is different components is known as -------------------

Answer: Data flow Diagram

Q4. A type of Data Flow Diagram which provides minimal amount of details about the working of system is known as -------------

Answer: Context Diagram

Q5. The first step of creating level 0 Data Flow Diagram is to -----------

Answer: Represent interaction between external entities

Q6. in SQL server, data is stored in database in the form of ---------

Answer: Tables

Q7. Microsoft SQL server is a ---------DBMS.

Answer: Relational

Q8. Which of the following software is used to create and manage the database ?

Answer: Microsoft SQL Server

Q9. The basic purpose of Microsoft SQL server is --------------

Answer: To store and retrieve data from database

Q10. which of the following diagram is most commonly use for designing databases?

Answer: Sequence Diagram

Q11. what does an oval or rounded rectangle represent in Data Flow Diagram?

Answer: Processes

Q12. In a Data Flow Diagram,----------- symbol is used to express the convergence of several data flow connections to a single point.

Answer: Merger

Q13. Which of the following company develops SQL server software?

Answer: Microsoft

Q14. which of the following is the main user interface of Microsoft SQL server?

Answer: Graphical user interface