Give two examples of how you might determine the structure
of the table DEPT.
Answers were Sorted based on User's Feedback
Answer / amrutharao d
1. SQL>Desc Dept
2. SQL>Select Table_name,Column_name,Data_type,nullable from
user_tab_columns wheRE table_name = 'DEPT'
3. SQL>set long 99999
SQL>select dbms_metadata.get_ddl('TABLE','DEPT') from
dual;
Is This Answer Correct ? | 8 Yes | 1 No |
by issuing "alter tablespace begin backup;" what happens to tablespace?
You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?
How do you open a cluster administrator? : sql server DBA
what is the difference between catalog & nocatalog?
why we use cursors
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What is dcl? : sql server DBA
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?
wat is global index and local indes