i agree... its a interesting thing to learn, just like learning an actual new language.
Answer:
C. The number of items in the column list doesn't match the number in the VALUES list.
Explanation:
The INSERT INTO statement is used to insert new records in a table.
<u>Syntax is as follows:</u>
INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);
Each column item has to match with the values to be inserted in the same order.
In the question, there are 8 column items specified whereas there are only 7 values given to be inserted.
Answer:
b. foreign key
Explanation:
In the database world, a foreign key is a field on one table and a primary key for another table. The purpose of a foreign key is to provide linkages between two or more tables. Given two tables A and B, and making A the point of reference, a primary key is a field that is unique in A while a foreign key is unique in B.
On another hand, a composite primary key is a combination of two or more fields/columns on database table that can be used to uniquely identify each row in the table.
In the database lingua, what we have is a unique key not a distinct key, though the two words are similar in meaning.
A duplicate key is used when an information may be repeatedly entered on a table.
So the correct option is a foreign key.
Answer:
APR is the Interest rate advertised by lenders.
Explanation:
APR is the annual percentage rate that is different from the interest rate. Interest rate is the rate of borrowing money. While APR is the rate which includes interest rate, processing fee and other cost that are involved in loan approving.
This cost is decided by lender, which may be equal to interest rate or greater than interest rate.