Define identity and uniqueidentifier property of column?
Answer / Amardeep Singh
'Identity' is a property in SQL Server that automatically generates a unique number for each row when it is inserted into a table. This property ensures each row has a unique identifier. 'uniqueidentifier' is a data type used to store 16-byte globally unique identifiers (GUIDs) in Microsoft Access and SQL Server.
| Is This Answer Correct ? | 0 Yes | 0 No |
Define ddl and dml.
Discuss transparent DBMS?
What is mean by dbms?
What are the basic elements of Base configuration of an oracle Database ?
Explain ERASE packaged procedure ?
Explain, why is rdbms better than dbms?
Explain the difference between physical and logical data independence?
Explain the concept of acid properties in dbms?
What is progress open edge?
Where the data file for system Tablespace is located? What is its name, initial size and maxsize?
What are vdl and sdl?
What is the main purpose of a database?
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)