what are different types of collation sensitivity? : Sql dba
Answer / Varunesh Pandey
Collation sensitivity refers to the way a database sorts characters or strings. In SQL DBA, there are three main types: case-sensitive, case-insensitive, and accent-sensitive. Case-sensitive compares the exact text, ignoring any differences in uppercase or lowercase letters. Case-insensitive ignores the difference between uppercase and lowercase letters when comparing text. Accent-sensitive considers diacritics (such as accents) when comparing text.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is switch column,colums cost in oracle?
What are Anti joins
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
how to debugg a procedure or package using dbms_output.put_line in plsql
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
What is synchronized subquery?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
What is example of database?
Is sql procedural language?
What is sql trigger example?
How the execution will be done in exceptions?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)