4 months ago - he overall logical structure (schema) of a database can be expressed graphically by
4 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’
4 months ago - This is used to bring together data that is stored in different tables by specifying the link between them.
4 months ago - The overall logical structure (schema) of a database can be expressed graphically by
4 months ago - Based on the given table Stocks choose the possible output if the following sql statement is executed. SELECT MAX(NAME) FROM STOCKS;
4 months ago - Are said to exhibit physical data independence if they do not depend on the physical schema.
4 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;
4 months ago - True/False. 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.
4 months ago - Provide the best answer for the following statement. A type of function that accept numeric input and return numeric values
4 months ago - Provide the best answer for the following statement. A type of function returns one result per group of row
4 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. SELECT CLASS, DESCRIPTION, PRICE FROM PARTS WHERE PRICE BETWEEN 200 AND 500; SELECT CLASS, DESCRIPTION, PRICE FROM PARTS WHERE PRICE BETWEEN 500 AND 500; SELECT CLASS, DESCRIPTION, PRICE FROM PARTS WHERE PRICE BETWEEN =200 AND 500; SELECT CLASS, DESCRIPTION, PRICE FROM PARTS WHERE PRICE BETWEEN 200 AND BETWEEN 500;
4 months ago - Character strings and date values are enclosed with double quotation marks.
4 months ago - Given the output below. Which of the following is the correct PL/SQL to be used? Select one: a. SELECT (PARTNUM|| belong to||DESCRIPTION) FROM PARTS WHERE CLASS = ‘SG’; b. SELECT (PARTNUM|| ‘belong to’||DESCRIPTION) FROM PARTS WHERE CLASS = SG; c. SELECT (PARTNUM|| ‘belong to’||DESCRIPTION) FROM PARTS WHERE CLASS = ‘SG’; d. SELECT (PARTNUM|| ‘belong to’||DESCRIPTION) FROM PARTS WHERE PARTNUM IN (‘BV06,’KV29’)
4 months ago - A null value means that the value is unavailable, unassigned, unknown, or inapplicable.
4 months ago - This is used to test for values in a specified set of values. Select one: a. IN b. Comparison c. Like d. Between
4 months ago - True/False. Character strings and date values are enclosed with double quotation marks.
4 months ago - Given the output below. Which of the following is the correct PL/SQL to be used Select one: a. SELECT WAREHOUSE, CLASS FROM PARTS WHERE CLASS IN (‘AP’,’SG’,’HW’); b. SELECT DICTINCT WAREHOUSE, CLASS FROM PARTS WHERE WAREHOUSE >=1; c. SELECT DISTINCT WAREHOUSE FROM PARTS; d. SELECT WAREHOUSE, CLASS FROM PARTS;
4 months 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’.
4 months ago - This is also known as facts that can be recorded and that have implicit meaning.
4 months ago - It is a unit of data – is a symbol or a set of symbols which is used to represent something.
4 months ago - It is the collection of information stored in the database at a particular moment is called
4 months ago - Which of the following is the correct example updating all student COURSE to ‘BSIT’ from STUDENTS table?
4 months ago - Which of the following is the correct example of updating the COURSE to ‘N/A’ of all students from STUDENTS table whose course IS NULL;
4 months ago - Suppose that a user wanted to update the lastname of student to ‘Santos’ and YR_LVL to ‘Irreg’ whose USN_ID is equal to 50, in one select statement which of the following is the correct sql statement to use.
4 months ago - It is a collection of interrelated data and a set of programs to access those data.
4 months ago - The overall logical structure schema of a database can be expressed graphically by an Answer
4 months ago - Which duplicates the first six bytes of a frame before making a decision?
4 months ago - Which duplicates the first six bytes of a frame before making a decision? Select one: a. ASIC switching b. fragment-free switching c. store and-forward switching d. cut through switching
4 months ago - If a router has four interfaces and each interface is connected to four switches, how many broadcast domains are present on the router? ?
4 months ago - Which interface counter can you use to diagnose a duplex mismatch problem?
4 months ago - What is the most appropriate summarization for these routes? 20.0.0.0 20.0.1.0 20.0.2.0 20.0.3.0
4 months ago - Which command can you enter to set the default route for all traffic to an interface?
4 months ago - which IP address can send traffic to all hosts on network 10.101.0.0/16?
4 months ago - he shortest compressed format of the IPv6 address 2001: 0DB8:0000:1470:0000:0000:0000:0200 is Answer
4 months ago - On Ethernet networks, the hexadecimal address FF-FF-FF-FF-FF-FF represent the Answer MAC address.
4 months ago - The shortest compressed format of the IPv6 address 2001: 0DB8:0000:1470:0000:0000:0000:0200 is Answer
4 months ago - n Ethernet networks, the hexadecimal address FF-FF-FF-FF-FF-FF represent the Answer MAC address.
4 months ago - Which subnet mask will allow all three web servers to be on the same network while providing the max number of subnets ?
4 months ago - If a router has 3 hosts connected in one port and two other hosts connected in another port, how may broadcast domains are present on the router?
4 months ago - Two hosts are attached to a switch with the default configuration. Which statement about the configuration is true?
4 months ago - Which command can you execute to set the user inactivity timer to 10 seconds?
4 months ago - Which statements are true about using leased lines for your WAN infrastructure? Select one or more: a. Leased lines with sufficient bandwidth can avoid latency between endpoints. b. Leased lines require little installation and maintenance expertise. c. Multiple leased lines can share a router interface. d. Leased lines provide inexpensive WAN access. e. Leased lines support up to T1 link speeds. f. Leased lines provide highly flexible bandwidth scaling.
4 months ago - Which statements are true about using leased lines for your WAN infrastructure?
4 months ago - For an address lookup what is the authoritative source ? Select one: a. the operating system cache b. the browser cache c. the ISP local cache d. a recursive DNS search
4 months ago - Which application use UDP as the transport layer protocol?Which application use UDP as the transport layer protocol?
4 months ago - The 8-bit binary value for 41 isDuring troubleshooting procedures, from which location will most Cisco routers load a limited IOS
4 months ago - Which value, that is contained in an IPv4 header field, is decremented by each router that receives a packet? Select one:
4 months ago - A collision fragment, also known as a Answer frame, is a frame of fewer than 64 bytes in length.
4 months ago - What happens if part of an FTP message is not delivered to the destination?A collision fragment, also known as a Answer frame, is a frame of fewer than 64 bytes in length.
4 months ago - Which area of the network would a college IT staff most likely have to redesign as a direct result of many students bringing their own tablets and smartphones to school to access school resources?