9 months ago - Based on the topic "Faces of Filipino Youth Today", game addiction is not a cause of poor performance in class.
9 months ago - Rent expense is debited for P20, 000 when payment for four months was made on July 1, 2017. At the end of the month, an adjusting entry requiring a debit to Prepaid Rent should be made for P15, 000.
9 months ago - Products which are introduced by the business firms into a product category where the business had not been doing business up to this time
9 months ago - Special journals are generally used to record frequently occurring transactions.
9 months ago - Document supporting the sales return and allowances is called a debit memo.
11 months ago - A type of ecosystem management that focuses on maintaining the greatest amount of ecological integrity.
11 months ago - Most of what happens to you happens because of other people’s decisions.
1 year ago - Which of the following is the correct query that counts the number of ST_CLERK job_id? Rename the column as “Total no. of ST_CLERK”.
1 year ago - Question 7Select one: a. SELECT MIN(LASTNAME), JOB_ID, MAX(SALARY) FROM EMPLOYEES WHERE JOB_ID LIKE 'REP%' GROUP BY JOB_ID; b. SELECT MIN(LASTNAME), MIN(JOB_ID), MAX(SALARY) FROM EMPLOYEES WHERE JOB_ID LIKE '%REP%' GROUP BY JOB_ID; c. SELECT MIN(LASTNAME), JOB_ID, MAX(SALARY) FROM EMPLOYEES WHERE JOB_ID LIKE '%REP%'; d. SELECT MIN(LASTNAME), JOB_ID, MAX(SALARY) FROM EMPLOYEES WHERE JOB_ID LIKE '%REP%' GROUP BY JOB_ID;
1 year ago - Which of the following is the correct report that display the smallest (minimum) Surname.. and apply the ff. functions: Get the average salary; Group the data per job_id; Get only job_id with a keyword “REP”; and Apply having clause, which the max salary per job_id is greater than 5000.
1 year ago - Which of the following is the correct query that displays the lowest salary rename as “LOWEST SALARY”, maximum salary rename as “HIGHEST SALARY” and department_id concatenated to job_id?
1 year ago - It combines the results of two or more component queries into one result.
1 year ago - Which of the following is the correct report showing all rows and columns sort the description in ascending order.
1 year ago - Which of the following is the correct example updating all student COURSE to ‘BSIT’ from STUDENTS table?
1 year ago - If we use the XPath expression //movie[@genre='drama'], the output will be:
1 year ago - In XML DTD declaration for elements, this symbol means zero or more element.
1 year ago - The following access list below was applied outbound on the E0 interface connected to the 192.169.1.8/29 LAN: access-list 135 deny tcp 192.169.1.8 0.0.0.7 eq 20 any access-list 135 deny tcp 192.169.1.8 0.0.0.7 eq 21 any How will the above access lists affect traffic?
1 year ago - Based on the given table Stocks choose the possible output if the following sql statement is executed. SELECT AVG(NVL(QTY,0)) FROM STOCKS;
1 year ago - The overall logical structure (schema) of a database can be expressed graphically by
1 year ago - This is used to bring together data that is stored in different tables by specifying the link between them.
1 year 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?
1 year ago - ased on the given table Stocks type the possible out if the following sql statement is executed. What is the maximum on hand from parts when this SQL statement is executed? SELECT MAX(ONHAND) FROM PARTS;
1 year 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’
1 year ago - Based on the given table Stocks type the possible out if the following sql statement is executed. What is the length of description Cordless Drill from parts when this SQL statement is executed? SELECT INSTR(DESCRIPTION,'O') FROM PART;
1 year 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’;
1 year ago - SELECT NAME, ORG, POSITION FROM ORGCHAR WHERE NAME LIKE ‘A%’ AND POSITION = ‘SEC’;
1 year 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;
1 year 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’;
1 year ago - Refer to table 1.0, suppose that user update the table using the statement below what would be the possible output? UPDATE ORGCHART SET ORG = ‘PCS’ WHERE ORG IS NULL;
1 year ago - SELECT NAME, ORG, POSITION FROM ORGCHAR WHERE ORG =’JPCS’ OR POSITION = ‘SEC’;
1 year ago - What query should be used in order toget theSUBSTR function that returns the job_id = ‘REP
1 year 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
1 year 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.
1 year ago - able is known as the collection of data that contains information relevant to an enterprise.
1 year ago - A type of function that accepts character input and can return both character and number values.
1 year ago - 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;
1 year 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’.
1 year ago - Database is the term generally used to describe what was done by large mainframe computers from the late 1940's until the early 1980's.
1 year 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.
1 year ago - SELECT MOD(SALARY,10) AS “EXCESS SALARY” FROM EMPLOYEES WHERE SALARY < 5000;
1 year 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.
1 year ago - Security is one of the characteristic of database that includes also the protection of the database from unauthorized access confidentiality and unauthorized changes.
1 year ago - Database Management System is a collection of interrelated data and a set of programs to access those data.
1 year ago - This query returns rows in the first query that are not present in the second query.
1 year 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.
1 year 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.
1 year 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’.
1 year ago - Which of the following is the correct report listing only the column DESCRIPTION, CLASS and PRICE of all PARTS where class is not equal to AP.
1 year ago - Which of the following is the correct report that will display the DESCRIPTION, WAREHOUSE AND distinct value for CLASS.
1 year ago - SELECT DESCRIPTION, PRICE + 10000 + PRICE AS “NEW PRICE LISTS” FROM PARTS ORDER BY PRICE DESC;