• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Advanced Database Administration IPU IT notes and question paper free download
#1
SYLLABUS:-

UNIT-I                                
Creating a Database – Database configuring Assistant (DBCA), Password management, Using DBCA to delete a database. 
Managing the database instance – Management framework, starting and stopping database control, Initialising parameter files, starting up and shutting down database instance. 
Managing Database storage structure – Storage structure, How table data is stored? Tablespaces and data files, Space Management in Tablespaces, Tablespace management.

UNIT-II                   
Database user security – Creating a user, Authenticating users, Unlocking a user account and resetting the password, Privileges and role, System privileges, object privileges. 
Managing Schema Objects – Table types, Action with tables, creating views, sequences, What is partition and why use it? Creating a Partition, Partitioning method, Index organised tables and heap tables, creating indexorganised tables, cluster, cluster types, sorted hash cluster. 
Managing data and concurrency – Manipulating with data through SQL, function procedure, packages, Triggers, locking concepts, detecting and resolving lock conflicts.

UNIT-III                  
Managing undo Data – Monitoring Undo, Administering Undo, Configuring Undo Retention, Sizing Undo tablespace. 
Implementing database security – database transparent encryption (TDE), TDE Process, Implementing TDE. 
Performance management - troubleshooting, tuning.

UNIT-IV                                                                                                                                       
Performing Backup and Recovery – Configuring Recovery Manager, using Recovery manager, Recovering from noncritical Losses , recovery from loss of control file , data file and redo file. 
Performing flashback – Flashback database , Flashback database Architecture, Configuring flashback Database using enterprise manager, Monitoring Flashback database  
Moving data- General Architecture , Loading data with SQL *loader , Data pump ,  Data pump export and import.

Part Time Work For Students

Part Time Work

Win Free Netflix Account

Part Time Work




  Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Cryptography and Network Security IPU IT notes and question paper free download Dipesh S 1 7,925 09-15-2018, 01:40 PM
Last Post: turemaf
  Probablistic Graphical Models IPU IT notes and question paper free download Dipesh S 0 5,585 05-01-2017, 07:43 PM
Last Post: Dipesh S
  Grid Computing IPU IT notes and question paper free download Dipesh S 0 2,295 05-01-2017, 07:40 PM
Last Post: Dipesh S
  System and Network Administration IPU IT notes and question paper free download Dipesh S 0 1,334 05-01-2017, 07:39 PM
Last Post: Dipesh S
  Enterprise Computing in Java IPU IT notes and question paper free download Dipesh S 0 1,375 05-01-2017, 07:35 PM
Last Post: Dipesh S
  .NET and C# Programming IPU IT notes and question paper free download Dipesh S 0 2,738 05-01-2017, 07:34 PM
Last Post: Dipesh S
  Software Testing IPU IT notes and question paper free download Dipesh S 0 2,779 05-01-2017, 07:30 PM
Last Post: Dipesh S
  Semantic Web Technologies IPU IT notes and question paper free download Dipesh S 0 1,156 05-01-2017, 07:28 PM
Last Post: Dipesh S
  Distributed Databases IPU IT notes and question paper free download Dipesh S 0 939 05-01-2017, 07:27 PM
Last Post: Dipesh S
  Cloud Computing IPU IT notes and question paper free download Dipesh S 0 2,925 05-01-2017, 07:23 PM
Last Post: Dipesh S

Forum Jump:


Users browsing this thread: 1 Guest(s)