⟩ How do you resize a data file?
ALTER DATABASE DATAFILE <datafile_name> RESIZE <new_size>;
ALTER DATABASE DATAFILE <datafile_name> RESIZE <new_size>;
What are the default extensions of the files created by library module?
What are the two phases of block coordination?
Lot of users are accessing select sysdate from dual and they getting some millisecond differences. If we execute SELECT SYSDATE FROM EMP; what error will we get. Why?
What are Most Common types of Complex master-detail relationships?
What are the Coordination Properties in a Master-Detail relationship?
What is the difference between SHOW_EDITOR and EDIT_TEXTITEM?
What are the built-ins that are used to Attach an LOV programmatically to an item?
What are the built_ins used the display the LOV?
Give two methods you could use to determine what DDL changes have been made.
What are the types of calculated columns available?