Get fully solved assignment. Buy online from website
online store
or
plz drop a mail with your sub code
we will revert you within 2-3 hour or immediate
Charges rs
125/subject and rs 625/semester only.
if urgent then call us
on 08791490301,
08273413412
PROGRAM
BSc IT
SEMESTER
THIRD
SUBJECT
CODE &
NAME
BT0075,
RDBMS and MySQL
Q1.
Explain the blob, text and enum data types. 10
Answer: The BLOB and TEXT Types: A BLOB is a binary large object
that can hold a variable amount of data. The four BLOB types are
TINYBLOB, BLOB, MEDIUMBLOB, and LONGBLOB. These differ only in the
maximum length of the values they can hold. The four TEXT types are
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 andpassword as created during the
installation steps.
Qus:3
Explain 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 detail.
Answer:
The
date and time functions in MySQL:
Q5.
Define grant tables. Describe the steps to set up MySQL user accounts. Also
explain the method to assign passwords to the anonymous accounts. 10
Answer:
The grant tables
define the initial MySQL user accounts and their access
privileges. These accounts are
set up as follows:
Qus:6
Briefly describe the error log and general query log.
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
Get fully solved assignment. Buy online from website
online store
or
plz drop a mail with your sub code
we will revert you within 2-3 hour or immediate
Charges rs
125/subject and rs 625/semester only.
if urgent then call us
on 08791490301, 08273413412
No comments:
Post a Comment