- Trigger: Event-driven database objects that execute actions automatically. - Cursor: Mechanism for processing query results row by row. - Stored Procedure: Reusable, precompiled SQL code blocks stored on the database server. - View: A virtual table providing a custom perspective on data from one or more base tables.
Which amongst the following options is the correct match of the Names in Column-I with the Actions in the Column-II? Column-I (Name) (i) Trigger (ii) Cursor (iii) Stored procedure (iv) View Column-II (Action) (a) A virtual table derived from other tables (b) Automatically execute active rules on occurrence of events (c) Single tuple from a Query result that retrieves a collection of tuples (d) Precompiled SQL statements that are stored at the database server - (5) Question not attempted
Asked in Analyst Cum Programmer (Deputy Director) 2024 · Topic: Basics of Computers and Information Technology (Database Management Systems (DBMS) Basics: Concepts, Types of Databases)
Show answer
Answer: C. (i)-(b), (ii)-(c), (iii)-(d), (iv)-(a)
Read the notes: Basics of Computers and Information Technology →
More Information and Communication Technology questions
- What is a common technique for concurrency control in DBMS? - Question not attempted
- Which condition must be true for using MINUS between two relations? - Question not attempted
- In embedded SQL, which prefix allows the programmers to refer shared variables in SQL statements? - Question not attempted
- Which of the following statement is true with regards to candidate keys and super keys? - Every super key is a candidate key. - Candidate keys must contain all attributes of the relation. - Candidate keys are minimal super key with no redundant attributes. - A candidate key must include a foreign key. - Question not attempted
- Under which of the following conditions, a SQL view is said to be updatable? - The FROM clause has more than one database relation. - The SELECT clause contains only attribute names (no expressions, aggregates or DIS‐ TINCT). - Any attribute not listed in SELECT clause can be set to NULL and is not part of primary key. - The query does not use GROUP BY or HAVING. Select the correct combination using the code below - (1) (A), (B), (C) and (D) (2) (A), (B) and (D) only (3) (B), (C) and (D) only (4) (A) and (B) only (5) Question not attempted
- Consider a database table - Studentcourses(Student_Id, Student_Name, Course_Id, Course_Name, Instructor_Name) If a new course "XYZ123" is required to be introduced but none of the students have enrolled for it yet then which amongst the following problems will the database face? - Updation anomaly - View anomaly - Deletion anomaly - Insertion anomaly - Question not attempted
- What is the primary goal of query optimization in a DBMS? - To encrypt data during query execution - To validate query syntax - To normalize the database schema - To find the most efficient and cost-effective way to execute a query - Question not attempted
- In M.S. Excel, column in a table is called as
All 1,360 Information and Communication Technology questions →
