0
Database Programming
Databases are collections of tables that maintain and display information, often collaboratively; this information can be used for interaction with an application or gaining general knowledge. Questions about database engines and modifying or using them belong in this category.
8,803 Questions
What is serial processing in an operating system?
Serial processing in operating system is one of the types of data processing in the computer. The data is read by the CPU, analyzed, processed and then executed in this system.
Can we use javascript in SQL stored procedure?
Transact-SQL in an internationally standardised method to create, modify and delete databases and tables, as well as insert, retrieve, modify and delete data stored in a database. With Microsoft SQL Server 2005 you can also author procedures in any managed language such as C# or VB. This is because it is integrated with the CLR which allows you write powerful programs inside stored procedures. All functionality of the .NET Framework BCL (Base Class Library) is available to your stored procedures. This means that developers have access to thousands of pre-built classes and routines which can be accessed. The BCL includes classes that provide functionality for improved string functioning, advanced math operations, file access, cryptography, and more.
What is data type and field name?
Data Type defines the type of data that will be stored.
Example : int, byte, short etc
- everton fc are the best man united and Liverpool are awful
- partick thistle
- Happy
- Sad
electronic health records have same access control requirements as paper based record system
Where default access database store?
the data which alerady stored in the memory of the computer and can not be change is know as default access data base store
Is a computer an office machine yes or no in both cases how can you explain?
An 'office machine' for offical purposes is a computer, laptop, fax machine, copier, printer, scanner, plotter, or any other large machine used to do business. It does not include phones or calculators.
Sample program of arithmetic operation in assembly language?
The simple Assembly Programs:
mov ax,15
mov bx,45
add ax,bx
int 21
This is a simple Assembley programs that perform addition of two numbers
like 15,45 in above example
Which cabling can support a maximum throughput of 100 megabits per second Mbps?
CAT5 or if nessecary CAT6 Twisted pair...
The foreign key has to match the information from the corresponding record in the other table.
What is the advantage of presenting data in table form?
Depends on advantage compared to what. There may not be any advantage compared with representing data in graph form.
How to write a program to show the counter that counts 1000000 in a second?
You need to know how long a loop of 1000000 takes to execute. If it executes in an appropriate fraction of a second, you can provide a sub-loop or no-op instructions to make up the difference. If it does not, you can not.
Difference between grant and revoke statements in sql?
grant will give permission to the user on database by using revoke we can remove the permission
Data is stored as objects and can be interpreted only using the methods specified by its class.
What is the history of Unified Modeling Language?
Overview
The Unified Modeling Language (UML) is used to specify, visualise, modify, construct and document the artifacts of an object-oriented software intensive system under development.[1] UML offers a standard way to visualize a system's architectural blueprints, including elements such as:
- actors
- business processes
- (logical) components
- activities
- programming language statements
- database schemas, and
- reusable software components.[2]
UML combines best techniques from data modeling (entity relationship diagrams), business modeling (work flows), object modeling, and component modeling. It can be used with all processes, throughout the software development life cycle, and across different implementation technologies.[3] UML has synthesized the notations of the Booch method, the Object-modeling technique (OMT) and Object-oriented software engineering (OOSE) by fusing them into a single, common and widely usable modeling language. UML aims to be a standard modeling language which can model concurrent and distributed systems. UML is a de facto industry standard, and is evolving under the auspices of the Object Management Group (OMG). OMG initially called for information on object-oriented methodologies that might create a rigorous software modeling language. Many industry leaders have responded in earnest to help create the UML standard.[1]
UML models may be automatically transformed to other representations (e.g. Java) by means of QVT-like transformation languages, supported by the OMG. UML is extensible, offering the following mechanisms for customization: profiles and stereotype. The semantics of extension by profiles have been improved with the UML 2.0 major revision.
Can a having clause and a where clause be used together in a SQL query?
Yes, you can use a having clause and a where clause together in an SQL query. select emp_dept, sum(value) total_value, count(1) sales
from all_sales
where emp_dept in ('fashions','stereos','cosmetics')
group by emp_dept
having sum(value) > 125000
Which type of data is the number of employees in Walmart store in Hutchinson Kansas?
The type of data that would probably best describe the number of employees of a single store might be an unsigned byte (from 0 to 255). Generally, you want to plan for future expansion, however, so you might want to designate the type as an unsigned short int (0 to 65535).
If you need the portability of a compact disk combined with speed of a memory chip then Kingstons flash drives are for you. Kingston is the industry standard when it comes to memory and related products. Recently Kingston Technology added Data Traveler 256MB USB Flash Memory Drive to their a portable Flash digital media product line. The Data Traveler units elegant ultra light weight sleek design and plug and play technology makes it the latest digital media solution to combine high storage capacity with portability and fast data transfer rates. Data Traveler is a portable Flash drive that combines the speed of a memory chip with the portability of a compact disk, When you plugging the DataTraveler into your system's USB port, the DataTraveler will appear as a separate hard drive on your system, thus allowing for easy data transfers. The USB Flash device operates with the latest operating systems supporting USB interface 1.1. Drivers are not needed for the DataTraveler on operating systems except Windows 98 (drivers included for Windows 98).
yes
Are there any disadvantages to having data linked?
Yes. If your data source is deleted or moved, your spreadsheet or database application will have no data to display.
Does rebooting the computer erases all the data on the computer?
No, simply rebooting your computer (turning it off, then on again) does not erase all the data on the computer. However, you can lose unsaved data on files that you are currently working on if you don't save. Reformatting (reinstalling your operating system) will erase all the data on your computer and set it back to its default settings.
Analysis of an algorithm means prediction of how fast the algorithm works based on the problem size. It is necesary to analyze an algorithm so that, if we have n no Of algorithms then the fastest and 1 with less time & space complexity can selected. Which will allow and ensure maximum utilization of available resourses.
