Write the SQL functions which will perform the following operations: (i) To display the name of the month of the current date . -Technology

Write the SQL functions which will perform the following operations: (i) To display the name of the month of the current date . -Technology
by

1 Answer

Answer :

(i) monthname(date(now()))(ii) trim(“ Panaroma “)(iii) dayname(date(dob))(iv) instr(name, fname)(v) mod(n1,n2)
by

Related questions

Write the SQL command that will display the current time and date. -Technology

Description : Write the SQL command that will display the current time and date. -Technology

Last Answer : Select now();

Consider the following SQL string: “Preoccupied” Write commands to display: (a)“occupied” (b)“cup” -Technology

Description : Consider the following SQL string: “Preoccupied” Write commands to display: (a)“occupied” (b)“cup” -Technology

Last Answer : commands to display:(a)“occupied” (b)“cup”

Considering the same string “Preoccupied” Write SQL commands to display: (a) the position of the substring ‘cup’ in the string “Preoccupied” -Technology

Description : Considering the same string “Preoccupied” Write SQL commands to display: (a) the position of the substring ‘cup’ in the string “Preoccupied” -Technology

Last Answer : (a)select instr 'Preoccupied' , ‘ 'cup'));(b)select left 'Preoccupied',4);

Name SQL Single Row functions (for each of the following) that 1. returns a number. -Technology

Description : Name SQL Single Row functions (for each of the following) that 1. returns a number. -Technology

Last Answer : (i) ASCII () function returns a number.(ii) LCASE () function returns lowercase letters .(iii) DAYNAME () function returns names of days.(iv) DAYOFWEEK () function returns weekday number

Write SQL query to create a table “BOOKS” with the following structure: Table: BOOKS -Technology

Description : Write SQL query to create a table “BOOKS” with the following structure: Table: BOOKS -Technology

Last Answer : Create table Books(BOOK_ID Integer (2) Primary Key,BOOK_NAME Varchar (20),CATEGORY Varchar (20),ISSUE_DATE Date);

Write SQL query to create a table “Registration” with the following structure: -Technology

Description : Write SQL query to create a table “Registration” with the following structure: -Technology

Last Answer : Create table Registration(Reg_Id Integer(2) Primary Key,Name varchar(20),Course varchar(10),Join_Dt date);

With reference to the above given tables, write commands in SQL for (i) and (ii) and output for (iii) below: -Technology

Description : With reference to the above given tables, write commands in SQL for (i) and (ii) and output for (iii) below: -Technology

Last Answer : (i) select TName, Passenger from Train T, Reservation R where T.TrainId=R.TrainId;(ii) select T.* from Train T, Reservation R where T.TrainId!=R.TrainId;(iii)TrainIdTNameSourceDestination3424Lucknow MailLucknowNew Delhi5400Century ExpressNew DelhiKanpur

Consider the following table Furniture. Write SQL commands for the statements (i) to (viii) and write output for SQL queries (ix) and (x). -Technology

Description : Consider the following table Furniture. Write SQL commands for the statements (i) to (viii) and write output for SQL queries (ix) and (x). -Technology

Last Answer : SQL commands for the given statements (i) to (viii) ;1. SELECT FCODE, NAME. PRICE FROM Furniture WHERE PRICE < 5000;2. SELECT NAME. PRICE FROM Furniture3.4. WHERE NAME LIKE %table% ;5. SELECT DISTINCT WCODE ... ;15.16. Output for SQL queries (ix) and (x)(ix)SUM(PRICE)6500(x)COUNT(DISTINCT PRICE)5

Write SQL query to create a table Inventory with the following structure : -Technology

Description : Write SQL query to create a table Inventory with the following structure : -Technology

Last Answer : CREATE TABLE Inventory(Material Id Integer Primary Key,Material Varchar (50) NOT NULL,Category Char,DatePurchase Date) :

Write SQL query to create a table Player with the following structure : -Technology

Description : Write SQL query to create a table Player with the following structure : -Technology

