Walkins Openings in India & Interview Questions

Related Content

• What is the difference between tables and structures?  04.08.07

  Tables: 1)Data is permanently stored in tables in the database. 2)Database tables are generated from them. Structure: 1)It contains data temporarily during pro...

• How many types of tables exist ?  03.08.07

  Four Types of Tables: 1. Transparent tables - Exists with the same structure both in dictionary as well as in database exactly with the same data and fields. Bo...

• How do I list the available tables in a database I’m querying?  28.07.07

  You can get a list of tables in a database by calling the INFORMATION_SCHEMA.Tables view like this: SELECT * FROM information_schema.tables This returns the n...

• What is difference between SQL and SQL*PLUS ?  27.07.07

  SQL*PLUS is a command line tool where as SQL and PL/SQL language  interface and reporting tool. Its a command line tool that allows user to type SQL commands t...

• What is Data Dictionary ?  27.07.07

  The DATA DICTIONARY is a comprehensive set of tables and views owned by the DBA users SYS and SYSTEM, which activates when ORACLE is initially installed, and is...