P2 Exam Questions

Question 1

What is a database administrator?

Answer 1

A database administrator (DBA) manages, secures, and maintains databases, ensuring data availability and integrity.

Question 2

What are the roles of a database administrator?

Answer 2

Roles include database installation, backup, recovery, performance tuning, user access control, and security.

Question 3

Queries of DDL and DML (roles of each)

Answer 3

DDL (Data Definition Language) -> Create, Drop, Alter, Truncate -> defines or modifies database structure.

DML (Data Manipulation Language) -> Insert, Update, Delete -> manipulates data in the database.

Question 4

What is physical schema?

Answer 4

Describes how data is physically stored on storage devices (e.g., files, indexes, memory layout).

or

It defines how data is stored physically in storage systems like files, indexes, and partitions.

Question 5

What is conceptual schema?

Answer 5

It is a high-level representation of a database, focusing on the core concepts and relationships within the system. It describes the structure and organization of the entire database at a conceptual level, including relationships between entities, but without any specific storage details, independent of physical storage. Essentially, it’s a blueprint for the database, providing a broad understanding of the data and its organization.

Question 6

What is logical schema?

Answer 6

Specifies the structure of the data as seen by the DBMS, including tables, columns, data types, and constraints

or

It outlines the logical structure like tables, fields, and relationships, independent of physical implementation.

Question 7

What is 1NF?

Answer 7

Remove repeating groups and ensure all attributes have atomic (indivisible) values.

Question 8

What is 2NF?

Answer 8

Ensure table is in 1NF and move partial dependencies to separate tables.