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

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

1 Answer

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 FROM Furniture ;6. SELECT NAME. PRICE +500 FROM Furniture ;7. SELECT FCODE. NAME FROM Furniture ORDER BY FCODE DESC ;8. SELECT * FROM Furniture9.10. WHERE MANUFDATE BETWEEN ‘01 - JAN - 2016' AND ‘15 - JUN - 2017' ;11. SELECT AVG (PRICE) FROM Furniture12.13. WHERE WCODE = 'W02' ;14. SELECT WCODE AS wise, WCODE, MAX (PRICE) FROM Furniture ;15.16. Output for SQL queries (ix) and (x)(ix)SUM(PRICE)6500(x)COUNT(DISTINCT PRICE)5
by

Related questions

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

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”

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

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 following two commands C1 and C2 on the relation R from an SQL database: C1: drop table R; C2: delete from R; Which of the following statements is TRUE? I. Both C1 and C2 delete the schema for R. II. C2 retains relation R, but deletes all tuples in R. III. C1 deletes not only all tuples of R, but also the schema for R. (A) I only (B) I and II only (C) II and III only (D) I, II and III

Description : Consider the following two commands C1 and C2 on the relation R from an SQL database:  C1: drop table R; C2: delete from R; Which of the following statements is TRUE? I. Both C1 and C2 delete the schema for R. II. C2 ... R. (A) I only (B) I and II only (C) II and III only (D) I, II and III

Last Answer : (C) II and III only

On the basis of the Table Student, write the output(s) produced by executing the following queries: -Technology

Description : On the basis of the Table Student, write the output(s) produced by executing the following queries: -Technology

Last Answer : (i)Max(Average)Min(Average)9565(ii)NameShrishtiAdityaRitu RajSaumyaAshutoshAman

Consider the following three SQL queries (Assume the data in the people table) : (a) Select Name from people where Age>21; (b) Select Name from people where Height>180; (c) Select Name from people where (Age>21) or (Height>180); If the SQL queries (a) and (b) above, return 10 rows and 7 rows in the result set respectively, then what is one possible number of rows returned by the SQL query (c) ? (A) 3 (B) 7 (C) 10 (D) 21

