answersLogoWhite

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 the difference between starts with and min value in sequence?

Sequences are not necessarily ordered from lowest to highest. A sequence can be (3, 6, 2, 8, 9, 1, 10) and in that case, 1 is the MIN value, but 3 is the first value in the sequence. In a database, a table is usually ordered by the table's primary key. PrimaryKey FirstName LastName Age 1 Eric Smith 20 2 Joan Johnson 18 3 John Ericson 24 4 Steve Johns 74 In the table above, the MIN value and the first value of the primary key would be the same, but the MIN value and the first value of the AGE would not be the same. In that case, the first value would be 20, but the MIN value would be 18. If you ordered the AGE in ascending order, then the MIN and the first values would be the same: SELECT TOP 1 AGE FROM tablename ORDER BY AGE. would provide the same result as SELECT MIN(AGE) AS AGE FROM tablename.

Difference between Index File and Index Sequential file?

index file is organized with the help of any key as index number at rondomly but index sequencial file organized with the help of any index sequentialy

rajesh patel

Where can I learn more about the fleet management system online?

Here are a few sites to look into: http://www.fmsgps.com/frontend/ www.intermec.com/FleetManagement www.virtualfleetsupervisor.com www.teletrac.net/Fleet-Management www.qualcomm.com

What is the advantages and disadvantages of hierarchical database?

hierarchical databases are fast and conceptually simple however do not support many-to-many relationships and have a lack of referential integrity. dan woodfield was a creater of Hierarchical Databases

One disadvantage of database system over previous data management is increased costs?

One disadvantage of database system over previous data management approaches is increased costs

What is data base sorting?

Databse sorting means arranging the records in a specific way to make reported data more usable.

How many maximum Redo Logfiles one can have in a Database?

In a database we can create 255 maximum redo log files

Depends on what you specified for MAXLOGFILES during database creation (manually) or what you specified for "Maximum no. of redo log files" with DBCA.

sri

What schools offer courses on SQL & Databases?

There are a number of schools that offer online courses on SQL and databases. These courses range in price as well as content covered.

Difference between object and dynamic modelling?

Object modelling is static type type of modelling,it is done with class diagram whereas dynamic modelling is associated with control in processing and it uses state diagram

What other database trends are also affecting data resource management in business?

Largest database

  • More strong analytical tools able for generating output (textually, graphically and also animations)
  • Increased adoption of MySQL
  • Improving replication technologies
  • Web 2.0
  • Mirroring and replication will enable offline data access
  • Mobile data access

Web Databases?

form_title=Web Databases form_header=Improve your workflow with databases created specifically for your business! What do you want your database to be used for?=_ What specific features do you want in your database?=_ How many employees will be access this database?=_

Custom Database Design?

form_title=Custom Database Design form_header=Design, develop and manage the database that fits your business needs. What do you need the database to offer?=_ Who will have access to the database?=_ Is this database for the internal or external public?= {(),Internal,External} Do you need the new database to integrate with a current system?= () Yes () No () Not Sure

Database Design Tools?

form_title=Database Design Tools form_header=Build a complicated database with ease by getting help from the experts! What tools do you want included on the database?=_ What is your budget for the database?=_ When does the database need to be completed by?=_

Database Design?

form_title=Database Design form_header=Transform your company by incorporating a new database design. What program will the database be used with?=_ Please explain what you will be using the database for?="" Do you have a database that you're already using?= () Yes () No

Who decides how and when data in an organization will be used and or controlled?

who decides how and when data in an organization will be used or controlled

Does databases has a note taking tools?

Yes, databases can have note-taking tools as part of their system. Some databases include features that allow users to add comments or notes to entries, records, or queries to document information, provide context, or share insights. These notes can enhance collaboration and aid in organizing and understanding the data stored in the database.