GATE Exam: DBMS Trivia Quiz

31 Questions | By Nauakrimilgai | Updated: Mar 22, 2022 | Attempts: 2442

Questions

Settings

The GATE exam is upon us, and this trivia quiz is perfect for those of you who want to refresh their knowledge when it comes to DBMS. Are you one of them? Well, don’t just stare at the screen, press start, and be a step closure to the grade you desire with every answer you get right. All the best!

Questions and Answers

1.

-------------------------------responsible for authorizing access to the database, for co-ordinating and monitoring its use, acquiring software, and hardware resources, controlling its use and monitoring efficiency of operations.
- A.
  
  Authorization Manager
- B.
  
  Storage Manager
- C.
  
  File Manager
- D.
  
  Transcation Manager
- E.
  
  Buffer Manager
2.

------------------------------is a property that describes various characteristics of an entity
- A.
  
  ER Diagram
- B.
  
  Column
- C.
  
  Relationship
- D.
  
  Attribute
3.

---------------------- level describes what data is stored in the database and the relationships among the data
- A.
  
  Physical Level
- B.
  
  Logical Level
- C.
  
  Conceptual Level
- D.
  
  None of the above
4.

------------------------ denote derived attributes.
- A.
  
  Double ellipse
- B.
  
  Dashed ellipse
- C.
  
  Squared ellipse
- D.
  
  Ellipse with attribute name underlined
5.

A ----------------------- is an association between entities
- A.
  
  Relation
- B.
  
  One to One
- C.
  
  Generalization
- D.
  
  Specialization
6.

--------------------------- stores metadata about the structure of the data base
- A.
  
  Physical data base
- B.
  
  Query Analyzer
- C.
  
  Data Dictionary
- D.
  
  Data Catalog
7.

--------------------------is a collection of operations that perform s single logical function in a database application
- A.
  
  Transaction
- B.
  
  Concurrent operation
- C.
  
  Atomocity
- D.
  
  Durability
8.

The problem that is compounded when constraints involve several data items from different files are Called ------------------------------------
- A.
  
  Transaction Control Management Problem
- B.
  
  Security Problem
- C.
  
  Integrity Problem
- D.
  
  Durability Problem
9.

Ensuring atomicity is the responsibility of the --------------------------component
- A.
  
  File Manager
- B.
  
  Buffer Manager
- C.
  
  DBA
- D.
  
  Transation Manager
10.

-------------------manages the allocation of the space on the disk storage and the data base structure used to represent information stored on disk
- A.
  
  Disk Manager
- B.
  
  File Manager
- C.
  
  Buffer Manager
- D.
  
  Memory Manager
- E.
  
  None of the above
11.

----------------------------is the minimal super key
- A.
  
  Primary Key
- B.
  
  Candidate Key
- C.
  
  Surrogate Key
- D.
  
  Unique Key
- E.
  
  Alternate Key
12.

-----------------------------engine executes low level instructions generated by the DML compilier
- A.
  
  DDL Analyzer
- B.
  
  Query Interpreter
- C.
  
  Database Engine
- D.
  
  None of the above
13.

--------------------------responsible to define the content, the structure, the constraints, and functions or transactions against the database
- A.
  
  Transcation Manager
- B.
  
  Query Analyzer
- C.
  
  DBA
- D.
  
  All the above
- E.
  
  None of the above
14.

In ER model ---------------------------denote derived attributes
- A.
  
  Double ellipse
- B.
  
  Diamond
- C.
  
  Reactangle
- D.
  
  None of the above
15.

--------------------attributes can be divided into parts (Write the answer in lowercase)
16.

Foreign Key can be null
- A.
  
  TRUE
- B.
  
  FALSE
17.

All primary keys should be super keys.
- A.
  
  TRUE
- B.
  
  FALSE
18.

In Relational database Data is stored as record types and the relationship is represented by set types
- A.
  
  True
- B.
  
  False
19.

In Hierarchical database to get to a low-level table, you start at the root and work your way down the tree until you reach your target data.
- A.
  
  True
- B.
  
  False
20.

Using relational model we design conceptual database design
- A.
  
  True
- B.
  
  False
21.

Conceptual data model is the source of information for logical design phase
- A.
  
  True
- B.
  
  False
22.

Logical database design describes describes base relations, file organizations, and indexes that are used to achieve efficient access to data.
- A.
  
  True
- B.
  
  False
23.

Conceptual data modeling uses a high level data modeling concept of E-R Models
- A.
  
  True
- B.
  
  False
24.

Tables are required to have at least one column
- A.
  
  True
- B.
  
  False
25.

Logical data independence: Refers to the separation of the external views from the conceptual view
- A.
  
  True
- B.
  
  False

Featured Quizzes

Maladaptive Daydreaming Test: Am I A Maladaptive Daydreamer? Maladaptive Daydreaming Test: Am I A Maladaptive Daydreamer?

Ethnicity Quiz: What Is My Ethnicity? Ethnicity Quiz: What Is My Ethnicity?

Are You Smarter Than A 5th Grader? Quiz Questions Are You Smarter Than A 5th Grader? Quiz Questions

Will You Have a Valentine This Year? Quiz Will You Have a Valentine This Year? Quiz

Which Sonic character are you quiz Which Sonic character are you quiz

What Kind of Valentine Are You Quiz! What Kind of Valentine Are You Quiz!

GATE Exam: DBMS Trivia Quiz

Related Topics

Featured Quizzes

Popular Topics

Related Quizzes