CS403 Final Term Solved MCQs by VU Malik

VU MALIK

Q1. Truncate is an alternative of Delete command.

1. True
2. False

Q2. The most recently accessed data from the disk (as well as adjacent sectors) is stored in a

1. Memory buffer
2. EPROM
3. ROM
4. Hard disk
5. Browser Based & Non-Browser/Simple are two different types of .a. Forms

1. Language
2. Interface
3. Programs

Q4. Which of the following is incorrect about alter table statement?

1. Cannot be used to modify type or size of an existing column
2. Can be used to delete a column
3. Cannot be used to create a new table
4. Can be used to add column in the existing table

Q5. What does the abbreviation DBMS stand for?

1. Database management software
2. Data borrowing and movement software
3. Digital base mapping system

Database management system

Q6. Suppose we have two tables T1 and T2, Tuples of T1 that do not match some row in T2 will not appear in

1. Outer joinb.

Inner join c. Both I and II d. None of the above

Q7. Value of a function in SQL is always determined by the input parametersa. True

1. False

Q8. Which of the following is true about creating database in MS Access?

1. First we will run MS Access and select New option from the file. Next it will askthe name of database.
2. After running MS Access, create database option is selected directly
3. Go to the tool option of MS Access and select create Database option with suitable name
4. Click on the file menu, select database option and then click it

Q9. In SQL queries, while creating tables or relations in database, key columns may be specified by

1. Null
2. Not Null
3. Data Type
4. None of the above
5. In SQl, which command is used to modify the rows of tables.a. UPDATE

1. INSERT
2. BROWSE
3. APPEND

Q11. Which of the following is one of the purposes of using DDL commands?

1. Inserting records into databases
2. Updating records into databases
3. Manipulating databases
4. Creating and destroying databases
5. The should be user friendly. Data integrity must be ensured and checks can be applied within the tables.

1. Input forms
2. Computer language
3. Application programming
4. Database

Q13. A memory cache, sometimes called a cache store or

1. ROM
2. DROMc.

RAM d. Hard disk

Q14. According to his/her level of knowledge/understanding, how many types of users are there

1. Three
2. Four
3. Six

Two

Q15. DML does not used to:

1. Add new rows to tables
2. Retrieve rows from table
3. Modify the rows of tablesd.

Alter a table definition

Q16. Which of the following prevents duplicate values to be displayed as a result of an SQL statement?

1. DISTINCT
2. DELETE
3. UPDATE
4. ALTER

Q17. GRANT belongs to which type of SQL commands classification

1. DML
2. DDLc.

DCL d. DQL 18. user interface is preferred over

user interface with respect to user.

1. Easy to understand, efficient
2. Hard to understand, efficientc.

Easy to understand, effective d. Hard to understand, effective

Q19. Which of the following is not true regarding clustering?

1. It increases the efficiency since related records are placed close to each other
2. Clustering makes records, difficult to access
3. Suitable to relatively static situations
4. It is a process, which means to place records from different tables to place in adjacent physical locations
5. The condition allows to retrieve values within a specific range.

1. AND
2. LIKE
3. BETWEEN
4. FROM

Q21. WORM Stands for

1. Write on. Read memoryb.

Write-once, read-many c. Write only memory d. Read only memory