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
what are the types of connection load-balancing?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
. 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?
Can you redefine a table online?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What are the commands used in dcl? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
How do you open a cluster administrator? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What is transparent data encryption? : sql server DBA
Why would you call update statistics? : sql server DBA
how to restore files with rman?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What is the default port no on which sql server listens? : sql server DBA