How does an execution block start and end in pl sql?

962

What is odi studio?

600

What do you mean by query optimization?

1016

How to set up autotrace for a user account?

1072

What do you understand by check constraint in sql server?

958

How would you lock a table in sybase? What text command will you use for it?

897

What is unique key constraint?

1072

If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?

581

What happens if date-only values are provided as date and time literals?

1038

What is the command used to fetch first 5 characters of the string?

1414

What are different types of statements supported by sql?

1175

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2321

What are different relationships existing in database?

1015

How a database is related to tablespaces?

1053

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1097