4 months ago - Indicate which structure would be a more suitable choice for each of the following applications.An electronic address book ordered by name
4 months ago - Indicate which structure would be a more suitable choice for each of the following applications. A program to receive data that is to be saved and processed in the reverse order.
4 months ago - Indicate which structure would be a more suitable choice for each of the following applications.A program to keep track of family relationships
4 months ago - Indicate which structure would be a more suitable choice for each of the following applications.A program to maintain the routes in an airline.
4 months ago - Indicate which structure would be a more suitable choice for each of the following applications. A bank simulation of its teller operation to see how waiting times would be affected by adding another teller.
4 months ago - Indicate which structure would be a more suitable choice for each of the following applications.A program keeping track of where canned goods are located on a shelf.
4 months ago - Which of the following is true about the characteristics of abstract data types?i. It exports a type.ii. It exports a set of operations.
4 months ago - A hash function is a function which when given a key, generates an address in the table.
4 months ago - _______ Algorithm : performs better in typical situations (sparse graphs) because it uses simpler data structures.
4 months ago - A RADIX is a specific tree based data structure in which all the nodes of tree are in a specific order.
4 months ago - A graph is a collection of points, called vertices, and line segments connecting those points, called edges.
5 months ago - Refer to table 1.0 Using the SELECT statement below what would be the possible output: SELECT NAME, ORG, POSITION FROM ORGCHAR WHERE NAME LIKE ‘%A’;
5 months ago - Refer to table 1.0 Using the SELECT statement below what would be the possible output: SELECT NAME, ORG, POSITION FROM ORGCHAR WHERE ORG =’JPCS’ OR POSITION = ‘SEC’;
5 months ago - Based on the given table Stocks type the possible out if the following sql statement is executed. What is the character position of ‘O’ of the description Microware Oven from parts when this SQL statement is executed? SELECT INSTR(DESCRIPTION,'O') FROM PART;
5 months ago - Refer to table 1.0 Using the SELECT statement below what would be the possible output: SELECT NAME, ORG, POSITION FROM ORGCHAR WHERE NAME LIKE ‘A%’ AND POSITION = ‘SEC’;
5 months ago - Suppose that a user wanted toad a new column name as CITY datatype set to char size 10. Which of the following is the correct sql statement?
5 months ago - Based on the given table Stocks choose the possible output if the following sql statement is executed. SELECT AVG(WAREHOUSE) FROM STOCKS;
5 months ago - Refer to table 1.0 Using the SELECT statement below what would be the possible output: SELECT NAME, ORG, POSITION FROM ORGCHAR WHERE ORG =’JPCS’ OR POSITION = ‘SEC’ AND NAME LIKE ‘%N’
5 months ago - Based on the given table Stocks type the possible out if the following sql statement is executed. What is the minimum warehouse from parts when this SQL statement is executed? SELECT MIN(WAREHOUSE) FROM PARTS;
5 months ago - Based on the given table Stocks choose the possible output if the following sql statement is executed. SELECT COUNT(PRICE) FROM STOCKS;
5 months ago - Refer to table 1.0 Using the SELECT statement below what would be the possible output: SELECT NAME, ORG, POSITION, ID * (100 + 3) FROM ORGCHAR WHERE ORG = ‘AMATHS’
5 months ago - What query should be used in order toget theSUBSTR function that returns the job_id = ‘REP’.
5 months ago - Based on the given SELECT statement below what would be the possible output? SELECT FIRSTNAME, SALARY, LPAD(SALARY * 0.10 + SALARY – 100, 8, ‘$’) AS BONUS FROM EMPLOYEES WHERE DEPARTMENT_ID NOT IN (10, 110, 50 AND SALARY=17000;
5 months ago - What query should be used in order to display the employees lastname concatenated to salary. Format the salary column to 6 character long left padded with ‘*’ as special character for all employees whose manager_id is null or salary between 4000 and 6000 Rename the column as employees and their Salaries
5 months ago - Based on the given SELECT statement below what would be the possible output? SELECT LASTNAME,SALARY, RPAD(SALARY,4,’@’) FROM EMPLOYEES WHERE SALARY BETWEEN 4000 AND 9000 LASTNAME LIKE ‘%S’;
5 months ago - What query should be used in order todisplay the firstname in capitalized format rename the column as pangalan whose job_id is equal to ‘SA_REP’.
5 months ago - A type of function that helps how to group rows in a table into smaller sets and how to specify search criteria for groups of rows.
5 months ago - What query should be used in order to display the salary leftpadded with 15 character long and ‘$’ as special character and another column salary right padded with 10 character long with ‘@’ as special character used of all employees in 201, 176 and 144.
5 months ago - What query should be used in order todisplay a report that trim the letter ‘A’ from lastname of all employees whose department_id between 60 and 90.
5 months ago - What query should be used in order to display the lastname and salary of all employees whose department_id = 60 or job_id like ‘_T%’. Format the salary to be 15 character long, left padded with ‘$’ as special character. Label the column Salary.
5 months ago - It combines the results of two or more component queries into one result.
5 months ago - This query returns the rows from both queries after eliminating duplications.
5 months ago - This query returns rows in the first query that are not present in the second query.
5 months ago - What query should be used in order to display the employees lastname concatenated with firstname and with a ‘, (comma)’ in between. A rename on the concatenated column as Complete Name. Note all values in Complete Name column should be in lowercase plus display the length of employees lastname for all employees whose lastname starts with letter M sort the lastname in its default order.
5 months ago - Which of the following is the correct report listing only the column DESCRIPTION, PARTNUM, CLASS and PRICE of all parts where the description fourth letter starting from the first is equal to ‘D’.
5 months ago - This is used to test for values in a specified set of vaaThis is used to display rows based on a range of values.lues.
5 months ago - Which of the following is the correct report listing the column PARTNO, DESCRIPTION and WAREHOUSE. Get only that description that does not ends with ‘ER’. Note that you have to merge the said three columns, rename the merge column as “Parts Record”. Below is the sample output for column. Parts Record AT94is the part number ofIRONwhich belong to warehouse3
5 months ago - Choose the letter of the correct answer based on table PARTS as shown below Which of the following is the correct report listing only the column CLASS, DESCRIPTION and PRICE of all PARTS where price range is between 200 to 500. Sort the Price in descending order.
5 months ago - Which of the following is the correct report listing only the column CLASS, DESCRIPTION and PRICE of all PARTS where price range is between 200 to 500. Sort the Price in descending order.
5 months ago - Which of the following is the correct report listing only the column DESCRIPTION, ONHAND and WAREHOUSE of all PARTS where ONHAND is greater than or equal to 21.
5 months ago - A null value means that the value is unavailable, unassigned, unknown, or inapplicable.
5 months ago - Which of the following is the correct report listing only the column PARTNUM, CLASS and ONHAND of all parts where partnum is equal to AT94, DR93 and KV29. (Note 1 query only and do not use logical condition)
5 months ago - This is a characteristic of database that includes also the protection of the database from unauthorized access confidentiality and unauthorized changes.
5 months ago - The overall logical structure schema of a database can be expressed graphically by an Answer .
5 months ago - The overall logical structure schema of a database can be expressed graphically by an
5 months ago - It is a collection of interrelated data and a set of programs to access those data. Answer:
5 months ago - It is a bundle of actions which are done within a database to bring it from one consistent state to a new consistent state. Answer:
5 months ago - _____matrix in graph theory is a matrix sized n*n , where n is the number of vertices of the graph.
5 months ago - A _______ queue acts like a queue in that you dequeue an item by removing it from the front.
5 months ago - _________ algorithms work by recursively constructing a set of objects from the smallest possible constituent parts.