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

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

1 Answer

Answer :

Select now();
by

Related questions

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

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

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

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 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);

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 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

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'

Given a Pandas series called Sequences, the command which will display the first 4 rows is .... (a) print(Sequences.head(4)) -Technology

Description : Given a Pandas series called Sequences, the command which will display the first 4 rows is .... (a) print(Sequences.head(4)) -Technology

Last Answer : (a) print(Sequences.head(4))

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...

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);

Write the output on the Web page for the following HTML command. -Technology

Description : Write the output on the Web page for the following HTML command. -Technology

Last Answer : The output on the Web page will be the Atomic weight of O 2

Which tab and command let you insert animations in your slide? Write the steps for applying animations in your presentation. -Technology

Description : Which tab and command let you insert animations in your slide? Write the steps for applying animations in your presentation. -Technology

Last Answer : Animating Text and Objects:We can give sound effects or visual effects, including movement to the text or objects in a presentation. Animation can be used to focus on important points, to control the ... to animate the object.Effects appear in the Custom Animation list in the order that you add them

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 command using Insert() function to add a new column in the last place(3rd place) named “Salary” from the list Sal=[10000,15000,20000] -Technology

Description : Write the command using Insert() function to add a new column in the last place(3rd place) named “Salary” from the list Sal=[10000,15000,20000] -Technology

Last Answer : EMP.insert(loc=3,column=”Salary”,value=Sal)

(i) Write command to compute sum of every column of the data frame. -Technology

Description : (i) Write command to compute sum of every column of the data frame. -Technology

Last Answer : (i) df1.sum()(ii) df1[‘Rainfall’].mean()(iii) df1.loc[:11, ‘maxtemp’:’Rainfall’].mean( )

Write the Django command to start a new app named ‘users’ in an existing project? -Technology

Description : Write the Django command to start a new app named ‘users’ in an existing project? -Technology

Last Answer : python manage.py startapp users

Given the following Series S1 and S2: Write the command to find the sum of series S1 and S2 -Technology

Description : Given the following Series S1 and S2: Write the command to find the sum of series S1 and S2 -Technology

Last Answer : print(S1+S2)

What command is used to remove a table or index from a SQL database ?

Description : What command is used to remove a table or index from a SQL database ?

Last Answer : DROP TABLE is used to remove a table or index from a SQL database .

What command would you use to encrypt a PL/SQL application?

Description : What command would you use to encrypt a PL/SQL application?

Last Answer : WRAP

In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction? A. CREATE PACKAGE B. CREATE SCHEMAC.CREATE CLUSTERD.All of theaboveE.None of the above;

Description : In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction? A. CREATE PACKAGE B. CREATE SCHEMA C. CREATE CLUSTER D. All of theabove E. None of the above;

Last Answer : CREATE SCHEMA

In SQL, which command(s) is(are) used to change atable's storage characteristics? A. ALTER TABLE B. MODIFY TABLE C. CHANGE TABLE D. All of theabove E. None of the abov

Description : In SQL, which command(s) is(are) used to change atable's storage characteristics? A. ALTER TABLE B. MODIFY TABLE C. CHANGE TABLE D. All of theabove E. None of the abov

Last Answer : ALTER TABLE

. In SQL, which command(s) is(are) usedto recompilea storedfunction? A. SET FUNCTION B. SET STORED FUNCTION C. ALTER FUNCTION D. All of theabove E. None of the above

Description : . In SQL, which command(s) is(are) usedto recompilea storedfunction? A. SET FUNCTION B. SET STORED FUNCTION C. ALTER FUNCTION D. All of theabove E. None of the above

Last Answer : ALTER FUNCTION

In SQL, the command(s) is (are)used tocreate an index for atable or cluster A. CREATE INDEX B. MODIFY INDEX C. SET INDEX TO FILE D. All of theabove E. None of the above

Description : In SQL, the command(s) is (are)used tocreate an index for atable or cluster A. CREATE INDEX B. MODIFY INDEX C. SET INDEX TO FILE D. All of theabove E. None of the above

Last Answer : CREATE INDEX

Write Unix command for following: i)create a folder OSY ii) create a file FIRST in OSY folder iii) List/display all files and directories. iv) Write command to clear the screen

Description : Write Unix command for following: i)create a folder OSY ii) create a file FIRST in OSY folder iii) List/display all files and directories. iv) Write command to clear the screen

Last Answer : i) create a folder OSY: $mkdir OSY ii)create a file FIRST in OSY folder: $cd OSY $cat>FIRST or $ touch FIRST iii) List/display all files and directories: $ls iv) to clear screen: $clear

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.

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

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 ;

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 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;

A command tab which allows to create the table in an interactive manner is called (a) Home -Technology

Description : A command tab which allows to create the table in an interactive manner is called (a) Home -Technology

Last Answer : (d) MS-Access provides a command tab named Create which allows creating the table in an interactive manner.