Automation of XYZ Soft drink parlour XYZ Soft drink Parlour wants to automate its functionalities. The Admin can add new items in the stock and also update the details of the existing items. The items are only soft drinks .The details to be maintained are Item’s name, quantity and price. The salesman can view the availability of the items as per the order placed then confirms the order. At the end of day the Admin generates a report of the total sales (total quantity and price of individual items). Identify the Joins , union, and Cartesian product Report.

1 Answers  

---

Q.N.1: DIFFERENCE BETWEEN HUB AND SWITCH? Q.N.2: DIFFERENCE BETWEEN WINNT 4.0SVR & WINDOW2000/2003SVR? Q.N.3: WHAT IS ACTIVE DIRECTORY AND WHAT ARE BENEFITS? Q.N.4: NAME ANY TWO NAME RESOLUTION NETWORK SERVICE? Q.N.5: NAME PRINT SERVICE? Q.N.6: NAME WINDOWS INSTALLER SERVICE? Q.N.7: NAME THE SERVICE RESPONSIBLE FOR MAKING NETWROK BROWSING LIST? Q.N.8: DIFFRENCE BETWEEN IP VERSION 4.0 AND VERSION 6.0? Q.N.9: DIFFRENCE BETWEEN TCP AND UDP PROTOCOL? Q.N.10: WRITE DOWN THE DEFAULT SUBNET MASK OF i. 191.168.0.20 ii. 172.16.0.2 iii. 201.15.16.1 Q.N.11: BENEFITS OF DOING SUBNETTING IN NETWORK? Q.N.12: DEFINE THE FOLLOWING TERMS:  SINGLE COLLISION DOMAIN AND MULTIPLE COLLISION DOMAINS.  SINGLE BROADCAST DOMAIN. Q.N.13: WHAT IS DNS? ROLE OF DNS SERVER IN ACTIVE DIRECTORY? Q.N.14: DIFFERENCE BETWEEN  DNS AND DDNS  IXFR AND AXFR  WIN2000 DNS AND WIN 2003 DNS Q.N.15: WHAT DO YOU MEAN BY GC SERVER? FUNCTION OF G.C SERVER IN ACTIVE DIRECTORY? Q.N.16: NAME THE PROTOCOL AND SERVICE USED IN INTRASITE REPLICATION OF AD DATABASE? Q.N.17: WHEN DO WE NEED TO CREATE DIFFERENT SITES IN ACTIVE DIRECTORY? Q.N.18: WRITE DOWN THE PORT NUMBERS (TCP/UDP)  LDAP(LIGHT WEIGHT DIRECTORY ACCESS PROTOCOL)  DNS (DOMAIN NAME SERVICE)  DHCP (DHYNAMIC HOST CONFIGURATION PROTOCOL)  SMTP (SIMPLE MAIL TRANSFER PROTOCOL)  HTTPS (HYPER TEXT TRANSFER PROTOCOL SERVER)  WINS (WINDOWS INTERNET NAME SERVICE)  KERBEROS  TELNET (TERMINAL EMULATION PROGRAM)  FTP (FILE TRANSFER PROTOCOL)  TFTP (TRIVIAL FILE TRANSFER PROTOCOL)  IP (INTERNET PROTOCOL)  ICMP (INTERNET CONTROL MESSAGE PROTOCOL)  TCP (TRANMISSION CONTROL PROTOCOL)  UDP (USER DATAGRAM PROTOCOL)  RDP (REMOTE DESKTOP PROTOCOL) Q.N.19: CORE COMPONENTS OF MICROSOFT EXCHANGE SERVER 2003? Q.N.20: DEFINE ROUTING AND ADMINISTRATIVE GROUP IN MICROSOFT EXCHANGE SERVER? Q.N.21: DIFFERENCE BETWEEN POP3 AND IMAP4 PROTOCOL? Q.N.22: DIFFERENCE BETWEEN EXCHANGE 5.5 AND EXCHANGE SERVER 2000/2003? Q.N.23: DIFFERENCE BETWEEN FAT AND NTFS? Q.N.24: MAX.NO. OF PARTITIONS IN WINDOWS 2000/XP? Q.N.25: WRITE THE COMMANDS:-  TO DISPLAY ARP CACHE TABLE  TO DISPLAY RESOLVER CACHE TABLE  TO DISPLAY NETBIOS CACHE TABLE  TO TRACE ROUTE  TO DISPLAY PORT STATUS  DNS TROUBLESHOOTING COMMAND  TO DISPLAY EFFECTIVE GROUP POLICY  TO KNOW FSMO ROLES AND USER’S SID  TO VERIFY REPLICATION STATUS OF ACTIVE DIRECTORY DATABASE  TO START AND STOP A PARTICULAR SERVICE Q.N.26: NAME THE ACTIVE DIRECTORY PARTITION? Q.N.27: WHAT DO YOU MEAN BY SINGLE AND MULTIMASTER REPLICATION? STATE ALL FSMO ROLES AND THEIR FUNCTION? Q.N.28: WHAT IS SYSTEM STATE DATA BACKUP? HOW TO RESTORE? Q.N.29: DIFFENIATEBETWEENAUTHORITATIVE AND NON-AUTHORITATIVE RESTORE OF SYSTEM STATE DATA? Q.N.30: DIFFERENCEBETWEEN INCREMENTAL & DIFFERENTIAL BACKUP? Q.N.31: WHAT IS THE BENEFIT OF VSC (VOLUME SHADOW COPY) IN WIN2003SERVER? Q.N.32: DEFINE THE TERM POOLING & SPOOLING IN RESPECT OF PRINTER? Q.N.33: WHICH AUTHENTICATION PROTOCOL IS USED IN WIN2000 /WIN2003 DOMAIN (NATIVE)? Q.N.34: BENFITS OF VPN? DIFFERENCE BETWEEN L2TP AND PPTP PROTOCOL? Q.N.35: DIFFERENCE BETWEEN SECURITY AND DISTRIBUTION GROUP? WHAT DO YOU UNDERSTAND BY GROUP NESTING? Q.N.36: DIFFERENCE BETWEEN OUTLOOK EXPREES AND MICROSOFT OUTLOOK? Q.N.37: WHAT IS THE MAX.LENGTH OF UTP CAT 5 SEGMENT? WHAT IS THE STANDARD COLOR CODING? Q.N.38: FUNCTION OF POINT TO POINT (PPP) PROTOCOL IN WAN CONNECTION? Q.N.39: BASIC DIFFERENCE BETWEEN ISDN AND PSTN LINE? Q.N.40: WHAT DO YOU UNDERSTAND BY COMPACTING NTDS.DIT? WHAT IS THE WAY TO DO THAT?

