what are the types of join and explain each? : Sql dba

1055

In ms access 2013 what are the different ways you can enter data?

1046

How can we run batch mode in mysql?

1072

There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?

2133

What are data resources?

934

How to insert and update data into a table with "insert" and "update" statements?

995

What is the use of commit?

1011

Why do we use %rowtype & %type in plsql?

1060

Can you upgrade sql express to full sql?

1086

What are the types of processing and explain each? : sql server analysis services, ssas

1160

What are variables in pl sql?

1179

Is microsoft access part of office?

889

What is the usage of when clause in trigger?

1069

Why partition by is used in sql?

1053

What do you mean by ms access?

910