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) hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
2233Table 1: STUDIES PNAME (VARCHAR), SPLACE (VARCHAR), COURSE (VARCHAR), CCOST (NUMBER) Table 2: SOFTWARE PNAME (VARCHAR), TITLE (VARCHAR), DEVIN (VARCHAR), SCOST (NUMBER), DCOST (NUMBER), SOLD (NUMBER) Table 3: PROGRAMMER PNAME (VARCHAR), DOB (DATE), DOJ (DATE), SEX (CHAR), PROF1 (VARCHAR), PROF2 (VARCHAR), SAL (NUMBER) PNAME – Programmer Name, SPLACE – Study Place, CCOST – Course Cost, DEVIN – Language the software or package is developed in, SCOST – Software Cost, DCOST – Development Cost, PROF1 – Proficiency 1 Use the above table definitions to answer the questions that follow. Find out the selling cost average for packages developed in Oracle. Display the names, ages and experiences of all programmers How much revenue has been earned through
1 6564in a master-master replication with two masters and alternate slaves running on two systems.can i have a script or any mysql command to know which one is right now acting as master.
1 3779What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....
9 63838i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
eicc,
2336wat will be the sql query to extract only last 3 records from table supose table hving thousands for records
19 29987
How to create a single index for multiple columns?
Which database is good for large data?
At what levels can data validation be done in microsoft access database?
What is left join in sql?
Explain the disadvantages of cursors?
Can you insert NULL in unique column?
Why use update_statistics command in sql server?
What is the purpose of sql profiler in sql server? : sql server database administration
Is data lake a database?
Explain having clause?
List and explain the different types of join clauses supported in ansi-standard sql?
What information is maintained within the msdb database?
Show how functions and procedures are called in a pl/sql block.
What is table scan and index scan?
How do you backup a database?