Shared By Anuj :
- NFS Managed By?
- IDRBTRDBMS-10 QUS
- NPCL
- Sql - 10 qus
- LAN,WAN ROUTER SWITCH
- CASE STUDY ON LANGUAGE AND DATABASE
- WHICH BIOMETRIC USED IPHONEX-IRIS
- RDBMS-10 QUS
- NFS MANAGED BY ? - NPCI
- 8-10 QUS ON DATA WAREHOUSE
- 2-3 QUS MALWARE,VIRUS ETC
Questions asked in Morning Shift: From Murugan Sir Collection
1. SDLC phase and definition
2. Normalization definition
3. Threats and attacks in network.
4.Routers/Switch/Firewall
5. Honey Pot
6. Biometrics.
7. Disaster avoidance.
8. Phases of CMM.
9. SQL query commands.
10. DDL/DML
11. NEFT/RTGS/FEDWIRE
12.SLA Negotiation
13. Purging of data.
14. Artificial Intelligence
15. Spamming/Eavesdropping/Phishing
16.Digital Signature
17. IDEA encryption
18. RAID
19.Generalized Audit Software
20. Virtual Classroom concept
21. Web SAFARI
22. Strategic Information
23. Fibre Optic cables.
24. Blooms Taxonomy
25. OLAP
26.Deferred Payment System
27.SFMS
28. Floor Limit ??
29. Software Escrow Management?
30. Types of cards?
31. Call Centre Benchmarks?
32. Hash Function used in Digital Signature?
33. SCORM benifit?
34. Characteristics of BHIM ?
35. Rupay Cards used in ?
Shared by Rahul :
One question on honeypot
5 questions on Sql simple one, no programming needed, 5 question on DBMS concept like redundancy, consistency etc, Trojan horse 1 question, ATM CARD & RVM chip one Question, ER DIAGRAM 1 question , Networking Devices 5 Questions,
Biometric authentication -2,3 questions, VOIP 5 questions, DRP, BCP - 2 Questions, LAN, MAN, WAN - 1 Question, COMPUTER GENERATION -2 question like C++ which generation language, 1 question on class os IP- like 147.221.22.223 which class ip, 3- Questions on operating system like mobile os- ios, os used in servers- unix/ linux,why normalization used,1 question virtualization, key management like digital signature, SFMS protocol- X.509, NEFT RTGS QUESTIONS-2, fasterst media- Optical fibre in guided access, email spam, sniffing, spoofing, imp- Evas dropping in netwrok- 2 Questions
Shared by Rahul :
One question on honeypot
5 questions on Sql simple one, no programming needed, 5 question on DBMS concept like redundancy, consistency etc, Trojan horse 1 question, ATM CARD & RVM chip one Question, ER DIAGRAM 1 question , Networking Devices 5 Questions,
Biometric authentication -2,3 questions, VOIP 5 questions, DRP, BCP - 2 Questions, LAN, MAN, WAN - 1 Question, COMPUTER GENERATION -2 question like C++ which generation language, 1 question on class os IP- like 147.221.22.223 which class ip, 3- Questions on operating system like mobile os- ios, os used in servers- unix/ linux,why normalization used,1 question virtualization, key management like digital signature, SFMS protocol- X.509, NEFT RTGS QUESTIONS-2, fasterst media- Optical fibre in guided access, email spam, sniffing, spoofing, imp- Evas dropping in netwrok- 2 Questions
READ :
The SQL ORDER BY clause is used to sort the data in ascending or descending order, based on one or more columns. Some databases sort the query results in an ascending order by default.
Syntax
The basic syntax of the ORDER BY clause is as follows −
SELECT column-list FROM table_name [WHERE condition] [ORDER BY column1, column2, .. columnN] [ASC | DESC];
You can use more than one column in the ORDER BY clause. Make sure whatever column you are using to sort that column should be in the column-list.
Example
Consider the CUSTOMERS table having the following records −
+----+----------+-----+-----------+----------+ | ID | NAME | AGE | ADDRESS | SALARY | +----+----------+-----+-----------+----------+ | 1 | Ramesh | 32 | Ahmedabad | 2000.00 | | 2 | Khilan | 25 | Delhi | 1500.00 | | 3 | kaushik | 23 | Kota | 2000.00 | | 4 | Chaitali | 25 | Mumbai | 6500.00 | | 5 | Hardik | 27 | Bhopal | 8500.00 | | 6 | Komal | 22 | MP | 4500.00 | | 7 | Muffy | 24 | Indore | 10000.00 | +----+----------+-----+-----------+----------+
The following code block has an example, which would sort the result in an ascending order by the NAME and the SALARY −
SQL> SELECT * FROM CUSTOMERS ORDER BY NAME, SALARY;
This would produce the following result −
+----+----------+-----+-----------+----------+ | ID | NAME | AGE | ADDRESS | SALARY | +----+----------+-----+-----------+----------+ | 4 | Chaitali | 25 | Mumbai | 6500.00 | | 5 | Hardik | 27 | Bhopal | 8500.00 | | 3 | kaushik | 23 | Kota | 2000.00 | | 2 | Khilan | 25 | Delhi | 1500.00 | | 6 | Komal | 22 | MP | 4500.00 | | 7 | Muffy | 24 | Indore | 10000.00 | | 1 | Ramesh | 32 | Ahmedabad | 2000.00 | +----+----------+-----+-----------+----------+
The following code block has an example, which would sort the result in the descending order by NAME.
SQL> SELECT * FROM CUSTOMERS ORDER BY NAME DESC;
This would produce the following result −
+----+----------+-----+-----------+----------+ | ID | NAME | AGE | ADDRESS | SALARY | +----+----------+-----+-----------+----------+ | 1 | Ramesh | 32 | Ahmedabad | 2000.00 | | 7 | Muffy | 24 | Indore | 10000.00 | | 6 | Komal | 22 | MP | 4500.00 | | 2 | Khilan | 25 | Delhi | 1500.00 | | 3 | kaushik | 23 | Kota | 2000.00 | | 5 | Hardik | 27 | Bhopal | 8500.00 | | 4 | Chaitali | 25 | Mumbai | 6500.00 | +----+----------+-----+-----------+----------+
No comments:
Post a Comment