Quizr: Database Management Systems Quiz#1, MCQs

Database Management Systems Quiz#1, MCQs

NOTE: Attempt all Questions to see the Result at the bottom of this page.

The Timer has started 10:00

1)

Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss?
- A) User accessible catalog
- B) Data processing
- C) Authorization service
- D) Recovery service
Right Answer is the option "D"

2)

Which of the following statements is true about the views?
- A) view is always a complete set of all the tables in a database
- B) View can not be used for retrieving data
- C) The results of using a view are not permanently stored in the database
- D) Rows can not be updated or deleted in the view
Right Answer is the option "C"

3)

Which of the following is true about TRUNCATE?
- A) Can be Rolled back.
- B) Activates Triggers.
- C) is DML Command.
- D) Resets identity of the table.
Right Answer is the option "D"

4)

Which of the following is the correct way to find out the size of cartesian product incase of CROSS JOIN?
- A) the number of columns in the first table multiplied by the number of columns in the second table.
- B) the number of columns in the first table multiplied by the number of rows in the second table.
- C) the number of rows in the first table multiplied by the number of columns in the first table.
- D) the number of rows in the first table multiplied by the number of rows in the second table.
Right Answer is the option "D"

5)

Suppose there are 8 rows and 4 columns in TABLE1 and 3 rows and 4 columns in TABLE2; what is the size of the cartesian product incase of CROSS JOIN between these two tables?
- A) 24
- B) 32
- C) 12
- D) 16
Right Answer is the option "A"

6)

Which of the following is not one of the properties of Transaction?
- A) atomicity
- B) consistency
- C) redundancy
- D) durability
Right Answer is the option "C"

7)

Which of the following is INCORRECT about VIEWS?
- A) It is not possible to left out the data which is not required for a specific view.
- B) A database view displays one or more database records on the same page.
- C) Views can be used as security mechanisms
- D) Views are generally used to focus the perception each user has of the database.
Right Answer is the option "A"

8)

Each course section is assigned a particular faculty member, and each course section corresponds to a particular course. Conceptually, what is the relationship between faculty and course (not course section).
- A) 1:1
- B) 1:M
- C) M:M
- D) Ternary
Right Answer is the option "C"

9)

Which of the following is used to add or drop columns in an existing table?
- A) ALTER
- B) HAVING
- C) SELECT
- D) THEN
Right Answer is the option "A"

10)

Which of the following is a correct way of selecting all the columns from a table called PERSONS?
- A) SELECT FROM * Persons
- B) SELECT * FROM Persons
- C) SELECT * WHERE Persons
- D) SELECT WHERE * Persons
Right Answer is the option "B"