Give two examples of how you might determine the structure
of the table DEPT.
Answer Posted / 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 |
Post New Answer View All Answers
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What authentication modes does sql server support? : sql server DBA
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
what is logical system in sap basis
who owns the operating system files created by the utl_file package?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What are statistics, under what circumstances they go out of date, how do you update them?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
which background process invoke at the time of upgradation tell me???
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
what are the benefits of flashback feature?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.