hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?
Answers were Sorted based on User's Feedback
Answer / shwetabh vishnoi
Oracle should be used as it is used by large scale data
handling companies and it provides more efficient data
administrative tools also it provides full support to Java
Technology which is used mostly.
| Is This Answer Correct ? | 9 Yes | 0 No |
What is an example of a foreign key?
What is create statement?
When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO
How would you add a section to a table?
Why do we backup Active Directory ?
what is checksum in sql server.........???
Explain the properties of a relational table?
Different types of keys in SQL?
What is normalization?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
What is a Join in SQL Server?
if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition
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)