Define the explaining plan and its used
Define the explaining plan and how is this used?
Expert
EXPLAIN PLAN:
This command is a tool to tune SQL statements. Here to use it you should have an explain_table generated within the user you are running the explain plan intended for. It is created using the utlxplan.sql script. When the explain plan table subsists you run the explain plan command providing as its argument the SQL statement to be described. The explain_plan table is after that queried to see the execution plan of the statement. This plans can also be run by using tkprof.
Write down some of the differences between the data query and the knowledge query.
What do you understand by the term concurrency control in DBMS?
Name the main data structures used in these areas: Hierarchical data model, RDBMS and Network data model?
Define the efficient data structure used within the internal storage representation in RDBMS?
What is meant by the parameter file?
List out the various schemas which are supported by the BO Designer?
Explain the two in order to importing users & groups from the supervisor?
Give a brief introduction of the term SAS Business Intelligence?
Write down the unsupported repository objects for mapplet?
18,76,764
1934575 Asked
3,689
Active Tutors
1445095
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!