0
Which administrator tool is used to configure a data sources for applications that require access to database?
Wiki User
∙ 13y ago
The ODBC Administrator, also known as Data Sources (ODBC).
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
The relationships between users database applications DBMS and database?
The relationships between database applications DBMS and databases is as follows: Databases can be simple or complex. simple databases can be kept in a Microsoft Excel spreadsheet or they can be maintained in a user generated Microsoft Access database which can be programmed to query certain data that has been entered into that database over a period of time. Microsoft Excel and Microsoft Access are also applications that are used to build databases that can be incorporated into DBMS or Database Management Systems. These systems can be extremely complex or they can be simple meaning that maintenance to these systems is not demanding. If the DBMS is complex it may require an entire team of technicians and in some cases engineers.The relationship between users, database applications, databases, and Database Management Systems can be simplified even further - Users can access a database that has been created with a database application to query managed data that is a part of a uniform Database management system.
What a good database design require?
A good database design requires that the Data is conveniently and efficiently stored. Also the data can be easily stored and maintained.
What are the Advantages of single tier architecture?
Every thing means Database, application and presentation (user interface) are at same place.The application doesn't require Network connection to work.It is easy to install on any pc and start using it.
What are the relative merits of server based network and peer to peer?
There several merits of a server based network and peer to peer. Some of them include being cheap to set up and maintain, it is very fast and does not require a network administrator among others.Ê
What is a field length check in a database?
Most database field types have an inherent data length limit, however the business rules of the application may require a lower maximum limit on the field. For example, an integer field may hold positive and negative values in the hundreds of thousands or more, but if the field is designed to hold the price of something, it makes no logical sense to permit values that high if it is for items in a supermarket.
What are the security issues in database management system?
Database Security IssuesDaily Maintenance: Database audit logs require daily review to make certain that there has been no data misuse. This requires overseeing database privileges and then consistently updating user access accounts. A database security manager also provides different types of access control for different users and assesses new programs that are performing with the database. If these tasks are performed on a daily basis, you can avoid a lot of problems with users that may pose a threat to the security of the database.Varied Security Methods for Applications: More often than not applications developers will vary the methods of security for different applications that are being utilized within the database. This can create difficulty with creating policies for accessing the applications. The database must also possess the proper access controls for regulating the varying methods of security otherwise sensitive data is at risk.Post-Upgrade Evaluation: When a database is upgraded it is necessary for the administrator to perform a post-upgrade evaluation to ensure that security is consistent across all programs. Failure to perform this operation opens up the database to attack.Split the Position: Sometimes organizations fail to split the duties between the IT administrator and the database security manager. Instead the company tries to cut costs by having the IT administrator do everything. This action can significantly compromise the security of the data due to the responsibilities involved with both positions. The IT administrator should manage the database while the security manager performs all of the daily security processes.Application Spoofing: Hackers are capable of creating applications that resemble the existing applications connected to the database. These unauthorized applications are often difficult to identify and allow hackers access to the database via the application in disguise.Manage User Passwords: Sometimes IT database security managers will forget to remove IDs and access privileges of former users which leads to password vulnerabilities in the database. Password rules and maintenance needs to be strictly enforced to avoid opening up the database to unauthorized users.Windows OS Flaws: Windows operating systems are not effective when it comes to database security. Often theft of passwords is prevalent as well as denial of service issues. The database security manager can take precautions through routine daily maintenance checks.These are just a few of the database security problems that exist within organizations. The best way to avoid a lot of these problems is to employ qualified personnel and separate the security responsibilities from the daily database maintenance responsibilities.
Database Administrator?
A database administrator or DBA creates and maintains databases. The databases may be part of a Website, or store customer records at a company or patient records or the records of employees or students. Some databases, especially those associated with Websites, are primarily used to store content and serve it to the Web. Database administrators are often responsible not only for creating and supporting database applications, but the servers the databases live on. You may also be responsible for backing up and upgrading the database and its server.While many database administrators have a four year college degree with a computer science or engineering background, not all employers require a four year degree. You may find that you can take classes to prepare you for a job as a database administrator. You’ll need to learn about database design. You’ll also need to learn to use one or more database applications, ranging from Microsoft Access, Microsoft SQL Server, MySQL, or Oracle. You’ll need to learn about creating databases, how to construct queries, and about administering database servers.You should focus on one database application or product, but have at least basic familiarity with several database systems and servers. Most people specialize in one database product, but it’s a good idea to be familiar with the leading commercial database systems, as well as the free and open source MySQL. Most technical schools offer the kinds of classes you’ll need, as do extension and community college programs. Commercial database applications from Oracle and Microsoft offer professional certification exams. Be prepared to also do a lot of reading and research on your own, and consider volunteering for a school or local charity, or applying for internships as ways of gaining real-world experience.
What is the difference between data administrator and database designer?
(Additional answers or links to help answer the question are welcome.)AnswerWell, assuming that you are not a IT person, my answer is that the administrator is someone that manages the information(data) and databases(the boxes) and the designer creates the database schema (the way the data should be stored in the database, logic and physic). In my opinion, this two concepts should be always together, I mean, the DBA must know administration and design of databases.AnswerThe database administrator (DBA) should know something of database design, and in a small shop the DBA might handle both the administration and the data design. But since both areas (database administration and database design) require a lot of different and extensive knowledge and experience, best results can be had when there are experts in both areas. The DBA will work closely with the system administrator and may in fact also be an SA. The database designer will work closely with the software developers, as the data structure is integral to the software application. Of course, the database administrator and the database designer must coordinate with each other throughout the project.The DBA works with the RDBMS (relational database management system) itself and should know how to install and configure the RDBMS application. The DBA will work with the SA on tuning the system to best support the database engine and the database usage. The DBA and SA will work on sizing, storage, and backup management. The DBA is ultimately responsible for backups and everything else to do with data integrity (at the database level). The DBA will monitor data handling operations and either make database-level changes to improve performance or, through analysis, capture information to pass back to the data designer or development staff for their use in improving their usage of the database.The database designer should understand something of software development and applications structure. The designer will learn from the applications designers the data types, quantities, relationships, and desired operations (searches, sorts, updates, etc.) and work with the developers to design a structure/schema that will meet the requirements of the software application in terms of function and performance and at the same time assure data integrity. The designer will be considering matters such as unique keys, primary and foreign keys, data types, counters, naming, table relationships, search and sort elements, database normalization, search and sort efficiency, and data integrity.
The relationships between users database applications DBMS and database?
The relationships between database applications DBMS and databases is as follows: Databases can be simple or complex. simple databases can be kept in a Microsoft Excel spreadsheet or they can be maintained in a user generated Microsoft Access database which can be programmed to query certain data that has been entered into that database over a period of time. Microsoft Excel and Microsoft Access are also applications that are used to build databases that can be incorporated into DBMS or Database Management Systems. These systems can be extremely complex or they can be simple meaning that maintenance to these systems is not demanding. If the DBMS is complex it may require an entire team of technicians and in some cases engineers.The relationship between users, database applications, databases, and Database Management Systems can be simplified even further - Users can access a database that has been created with a database application to query managed data that is a part of a uniform Database management system.
In what companies must an administrator go through database training?
Most if not all IT companies in the US will require that their employees that work on the databases to have database training. Online database training can be found at http://www.webucator.com/database/index.cfm. Any company that is dealing with or has a technical support department or IT department. Most of them have to go through some kind of data base training to know the system well.
How do you use blocked applications on a non-admin account on a Mac Leopard OSX?
Applications are blocked so that they cannot be used without authorisation. To use a blocked application will require asking an administrator to unblock the application.Re: I know. It says that. I just want to know if there are any other ways.
Which of is predetermined by an administrator and does not require a routing algorithm?
ospf and static route
When do most schools require that applications be submitted?
january
What potential problem do developers of directory enabled applications face?
the large amount of resources that these applications require
Why is Microsoft office 2007 saying you are not an administrator?
Because certain functions in MS Office 2007 require you to be logged on as administrator. If you're not, then those higher functions are unavailable.
What are the skills to ba a secretary?
Word processing, writing, and communication skills are essential for all secretaries and administrative assistants. However, employers increasingly require extensive knowledge of software applications, such as desktop publishing, project management, spreadsheets, and database management.
Which database recovery techniques do not require any rollback?
remote backup system.
