Databases Interview Questions
Questions Answers Views Company eMail

Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

2 9470

what operator performs pattern matching?

2 10593

Which command executes the contents of a specified file?

ABC, InfoMedia,

2 6875

Which command displays the SQL command in the SQL buffer, and then executes it?

TCS,

3 17210

Which system tables contain information on privileges granted and privileges obtained

1 6361

Which system table contains information on constraints on all the tables created?

2 6329

what command is used to create a table by copying the structure of another table?

7 12539

What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

2 8625

What is the use of CASCADE CONSTRAINTS?

3 9830

What is the difference between join and union.

3i Infotech, ABC, Oracle, Polaris, TCS, XT Global,

27 172539

What is the difference between anonymous block and named blocks?

3 9291

What is user Account in Oracle database ?

2 3586

How will you enforce security using stored procedures ?

2 4890

What are the dictionary tables used to monitor a database spaces ?

2 7387

What are the responsibilities of a Database Administrator ?

3 7010


Un-Answered Questions { Databases }

explain different types of backups avaialabe in sql server? : Sql server database administration

568


What does select top 1 do in sql?

514


What is mysql command line?

484


What are the default system databases in sql server 2000?

518


According to you what goes into making the best database administrator? : sql server database administration

517






What do you mean by a dependent functionality in a build?

634


What do you mean by rowid?

519


What the is the diff between local index and global index. give some example.

1110


What is scheduled job and how to create it?

527


How to use subqueries with the in operators in ms sql server?

541


In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

784


What are extended events in sql server?

484


How would you go about increasing the buffer cache hit ratio?

1925


How to assign sql query results to pl sql variables?

492


How to update multiple rows with one update statement in ms sql server?

616