Database System Assistant MCQ: Objective Question Answers

The trainee learns about demonstration of various parts of computer system and practice with Microsoft Word. Familiarize with Operating System and practice with all the system application. Install Operating System and all other related application software. Configure network connection and browsing Internet. Create, format, edit a worksheet using Microsoft Excel. Create customized database files using Microsoft Access. Design and develop web pages using HTML. Design and develop web pages using PHP. Install and configure MySQL; and practice on MySQL syntax for database design. At the end of this year trainees can go on industrial visit or projects specified in the syllabus.

The trainee learns to create a table and manipulate data using query language. Select data from table using ‘select’ query and maintain database. Practice on transaction in database using SQL programming. Implement XML data and use it in SQL server. Design an online Database System using open source software tools. Secure a Database System by applying Information Security, Security Threats, Security Vulnerabilities and Risk Management. Implement Database System backup and restoring backup. Implement Database System security by creation of roles and functions for Database Users. Configure and use Web Server, Reporting Services tools. At the end of year trainees can go on industrial visit or projects specified in the syllabus.