Description : Consider the following three SQL queries (Assume the data in the people table) : (a) Select Name from people where Age>21; (b) Select Name from people where Height>180; (c) Select Name from people where (Age>21) or (Height ... number of rows returned by the SQL query (c) ? (A) 3 (B) 7 (C) 10 (D) 21

Last Answer : (C) 10

Consider a database table R with attributes A and B. Which of the following SQL queries is illegal ? (A) SELECT A FROM R; (B) SELECT A, COUNT(*) FROM R; (C) SELECT A, COUNT(*) FROM R GROUP BY A; (D) SELECT A, B, COUNT(*) FROM R GROUP BY A, B;

Description : Consider a database table R with attributes A and B. Which of the following SQL queries is illegal ? (A) SELECT A FROM R; (B) SELECT A, COUNT(*) FROM R; (C) SELECT A, COUNT(*) FROM R GROUP BY A; (D) SELECT A, B, COUNT(*) FROM R GROUP BY A, B;

Last Answer : (B) SELECT A, COUNT(*) FROM R;

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

Observe the table named “Training” given above carefully and predict the output of the following queries: -Technology

Description : Observe the table named “Training” given above carefully and predict the output of the following queries: -Technology

Last Answer : (i) New DelhiFaridabadGurugram(ii) 2(iii) 11000(iv) Ms. Neena

Observe the given table named “Loan” carefully and predict the output of the following queries: -Technology

Description : Observe the given table named “Loan” carefully and predict the output of the following queries: -Technology

Last Answer : (i)(ii)(iii)(iv)

Which of the following statements about the coagulation cascade is/are true? A. The intrinsic pathway of coagulation is the predominant pathway in vivo for hemostasis and coagulation. B. The intrinsic pathway beginning with the activation of factor XII is the predominant in vivo mechanism for activation of the coagulation cascade. C. Deficiencies of factor VIII and IX cause highly significant coagulation abnormalities. D. Deficiencies of factor XII cause severe clinical bleeding syndromes.

Description : Which of the following statements about the coagulation cascade is/are true? A. The intrinsic pathway of coagulation is the predominant pathway in vivo for hemostasis and coagulation. ... coagulation abnormalities. D. Deficiencies of factor XII cause severe clinical bleeding syndromes.

Last Answer : Answer: AC DISCUSSION: Although it was previously held that two somewhat distinct pathways existed for the activation of the coagulation cascade, it is now recognized that the predominant ... bleeding. This further emphasizes the secondary role that the intrinsic pathway plays in coagulation

Suppose ORACLE relation R(A, B) currently has tuples {(1, 2), (1, 3), (3, 4)} and relation S(B, C) currently has {(2, 5), (4, 6), (7, 8)}. Consider the following two SQL queries SQ1 and SQ2 : SQ1 : Select * From R Full Join S On R.B=S.B; SQ2 : Select * From R Inner Join S On R.B=S.B; The numbers of tuples in the result of the SQL query SQ1 and the SQL query SQ2 are given by : (A) 2 and 6 respectively (B) 6 and 2 respectively (C) 2 and 4 respectively (D) 4 and 2 respectively

Description : Suppose ORACLE relation R(A, B) currently has tuples {(1, 2), (1, 3), (3, 4)} and relation S(B, C) currently has {(2, 5), (4, 6), (7, 8)}. Consider the following two SQL queries SQ1 and SQ2 ... (A) 2 and 6 respectively (B) 6 and 2 respectively (C) 2 and 4 respectively (D) 4 and 2 respectively

Last Answer : (D) 4 and 2 respectively

I have some matchsticks set up like this: I + XI = X. If you do not know Roman numerals, here is a quick starter: I=1 II=2 III=3 IV=4 V=5 VI=6 VII=7 VIII=8 IX=9 X=10 XI=11 XII=12 XIII=13 XIV=14 XV=15...... Of course, I + XI = X is wrong. You are told to move the minimum number of matchsticks to make the question correct. So, how many do you have to move? -Riddles

Description : I have some matchsticks set up like this: I + XI = X. If you do not know Roman numerals, here is a quick starter: I=1 II=2 III=3 IV=4 V=5 VI=6 VII=7 VIII=8 IX=9 X=10 XI=11 ... are told to move the minimum number of matchsticks to make the question correct. So, how many do you have to move? -Riddles

Last Answer : Most people would get to one move at the least, but the real answer is zero moves. If you rotate the whole question around 180 degrees, it will display this: X = IX + I

Cold conc. `HNO_(3)` will completely dissolve: (i) Pb (ii) `Pb_(3)O_(4)` (iii) Fe (iv) Sn (v) Mg (vi) MgO (vii) Hg (viii) Au (ix) Ag (x) Pt

Description : Cold conc. `HNO_(3)` will completely dissolve: (i) Pb (ii) `Pb_(3)O_(4)` (iii) Fe (iv) Sn (v) Mg (vi) MgO (vii) Hg (viii) Au (ix) Ag (x) Pt

Last Answer : Cold conc. `HNO_(3)` will completely dissolve: (i) Pb (ii) `Pb_(3)O_(4)` (iii) Fe (iv) Sn (v) Mg (vi) MgO (vii) Hg (viii) Au (ix) Ag (x) Pt

Cold conc. `HNO_(3)` will completely dissolve: (i) Pb (ii) `Pb_(3)O_(4)` (iii) Fe (iv) Sn (v) Mg (vi) MgO (vii) Hg (viii) Au (ix) Ag (x) Pt

Description : Cold conc. `HNO_(3)` will completely dissolve: (i) Pb (ii) `Pb_(3)O_(4)` (iii) Fe (iv) Sn (v) Mg (vi) MgO (vii) Hg (viii) Au (ix) Ag (x) Pt

Last Answer : Cold conc. `HNO_(3)` will completely dissolve: (i) Pb (ii) `Pb_(3)O_(4)` (iii) Fe (iv) Sn (v) Mg (vi) MgO (vii) Hg (viii) Au (ix) Ag (x) Pt

Differentiate between any five of the following. (i) Artery and vein (ii) Hard water and soft water (iii) E-mail and Snail mail (iv) Apes and monkey (v) Hydrostatics and hydrodynamics (vi) Comet and meteor (vii) Barrage and dam (viii) Electron and hole (ix) Isobars and isotopes (x) Autopsy and biopsy

Description : Differentiate between any five of the following. (i) Artery and vein (ii) Hard water and soft water (iii) E-mail and Snail mail (iv) Apes and monkey (v) Hydrostatics and hydrodynamics (vi) Comet and ... (vii) Barrage and dam (viii) Electron and hole (ix) Isobars and isotopes (x) Autopsy and biopsy

Last Answer : Answers: (i) Artery and vein: Arteries: Muscular blood vessels that carry blood away from the heart. All arteries, with the exception of the pulmonary and umbilical arteries, carry oxygenated blood ... to determine cause of death Biopsy: Removal and study of a tissue sample for diagnostic purposes

Name the quantities which are measured by the following units. (i) Newton (ii) Joule (iii) Watt (iv) Volt (v) Light year (vi) Angstrom (vii) Acre-foot (viii) Becquerel (ix) Hertz (x) Cusec

Description : Name the quantities which are measured by the following units. (i) Newton (ii) Joule (iii) Watt (iv) Volt (v) Light year (vi) Angstrom (vii) Acre-foot (viii) Becquerel (ix) Hertz (x) Cusec

Last Answer : Answers: (i) Force (ii) Work Energy (iii) Power of electricity (iv) Potential difference (v) Distance of stars and planets (vi) Length (vii) Volume (viii) Radioactivity (ix) Frequency (x) Rate of flow of water

Which quantity do the following units measure: (i) Volt (ii) Coulomb (iii) Walt (iv) Ohm (v) Mho (vi) Ampere (vii) Dyne (viii) Celsius (ix) Joule (x) Calorie

Description : Which quantity do the following units measure: (i) Volt (ii) Coulomb (iii) Walt (iv) Ohm (v) Mho (vi) Ampere (vii) Dyne (viii) Celsius (ix) Joule (x) Calorie

Last Answer : Answers: (i) Voltage (ii) Charge of Electricity (iii) Power (iv) Resistance (v) Conductivity (vi) Current (vii) Force (viii) Temperature (ix) Energy (x) Heat

Which of the following cranial nerves can regulate heart beat? (a) X (b) IX (c) VIII (d) VII

Description : Which of the following cranial nerves can regulate heart beat? (a) X (b) IX (c) VIII (d) VII

Last Answer : a) X

