0
Can A schema can be changed by an administrator or an application to best suit an organization needs?
Wiki User
∙ 11y ago
True
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
What are the roles and responsibilities of database administrator?
The Database Administrator is super-user of the system.The role of the DBA is very important which is defined by the following functions.ØDefining the SchemaThe DBA defines the schema which contains the structure of the data in the application.....http://solvedbcaassignment.blogspot.in/2013/03/2-what-are-roles-and-responsibilities.html
What are the responsibilities of database administrator?
* Defining the Schema The DBA defines the schema which contains the structure of the data in the application. The DBA determines what data needs to be present in the system ad how this data has to be represented and organized. * Liaising with Users The DBA needs to interact continuously with the users to understand the data in the system and its use. * Defining Security & Integrity Checks The DBA finds about the access restrictions to be defined and defines security checks accordingly. Data Integrity checks are also defined by the DBA. * Defining Backup / Recovery Procedures The DBA also defines procedures for backup and recovery. Defining backup procedures includes specifying what data is to backed up, the periodicity of taking backups and also the medium and storage place for the backup data. * Monitoring Performance The DBA has to continuously monitor the performance of the queries and take measures to optimize all the queries in the application.
What does a Database management system contain?
A DBMS contains a set of Schemas, tables and views that are used to stored/organize user information logically. The user has options to view, insert, update and delete the data present in the tables.DBMS Schema 1 Table 1 Column 1Column 2Column 3...Table 2Table 3...Schema 2Schema 3...
List six major steps that you would take in setting up a database for a particular?
1. Requirement Analysis 2. Conceptual Data Base Design 3. Logical Data Base Design 4. Schema Refinement 5. Physical Data Base Design 6. Security Design
What Database Administration Looks Like?
Computer technology has changed the way all organizations operate. The management of large amounts of data has become a mandatory objective for businesses. Data is generated by customer service operations, sales orders, inventory reports and other day-to-day activities. Specialized software and hardware is used to store data in a database. Database administrators design, implement and manage the operation of databases. They are responsible for not only the operation, but the efficiency and the security of their databases. Database administrators sometimes have to migrate data from old databases into new databases, which can be very challenging because how the old database system was set up determined how the data was accessed. Transferring data from one system to another is one of the most stressful parts of this job, especially since the data transfer sometimes has to be done manually in order to circumvent incompatibilities between the two systems. Aside from difficulties like these, the majority of the day-to-day activities of a database administrator consist of monitoring the database and making any adjustments or repairs as needed. Database management involves having detailed knowledge of the database structure, including external, internal and conceptual schema used for storing and transferring data. The risk of data loss must constantly be monitored, and database administrators have to move fast to protect data from corruption if the database somehow malfunctions. Computer and network security has become especially important since the rise of orchestrated cyber attacks against major corporate and retail websites. Protecting the database from external attack is critical, and database administrators need to be able to react quickly to attempted attacks to prevent the database from becoming infected with malicious software such as a computer virus or otherwise damaged or corrupted. This risk is highlighted by the fact that many databases are connected to the Internet and thus are exposed to the risk of remote cyber attacks. Database administrators typically work in comfortable, well-lighted offices for forty hours per week, although they may work more if the situation demands. Salaries range from forty-nine to eighty-one thousand dollars per year.
Five main functions of database administrator?
Schema Definition Storage structure and access method definition Schema and physical organization modification. Granting authorization for data access. Routine Maintenance
What is schema and sub-schema?
The schema is the physical arrangement of the data as it appears in the DBMS. The subschema is the logical view of the data as it appears to the application program.
What is sub schema?
The schema is the physical arrangement of the data as it appears in the DBMS. The sub-schema is the logical view of the data as it appears to the application program.
What are the roles and responsibilities of database administrator?
The Database Administrator is super-user of the system.The role of the DBA is very important which is defined by the following functions.ØDefining the SchemaThe DBA defines the schema which contains the structure of the data in the application.....http://solvedbcaassignment.blogspot.in/2013/03/2-what-are-roles-and-responsibilities.html
What happened schema master fails?
No updates to the Active Directory schema will be possible. Since schema updates are rare (usually done by certain applications and possibly an Administrator adding an attribute to an object), then the malfunction of the server holding the Schema Master role will not pose a critical problem.
What is difference between Schema and Subschema?
SCHEMA is the physical arrangement of the data as it appears in the DBMS. SUB-SCHEMA is the logical view of the data as it appears to the application program.
What language Enables a database administrator to define schema components?
SQL (Structured Query Language) enables a database administrator to define schema components, such as tables, columns, indexes, and relationships in a database. By using SQL commands like CREATE TABLE, ALTER TABLE, and CREATE INDEX, administrators can create and modify the structure of a database according to their requirements.
What type or permissions do you need in order to install the first Exchange server in a forest?
Forest: Schema Admin, Enterprise admin, schema admin, domain admin, local machine administrator
What is a task that a member of Schema Administrator cannot perform that a member of Enterprise Administrator or Domain Administrator can perform?
Since a member of a Schema Admin grp can only modify the active directory schema, but a member of an enterprıse or domain admin grp will have full control so there are lot of thıngs a schema admın cannot do that an enterprıse admın can do, for ınstance lıke backıng up fıles, accessıng the workstatıon from the network, managıng audıtıng and securıty logs, restore fıles and dırectorıes, shut down the server, take ownershıp of fıles and other object...
You are installing an application that requires the Active Directory schema to be extended The?
Using the Active Directory Schema snap-in, add an attribute to the user accountproperty for Employer ID Code.
2.5 What is the difference between logical data independence and physical data independence?
Logical data independence refers to the ability to change the conceptual schema without affecting the external schema or application programs. Physical data independence, on the other hand, refers to the ability to change the physical schema without affecting the conceptual schema. This allows changes in the storage structure or access methods without changing how data is viewed or accessed by applications.
What services does active directory schema provide?
An active directory schema allows the user to perform a detailed search for an individual, place or other piece of information. A well designed schema represents software that gives the user access to information within an organization. The structure becomes more detailed as the schema becomes detailed.
