We are building EduLadder(ELADR) - Protocol

The Eladr Protocol is a decentralized, security and efficiency enhanced Web3 noSQL database powered by IPFS as the data storage layer https://ipfs.io/, and the Cardano block chain as the rewards token platform, https://cardano.org/. It provides a JSON based, IPFS layer 2 solution for data indexing and retrieval in an 'append only' file system built with open source Node.js API libraries.

Eladr tokens are designed to incentifised community members as a proof of contribution. Using that they can access diffrent infrastructure built on top of eladr


Using this You can,Buy courses,Reward others and exchange for real money.


WHITE PAPER Buy Now

Real Problems! Real Experts!

Join Our Telegram Channel !


The Eduladder is a community of students, teachers, and programmers. We help you to solve your academic and programming questions fast.
In eduladder you can Ask,Answer,Listen,Earn and Download Questions and Question papers.
Watch related videos of your favorite subject.
Connect with students from different parts of the world.
Apply or Post Jobs, Courses ,Internships and Volunteering opportunity. For FREE
See Our team
Wondering how we keep quality?
Got unsolved questions? Ask Questions
ELADR beta version launched

We launched Anonymous immutable internet on eladr protocol

For any question or query please joinOur Telegram Channel !


Try BETA
Youtube Videohttps://www.youtube.com/watch?v=ySLPZu3Jxro

Our Github Repo
FrontEnd BackEnd

We are looking for some great and cool people to work with us. Please sent your resume to admin@eduladder.com

MySql-Interview-questions-->View question


Asked On2019-06-18 05:44:47 by:RSHAH12

Taged users:


Likes:
Be first to like this question

Dislikes:
Be first to dislike this question
Talk about this  Like  Dislike
View all questions
Answers
  1. Data Definition language (DDL): 
    It contains of commands which defines the data. The commands are: 
  • create: It is used to create a table. 
    Syntax: 
create table 
tablename(attribute1 datatype......attributen datatype); 
  • drop: It is used to delete the table including all the attributes. 
    Syntax: 
drop table tablename; 
  • alter: alter is a reserve word which modifies the structure of the table. 
    Syntax: 
alter table 
tablename add(new column1 datatype......new columnx datatype); 
  • rename: A table name can be changed using the reserver ‘rename’ 
    Syntax: 
rename old table name to new table name; 

        2. Data Manipulation Language (DML): 
            Data Manipulation Language contains commands used to manipulate the data. 
            The commands are: 

  • insert: This command is generally used after the create command to insert a set of values into the table. 
    Syntax: 
insert into tablename values(attribute1 datatype);
:
:
:
insert into tablename values (attributen datatype); 
  • delete: A command used to delete particular tuples or rows or cardinality from the table. 
    Syntax: 
delete from tablename where condition; 
  • update: It updates the tuples in a table. 
    Syntax: 
update tablename set tuplename='attributename'; 
  • Triggers: 
    Triggers are actions performed when certain conditions are met on the data. 

    A trigger contains of three parts. 

      • (i). event – The change in the database that activates the trigger is event. 
         
      • (ii). condition – A query or test that is run when the trigger is activated. 
         
      • (iii). action – A procedure that is executed when trigger is activated and the condition met is true. 
         

             2. Client server execution and remote database access: 
                 Client server technology maintains a many to one relationship of clients(many) and server(one). We have commands in SQL that control how a client                          application can access the database over a network. 

              3. Security and authentication: 
                  SQL provides a mechanism to control the database meaning it makes sure that only the particular details of the database is to be shown the user and the                 original database is secured by DBMS. 

              4. Embedded SQL: 
                    SQL provides the feature of embedding host languages such as C, COBOL, Java for query from their language at runtime. 

              5. Transaction Control Language: 
                    Transactions are an important element of DBMS and to control the transactions, TCL is used which has commands like commit, rollback and savepoint. 

    • commit: It saves the database at any point whenever database is consistent. 
      Syntax: 
    commit; 
    • rollback: It rollbacks/undo to the previous point of the transaction. 
      Syntax: 
    rollback; 
    • savepoint: It goes back to the previous transaction without going back to the entire transaction. 
      Syntax: 
    savepoint; 

            6. Advanced SQL: 
                The current features include OOP ones like recursive queries, decision supporting queries and also query supporting areas like data mining, spatial data and             XML(Xtensible Markup Language). 


Answerd on:2021-12-29 Answerd By:Muskan-Kumari

Likes:
Be first to like this answer

Dislikes:
Be first to dislike this answer
Talk about this  Like  Dislike

You might like this video:Watch more here

Watch more videos from this user Here

Learn how to upload a video over here



Lets together make the web is a better place

We made eduladder by keeping the ideology of building a supermarket of all the educational material available under one roof. We are doing it with the help of individual contributors like you, interns and employees. So the resources you are looking for can be easily available and accessible also with the freedom of remix reuse and reshare our content under the terms of creative commons license with attribution required close.

You can also contribute to our vision of "Helping student to pass any exams" with these.
Answer a question: You can answer the questions not yet answered in eduladder.How to answer a question
Career: Work or do your internship with us.Work with us
Create a video: You can teach anything and everything each video should be less than five minutes should cover the idea less than five min.How to upload a video on eduladder