A company has to choose between two projects whose cash flows are as indicated below; Project 1: i. Investment – Rs. 15 Lakhs ii. Annual cost savings – Rs. 4 lakhs. iii. Bi-annual maintenance cost – Rs. 50,000/- iv. Reconditioning and overhaul during 5th year: 6 lakhs v. Life of the project – 8 years vi. Salvage value – Rs. 5 lakhs Project 2: vii. Investment – Rs. 14 Lakhs viii. Annual cost savings – Rs. 3.5 lakhs. ix. Annual Maintenance cost – Rs. 20,000/- x. Reconditioning and overhaul during 4th year: 5 lakhs xi. Life of the project – 8 years xii. Salvage Value- 2 lakhs Which project should the company choose? The annual discount rate is 12

Description :  A company has to choose between two projects whose cash flows are as indicated  below; Project 1:  i. Investment - Rs. 15 Lakhs ii. Annual cost savings - Rs. 4 lakhs. iii. Bi-annual ... years xii. Salvage Value- 2 lakhs Which project should the company choose? The annual discount rate is 12

Last Answer : Year Project 1 Project 2 Outgo Saving NPV Outgo Saving NPV 0 15.0 0 =-15.0 14.0 0 = -14 1 0 4.0 = (4 / (1+.12)1 = 3.571 0.2 3.5 = (3.3 / (1+.12)1 = 2.95 2 0.5 4.0 = (3.5 / (1+.12)2 = 2.79 0.2 3.5 ... (1+.12)8 = 3.43 0.2 5.5  (3.5+2) = (5.3 / (1+.12)8 = 2.14 NPV = + 2.301 @12% = + 0.15

The patient whom you are about to treat states that he has Von Willebrand’s disease. Which one of the following preoperative haematological analyses may reflect this disease: A. Bleeding time and factor VIII level ptt also prolonged decreased platelet count. B. Bleeding time and factor IX level C. Bleeding time and factor X level D. Platelet count E. Thromboplastin generation time

Description : The patient whom you are about to treat states that he has Von Willebrand's disease. Which one of the following preoperative haematological analyses may reflect this disease: A. Bleeding time and ... C. Bleeding time and factor X level D. Platelet count E. Thromboplastin generation time

Last Answer : A. Bleeding time and factor VIII level ptt also prolonged decreased platelet count

Consider the following DataFrame, classframe Rollno Name Class Section CGPA Stream St1 1 Aman IX E 8.7 Science -Technology

Description : Consider the following DataFrame, classframe Rollno Name Class Section CGPA Stream St1 1 Aman IX E 8.7 Science -Technology

Last Answer : i. classframe[‘Activity’]=[‘Swimming’,’Dancing ’,’Cricket’, ‘Singing’]ii. classframe.loc[‘St5’]=[1,’Mridula’, ‘X’, ‘F’, 9.8, ‘Science’]

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

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

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

Cold dil. `H_(2)SO_(4)` will completely dissolve : (i) Pb (ii) `Fe_(3)O_(4)` (iii) Fe (iv) Cu (v) Mg (vi) MgO (vii) `CoCO_(3)` (viii) `CuCO_(2)` (ix)

Description : Cold dil. `H_(2)SO_(4)` will completely dissolve : (i) Pb (ii) `Fe_(3)O_(4)` (iii) Fe (iv) Cu (v) Mg (vi) MgO (vii) `CoCO_(3)` (viii) `CuCO_(2)` (ix)

Last Answer : Cold dil. `H_(2)SO_(4)` will completely dissolve : (i) Pb (ii) `Fe_(3)O_(4)` (iii) Fe (iv) Cu (v) ... ) `CoCO_(3)` (viii) `CuCO_(2)` (ix) `SrCO_(3)`

(i) `NH_(3)` (ii) `N_(2)H_(4)` (iii) `HN_(3)` (iv) `PH_(3)` (v) `H_(2)S` (vi) `AsH_(3)` (vii) `SbH_(3)` (viii) `H_(2)Se` (ix) `H_(2)Te` Number of mole

Description : (i) `NH_(3)` (ii) `N_(2)H_(4)` (iii) `HN_(3)` (iv) `PH_(3)` (v) `H_(2)S` (vi) `AsH_(3)` (vii) `SbH_(3)` (viii) `H_(2)Se` (ix) `H_(2)Te` Number of mole

Last Answer : (i) `NH_(3)` (ii) `N_(2)H_(4)` (iii) `HN_(3)` (iv) `PH_(3)` (v) `H_(2) ... lone pair of electrons on the central atom is present in pure s-orbital

Cold dil. `H_(2)SO_(4)` will completely dissolve : (i) Pb (ii) `Fe_(3)O_(4)` (iii) Fe (iv) Cu (v) Mg (vi) MgO (vii) `CoCO_(3)` (viii) `CuCO_(2)` (ix)

Description : Cold dil. `H_(2)SO_(4)` will completely dissolve : (i) Pb (ii) `Fe_(3)O_(4)` (iii) Fe (iv) Cu (v) Mg (vi) MgO (vii) `CoCO_(3)` (viii) `CuCO_(2)` (ix)

Last Answer : Cold dil. `H_(2)SO_(4)` will completely dissolve : (i) Pb (ii) `Fe_(3)O_(4)` (iii) Fe (iv) Cu (v) ... ) `CoCO_(3)` (viii) `CuCO_(2)` (ix) `SrCO_(3)`

(i) `NH_(3)` (ii) `N_(2)H_(4)` (iii) `HN_(3)` (iv) `PH_(3)` (v) `H_(2)S` (vi) `AsH_(3)` (vii) `SbH_(3)` (viii) `H_(2)Se` (ix) `H_(2)Te` Number of mole

Description : (i) `NH_(3)` (ii) `N_(2)H_(4)` (iii) `HN_(3)` (iv) `PH_(3)` (v) `H_(2)S` (vi) `AsH_(3)` (vii) `SbH_(3)` (viii) `H_(2)Se` (ix) `H_(2)Te` Number of mole

Last Answer : (i) `NH_(3)` (ii) `N_(2)H_(4)` (iii) `HN_(3)` (iv) `PH_(3)` (v) `H_(2) ... lone pair of electrons on the central atom is present in pure s-orbital

One of the practical applications of genetic engineering is the bacterial production of ____.a. human insulin. b. human growth hormone c. blood clotting factors VIII and IX d. antiviral proteins e. all of the above

Description : One of the practical applications of genetic engineering is the bacterial production of ____. a. human insulin. b. human growth hormone c. blood clotting factors VIII and IX d. antiviral proteins e. all of the above

Last Answer : c. blood clotting factors VIII and IX

Hemophilia A is characterised by deficiency of Options: 1) Factor VII 2) Factor VIII 3) Factor IX 4) Factor XI

