A view is a virtual table that provides a customized way to look at data from one or more underlying tables, without storing the data itself. It acts as a logical window into the database.
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
Asked in Programmer Exam 2024 · Topic: Basics of Computers and Information Technology (Database Management Systems (DBMS) Basics: Concepts, Types of Databases)
More Information and Communication Technology questions
- 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 -
- Which of the following concurrency control protocols ensure both conflict serializability and freedom from deadlock? Consider the following: (I) 2PL (Two Phase Lock) (II) Time-Stamp ordering (III) Multiple granularity protocol
- Which SQL statement is used in embedded SQL to fetch data into host variables? - Question not attempted
- Consider a relation R with attributes (A, B, C), where B is the only candidate key. Identify the total number of possible super keys of the relation R. - Question not attempted
All 1,360 Information and Communication Technology questions →