IGCSE Computer Science Paper-1: Specimen Questions with Answers 89 - 90 of 164

Question 89

Edit

Write in Short

Short Answer▾

List the different types of languages available in the DBMS.

Explanation

Image of The DBMS

Image of the DBMS

Loading image

There are four types of languages in the DBMS:

i) DDL or the Data Definition Language used for defining the database and schema structure by using some set of SQL Queries like CREATE, ALTER, TRUNCATE, DROP and RENAME.

ii) DCL or the Data Control Language is used to control the access of the users inside the database by using some set of SQL Queries like Commit, Rollback, Savepoint and Transaction.

iii) DML or the Data Manipulation Language being used to do some manipulations in the database like Insertion, Deletion, etc. by using some set of SQL Queries like SELECT, INSERT, DELETE and UPDATE.

iv) TCL or the Transaction Control Language is used to control transactional processing in a database. The GRANT is responsible for conferring the authorization to the users. REVOKE command is used for withdrawing the authorization.

Question 90

Edit

Write in Short

Short Answer▾

What information is present on the magnetic stripe of a plastic card?

Explanation

The magnetic stripe present at the backside of a plastic card such as credit card or debit card contains CVV no. or the Card Verification Value. This CVV no is a 3-digit number and a sensitive information.

The other sensitive information present in the magnetic stripe are credit card number, full name along with the card’s expiration date and the country code.

Choose Paper