Description : Hemophilia A is characterised by deficiency of Options: 1) Factor VII 2) Factor VIII 3) Factor IX 4) Factor XI

Last Answer : Correct Answer: 2) Factor VIII

What is table? Name the basic commands for creating a table. -Technology

Description : What is table? Name the basic commands for creating a table. -Technology

Last Answer : Tables are made up of rows and columns. In HTML, tables are used to display tabular data in Web pages.The basic commands for creating tables are as follows:Table tags Row tags Cell tags andCaption tags .

Anjali writes the following commands with respect to a table employee having fields, empno, name, department, commission. -Technology

Description : Anjali writes the following commands with respect to a table employee having fields, empno, name, department, commission. -Technology

Last Answer : This is because the column commission contains a NULL value and the aggregate functions do not take into account NULL values. Thus Command1 returns the total number of records in the table whereas Command2 returns the total number of non NULL values in the column commission.

Consider the table Student(stuid, name, course, marks). Which one of the following two queries is correct to find the highest marks student in course 5? Q.1. Select S.stuid From student S Where not exists (select * from student e where e course='5' and e marks ≥ s marks) Q.2. Select S.stuid From student S Where s.marks > any (select distinct marks from student S where s.couse = 5) (A) Q.1 (B) Q.2 (C) Both Q.1 and Q.2 (D) Neither Q.1 nor Q.2

