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.
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.
Q2.
1.
Explain insert statement with example.
2.
Exercise: Create table CUSTOMERS with fields – ID, name, age, address and
salary and insert records in the table (insert at least five records.)
Answer:
i)
There
are 2 syntaxes for the INSERT statement depending on whether you are inserting
one record or multiple records.
Qus:3
Explain update and replace statements with example.
Answer:
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:
·
Accounts
with the username root are created. These are superuser accounts that can do
anything. The initial root account passwords are empty, so anyone can connect
to the MySQL server as root – without a password – and be granted
all privileges.
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 the error log. On some operating systems, the error log contains a stack
trace if mysqld dies. The trace can be used to determine
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