Last Answer : CREATE TABLE Player(};

Write SQL Query commands based on the following table: -Technology

Description : Write SQL Query commands based on the following table: -Technology

Last Answer : This answer was deleted by our moderators...

Write the output of the following SQL command. select round (49.88); (a)49.88 (b)49.8 (c)49.0 (d)50 -Technology

Description : Write the output of the following SQL command. select round (49.88); (a)49.88 (b)49.8 (c)49.0 (d)50 -Technology

Last Answer : The correct answer is : (a) 50

Consider the decimal number x with value 8459.2654. Write commands in SQL to: i. round it off to a whole number -Technology

Description : Consider the decimal number x with value 8459.2654. Write commands in SQL to: i. round it off to a whole number -Technology

Last Answer : i. select round(8459.2654);ii.select round(8459.2654,-2);

What is the purpose of SQL? -Technology

Description : What is the purpose of SQL? -Technology

Last Answer : SQL is structured query language. It is a standard language of all the RDBMS.

Help him in writing SQL query for the following purpose: (i) To count how many female candidates will be attending the training. -Technology

Description : Help him in writing SQL query for the following purpose: (i) To count how many female candidates will be attending the training. -Technology

Last Answer : (i)Select count(name) from training where name like ‘Ms.%’;(ii) Select * from training where fee is NULL;(iii) Select city, fee from training where topic = ‘Cyber Security’;(iv) Alter table training add feedback varchar(20);

Ms. Pari, a beginner in SQL is not able to understand the meaning of “Cancelling a Transaction”. Help her in understanding the same. -Technology

Description : Ms. Pari, a beginner in SQL is not able to understand the meaning of “Cancelling a Transaction”. Help her in understanding the same. -Technology

Last Answer : Cancelling a transaction means rolls the transaction to the beginning. It aborts any changes made during the transaction and the state of database is returned to what it was before the transaction began to execute.Rollback command is used for the same.

What is the use of COMMIT in sql ? -Technology

Description : What is the use of COMMIT in sql ? -Technology

Last Answer : Commit is used to save all the DML transactions, and once saved they cannot be rolled back.

What is the purpose of SQL? -Technology

Description : What is the purpose of SQL? -Technology

Last Answer : SQL is structured query language. It is a standard language of all the RDBMS.

To select tuples with some salary, Siddharth has written the following erroneous SQL statement : -Technology

Description : To select tuples with some salary, Siddharth has written the following erroneous SQL statement : -Technology

Last Answer : The correct code is :SELECT ID, Salary FROM empsalaryWHERE Salary = 56000 ;

The ....... command can be used to makes changes in the rows of a table in SQL. -Technology

Description : The ....... command can be used to makes changes in the rows of a table in SQL. -Technology

Last Answer : The update command can be used to makes changes in the rows of a table in SQL.

Write the HTML code to display horizontal line of red color. -Technology

Description : Write the HTML code to display horizontal line of red color. -Technology

Last Answer :

Write HTML code to display various bullet types. -Technology

Description : Write HTML code to display various bullet types. -Technology

Last Answer : LotusRoseSunHoonoutput

Write HTML code to display ordered lists. -Technology

Description : Write HTML code to display ordered lists. -Technology

Last Answer : Many Ordered ListNumbered listSunMoonLetters 1is t SunMoonLowercase letters starting from 3rd 1etter

Write the HTML command to display the following in your Web page. -Technology

Description : Write the HTML command to display the following in your Web page. -Technology

Last Answer : The HTML command is – A2 + B2

Write the HTML code to display an image on the right side of the page. -Technology

Description : Write the HTML code to display an image on the right side of the page. -Technology

Last Answer :

Write the HTML code to display an inline image named pencil.jpg located at C:\ in the center of your Web page. -Technology

Description : Write the HTML code to display an inline image named pencil.jpg located at C:\ in the center of your Web page. -Technology

Last Answer :

Write HTML code to display a table with border of 5px. -Technology

