What is the correct syntax in SQL for the update? A. UPDATE tblcustomer SET name = ‘sok’ B. UPDATE TABLE tblcustomer SET name = ‘sok’ C. UPDATE TABLE tblcustomer SET name = ‘sok’ WHERE cid = 101 D. None correct…
What is the correct syntax for creating a table? A. CREATE tblcustomer (cid INTEGER, name VARCHAR(255)) B. CREATE TABLE tblcustomer (cid INTEGER, name VARCHAR(255)) C. CREATE tblcustomer {cid INTEGER, name VARCHAR(255)} D. None correct Answer: Option B
Which of the following syntax is correct for the insert? A. INSERT tblcustomer VALUES(101, ‘sok’) B. INSERT INTO tblcustomer VALUES(101, ‘sok’) C. INSERT INTO TABLE tblcustomer VALUES(101, ‘sok’) D. None correct Answer: Option B
In SQL, which of the following syntax is correct? A. SELECT FROM tblcustomer B. DELETE FROM tblcustomer C. UPDATE FROM tblcustomer D. All correct Answer: Option A
In SQL, why you should always use WHERE clause when using DELETE? A. If you don’t use WHERE clause, it will accidently delete all the records B. Because you want to delete all the records C. Because it is easy…
In SQL, why you should always use WHERE clause when using UPDATE? A. If you don’t use WHERE clause, it will accidently update all the records B. Because you want to update all the records C. Because it is easy…
If you develop a mobile app, which methodology is wrong for that? A. Waterfall B. Rapid App Development C. Agile D. None correct Answer: Option A
Why Waterfall methodology is longer relevant for today’s system project? A. Because once a step is finished, it cannot go back. B. Because it is too fast. C. Because it always needs user inputs. D. None correct Answer: Option A
What is step is not belong to SDLC? A. Marketing B. System Designing C. Coding D. All correct Answer: Option A
In DB, which attribute is always unique for each item? A. ISBN – International Standard Book Number B. S/N – Product Serial Number C. SKU – Stock Keeping Unit D. None correct Answer: Option D
KB Cambodia