Basics of Computer

Q.1:-a)Define and explain the following terms data, information, Meta Data and
Database?
       b)Define entity also define its properties with a simple example.

Q.2:-a)Write down simple examples of SQL which shows the use of Truncate & AND (logical operator) separately.
      b)Define entity also define its properties with a simple example.

Q.3:-a)Define function with character manipulation functions.
       b)Define DML also explain the terms with example insert, delete, update.

Q.4:-Define Key, Primary Key, simple composite candidate key with theoretical &
SQL examples.

Q.5:-a)Define Grant and Revoke with the help of theoretical & SQL examples.
       b)Define association / relationship with the help of ER diagram & theoretical
definition along with its types.

Q.6:-a)Define Normalization and its types.
        b)Write down the SQL examples for Maximum & average group functions.

Q.7: -a) Define transaction also explain with the help of example the terms commit
& Roll back.
        b)Define ERD. Mention at least three symbols with example & explain each.

Q.8:-Define and explain any two of the following.

i ) RDBMS
ii) DCL.
iii) Transitive dependence