A database view is essentially a saved query. It acts like a table but does not contain its own data. When you query a view, the database executes the underlying query to retrieve the data from the base tables. - Virtual Nature Views are virtual tables, meaning they do not store data. - Query-Based They are defined by a SQL query that selects data from one or more base tables. - Simplification Views can simplify complex database structures and queries for users. - Security They can be used to restrict access to certain rows or columns of a table.
‘View’ in a database is -
Asked in Programmer Exam 2024 · Topic: Basics of Computers and Information Technology (Database Management Systems (DBMS) Basics: Concepts, Types of Databases)
Show answer
Answer: C. A virtual table created by querying one or more tables
Read the notes: Basics of Computers and Information Technology →
More Information and Communication Technology questions
- Consider Relations R1 and R2 as given below - R1 (P, Q, R) P Q R p q r k i j m q r d e f R2 (Q, R, S) Q R S q r n i c o q r a q r b e f g The number of tuples in output of R1 ⋈ R2 will be - - Question not attempted
- Consider below statements – (I) Each non- leaf node in B+ tree has between [n/2] and n Children, where n is fixed for a particular tree. (II) The search key of a clustering index is always primary key. (III) Secondary indices must be dense. (IV) In a dense index, an index entry appears for only some of the search-key values. Which of the above statements are true?
- Any relation that is not a part of the Logical Model, but is made visible to a user as a virtual relation is called a - - Question not attempted
- Two phase locking protocol has which of the following problem(s)? - Question not attempted
- Consider following relation S(S1, S2, S3, E1, E2) and functional dependencies hold on the schema are as - FD1 : S1 → {S2, S3} FD2 : {E1, S3, S2} → S1 FD3 : E2 → {S3, S2, E1} What is the highest normal form of the relation S? - Question not attempted
- In ER Model, which of the following relationship is correct for a condition that a person in INDIA has an Aadhaar Card? - (5) Question not attempted
- An organized collection of logically related data is called - - (5) Question not attempted
- Indices whose search key specifies an order different from the sequential order of the file are called -
All 1,360 Information and Communication Technology questions →