Programming Languages (22694)
Scripts (9280)
Networking (2571)
Microsoft Related (21566)
Databases (16615)
Operating Systems (12022)
Testing (17995)
Servers (1375)
MainFrame (6620)
Java Related (15396)
Middleware (526)
Web Related (7038)
Data Warehouse (8975)
HR Questions (2698)
Software Design (1923)
Debugging (73)
Version Control (464)
Editors (229)
Telecom (1164)
ERP CRM (26424)
Embedded Systems (1221)
Client Server (333)
Artificial Intelligence (3276)
Cryptography (718)
EAI (466)
Multimedia (674)
Software Development Life Cycle (303)
Image Processing (170)
Mobile OS (3116)
Security (125)
Big Data (4325)
Cloud Computing (1790)
Automation (2674)
Internet of Things (IoT) (299)
Apache Related (370)
Frameworks Tools (1329)
Oracle Related (0) A select query over a large table runs very slow because of the growing number of entries in that table. What different measures could be taken to improve speed?
5 14874A company wants to store their invoices in a database. They already have their customers and articles in that database. Both customer and article are each identified by an unique integer value. Please create the SQL statements for creating the necessary table(s) for storing the invoices in a MySQL database. An invoice should hold information like invoice number, customer, date, article(s) and quantity etc.
1 4513For the database from the previous question, please give an SQL query which returns the invoice number of all invoices which contain the article with the number ?1234?. The query should be able to run under a MySQL 4.0 database.
1 3765How would you backup and restore a big MySQL database? What are the advantages of the approach which you have taken over the others?
4 11040What are the differences between MySQL_fetch_array(), MySQL_fetch_object(), MySQL_fetch_row()?
2 8414The table tbl_sites contains the following data: ----------------------------------------------------- Userid sitename country ------------------------------------------------------ 1 sureshbabu indian 2 PHPprogrammer andhra 3 PHP.net usa 4 PHPtalk.com germany 5 MySQL.com usa 6 sureshbabu canada 7 PHPbuddy.com pakistan 8. PHPtalk.com austria 9. PHPfreaks.com sourthafrica 10. PHPsupport.net russia 11. sureshbabu australia 12. sureshbabu nepal 13. PHPtalk.com italy Write a select query that will displayed the duplicated site name and how many times it is duplicated?
4 9771
Data structure used to implements a menu:
What is difference between microsoft sql and mysql?
What is platform independence"?
Define the mesi? : Dot net architecture
Why you use browsermodule, commonmodule, formsmodule, routermodule, and httpclientmodule?
How do you define a variable?
Can we call dml statement in function?
For ex: i scheduled one ABAP program as a background job but it was running 10 days, how to analyze the problem?
Search for: how do I install linux?
Find the scenario and give the result: a, b, c are employees, where a, b will get basic, hra, da. C gets basic and da. How to group for the allowances? : sap abap hr
What is TPU and GPU ? Whey they we need ?
Explain about declaring variables in Visual basic?
Explain 'this' pointer and what would happen if a pointer is deleted twice?
What are the main advantages of drupal?
You are a contract project manager working with the State of Bliss. Your latest project involves rewriting the Department of Revenue's income tax system. One of the key stakeholders is a huge movie huff, and she has the power to promote you into a better position at the conclusion of this project. She's discovered that one of her favorite superstars lives in the State of Bliss and therefore must file income tax star. What is the most appropriate response? A. Report her to the management team B. Refuse to comply with the request, citing conflict of interest and violation of confidential company data C. Look up the information she's requested. Since the data is considered part of the project, there is no conflict of interest D. You believe that tax records are public information, so you comply with the request