Assignment
1: what is DBMS?
A database management system (DBMS) is a software package designed to define,
manipulate, retrieve and manage data in a database. A DBMS generally manipulates the
data itself, the data format, field names, record structure and file structure. ... Some
other DBMS examples include: MySQL. SQL Server.
2: what is are DBMS?
RDBMS Stands for “Relational Database Management System." An RDBMS is a DBMS
designed specifically for relational databases. ... A relational database refers to a database
that stores data in a structured format, using rows and columns.
3: what is SQL?
SQL is a domain-specific language used in programming and designed for managing data
held in a relational database management system, or for stream processing in a relational
data stream management system. Wikipedia
4: what is the difference between delete and truncate commands?
DROP and TRUNCATE are DDL commands, whereas DELETE is a DML command.
Therefore DELETE operations can be rolled back (undone), while DROP and
TRUNCATE operations cannot be rolled back. TRUNCATE can be rolled back if
wrapped in a transaction.
5: what is the difference between DROP and Truncate? Explain?
Difference between drop, delete and truncate in SQL database is frequently asked
interview question. DELETE removes rows one by one depending upon WHERE
condition or delete all rows if there is no WHERE condition. TRUNCATE removes all
rows at once and DROP command removes a table or database completely from database.
6: what is constraint? Explain
Constraints are the rules enforced on the data columns of a table. These are used to limit
the type of data that can go into a table. This ensures the accuracy and reliability of the
data in the database. Constraints could be either on a column level or a table level.
7 : what is data integrity ?Explain
Data integrity is the maintenance of, and the assurance of the accuracy and consistency of
data over its entire life-cycle, and is a critical aspect to the design, implementation and
usage of any system which stores, processes, or retrieves data.
8: DDL data Definition language :use?
A data definition or data description language is a syntax similar to a computer
programming language for defining data structures, especially database schemas. DDL
statements create and modify database objects such as tables, indexes, and users.
Common DDL statements are CREATE, ALTER, and DROP. A
9: DML Data control language explains?
DML stands for Data Manipulation Language. It is a language used for selecting,
inserting, deleting and updating data in a database. It is used to retrieve and manipulate
data in a relational database. DML performs read-only queries of data.
10: DCL Data control language explains?
A data control language (DCL) is syntax similar to a computer programming language
used to control access to data stored in a database (Authorization). In particular, it is a
component of Structured Query Language (SQL). Examples of DCL commands include:
GRANT to allow specified users to perform specified tasks.
11: why do we use SQL constraints? Which constraints we can use while creating a
database in SQL?
SQL constraints are used to specify rules for the data in a table. Constraints are used to
limit the type of data that can go into a table. This ensures the accuracy and reliability of
the data in the table. If there is any violation between the constraint and the data action,
the action is aborted.
12: what is the difference between SQL and MYSQL?
SQL is used in the accessing, updating, and manipulation of data in a database while
MySQL is an RDBMS that allows keeping the data that exists in a database organized.
SQL is a Structured Query Language and MySQL is a RDBMS to store, retrieve, modify
and administrate a database.
13: what do we need to check in database testing?
Database testing is a very important aspect of software testing. A database testing
is necessary to ensure that the values that an application is retrieving or storing into
the database are accurate or not. In order to test a database it is necessary that the
tester should have sound knowledge of SQL.
