What are the different types of tables in sql?
No Answer is Posted For this Question
Be the First to Post Answer
IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????
What is the life of an sql statement?
How to find string or key value using pl/sql code?
what is union, minus and interact commands? : Sql dba
which operator is used in query for pattern matching? : Sql dba
What is union and union all keyword in sql and what are their differences?
What are all different types of collation sensitivity?
What is the purpose of cursors in pl/sql?
What do you understand by exception handling in pl/sql?
How will you a activate/deactivate integrity constraints?
What are inner outer left and right joins in sql?
How do you identify a primary key?
Oracle (3259)
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)