Description : Consider the table Student(stuid, name, course, marks). Which one of the following two queries is correct to find the highest marks student in course 5? Q.1. Select S.stuid From student S Where not exists (select * from student ... ) Q.1 (B) Q.2 (C) Both Q.1 and Q.2 (D) Neither Q.1 nor Q.2

Last Answer : (B) Q.2 Explanation: First query gives stuid of students whose marks are greater than all students taking course 5. Second query gives stuid of students whose marks are greater than any student taking ... comparison is between maximum of marks by any student in course 5. So the answer is option D.

Consider the relations R(A,B) and S(B,C) and the following four relational algebra queries over R and S: I. πA,B(R⋈S) II. R⋈πB(S) III. R∩(πA(R) Χ πB(S)) IV. πA,R.B(R Χ S) where R.B refers to the column B in table R. One can determine that: (A) I, III and IV are the same query. (B) II, III and IV are the same query. (C) I, II and IV are the same query. (D) I, III and III are the same query.

Description : Consider the relations R(A,B) and S(B,C) and the following four relational algebra queries over R and S: I. πA,B(R⋈S) II. R⋈πB(S) III. R∩(πA(R) Χ πB(S)) IV. πA,R.B(R Χ S) where R.B refers to ... IV are the same query. (C) I, II and IV are the same query. (D) I, III and III are the same query.

Last Answer : (D) I, III and III are the same query.

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

Does OpenOffice support all the standard SQL commands?

Description : Does OpenOffice support all the standard SQL commands?

Last Answer : http://www.google.com/#hl=en&q=openoffice+sql+functions

. Which attack is an HTTP attack which allows attackers to access restricted directories and execute commands outside the web servers root directory? a. XSS attack b. Path Traversal attack c. MITM attack d. SQL Injection attack

Description : . Which attack is an HTTP attack which allows attackers to access restricted directories and execute commands outside the web servers root directory? a. XSS attack b. Path Traversal attack c. MITM attack d. SQL Injection attack

Last Answer : d. SQL Injection attack

Database is made up of all the following components except (a) tables (b) queries -Technology

Description : Database is made up of all the following components except (a) tables (b) queries -Technology

Last Answer : (d) A database is made up of tables, queries, and forms.

The different objects supported by MS_Access are tables, queries, ………… and reports. -Technology

Description : The different objects supported by MS_Access are tables, queries, ………… and reports. -Technology

Last Answer : The different objects supported by MS-Access are tables, queries, forms, and reports.

Consider the following python code and write the output for statement S1 import pandas as pd -Technology

Description : Consider the following python code and write the output for statement S1 import pandas as pd -Technology

Last Answer : 0.50 8.00.75 11.0

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

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)