2 Answers   HCL,

---

MILITARY ENGINEER SERVICES

1 Answers   MES,

---

hi...sir, i have passed my 10th from I.C.S.E. board with 64% and my 12th with 71%( i have passed my 12 th in the second year...1 year back)...and in engineering i took computer science ..but i am having back in 1st sem and 2nd sem too...i have completed my 3rd sem in pes school of engineering...will i be eligilble to get placed in any companies...if so, what are the requirements for multi national companies like yahoo,google,microsoft and e.t.c....at present my aggregate is 63%...pls help me??

2 Answers   HCL,

---

Explain Belady's Anomaly.

0 Answers  

---

Write a c pgm to print the letter as per given condition i.e.. if u give 4 out put should b 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4

0 Answers   Veritas,

---

Please send me Sample papers National Informatics Centre (NIC) Programmer. I am giving this paper first time..so if any one have previous question papers send to manoj200.yadav@gmail.com. thnx in advance

0 Answers   NIC,

---

i have got a gre score of 800 in my first attemt and a score of 1080 in the second and i have repoted both the scores.will it effect my chances of getting good university

0 Answers  

---

I am refused L1-B visa filed by my employer on May 09 by US consulate Chennai. When i am eligible to apply L1-B visa again through my employer?

0 Answers  

---

what are the differences between malloc() and calloc() in c language?

0 Answers  

---

HELLO ALL OF U.I HAVE QUALIFIED IN SBI CLERICAL WRITTEN EXAMINATION AND MY INTERVIEW IS ON 20TH OF THIS MONTH.IAM SOTWARE BACKGROUNDED CANIDIATE SO CAN ANY ANYBODY WHOSE INTERVIEW IS OVER CAN TELL ME THAT WHAT QUESTIONS THEY ASKED RELATING TO COMPUTER SCIENCE.

0 Answers  

---

what are the qualifications for a cse student to get government job

1 Answers  

---