Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,152,365 members, 7,815,780 topics. Date: Thursday, 02 May 2024 at 06:12 PM |
Nairaland Forum / Science/Technology / Webmasters / A Little Sql Question (321 Views)
Lga/ward/polling Center Database (sql) / How to repair corrupted MS SQL Server database? / Soccer and it logo Sql (2) (3) (4)
(1) (Reply)
A Little Sql Question by Nobody: 9:56am On Nov 01, 2018 |
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. |
Re: A Little Sql Question by Ruddyman(m): 10:13am On Nov 01, 2018 |
Correct answer is C.,.. |
(1) (Reply)
I Need A Senior Php Or Node.js Developer For An Urgent Project / Pls Help Me On This Developers / Breaking Bad API With Vanilla Javascript
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 6 |