BT0075-RDBMS AND MYSQL

Dear students get fully solved assignments

Send your semester & Specialization name to our mail id :

“ help.mbaassignments@gmail.com ”

or

Call us at : 08263069601

(Prefer mailing. Call in emergency )

ASSIGNMENT

PROGRAM	BSc IT
SEMESTER	THIRD
SUBJECT CODE & NAME	BT0075,RDBMS AND MYSQL
CREDIT	4
BK ID	B1003
MAX.MARKS	60

Q.1 Define and explain MySQL database. Explain the following features of MySQL:

1. Internals and portability 2. Statements and functions.

Ans : MySQL database:-

MySQL is a fast, easy-to-use RDBMS being used for many small and big businesses. MySQL is developed, marketed, and supported by MySQL AB, which is a Swedish company. MySQL is becoming so popular because of many good reasons:

·         MySQL is released under an open-source license. So you have nothing to pay to use it.

·         MySQL is a very powerful program

·          

Q.2 Explain the char and varchar and the set data types of mysql.

Ans: The CHAR and VARCHAR types are similar, but differ in the way they are stored and retrieved. They also differ in maximum length and in whether trailing spaces are retained.

The CHAR and VARCHAR types are declared with a length that indicates the maximum number of characters you want to store. For example, CHAR (30) can hold up to 30 characters.

The length of a CHAR column is fixed to the

Q.3 1. Explain insert statement with example.

2. Create table CUSTOMERS with fields – ID, name, age, address and salary and insert records in the table (insert at least five records.)

Ans: insert statement:

 The INSERT statement inserts rows into a table, 4 nickname, or view, 4 or the underlying tables, nicknames, or views of the specified 4 full select. Inserting a row into a nickname inserts the row into the data source object to which the nickname refers. Inserting a row into a view also inserts the row into the table on which the view is based, if no INSTEAD OF trigger is defined for the insert operation on this view. If such a trigger is defined, the trigger will be executed instead.

Q.4 What is use of Join statement in MySQL? Also explain the types of joins in MySQL

Ans: of Join statement in MySQL: -

The MySQL INNER JOIN clause matches rows in one table with rows in other tables and allows you to query rows that contain columns from both tables.

The MySQL INNER JOIN clause an optional part of the SELECT statement. It appears immediately after the FROM clause.

Q.5 Explain Row subqueries and subqueries in the FORM clause.

Ans Row subqueries:-

A single row subquery returns zero or one row to the outer SQL statement. You can place a subquery in a WHERE clause, a HAVING clause, or a FROM clause of a SELECT statement.

We can place a subquery in the WHERE clause of another query. Let's take an example of a query that contains a subquery placed in its WHERE clause

Q.6 List all the options for mysqld security and explain any eight of them.

Ans: The most common methods are to provide options in an option file or on the command line. However, in most cases it is desirable to make sure that the server uses the same options each time it runs. The best way to ensure this is to list them in an option file.

mysqld reads options from the [mysqld] and [server] groups. mysqld_safe reads options from the [mysqld], [server], [mysqld_safe], and [safe_mysqld] groups. mysql.server  reads options from the [mysqld] and [mysql.server] groups.

Dear students get fully solved assignments

Send your semester & Specialization name to our mail id :

“ help.mbaassignments@gmail.com ”

or

Call us at : 08263069601

(Prefer mailing. Call in emergency )