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
TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT. These correspond to the four
BLOB types and have the same maximum lengths and storage requirements.
BLOB columns are
Q2. How to alter databases and tables? 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
Qus:3 Explain update and replace statements with
example.
Answer:
Answer:
MySQL update and replace statements with example:
UPDATE:
For the
single-table
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:
·
Accounts with
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 automatically checked or repaired, it writes a message
to
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