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

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

1 Answer

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
by

Related questions

State any two differences between single row functions and multiple row functions. -Technology

Description : State any two differences between single row functions and multiple row functions. -Technology

Last Answer : Differences between single row functions and multiple row functions.(i) Single row functions work on one row only whereas multiple row functions group rows(ii) Single row functions return one output per row whereas multiple row functions return only one output for a specified group of rows.

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)

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

X, Y , Z are three towns on a lake which flows uniformly. Y is equidistant from X and Z. A man rows from X to Y and returns in 20hrs. He can row from X to Z in 8 hr. The ratio of speed of the man in still water to the speed of the current is. A) 3:5 B) 5:3 C) 2:3 D) None of these

Description : X, Y , Z are three towns on a lake which flows uniformly. Y is equidistant from X and Z. A man rows from X to Y and returns in 20hrs. He can row from X to Z in 8 hr. The ratio of speed of the man in still water to the speed of the current is. A) 3:5 B) 5:3 C) 2:3 D) None of these

Last Answer : ANSWER: A Explanation: Let the speed of man in still water = x km/hr Speed of the current = y km/hr Speed of downstream = (x+ y) km/hr Speed of upstream = ( x - y) km/hr Let the lake be flowing from X to Z and  xy = yz a ... y = 1 / 4  4x - 4y = x + y  3x = 5y x / y = 3 / 5 x : y = 3 : 5

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.

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

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.

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

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

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

Write down the steps to insert a new row into the table. -Technology

Description : Write down the steps to insert a new row into the table. -Technology

Last Answer : Insert a RecordSteps to insert a record in a Datasheet View are as follows:Step 1 When you create a table, a new blank record automatically appears in the second row of the table or If you enter ... into the fields.Step 3 When you have finished adding records in the datasheet, save it and close it.

HTML tag for row is (a) <colspan> (b) <tr> -Technology

Description : HTML tag for row is (a) (b) -Technology

Last Answer : (b) HTML tag for row is .

Which of the following is used to specify the beginning of a table’s row? (a) <table> -Technology

Description : Which of the following is used to specify the beginning of a table’s row? (a) -Technology

Last Answer : (b) tag indicates the beginning of a table’s row.

A cell is an intersection of a row and a column. -Technology

Description : A cell is an intersection of a row and a column. -Technology

Last Answer : True A cell is an intersection of a row and a column.

The rowspan attribute with < table > tag is used to merge more than one cells row wise. -Technology

Description : The rowspan attribute with < table > tag is used to merge more than one cells row wise. -Technology

Last Answer : True The rowspan attribute merges the cells row wise in a table.

The <td> tag (column setting) have higher priority than <tr> tag (row setting). -Technology

Description : The tag (column setting) have higher priority than tag (row setting). -Technology

Last Answer : True The tag (column setting) have higher priority than tag (row setting).

Table row <tr> tag can accept one attribute. -Technology

Description : Table row tag can accept one attribute. -Technology

Last Answer : False The tag can accept many attributes.

Soham has clicked on the cell residing at the intersection of first row and ninth column. What will be the address of the selected cell? -Technology

Description : Soham has clicked on the cell residing at the intersection of first row and ninth column. What will be the address of the selected cell? -Technology

Last Answer : First row and ninth column address will be II.

First row and ninth column address will be II. -Technology

Description : First row and ninth column address will be II. -Technology

Last Answer : There are two methods of adding a new worksheet iasm Excel workbook; Insert worksheet tab at the bor >m and Insert button on cells group under Home tab.

A cell range starting from first row, first column to fourth row and fifth column be can be represented as -Technology

Description : A cell range starting from first row, first column to fourth row and fifth column be can be represented as -Technology

Last Answer : (a) [A1: E4] because row count starts from 1 and column count starts from A andfirst we write the starting cell address.

Address of the cell at 10th column and 30th row is ……………… -Technology

Description : Address of the cell at 10th column and 30th row is ……………… -Technology

Last Answer : Address of the cell at the 10th column and 30th row is J30.

Write a small python code to drop a row from data frame labeled as 0. -Technology

Description : Write a small python code to drop a row from data frame labeled as 0. -Technology

Last Answer : # Drop rows with label 0df = df.drop(0)print(df )

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.

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

What are the functions of an interpreter? -Technology

Description : What are the functions of an interpreter? -Technology

Last Answer : Interpreter is very useful for debugging and suitable for novice programmer. This is a slow process and consumes less memory space.Some basic functions of an interpreter are as follows:1. Translates one instruction at a time.2. It checks the execution of the instructions line-by-line.

What is an operating system? Explain its functions with an examples. -Technology

Description : What is an operating system? Explain its functions with an examples. -Technology

Last Answer : It is a program that acts as an interface between the user and the hardware (i.e. for all computer resources). An operating system is an important component of a computer system, which controls and ... users cannot access the system e.g. MS-DOS, Windows 95, Windows XP, Windows Vista etc.

Mr. X has recently installed a new operating system on his computer 1. Describe the main functions of an operating system. -Technology

Description : Mr. X has recently installed a new operating system on his computer 1. Describe the main functions of an operating system. -Technology

Last Answer : 1. Monitors the performance of the system, enables software to communicate with hardware and application softwares to be loaded; gives prompts and error reports to the users.2. Antivirus and compression tool.

State any two functions of operating system,. -Technology

Description : State any two functions of operating system,. -Technology

Last Answer : 1. Device managementIn a computer system, there is a tremendous speed mismatch between the CPU and the I/O devices. The job of an operating system is to maintain a balance between the CPU and I/O ... execution, a process needs certain resources such as CPU time, memory space, files and I/O devices.

Suchi has recently installed a new operating system on her computer. 1. Describe the main functions of an operating system. -Technology

Description : Suchi has recently installed a new operating system on her computer. 1. Describe the main functions of an operating system. -Technology

Last Answer : 1. Monitors the performance of the system, enables software to communicate with hardware, enables applications, software to be loaded; gives prompts and error reports to the users.2. Command-driven user interface means CUI, by which a user gives instructions via typing command onto the computer.

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.

What is a File? Explain its functions. -Technology

Description : What is a File? Explain its functions. -Technology

Last Answer : FilesThese are the collection of information. In fact, almost all type of information is stored into the files. There are many types of files stored in different formats including operating system files, program ... period ( )).e.g. A document created using WordPad might have the filename John.rtf.

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.

State three functions of the Slides Pane. -Technology

Description : State three functions of the Slides Pane. -Technology

Last Answer : Three functions of the Slides Pane are as follows:1. New slides may be added to the presentation.2. Allows marking a slide as hidden for not showing it during a slide show.3. Deleting a slide from the presentation in case it is no longer neede

……… is a program that appears harmless but actually performs malicious functions. -Technology

Description : ……… is a program that appears harmless but actually performs malicious functions. -Technology

Last Answer : Trojan horse is a program that appears harmless but actually performs malicious functions.

Suggest the appropriate functions for the following situations: -Technology

Description : Suggest the appropriate functions for the following situations: -Technology

Last Answer : 1. = MIN(A1 : C5)2. = IF(D5>5,000, “Discount”, “NoDiscount”)