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 only.
if urgent then call us on 08791490301, 08273413412
Bt0075
Winter
2015
1 Write the SQL statements to demonstrate
the following using SELECT command:
a. Expression Evaluation
b. Using table aliases
c. ORDER BY
Answer: The most commonly used
clauses of SELECT statements are these:
·
Each
select_expr indicates a column that you want to retrieve. There must be at
least one select_expr.
·
table_references
indicates
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
provide alternative ways to perform operations that would otherwise require
complex joins and
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()(
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
Ø
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
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 only.
if urgent then call us on 08791490301, 08273413412
No comments:
Post a Comment