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.
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.
Description : A database that contains tables linked by common fields is called a (a) Centralized database (b) Flat file database -Technology
Last Answer : (c) Relational database stores data in the form of tables which are linked by common fields.
Description : In a MS_Access database, which component is not present? (a) Formula Bar (b) Tables -Technology
Last Answer : (a) MS-Access contains various components, i.e. Tables, Queries, Forms, Reports, Macros and Modules.
Description : Select Acc_No, sum(Amount) from Customer c, Transaction t where c.Acc_No=t.Acc_No group by c.Acc_No having Transaction_Type='Credit'; -Technology
Last Answer : 2301003 650002201002 20000
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
Description : Consider the tables given below. Salesperson -Technology
Last Answer : (i) Primary, Foreign(ii) Salespersons cannot be set as the primary key in the table Orders because table Orders has already primary key and one table cannot have more than one primary key column.
Description : Consider the following database: Product Code Product Name Date of sale QtySold Customer Name Amount -Technology
Last Answer : 1. Qty Sold and Amount fields2. ProductCode field3. Date/Time data type4. ProductCode, ProductName and CustomerName fields5. 6 fields and 5 records6. Validation Rule
Description : Four square table-tops of the same dimensions are shown below. Only the designs of their supports are different from each other. If a person stands upright on the red mark on each of the table, which of the tables will topple?
Last Answer : B C D
Description : Below is the list of various types of application softwares: A. Database B. Desktop publishing C. Drawing -Technology
Last Answer : 1. Drawing2. Word processing3. Desktop publishing4. Spreadsheet5. Database
Description : The director of a company uses a database to store data about job title. This is a part of the database given below: -Technology
Last Answer : 1. 62. 63. Secretary4. Finance department and their Payroll Numbers are A621 and M502.
Description : Answer the following questions based on the database given below: Prod_Id Prod_Name Category -Technology
Last Answer : 1. The primary key of the given table Product will be Prod _Id because no two products have the same Product_Id. So, it will be uniquely identified for each record in the table.2. The suitable data ... = 88. The data type OLE Object is suitable for adding the photograph of the product to the table.
Description : Write the HTML code to generate the following table on a Web page with the contents and alignment exactly as shown below: -Technology
Last Answer : The HTML code is
Description : Mr. Suman, a programmer in New Era Programming World has designed a registration page for a hobby club as shown below: -Technology
Last Answer : (i) int x=c1.getSelectedIndex();int fee=0;if(x==0)fee=1000;else if(x==1)fee=1500;else if(x==2)fee=2000;else if(x==3)fee=2500;t2.setText(''+fee);(ii) double disc=0;int fee=Integer.parseInt(t2. ... (t2.getText());double net=fee-disc;t4.setText(''+net);(iv) System.exit(0);(v) c1.addItem('Reading');
Description : Write a code to plot the speed of a passenger train as shown in the figure given below: -Technology
Last Answer : import matplotlib.pyplot as pltimport numpy as npx = np.arange(1, 5)plt.plot(x, x*1.5, label='Normal')plt.plot(x, x*3.0, label='Fast')plt.plot(x, x/3.0, label='Slow')plt.legend()plt.show()
Description : Identify the topology shown below. Write 2 advantages of this topology. -Technology
Last Answer : Star Topology Two advantages of star topology are as follows :1. Easy to detect faults and remove It.2. Failure to single system will not bring down the entire network.
Description : Identify the columns out of the given three, which should not be present in each of the following tables: -Technology
Last Answer : (i) DateofBirth(ii) Admno(iii) Phonenumber
Description : A report allows you to represent data retrieved from one or more tables so that, it can be analysed and printed if required. -Technology
Last Answer : True When you want to print those records which are fetched from your database then, reports are more useful for this purpose.
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.
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.
Description : Which tag is used to add columns in the tables? (a) (b) -Technology
Last Answer : (b) is used to add columns in the tables.
Description : Which tags divide HTML tables in multiple section? -Technology
Last Answer : , and
Description : Define cell padding and cell spacing with respect to tables in HTML. -Technology
Last Answer : CELLSPACING controls the space between table cells and CELLPADDING sets the amount of space between the contents of the cell and the cell wall.
Description : How many rows and column will be there in the Cartesian product of the above given tables. Also mention the degree and cardinality -Technology
Last Answer : Cartesian Product:Number of Rows: 20Number of Columns: 9Degree: 9Cardinality: 20
Description : Consider the following tables PATIENT and TEST and answer the questions that follow : -Technology
Last Answer : Primary key in PATIENT and TEST tables are PCODE and TESTID respectively. Because primary key of a relational table uniquely identifies each record.Foreign key in PATIENT table is TESTID whose value is derived from the primary key (TESTID) of another table (TEST).
Description : Is it true or false that a relational database typically consists of related two dimensional tables?
Last Answer : Need answer
Description : What are two virtual tables available during database trigger execution ?
Last Answer : The table columns are referred as OLD.column_name and NEW.column_name. For triggers related to INSERT only NEW.column_name values only available. For triggers related to UPDATE only OLD. ... values only available. For triggers related to DELETE only OLD.column_name values only available.
Description : How are relationship between tables expressed in a relational database?
Last Answer : Tables are the basic building blocks of a relationaldatabase.
Description : What is the difference between tables and form database objects?
Last Answer : Database table objects store data. Form objects used byapplications provide a visually pleasing or sensible way ofaccessing or updating data contained in the database tables. Thismeans that the form object is a display specification.
Description : What are the dictionary tables used to monitor a database space?
Last Answer : DBA_FREE_SPACE DBA_SEGMENTS DBA_DATA_FILES.
Description : What are the dictionary tables used to monitor a database spaces ?
Description : Upper CASE tools are used to create diagrams and generate code for database tables system functionality during the design phase.
Last Answer : Ans: False
Description : A relational database management (RDBM) package manages datain morethan one file at once. How does itorganizethese file? As A. tables B. relations C. tuple D. both (a)and (b) E. None of the above
Last Answer : both (a)and (b)
Description : Which of the following is included in the database collection: a) Schemes, Tables, Queries b) Queries, Report, Views and other Objects c) Both of Above d) None of These
Last Answer : c) Both of Above
Description : A database is typically composed of one or more: a) Columns b) Files c) Rows d) Tables e) None of These
Last Answer : d) Tables
Description : Which of the following describes a relational database? 1) It provides a relationship between integers 2) It consists of separate tables or related data 3) It retrieves data related to its queries 4) It provides a relationship between floats
Last Answer : 2) It consists of separate tables or related data
Description : Distance vector routing algorithm is a dynamic routing algorithm. The routing tables in distance vector routing algorithm are updated ........... (1) automatically (2) by server (3) by exchanging information with neighbour nodes. (4) with back up database
Last Answer : Answer: 3
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.
Description : Ms. Sita trying to log into your Internet Banking account for online transaction activity. However, as strange as it may seem, -Technology
Last Answer : I. (i)Source code is available.(ii) Money need not to be paid for procuring the license for usage and further distribution.II. She could be under a DoS attack!She should deploy an ... into her network if not already done. This helps in restricting the bandwidth usage to authenticated users only.
Description : How do you tell the system that a transaction is beginning -Technology
Last Answer : When a transaction begins, Oracle Database assigns the transaction to an available undo data segment to record the undo entities for the new transaction. A transaction ID is not allocated until an ... ID is unique to a transaction and represents the undo segment number, slot and sequence number.
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;
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;
Description : What is value of using access control database transaction and firewall log files?
Description : Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?
Last Answer : It is not possible. As triggers are defined for each table, if you use COMMIT of ROLLBACK in a trigger, it affects logical transaction processing.
Description : This first step inthe transaction processing cycle captures businessdata throughvarious modes suchas optical scanning orat an electronic commerce website– (A) Document and report generation (B) Database maintenance (C) Transaction processing startup (D) Data Entry
Last Answer : Data Entry
Description : Which of the following is/are the Database server functions? i) Data management ii) Transaction management iii) Compile queries iv) Query optimization A) i, ii, and iv only B) i, ii and iii only C) ii, iii and iv only D) All i, ii, iii, and iv
Last Answer : A) i, ii, and iv only
Description : B) CaixaBank Explanation: As per the agreement, they will expand banks guarantee transaction businesses by jointly providing credit to Indian-Spanish joint ventures and Indian local ... finance and export credit agency finance, infrastructure finance and networking services, among others.
Last Answer : Recently an Indian bank launched next generation features on its app „iMobile‟ which will enable customers to instantly pay taxes and book railway tickets within the app. Name the bank. A) Federal Bank B) Punjab National Bank C) Kotak Mahindra Bank D) ICICI Bank E) Bandhan Bank
Description : The national agency mandated to control, analyse and disseminate Suspicious Transaction Reports(STR), Cash Transaction Reports and counterfeit currency reports to various investigative agencies of the country after ... (IB) D. Central Bureau of Investigation(CBI) E. Central Intelligence Unit(CIU)
Last Answer : B. Financial Intelligence Unit(FIU) Explanation: The FIU is the national agency mandated to collect, analyse and disseminate Suspicious Transaction Reports (STRs), Cash Transaction Reports ... country after receiving it from banks and other financial intermediaries under a stipulated mechanism.
Description : If an exporter is doubtful about an issuing bank's ability to pay, he will expect a domestic bank to join the transaction in a _____ letter of credit. A. revolving B. irrevocable C. revocable D. unconfirmed E. confirmed
Last Answer : E. confirmed
Description : Which of the following would not fit the description of a related-party transaction? a. An unusually large sale of merchandise to the company's best and largest customer. b. Sales of merchandise ... person. d. Loans to corporate officers at market rates of interest with a regular repayment schedule.
Last Answer : An unusually large sale of merchandise to the company's best and largest customer.