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
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
