The `LIKE` operator combined with the `%` wildcard is used to find substrings within text fields in SQL queries.
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’;
Asked in Analyst Cum Programmer (Deputy Director) 2024 · Topic: Basics of Computers and Information Technology (Database Management Systems (DBMS) Basics: Concepts, Types of Databases)
More Information and Communication Technology questions
- Suppose we have two relations: R(A, B, C) and S(B, C, D). Consider the natural join operation: R ⋈ S Which of the following could be the resulting schema of this operation?
- Which relational algebra expression selects all employees from the emp table whose salary is greater than 40000 and who work in the Delhi location?
- What is the primary purpose of the embedded SQL?
- Which statement best describes the goal of data abstraction in a DBMS?
- A serializable schedule has 5 transactions, each with 2 operations. How many possible serial schedules exist?
- Consider the following Query SELECT Course FROM STUDENT GROUP BY Course HAVING Count(*) > 10; where STUDENT is a relation with one of its attributes as ‘Course’. What will be the result of the Query?
- Which collision resolution technique in hashing handles collisions by storing all keys that hash to the same index in a linked list? - Question not attempted
- In query optimization, why is join order important when dealing with multiple joins? - Question not attempted
All 1,360 Information and Communication Technology questions →