4) Write a SQL query to find information (created date, type of object and name

Question

4) Write a SQL query to find information (created date, type of object and name of object) about objects in your database. You need only objects whose type is FUNCTION in your query

5) Write a SQL query to find information about queue tables in your database

6) Write a SQL query to find information(names of the files ,status) about redo logs in your database

7) Write a SQL query to find information (names of the files, status) about tempfiles in your database. Do not use the data dictionary table, use dynamic performance view. 8) Name two dynamic performance views that will give you information about the SGA.

Explanation / Answer

4)Write a SQL query to find information (created date, type of object and name of object) about objects in your database. You need only objects whose type is FUNCTION in your query ?

ANS) select Date,ObjectName,ObjectType from Sys.Objects where ObjectType = 'FUNCTION';
Inorder to execute this query you need to use the specific database that you are using that to change the current database in SSMS or by a Use database; command. current default database can be checked by using Select DB_NAME();

6) Write a SQL query to find information(names of the files ,status) about redo logs in your database

ANS) select GROUP#,STATUS from v$log;

This query gives the information fields such as GROUP# and STATUS that are present.

7) Write a SQL query to find information (names of the files, status) about tempfiles in your database. Do not use the data dictionary table, use dynamic performance view.

ANS) select * from v$sort_usage;

dynamic performance views v$sort_usage and for more information regarding the usage of space within these temporary segments we have to use v$sort_segment.

Related Questions

Navigate

• Browse (All)
• Browse 4
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.