0
How do you view users permissions in oracle database via sql query?
Wiki User
∙ 12y ago
ask the DBA
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
The object that contains all of the database data is?
The object that contains all of the database data is typically a database management system (DBMS) such as MySQL, PostgreSQL, or Oracle. This system stores, organizes, and manages the data in a structured format, allowing users to query and manipulate the information stored within it.
What is database query?
A database "query" is basically a "question" that you ask the database. The results of the query is the information that is returned by the database management system. Queries are usually constructed using SQL (structured query language) which resembles a high-level programming language.
What does a query request?
A query request is a message sent to a database or search engine to retrieve specific information based on specified criteria. It allows users to ask questions or request data from a database or system.
What does query mean in relation to databases?
In databases, a query is a request for information from a database. It is usually written in a special query language, such as SQL, and is used to retrieve, update, or manipulate data stored in the database. Queries allow users to interact with the database to extract the specific information they need.
What is responsible for providing users with access to appropriate data in a database?
A database management system (DBMS) is responsible for providing users with access to appropriate data in a database. The DBMS controls user access permissions, enforces security measures, and manages queries to ensure users can retrieve the data they are authorized to access.
What term is used to refer to the requesting of information from a database?
querying
What is a query used for on a database?
A query is used to retrieve specific information or data from a database based on specific criteria. It allows users to search, filter, and retrieve data that meets their requirements. Queries can also be used to update or modify existing data in the database.
Why database system support data manipulation using a declarative query languages?
Declarative query languages allow users to specify what data they want without specifying how to retrieve it. This abstraction simplifies the querying process and allows for optimization by the database system to determine the most efficient way to execute the query. It also enhances portability and adaptability by separating the query logic from the database structure.
What provides the ability to query information from the database and to insert tuples into delete tuples from and modify tuples in the database?
SQL (Structured Query Language) provides the ability to query, insert, delete, and modify data in a database. It is a standard language used for managing and manipulating relational databases. By using SQL commands, users can interact with the database to retrieve, add, change, or remove data as needed.
What is an unsafe query Give an example and explain why it is important to disallow such queries?
A query in which the output is possibly infinite. This most often occurs in queries which are recursive or which contain negation. Such queries are disallowed by many database management systems to prevent unsafe queries.
What is the language used by most of the DBMS for helping their users to access data?
SQL (Structured Query Language) is the language used by most DBMS (Database Management Systems) to help users access data. It allows users to perform tasks such as querying databases, manipulating data, and managing database structures. SQL is a standardized language that is widely used in the industry.
Where can you find a comparison between oracle snapshot replication and oracle streams replication?
The process of creating and managing duplicate versions of a database. Replication not only copies a database but also synchronizes a set of replicas so that changes made to one replica are reflected in all the others. The beauty of replication is that it enables many users to work with their own local copy of a database but have the database updated as if they were working on a single, centralized database. For database applications where users are geographically widely distributed, replication is often the most efficient method of database access.