Description : Write HTML code to display a table with border of 5px. -Technology

Last Answer : l2 „

Write the HTML code to display links of a web page in yellow colour. -Technology

Description : Write the HTML code to display links of a web page in yellow colour. -Technology

Last Answer :

Write HTML code to display the following table : -Technology

Description : Write HTML code to display the following table : -Technology

Last Answer : scheduleDuty Chart8 AM10AM12 AM KEVIN KHUSHBOO AMARJEET

In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. Write a query to display customer’s name who has -Technology

Description : In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. Write a query to display customer’s name who has -Technology

Last Answer : (i) Select cust_name from customer c,transaction t where c.Acc_No=t.Acc_No and Transaction_Type= 'Debit';(ii)Select cust_name, t.* from customer c, transaction t where c.Acc_No=t.Acc_No;(iii) ... total amount of all type of transactions, it will only display the total of credit transactions only.

Write a query to display customer’s name who has withdrawn the money. -Technology

Description : Write a query to display customer’s name who has withdrawn the money. -Technology

Last Answer : Select cust_name from customer c,transaction t where c.Acc_No=t.Acc_No and Transaction_Type= 'Debit';

Write a query to display customer’s name along with their transaction details. -Technology

Description : Write a query to display customer’s name along with their transaction details. -Technology

Last Answer : Select cust_name, t.* from customer c, transaction t where c.Acc_No=t.Acc_No;

Write a query to display customer’s name who have not done any transaction yet. -Technology

Description : Write a query to display customer’s name who have not done any transaction yet. -Technology

Last Answer : Select cust_name from customer c,transaction t where c.Acc_No!=t.Acc_No;

Consider the following Series object, S_amt Table 350 Chair 200 Sofa 800 Stool 150 i. Write the command which will display the name -Technology

Description : Consider the following Series object, S_amt Table 350 Chair 200 Sofa 800 Stool 150 i. Write the command which will display the name -Technology

Last Answer : i. print(S_amt[S_amt>250])ii. S_amt.name= 'Furniture'

Write command for the operations (i) to (iii) based on the spreadsheet below: -Technology

Description : Write command for the operations (i) to (iii) based on the spreadsheet below: -Technology

Last Answer : 1. At cell F2, type =D2*E2 and then copy this formula using mouse Fill handle onto range F3: F5.2. At cell G2, type =IF(C2=”Consumable”, F2*0.07, F2*0.11) and then copy this formula using mouse Fill handle onto range G3: G5.3. At cell G6, type =SUM(G2: G5).

Write the commands to do the following operations on the dataframes given above : (i) To add dataframes df1 and df2. -Technology

Description : Write the commands to do the following operations on the dataframes given above : (i) To add dataframes df1 and df2. -Technology

Last Answer : import numpy as npimport pandas as pddf1 = pd.DataFrame({'mark1':[30,40,15,40],'mark2':[20,45,30,70]});df2 = pd.DataFrame({'mark1':[10,20,20,50],'mark2':[15,25,30,30]});print(df1)print(df2)(i) ... , inplace=True) print(df1)(iv) df1.rename(index = {0: 'zero', 1:'one'}, inplace = True) print(df1)

Surgeons can perform delicate operations using devices through computers. This technology is known as?

Description : Surgeons can perform delicate operations using devices through computers. This technology is known as?

Last Answer : Robotics

Which of the following is true ? I. Implementation of self-join is possible in SQL with table alias. II. Outer-join operation is basic operation in relational algebra. III. Natural join and outer join operations are equivalent. (A) I and II are correct. (B) II and III are correct. (C) Only III is correct. (D) Only I is correct.

Description : Which of the following is true ? I. Implementation of self-join is possible in SQL with table alias. II. Outer-join operation is basic operation in relational algebra. III. Natural join and outer join operations are ... (B) II and III are correct. (C) Only III is correct. (D) Only I is correct.

Last Answer : (D) Only I is correct.

