Give two examples of how you might determine the structure
of the table DEPT.
Answer Posted / ramesh
From Scott Schema
1.Desc Dept
2.Select Table_name,Column_name,Data_type,nullable from
user_tab_columns wheRE table_name = 'DEPT'
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
how can you record information about current session?
What is replication? : sql server DBA
What are the recovery models for a database? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
What is a correlated sub-query? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
how can you get actual data change values from previous transactions in oracle?
. 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 the role of dip user in our database?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
Why would you use sql agent? : sql server DBA
what is a user-defined lock?
How to start SQL Server in minimal configuration mode?