bt0075 smu b.sc it fall 2014 IIIrd sem assignment

Get fully solved assignment, plz drop a mail with your sub code

computeroperator4@gmail.com

Charges for mba rs 125/subject and rs 700/semester only.

For other rs 125/subject only

if urgent then call us on 08791490301, 08273413412

our website is www.smuassignment.in

PROGRAM BSc IT

SEMESTER THIRD

SUBJECT CODE &

NAME

BT0075, RDBMS and MySQL

Qus:1 What are the new features in MySQL 5.1?

Answer:

The new Features in MySQL 5.1:

The following features have been added to MySQL 5.1.

·         Partitioning.This capability enables distributing portions of individual tables across a file system, according to rules which can be set when the table is created. In effect, different portions of a table are stored as separate tables in different locations, but from the user point of view, the partitioned table is still a single table. Syntactically, this implements a number of new extensions to the CREATE TABLE, ALTER TABLE, and

Qus:2 How to alter databases and tables in MySQL? Explain with the help of examples.

Answer:

Alteration of databases and tables in MySQL:

The following screen shots demonstrate a step-by-step approach in connecting to the MySQL database server using a specific user name and password as created during the installation steps.

User is asked for the password before

Qus:3 Explain MySQL update and replace statements with example.

Answer:

MySQL update and replace statements with example:

UPDATE:

Qus:4 Explain all the date and time functions in MySQL.

Answer:

The date and time functions in MySQL:

Qus:5 Describe the cursors in MySQL in detail.

Answer:

The cursors in MySQL:

Simple cursors are supported inside stored procedures and functions. The syntax is as in embedded SQL. Cursors are currently asensitive, read-only,

Qus:6 Briefly describe the error log and general query log in MySQL.

Answer:

The error log and general query log in MySQL:

Error Log:

The error log contains information indicating when mysqld was started and stopped and also any critical errors that occur while the server is running. If mysqld notices a table that needs to be automatically checked or repaired, it writes a message to the error log. On some operating

Get fully solved assignment, plz drop a mail with your sub code

computeroperator4@gmail.com

Charges for mba rs 125/subject and rs 700/semester only.

For other rs 125/subject only

if urgent then call us on 08791490301, 08273413412

our website is www.smuassignment.in