1 month ago - What query should be used in order toget theSUBSTR function that returns the job_id = ‘REP’.
1 month ago - SELECT TRIM(‘K’ FROM LASTNAME)AS TRIM, LASTNAME, DEPARTMENT_ID, MANAGER_ID FROM EMPLOYEES WHERE DEPARTMENT_ID = 50 AND MANAGER_ID = 100;
1 month ago - SELECT SUM(QTY) FROM STOCKS WHERE WAREHOUSE IN (1,5) GROUP BY WAREHOUSE HAVING MAX(WAREHOUSE) >=5;
1 month 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 month 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 month 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 month ago - Count the Job_id; Apply where condition whose lastname ends with letter ‘N’; Group the job_id; and Apply having clause of employees having average salary that is greater than 10000.
1 month ago - Security architecture has its own discrete security methodology. Select one: True False
1 month ago - It involves a combination of two or more sampling techniques enumerated above
1 month ago - LSA type 1 including a list of directly attached network prefixes and link type
1 month ago - A virtual Answer is a special OSPF transit area that is used to connect a remote OSPF network to Area 0.
1 month ago - An ABR in a multiarea OSPF network receives LSAs from its neighbor that identify the neighbor as an ASBR with learned external networks from the Internet. Which LSA type would the ABR send to other areas to identify the ASBR, so that internal traffic that is destined for the Internet will be sent through the ASBR?
1 month ago - Use the show ip ospf database command to verify the contents of the OSPFv2 LSDB.
1 month ago - Used to display the OSPFv2 parameters configured on an interface, such as the OSPFv2 process ID that the interface is assigned to, the area that the interfaces are in, the cost of the interface, and the Hello and Dead intervals.
1 month ago - Which LSA type is flooded by a designated router to other OSPF routers within the same area?
1 month ago - Similarly to the form_error() function, returns all validation error messages produced by the Form Validation Library.
1 month ago - A rule reference that returns FALSE if the form element does not match the one in the parameter.
1 month ago - Which of the following is correct from the given statement below: //$this->db->limit(10);
1 month ago - Is Inequality can be considered as Social and Ethical Consequences of AI?
1 month ago - Is threatening behavior or unwanted advances directed at an adult using the Internet or other forms of online and electronic communications; it is the adult version of cyberbullying.
1 month ago - Is Security can be considered as Social and Ethical Consequences of AI?
1 month ago - It sees a set of prototypes in particular to be matched to cases at hand
1 month ago - answered Marked out of 1.00 Not flaggedFlag question Question text The following are distinct roles that KR plays EXCEPT
1 month ago - Floats specify an element on where to place, either using left or right classes accordingly
1 month ago - .text() It is used to get or set values from and to a non-input element like divs.
1 month ago - A grid layout that adapts or resize columns depending on the device screen size.
1 month ago - A grid layout that is used for static website designs because it has fixed/distributed column sizes.
1 month ago - Internal router is a router that has all of its interfaces in the same area.
1 month ago - Based on the given SELECT statement below what would be the possible output? SELECT TRIM(‘K’ FROM LASTNAME)AS TRIM, LASTNAME, DEPARTMENT_ID, MANAGER_ID FROM EMPLOYEES WHERE DEPARTMENT_ID = 50 AND MANAGER_ID = 100;
1 month 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’;
1 month 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;
1 month 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 month 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 month 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 month ago - Which of the following is the correct report listing only the column DESCRIPTION, WAREHOUSE, CLASS and PRICE of all parts where the description contains keyword ‘SHE’.
1 month ago - Which of the following is the correct report that will display the DESCRIPTION, WAREHOUSE AND distinct value for CLASS.
1 month ago - This method is commonly used in social sciences when investigating hard-to-reach groups
1 month ago - Every time you try to describe a large set of observations with a single indicator you run the risk of distorting the original data or losing important detail.
2 months ago - One of the four distance vector IPv4 IGPs refers as Advanced version of distance vector routing
2 months ago - To avoid repetitive function declarations on controllers and modules, we should use Look up method classes.
2 months ago - The helper libraries all located in system/controller. After loading the helper class to be used, its functions is ready to be used.
2 months ago - Database Synchronization is the process of organizing the columns/records or attributes and tables of the database to minimize data redundancy.
2 months ago - .CAPTCHAIt is very useful on web forms security against online bots, crawlers and spammers.
2 months ago - Self-service password reset (SSPR) is defined as any process or technology that allows users who forgot their password authenticate their account and reset their
2 months ago - Log In modules are needed to limit users from accessing off-limits and restricted webpages or content.
2 months ago - Sessions in native PHP are the “superglobal” variables that can be accessed anywhere on the web application because it is stored on the browser session.
2 months ago - Search Up methods is very useful on getting pieces of data, one at a time particularly on multiple tables and databases
2 months ago - For sending email, make sure you configured your email server properly. This method
2 months ago - For sending email, make sure you configured your email server properly. This method uses the Email class library
2 months ago - A report module is typically a back-end web page that contains various figures of interpreted database table records.