0
Check this link
http://www.caspur.it/risorse/softappl/doc/sas_docs/proc/z10ntax.htm
Wiki User
∙ 15y ago
The syntax for granting privileges in a database management system typically involves using the GRANT keyword followed by the specific privileges (e.g., SELECT, INSERT, UPDATE, DELETE) and the object (e.g., table, view) being granted on, to a specific user or role. Example: GRANT SELECT ON table_name TO user_name;
Add your answer:
Earn +20 pts
Major components of DBMS?
The major components of a database management system (DBMS) include data definition, data manipulation, data integrity, and data security. Data definition involves defining the structure of the database and schema, data manipulation involves querying and modifying data, data integrity ensures the accuracy and consistency of data, and data security involves protecting the database from unauthorized access and ensuring data confidentiality.
What is the difference between controlled redundancy and uncontrolled redundancy?
Controlled redundancy refers to intentionally duplicating certain components in a system to ensure reliability and fault tolerance, whereas uncontrolled redundancy occurs unintentionally due to inefficient processes or lack of coordination. Controlled redundancy is planned and managed to enhance system performance, while uncontrolled redundancy can lead to inefficiencies and waste of resources.
What is Data redundancy in DBMS?
Data redundancy in DBMS refers to the duplication of data within a database system. This can result in inconsistencies and inefficiencies, as well as consuming more storage space. It is important to minimize data redundancy in order to maintain data integrity and improve performance.
Discuss the main categories of data models?
The main categories of data models are conceptual, logical, and physical. Conceptual data models represent high-level concepts and relationships between different data elements, focusing on understanding the business requirements. Logical data models map the conceptual model into a specific data storage technology, translating the conceptual model into a more structured format. Physical data models define how data will be stored, organized, and accessed in a specific database system, incorporating details like tables, columns, keys, and indexes.
Explain the concept of Relational Model with a real time example of a University System?
The relational model is a method of structuring data using tables where relationships between entities are represented by common attributes. In a University System, you could have tables for students, courses, and instructors. The students table would have student information, courses table would have course details, and the instructors table would have details of instructors. The relationship between them can be established using keys, such as a student ID or course ID.
What are highlights of DBMS?
NA_ what are highlights of advanced DBMS what are highlights of advanced DBMS what are highlights of advanced DBMS
Is java DBMS?
no, Java is not dbms.. Java is a programming language Dbms is database
Is SQL DBMS or RDBMS?
dbms
What are three types of dbms?
Three types of DBMS (Database Management Systems) include relational DBMS, object-oriented DBMS, and NoSQL DBMS. Relational DBMS organizes data into tables with rows and columns, object-oriented DBMS stores data as objects and classes, and NoSQL DBMS handles unstructured and semi-structured data with flexible schemas.
What are rows in dbms?
In DBMS the data is stored in the form of table . Each row in DBMS is known as tuple.
What are the importance of dbms in industrial environment?
importance of DBMS
What is the difference between DBMS and GIS?
gis and dbms
What is the purpose of dbms?
What is the purpose of dbms?DBMS is a software that organises the creation, storage and maintenance of Databases for end users.
What is the use of dbms?
DataBase Management System (DBMS)is a software package# it allows data to be effectively stored, retrieved and manipulatedand # the data stored in a DBMS packege can be accessed by multiple users and by multiple application programs like (SQL Server, Oracle, Ms-Access) .Types of DBMS# Hierarachical DBMS (HDBMS)# Network DBMS (NDBMS)# Relational DBMS (RDBMS)# Object Oriented DataBase(OODB)# Distributed DBMS (DDBMS)
When was Polyhedra DBMS created?
Polyhedra DBMS was created in 1993.
What is DBMS?
DBMS is short for database management system . DBMS is the collection of related records.
What does an DBMS do?
DBMS is database management system and it stores data that are related. DBMS maintains data security and integrity as well.
