Showing posts with label commands. Show all posts
Showing posts with label commands. Show all posts

Tuesday, 23 March 2021

Using a search engine, research operating system timelines

Using a search engine, research operating system timelines
then, based on the OS timelines that you find, answer the following questions: 

Question 1. Why do you think Linux and UNIX share more commands than Windows XP and UNIX?

Solution: Windows operating system is built for a different market peoples.It was mainly fancied over using of the GUI rather than the command line.But whereas Linux built after Unix so they have more number of commands in common.

Question 2. Which line of operating systems has recently become more similar to UNIX?

Solution: The line of operating system which has become more similar to Unix is the Mac OS.

Question 3. Which line of operating systems split into two lines, only to merge again later? 

Solution: The line of operating systems split into two lines, only to merge again later is like MS-Dos in command line and later it is merged into Windows.

Question 4. Why do you think most versions of Linux and Windows use the cd command to change directories? 

Solution: The command is very easy to understand as cd refers to change directory which gives a specific meaning.And also the command is taken from the Unix system

Saturday, 9 November 2019

Stored procedures and functions are available in the current database

Q: Which of the following commands is the best way to generate an overview of what stored procedures and functions are available in the current database and what each does? Assume that the developer(s) of the database have followed the good coding guidelines laid out in this unit.


1.
SHOW PROCEDURES;
2.
SHOW PROCEDURE STATUS WHERE db = DATABASE();
3.
SELECT * FROM INFORMATION_SCHEMA.ROUTINES;
4.
SELECT name, comment, type FROM mysql.proc WHERE db = DATABASE();

Solution:
 
2.SHOW PROCEDURE STATUS WHERE db = DATABASE();
This is the ideal statement to list the procedures stored in the database mentioned in the search condition.
Only SHOW PROCEDURES is not a valid statement as it also needs STATUS
SELECT * FROM INFORMATION_SCHEMA.ROUTINES; this statement selects all the rows from the table ROUTINES and displays the result.
SELECT name, comment, type FROM mysql.proc WHERE db = DATABASE(); This is the selective display of certain columns from the table mysql.proc from the database db.