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
No comments:
Post a Comment