Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,194,804 members, 7,956,059 topics. Date: Sunday, 22 September 2024 at 10:59 PM |
Nairaland Forum / Nairaland / General / Education / Advanced 100+ SQL Interview Questions & Answers For Freshers 2018 | Mindmajix (390 Views)
Unilag Hostel Balloting For Freshers(utme& DE) / Funaab Announces Resumption Date For Freshers 6 Months After Writing Post UME / Current Affairs Questions And Answers For 1960 Till Date (2) (3) (4)
(1) (Reply)
Advanced 100+ SQL Interview Questions & Answers For Freshers 2018 | Mindmajix by gracylayla(f): 8:13am On Jan 25, 2018 |
Q. What is SQL? SQL (Structured Query Language), It is also pronounced as “SEQUEL” and it an Non-procedural Language which is used to operate all relational database. And it is used to communicate with the Database. This is a standard language used to perform tasks such as retrieval, updation, insertion and deletion of data from a database. Features of SQL: 1. Portability 2. Client server architecture, 3. Dynamic data definition, 4. Multiple views of data, 5. Complete database language, 6. Interactive, 7. High level, 8. Structure and SQL standards. Q. What are the different types of SQL’s statements? 1. DQL - Data Query Language ( or) Data Retrival Language SELECT Statement 2. DML – Data Manipulation Language DML is used for manipulation of the data itself. INSERT Statement UPDATE Statement DELETE Statement 3. DDL – Data Definition Language DDL is used to define the structure that holds the data. CREATE Statement ALTER Statement DROP Statement RENAME Statement TRUNCATE Statement 4. DCL – Data Control Language DCL is used to control the visibility of data. GRANT Statement REVOKE Statement 5. TCL - Transaction Control Language COMMIT Statement ROLLBACK Statement SAVEPOINT Statement For More info click here: SQL Interview Questions
|
(1) (Reply)
Unilorin Bounces Use Of Hair Attachments And Other Female Essentials. / UNIPORT Additional Lists Of Students Recommended For Temporary Withdrawal 17/18 / What Is The Difference Between Stay And Live?
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 8 |