End Sem February 2023 Question Paper
AKTU end-semester examination, February 2023. Course code ETIT427.
Free
IPU · CSE / CST · Semester 7
Advanced Database Administration
ETIT427
Loading material
IPU · CSE / CST · Semester 7
ETIT427
AKTU end-semester examination, February 2023. Course code ETIT427.
Official GGSIPU (USET) syllabus, unit-wise — Information Technology, semesters 3 to 8. Source: https://www.ipu.ac.in/univsyllabus/btechsyllabus010813/2Final%20B.Tech%20Syllabus%203rd%20Semester4,5,6,7,8/4Final%20Syllabus-IT-3rd%20Semester4,5,6,7,8.pdf
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.
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 index- organised 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.
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.
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.