₦airaland Forum

With the integration of technology into business comes the need for auditors to have technical knowledge. Structured Query Language(SQL) is used to make inquiries from databases.One of the basic requirements in today's auditing world is the ability to directly interrogate databases for sufficient and reliable evidence.Remember that evidence that you obtain directly as an auditor is more reliable than the evidence that the client's database administrator gives you. Can you attempt the question below ?


CREATE TABLE products {

product_id INTEGER CONSTRAINT products_pk PK,

product_type_id INTEGER

CONSTRAINT product_fk_product_types

REFERENCES product_types (product_type_id),

name VARCHAR2(30) NOT NULL

description VARCHAR2(50),

price NUMBER(5,2)

};



From the SQL statements above, which of the following is MOST LIKELY correct ?

A. The created table will have seven columns

B. Fields in description column can contain more than 50 characters

C. product_type_id column exists in another table

D. Fields in price column can contain up to seven numbers
Our next Certified Information Systems Auditor (CISA) training batch comes up on November 17,2018 .
Call/Whatsapp +2348033587126 to register.

Correct answer is C.,..