8 months ago - Based on the topic "Faces of Filipino Youth Today", game addiction is not a cause of poor performance in class.
8 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.
8 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
8 months ago - Special journals are generally used to record frequently occurring transactions.
8 months ago - Document supporting the sales return and allowances is called a debit memo.
10 months ago - A type of ecosystem management that focuses on maintaining the greatest amount of ecological integrity.
10 months ago - Most of what happens to you happens because of other people’s decisions.
11 months 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”.
11 months 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;
11 months 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.
11 months 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?
11 months ago - It combines the results of two or more component queries into one result.
11 months ago - Which of the following is the correct report showing all rows and columns sort the description in ascending order.
11 months ago - Which of the following is the correct example updating all student COURSE to ‘BSIT’ from STUDENTS table?
11 months ago - If we use the XPath expression //movie[@genre='drama'], the output will be:
11 months ago - In XML DTD declaration for elements, this symbol means zero or more element.
11 months 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?
11 months 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;
11 months ago - The overall logical structure (schema) of a database can be expressed graphically by
11 months ago - This is used to bring together data that is stored in different tables by specifying the link between them.
11 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?
11 months 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;
11 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’
11 months 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;
11 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’;
11 months ago - SELECT NAME, ORG, POSITION FROM ORGCHAR WHERE NAME LIKE ‘A%’ AND POSITION = ‘SEC’;
11 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;
11 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’;
11 months 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;
11 months ago - SELECT NAME, ORG, POSITION FROM ORGCHAR WHERE ORG =’JPCS’ OR POSITION = ‘SEC’;
11 months ago - What query should be used in order toget theSUBSTR function that returns the job_id = ‘REP
11 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
11 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.
11 months ago - able is known as the collection of data that contains information relevant to an enterprise.
11 months ago - A type of function that accepts character input and can return both character and number values.
11 months 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;
11 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’.
11 months 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.
11 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.
11 months ago - SELECT MOD(SALARY,10) AS “EXCESS SALARY” FROM EMPLOYEES WHERE SALARY < 5000;
11 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.
11 months ago - Security is one of the characteristic of database that includes also the protection of the database from unauthorized access confidentiality and unauthorized changes.
11 months ago - Database Management System is a collection of interrelated data and a set of programs to access those data.
11 months ago - This query returns rows in the first query that are not present in the second query.
11 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.
11 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.
11 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’.
11 months 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.
11 months ago - Which of the following is the correct report that will display the DESCRIPTION, WAREHOUSE AND distinct value for CLASS.
11 months ago - SELECT DESCRIPTION, PRICE + 10000 + PRICE AS “NEW PRICE LISTS” FROM PARTS ORDER BY PRICE DESC;