SQL set operators like `MINUS` (or `EXCEPT`), `UNION`, and `INTERSECT` require that the SE‐ LECT lists of the queries involved have the same number of columns and that the data types of corresponding columns are compatible. This ensures that the set operations can be performed correctly.
Which condition must be true for using MINUS between two relations? - 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. The two relations must have same number and types of columns
Read the notes: Basics of Computers and Information Technology →
More Information and Communication Technology questions
- 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
- Tag 260 in MARC-21 marks :
- By which entry you will get main information about a book ?
All 1,360 Information and Communication Technology questions →