Mode Of Examination
Number Of Question: 100 (1 Marks Each)
Total Time: 120 Min
General MySQL Use:
Database terminology, mysql setup and interactions.
Using SQL to Manage Data:
Server sql mode, mysql identifiers and rules, sql statements case sensitivity, selecting, creating, dropping and altering databases, table retrievals with joins, union and subqueries, views, transactions, foreign key, table creation, populating and modifying tables.
Data value categories, datatypes, sequences and type conversions.
Compound statements, stored functions, triggers, events and security.
Indexing, query optimizer, choosing and loading data types, scheduling and locking issues, administrative level optimizations, query mechanics and clauses.
Mysql programs and apis.
MySQL Programs Using C:
Compiling and linking client programs, server connection, error handling, processing sql statements, embedded server library, multiple statement execution.
MySQL Programs Using Perl DBI and PHP:
Perl script characteristics, perl dbi and php overviews.
Mysql components and administration, access control and security, database maintenance, backups and replication.
MySQL Data Directory:
Location, structure and relocating data directory’s.
General MySQL Administration:
Mysql installation and server startup, managing mysql user accounts, maintaining logs, server tuning, storage engine configuration, running multiple servers, internationalization and localization issues.
Access Control and Security:
Secure connections, internal and external security.
Database Maintenance, Backups and Replication:
Preventive maintenance principles, database backups, checking and repairing database tables, backups for data recovery and replication servers setting.
Data Type Reference, Operators and Functions:
Numeric, string and spatial data types, operators and functions.
System, Status and User Variables:
System and session only system variables, status and user defined variables.
Sql statement syntax, compound statement and comment syntax.
Select clauses, from clauses, order by clauses, where clauses, group by and having clause.
Nulls and Conditions and Miscellaneous:
Database copies, secure connections, conditional evaluation, null and condition types.