CS403P Quiz 1

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

1. Database Administrator
2. End User
3. Application Programmer
4. Analyst

Correct answer: Database Administrator

Q2. In SQL server, data is stored in database in the form of __________.

1. Files
2. Images
3. Objects
4. Tables

Correct answer: Tables

Q3. The instances of _________ cannot exist independently?

1. Strong Entity
2. Weak Entity
3. Hybrid Entity
4. Naming Entity

Correct answer: Weak Entity

Q4. Microsoft SQL server is a _____ DBMS.

1. Hybrid
2. Hierarchical
3. Network
4. Relational

Correct answer: Relational

Q5. Relationships between two entities in the Entity Relationship Data Model are represented by _________.

1. Oval symbol
2. Rectangular box
3. Line
4. Diamond symbol

Correct answer: Diamond symbol

Q6. How many users can access data stored in a database using SQL server?

1. Maximum 10 users
2. Only one user at a time
3. Many users concurrently
4. Exactly 50 users

Correct answer: Many users concurrently

Q7. Which of the following diagram is most commonly use for designing databases?

1. Block Diagram
2. Tree Diagram
3. Sequence Diagram
4. Data Flow Diagram

Correct answer: Data Flow Diagram

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

1. Context diagram
2. Level 3 diagram
3. Level 1 diagram
4. Level 2 diagram

Correct answer: Context diagram

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

1. Oracle
2. HP
3. Acer
4. Microsoft

Correct answer: Microsoft

Q10. The basic purpose of Microsoft SQL server is ________________.

1. To represent data in graphical form
2. To store and retrieve data from database
3. To fetch the data from Internet links
4. To design web pages

Correct answer: To store and retrieve data from database