Which of the following expression is true due to associativity?

Asked in Analyst Cum Programmer (Deputy Director) 2024 · Topic: Basics of Computers and Information Technology (Database Management Systems (DBMS) Basics: Concepts, Types of Databases)

1. RU(SUT) = (RUS)UT
2. R∩(SUT) = (R∩S)UT
3. RUS=S∩R
4. R-(S-T)=(R-S)-T

More Information and Communication Technology questions

• When a foreign key attribute is updated, what must the DBMS ensure?
• What does the recovery manager do in DBMS transaction processing?
• SELECT Name FROM Employees WHERE Department = 'IT' UNION SELECT Name FROM FormerEmployees WHERE ExitReason = 'Resigned'; In the above SQL query, which of the following statement is true about its result? - Question not attempted
• Consider the following Assertion (A) and the Reason (R) - Assertion (A) : "In object-oriented databases, persistent objects can survive after program termination and can be retrieved in future sessions". Reason (R) : Persistent objects are stored in volatile memory for faster access and cease to exist when program ends. Which of the following is correct?
• Which property ensures that a transaction is either fully executed or not performed at all? - Question not attempted
• In ER diagrams, a 'weak entity' is characterized by which of the following? - Question not attempted
• What is the primary goal of BCNF in database normalization? - Question not attempted
• Which SQL query retrieves all employees whose address contains the substring ‘AJMER’ from EMPLOYEE table? - SELECT * FROM EMPLOYEE WHERE Address = ‘AJMER’; - SELECT * FROM EMPLOYEE WHERE Address LIKE ‘%AJMER’; - SELECT * FROM EMPLOYEE LIKE Address = ‘AJMER’; - SE‐ LECT * FROM EMPLOYEE WHERE Address LIKE ‘AJMER’;

All 1,360 Information and Communication Technology questions →