Write a program to accept two numbers from user and perform addition, subtraction, multiplication and division operations using pointer.

Description : Write a program to accept two numbers from user and perform addition, subtraction, multiplication and division operations using pointer.

Last Answer : #include #include void main() { int no1,no2,*ptr1,*ptr2,result; clrscr(); printf("Enter no1:"); scanf("%d",&no1); printf("\nEnter no2:"); scanf("%d",&no2); ptr1=&no1; ptr2=&no2; ... "\n Multiplication=%d",result); result=*ptr1/(*ptr2); printf("\n Division=%d",result); getch(); }

Write all the functions of Minimize button. -Technology

Description : Write all the functions of Minimize button. -Technology

Last Answer : The Minimize button is among the three buttons at the right end of the title bar. This button has a small dash (or minus sign). It shrinks the window and places it on the taskbar while leaving the program running. To go back to this window, click on taskbar where it is shrinked.

Write three functions that can be performed in Slide Sorter view of a presentation. -Technology

Description : Write three functions that can be performed in Slide Sorter view of a presentation. -Technology

Last Answer : The three functions that can be performed in Slide Sorter view are as follows:1. We can see the entire presentation.2. We can move slide from one place to another using click-drag method. Also, we can rearrange the order of slides.3. We can insert, rename and delete slides.

What Functions,SP,tools are available within SQL for Creating XML?

Description : What Functions,SP,tools are available within SQL for Creating XML?

Last Answer : have a look here… http://msdn.microsoft.com/en-us/library/ms190922.aspx

Explain how procedures and functions are called in a PL/SQL block ?

Description : Explain how procedures and functions are called in a PL/SQL block ?

Last Answer : Function is called as part of an expression. sal := calculate_sal ('a822'); procedure is called as a PL/SQL statement calculate_bonus ('A822');

Can you have two functions with the same name in a PL/SQL block

Description : Can you have two functions with the same name in a PL/SQL block

Last Answer : Yes.

Insulators perform which of the following functions? a) Conduction b) Convection c) Provide electrical insulation d) Allows current leakage at interfaces

Description : Insulators perform which of the following functions? a) Conduction b) Convection c) Provide electrical insulation d) Allows current leakage at interfaces

Last Answer : c) Provide electrical insulation

The battery has following three major functions to perform: a) To provide a source of current for engine starting, lighting and use of horn. b) To help control the voltage in the electrical system. c) To store the current produced by dynamo/alternator and to furnish the current d) all of the above. Ans. d

Description : The battery has following three major functions to perform: a) To provide a source of current for engine starting, lighting and use of horn. b) To help control the voltage in the electrical system. c ... the current produced by dynamo/alternator and to furnish the current d) all of the above. Ans. d

Last Answer : ans d

Write the name of layers that perform the following functions in OSI : I. Data Encryption II. Error Correction III. File Transfer IV. Data Encoding

Description : Write the name of layers that perform the following functions in OSI : I. Data Encryption II. Error Correction III. File Transfer IV. Data Encoding

Last Answer : 1. Data Encryption-Presentation Layer 2. Error Correction-Data link layer and Transport layer 3. File Transfer-Application layer 4. Data Encoding-Presentation layer

Touch screen is an electronic ……….. display that can detect the presence and location of a touch within the display area. -Technology

Description : Touch screen is an electronic ……….. display that can detect the presence and location of a touch within the display area. -Technology

Last Answer : Touch screen is an electronic visual display that can detect the presence and location of a touch within the display area.

How would you display text in the title bar of a browser? -Technology

Description : How would you display text in the title bar of a browser? -Technology

Last Answer : To display text in a title bar of a browser, use the tag inside the tag in the HTML document.e.g. HTML document

Tags and text that do not display directly on the page afe placed in (a) body (b) table -Technology

Description : Tags and text that do not display directly on the page afe placed in (a) body (b) table -Technology

Last Answer : (c) Information in tag is not displayed directly in the Web page. It is used to identify the matter (tags) used in a Web page.