CS302P Final Term Quiz 10 File 2 July 2023 by Miss Mehwish

We also provide Past papers for Mids. and Finals Cross Check your answers befo re submitting directly from the file. We are not responsible for 100% correction as human error exists

MCQ 1: Question: REVOKE is a ______________ statement. A) Control B) Access C) Data Definition D) Data description E) Data manipulation

Correct option: E) Data manipulation

MCQ 2: Question: Truncate command response time is ______ as compared to Delete command. Options: A) Poor B) Worst C) Better D) Same

Correct option: C) Better MCQ 3: Question: Which of the following is used with INSERT command to insert values in a DB table? Options: A) ONTO B) WITH C) UPTO D) INTO

Correct option: D) INTO

MCQ 4: Question: Which of the following is correct syntax to create a table named Class with three attributes class_ID, start_time, Room? A) CREATE Class COLUMN (Class_ID varchar(5), Start_time datetime, Room varchar(10)) B) CREATE TBALE class COLUMN (Class_ID varchar(5), Start_time datetime, Room varchar(10)) C) CREATE class (Class_ID varchar (5), Start_time datetime, Room varchar(10))

Correct option: A) CREATE Class COLUMN (Class_ID varchar(5), Start_time datetime, Room varchar(10))

MCQ 5: Question: SQL is used for: A) All of the above B) Generating queries, organizing, managing, and retrieving data stored in a database. C) Creating, managing, and deleting tables and managing the relationships among the stored data. D) Maintaining data integrity and coordinating data sharing.

Correct option: A) All of the above

MCQ 6: Question: The ________ operator allows using wildcards in the WHERE clause of an SQL statement. A) FROM B) LIKE C) None of the above D) IN

Correct option: B) LIKE

MCQ 7: Question: Truncate is an alternative to the Delete command. A) True B) False

Correct option: A) True

MCQ 8: