bt0075 smu bsc it Fall 2015 IIIrd sem assignment

Get fully solved assignment. Buy online from website

http://smuassignment.in/online-store/

online store

or

plz drop a mail with your sub code

computeroperator4@gmail.com

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

CREDIT - 4

BK ID - B1003

MAX. MARKS – 60

Q1. How to drop database, tables, and index in MySQL? Explain with the help of examples. 3 ½ + 3 + 3 ½ = 10

Ans: DROP DATABASE : DROP DATABASE drops all tables in the database and deletes the database. Be very careful with this statement! To use DROP DATABASE, you need the DROP privilege on the database. DROP

Q2. a. Explain insert statement with example. b. Exercise: Create table CUSTOMERS with fields – ID, name, age, address and salary and insert records in the table(insert at least five records.) 5+5 = 10

Ans: INSERT statement: 1. Multiple records can be entered in a single INSERT statement through the use of multiple VALUES() clauses within the same statement. For

Q3. Explain update and replace statements with example. 5+5 = 10

Ans: UPDATE:

UPDATE [LOW_PRIORITY] [IGNORE] tbl_name

SET col_name1={expr1|DEFAULT} [, col_name2={expr2|DEFAULT}] ...

Q4. Explain all the date and time functions in detail. 10

Ans: Date and Time Functions: This section describes the functions that can be used to manipulate temporal values.

Q5. Describe the procedures to add new user account in MySQL. 10

Ans: Adding New User Accounts to MySQL: You can create MySQL accounts in two ways:

·         By using statements intended for creating accounts, such as CREATE USER or GRANT

·         By manipulating the MySQL grant tables directly with statements such as INSERT, UPDATE, or DELETE

The preferred method is to use account-creation statements because they are more concise and less error-prone. Another option for creating accounts is to use one of several available thirdparty programs that

Q6. Briefly describe the error log and general query log. 5+5 = 10

Ans: 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 where mysqld

Get fully solved assignment. Buy online from website

http://smuassignment.in/online-store/

online store

or

plz drop a mail with your sub code

computeroperator4@gmail.com

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