Scribd
Upload
21 views3 pages

DBA BSIT

Database administration

Uploaded by

Nadeem Mehmood
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
21 views3 pages

DBA BSIT

Database administration

Uploaded by

Nadeem Mehmood
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Punjab Colleges,

Lahore
MID-TERM EXAMINATION (FALL 2024)
BS PROGRAMS [UNIVERSITY OF EDUCATION]
Course Name (with Code): Database Administration
Course Instructor: Muhammad Nadeem Program & Term: BSIT 22
Time Allowed: 15 Min Maximum Marks: 12
TO BE FILLED IN BY THE STUDENT
Registration No:
Student Name:
University Roll No.: bsf

(OBJECTIVE)
Attempt all questions. (12×1=12)

1. Which Oracle memory structure stores parsed SQL statements?


a. (a) System Global Area (SGA) (b) Program Global Area (PGA)
b. (c) User Global Area (UGA) (d) Shared Pool
2. The background processes in an Oracle instance are responsible for:
a. (a) Executing user queries (b) Performing database maintenance
b. (c) Storing user data (d) Managing user connections
3. Which SGA component buffers data blocks read from disk?
a. (a) Shared Pool (b) Database Buffer (c) Redo Log Buffer (d) Large Pool
4. What is the purpose of the System Monitor (SMON) background process?
a. (a) Writes redo log entries to disk (b) Performs instance recovery
b. (c) Manages memory allocation (d) Manages user connections
5. Which type of Oracle file stores the actual data of database objects?
a. (a) Control files (b) Redo log files (c) Data files (d) Parameter files
6. A tablespace in Oracle is:
a. (a) A logical storage unit (b) A physical storage unit
b. (c) A memory area (d) A background process
7. Which files contain metadata about the database structure?
a. (a) Data files (b) Redo log files (c) Control files (d) Archive log files
8. What is the purpose of redo log files?
a. (a) To store copies of data file (b) To store changes made to the database
b. (c) To store user passwords (d) To store database configuration
parameters
9. What is the use of temp tablespaces?
a. (a) For storing permanent data (b) For storing temporary data during operations
b. (c) For storing redo log information (d) For storing control file information
10. A role in Oracle is:
a. (a) A collection of privileges (b) A single privilege
b. (c) A database user (d) A tablespace
11. Which statement is used to remove privileges from a user or role?
a. (a) GRANT (b) CREATE (c) REVOKE (d) DROP
12. The PGA (Program Global Area) is:
(a) Shared by all database sessions (b) Private to each database session
(c) Used for storing compiled PL/SQL code (d) Used for storing redo log information

Page 1 of 3
Punjab Colleges,
Lahore
MID-TERM
EXAMINATION (FALL 2024)
BS PROGRAMS [UNIVERSITY OF EDUCATION]
Course Name (with Code): Database Administration
Course Instructor: Muhammad Nadeem Program & Term: BSIT 22
Time Allowed: 75 Min Maximum Marks: 38
TO BE FILLED IN BY THE STUDENT
Registration No:
Student Name:
University Roll No.: bsf

(SUBJECTIVE)
SHORT QUESTIONS
Q.1. Attempt all questions. (5×3=15)

1. Describe the function of redo log files and archive log files. Why are they crucial for
database recovery?
2. What is a tablespace? Explain the difference between data files and tablespaces
3. Describe the steps involved in creating a new user in Oracle, including granting basic
privileges
4. Explain the importance of regular backups in database administration. Briefly describe
different backup strategies.
5. Explain the difference between authentication and authorization in the context of database
security.

LONG QUESTIONS
Q.2. Attempt all questions. (8×2 = 16 & 7×1 =7)

(a) Explain the process of user management in Oracle, from creating a user to granting and
revoking privileges. Include examples of SQL commands and discuss best practices for user
security.
(b) You are the lead DBA for a critical production Oracle database. You need to perform
planned maintenance on the server, which requires a database shutdown and restart. Explain
potential issues that might arise during startup and shutdown operations, such as:
a. Incomplete transactions during an IMMEDIATE shutdown.
b. Instance recovery requirements after an ABORT shutdown.
c. Problems with control files or data files during startup.
d. Long shutdown times due to long-running transactions.

Page 2 of 3
(c) You are a DBA. A new application requires a user, app_user, to have the following
privileges: CONNECT, CREATE TABLE, CREATE VIEW, SELECT on all tables in the
products schema, and INSERT, UPDATE, and DELETE on the orders table. Write the SQL
statements to create the user and grant the necessary privileges. Also, create a tablespace
named app_data which will be the default tablespace for app_user. (Focus: Comprehensive
scenario involving user creation, tablespaces, and various privileges)

Page 3 of 3

You might also like