SQL statement - Definition - Administering and Managing an Oracle Database

Q.  Select the correct SQL statement.
- Published on 28 Jul 15

a. Select * from global_name;
b. Select from global_name;
c. Select * from domain_name;
d. Both A and C

ANSWER: Select * from global_name;

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 27 Aug 15
    - Select * will display all the columns from the table.

    - GLOBAL_NAMES - It specifies whether a database link is required to have the same name as the database to which it connects.
    - If the value of GLOBAL_NAMES is false, then no check is performed.
    - If you use or plan to use distributed processing, then Oracle recommends that you set this parameter to true to ensure the use of consistent naming conventions for databases and links in a networked environment.

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