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
Bt0075
summer
2016
Q1. Explain the following SQL
joins with an example
·
INNER
·
OUTER
(LEFT, RIGHT, FULL)
·
CROSS
Answer:
INNER Join or EQUI Join
This is a simple JOIN in which the result is based on matched data as
per the equality condition specified in the query.
Inner
2 List the advantages of
subqueries. Explain correlated subquery with an example.
Answer: The main advantages of
subqueries are:
·
They
allow queries that are structured so that it is possible to isolate each part
of a statement.
·
They
·
3 Write a short note on update
and replace statements with examples.
Answer: UPDATE
For the single-table syntax, the UPDATE statement updates columns of existing
rows in tbl_name with new values.
The SET clause indicates which columns to modify and the values they should
be given. Each value can be
4 Explain all the date and
time functions in detail..
Answer: Date and time functions
Name Description
ADDDATE()(v4.1.1)
Add
dates
ADDTIME()(v4.1.1)
Add
time
CONVERT_TZ()(v4.1.3)
Convert from
one timezone to another
5 Define grant tables. Describe
the steps to set up MySQL user accounts. Also explain the method to assign
passwords to the anonymous accounts.
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.
·
On
6 Briefly describe the error log and
general query log.
Answer: 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 where
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
No comments:
Post a Comment