CS409: Introduction to Database Administration
CS409 Introduction to Database Administration is a course taught at Virtual University of Pakistan. Practise every lecture of CS409 with lecture-wise quizzes and Past Papers Style Solved MCQs, then test yourself with midterm and final term mocks made from your own syllabus.
- 45 lectures
- Past papers style solved MCQs
- Answers in English and Roman Urdu
How to prepare for CS409
CS409 Lecture Quizzes
Each quiz covers a few lectures. New here? Start with Lecture 1-3 Quiz.
Tap the lectures in your exam. Only matching quizzes stay highlighted.
CS409 Exam Mocks
A practice paper made only from the lectures in your syllabus. Pick the one that fits your next exam.
CS409 Leaderboard
Points are your correct answers in lecture quizzes.
Loading leaderboard…
Stuck on a lecture? Ask other CS409 students.
Post your question, discuss a tricky MCQ or help someone else. Be the first to start a discussion.
CS409 Introduction to Database Administration
Gradup covers all 45 lectures of CS409 Introduction to Database Administration with Past Papers Style Solved MCQs. Use the lecture quizzes while you study the CS409 handouts, then switch to the CS409 midterm and final term mocks. Every answer comes with an explanation and the handout reference, so you know exactly where to revise.
See all 45 CS409 lectures
- 1 CS409 Lecture 1Defining Data, Information & Database - Introduction to DBMS Components & Architecture - Introduction to DBA Responsibilities & Tasks
- 2 CS409 Lecture 2Overview of Physical Database Design - Concepts of Keys and Super keys - Candidate Keys with Examples
- 3 CS409 Lecture 3Primary Key - Surrogated Keys Examples - Foreign Keys Examples
- 4 CS409 Lecture 4Foreign Keys Examples - Composite Keys Examples
- 5 CS409 Lecture 5Additional or Other Constraints - Additional Constraints using DDL Alter SQL - Script of Referential Integrity Constraints SQL
- 6 CS409 Lecture 6Fundamentals of ER Model - ER Diagram with Relationship one to many - ER Diagram with Identifying & Weakness Relationship
- 7 CS409 Lecture 7ER Diagram with Mapping - Oracle Schema Objects & Data Access - Oracle Database Architecture
- 8 CS409 Lecture 8Oracle11g Installation - Oracle Configuration for Connection - Oracle Data Dictionary Views
- 9 CS409 Lecture 9Memory Management & Memory Architecture Overview - Memory Architecture Overview (SGA) - Memory Related Data Dictionary Views
- 10 CS409 Lecture 10Backup using MS SQL Server - Back up Control Files - Recover & Dropping Control Files
- 11 CS409 Lecture 11What are Redo Log Files? - Creating Redo Log Files Groups - Dropping Redo Log Groups & Members
- 12 CS409 Lecture 12Forcing Log Switches Between Redo Log Groups & Members - Metadata Views of Redo Log File - Controlling Archiving
- 13 CS409 Lecture 13Specifying Archive Destinations - Database Physical Design - Creating Tablespaces
- 14 CS409 Lecture 14Specifying Non Standard Block Sizes for Tablespaces - Altering Tablespaces - Readonly & Online Status of Tablespaces
- 15 CS409 Lecture 15Altering & Maintaining Tablespaces - Renaming & Dropping Tablespaces
- 16 CS409 Lecture 16Managing SYSAUX Tablespaces - Migrating the System Tablespace - Viewing Tablespace using Data Dictionary Views
- 17 CS409 Lecture 17Logical Storage Structure & Hierarchy - Percentage of Free Space in Blocks (PCTFREE) - Overview of Segments
- 18 CS409 Lecture 18Creating Schema Objects Tables, Views - Managing Integrity Constraints-1 - Schema Objects, Queries & Views
- 19 CS409 Lecture 19Creating Tables & Alter Tables - DDL Script Writing-2 - Indexed Organized Tables
- 20 CS409 Lecture 20Data Dictionary Views for Tables - Recycle Bin - Data Dictionary Views for Index
- 21 CS409 Lecture 21Defining Clusters - Defining Hash Clusters - Data Dictionary Views for Hash Clusters
- 22 CS409 Lecture 22Defining & Managing Views - Alter & Drop Sequences - Create & Drop Synonyms
- 23 CS409 Lecture 23Data Dictionary Views for Synonyms, Views & Sequences - PL / SQL Benefits & Basic Constructs - Basic Programs Block Structure with more examples
- 24 CS409 Lecture 24Basic Programs Block Structure with more examples - Program Examples - FOR & WHILE Loops
- 25 CS409 Lecture 25Anonymous Blocks with Examples - PL / SQL Procedure - Calling Procedures & Functions
- 26 CS409 Lecture 26Exercises of Functions - PL / SQL Package-2 - PL / SQL Triggers
- 27 CS409 Lecture 27Trigger Examples - Cursor Programming-2 - Programming using an Array
- 28 CS409 Lecture 28Examples with Advance Topics - Concepts of Oracle Instance-3 - Instance Startup & Shutdown-2
- 29 CS409 Lecture 29Instance Startup & Shutdown-3 - Checkpoints Commands Samples - Instance Recovery Protocol
- 30 CS409 Lecture 30Managing Recovery using MS SQL Server - Initializing Parameter Files - Commands & Log Alerts
- 31 CS409 Lecture 31Trace Files Commands - Users information using Data Dictionary Views - System Privileges Commands
- 32 CS409 Lecture 32System Multiple Privileges Commands - Benefits of Roles-1 - Creating Roles
- 33 CS409 Lecture 33Pre-defined Roles & Assigning Roles - Application Roles - Removing Roles
- 34 CS409 Lecture 34Guidelines for Creating Roles - Data Loading Methods - SQL*Loader
- 35 CS409 Lecture 35SQL*Loader Control Files - Direct & Conventional Path Loads - Log Files & Steps to adopt
- 36 CS409 Lecture 36Sample Example to Load Data-1 - Sample Example to Load Data-4 - Sample Example to Load Data-6
- 37 CS409 Lecture 37Sample Example to Load Data-7 - Full Logical Backup - Logical Backup of Schema Contents Tables
- 38 CS409 Lecture 38Cold Physical Backup - Hot Backup Demo - Partial Restore Logical Backup
- 39 CS409 Lecture 39Complete & Incomplete Recovery - Walkthrough Import when Table Data Exist - Logical Backup with Oracle Utilities
- 40 CS409 Lecture 40Walkthrough Export with Moving Objects - Defining Transaction - Examples of Transactions
- 41 CS409 Lecture 41Examples of Transactions - Lost Update Example-1 - Dirty Read Example
- 42 CS409 Lecture 42Incorrect Summary Problem - System Log - Conflicts
- 43 CS409 Lecture 43Serializability - Serial Schedules Example-3 - Conflict Serializability Example-2 (Graph Test)
- 44 CS409 Lecture 44Apply Locking - DDL Schema Script including Tables, Columns and Data Types - Creation of DML Insert Statements for Data
- 45 CS409 Lecture 45DDL Schema Script including List of Roles and Privileges - DDL Schema Script including Synonyms of Tables & Drop of all Objects - Revision of Course Contents
Frequently asked questions
Quick answers about practising CS409 on Gradup.
Gradup has lecture-wise CS409 quizzes with Past Papers Style Solved MCQs covering all 45 lectures, with explanations in English and Roman Urdu.
Yes. Choose the lectures that are in your midterm and Gradup builds a CS409 midterm mock from Past Papers Style Solved MCQs of only those lectures. Try again for other questions from the same lectures.
Yes. The CS409 final term mock mixes easy, medium and hard MCQs from the lectures you select, just like the real paper.
You can take any quiz without an account. Sign up free to get one month of full access with progress tracking, mocks, streaks and the leaderboard.