Which three statements are true about the DESCRIBE command? (Choose three.)
Which three statements are true about the DESCRIBE command? (Choose three.)
The DESCRIBE command can be used from SQL Developer, meaning it is not limited to just SQL*Plus, so it can be used in multiple development environments. It displays the NOT NULL constraint for any columns that have that constraint, providing essential structural information about the database schema. Additionally, it can be used to display the structure of an existing view, making it a versatile tool for understanding the layout of both tables and views in a database.
BCD is the correct ans
i agree
But F is also definitely true.
Sorry my mistake, I didn't read "only". BCD it is :)
BCD are correct
It can be used in SQL developer as well as SQL Plus. I tried it as well.
I use describe comand in sqldeveloper, i guess the answers are not totaly right
B,C,D is correct
I agree BDC, Checked
A - FALSE; describe displays only NOT NULL constraint B - TRUE; C - TRUE; see A D - TRUE; e.g. DESC user_cons_columns; E - FALSE; dictionary views USER_CONS_COLUMNS, ALL_CONS_COLUMNS and DBA_CONS_COLUMNS shows constraints, not DESCRIBE F - FALSE; it can be used from SQL Developer
BCD is correct
B C D are correct
BCD are correct