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
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
Qus:2
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
Ques
3Explain CALL statements with examples.
Ans
|
CALL sp_name([parameter[,...]])
CALL sp_name[()]
|
The CALL statement invokes a stored
procedure that was defined previously with CREATE
Ques
4Mention the properties of the account that is created using GRANT statement.
Ans
The DROP USER
statement removes one or more MySQL accounts. To use it, you must have the
global CREATE USER privilege or the DELETE privilege for the mysql database.
Each account is named using the same format as for the GRANT statement; for
example, 'jeffrey'@'localhost'. The
user and
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 the username root are created. These are super user accounts that can do
anything. The
Ques
6Briefly describe the binary log.
Ans
The binary log
contains all statements that update data. It also contains statements that
potentially could have updated it (for example, a DELETE which matched no
rows), unless row-based logging is used. Statements are stored in the form of
―events‖ that describe the modifications. The binary log also contains
information about how
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
if urgent then
call us on 08791490301, 08273413412
No comments:
Post a Comment