Skip to main content

Posts

Showing posts from July, 2023

SQL IMPORTANT QURIES

 mysql> SHOW DATABASES; +----------+ | Database | +----------+ | mysql    | | test     | | tmp      | +----------+ The mysql database describes user access privileges. The test database often is available as a workspace for users to try things out. The list of databases displayed by the statement may be different on your machine; SHOW DATABASES does not show databases that you have no privileges for if you do not have the SHOW DATABASES privilege. See Section 13.7.7.14, “SHOW DATABASES Statement”. If the test database exists, try to access it: mysql> USE test Database changed USE, like QUIT, does not require a semicolon. (You can terminate such statements with a semicolon if you like; it does no harm.) The USE statement is special in another way, too: it must be given on a single line. You can use the test database (if you have access to it) for the examples that follow, but anything you create in that database can be removed by anyone else with access to it. For this reason, you

Fourer series formula

 Fourer series formula

DABASE MANAGEMENT SYSTEM QUESTIONS

 DABASE MANAGEMENT  SYSTEM SHORT QUESTIONS AND ANSWERS 1. What is database? A database is a logically coherent collection of data with some inherent meaning, representing some aspect of real world  and which is designed, built and populated with data for a specific purpose. 2. What is DBMS? It is a collection of programs that enables user to create and maintain a database. In other words it is general-purpose  software that provides the users with the processes of defining, constructing and manipulating the database for various  applications. 3. What is a Database system? The database and DBMS software together is called as Database system. 4. What are the advantages of DBMS? 1. Redundancy is controlled.  2. Unauthorised access is restricted.  3. Providing multiple user interfaces.  4. Enforcing integrity constraints.  5. Providing backup and recovery.  5. What are the disadvantage in File Processing System? 1. Data redundancy and inconsistency.  2. Difficult in accessing data. 3. Data