CS403 Solved Quiz 1 by VUBuddy

WMIg3Q

CS403 QUIZ 1 SOLVED

Q1. Truncate is an alternative of Delete command.

1. True
2. False

Correct answer: True

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

Correct answer: Memory buffer

Q3. Browser Based & Non-Browser/Simple are two different types of .

1. Forms
2. Language
3. Interface
4. Programs

Correct answer: Forms

WMIg3Q

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

Correct answer: Cannot be used to modify type or size of an existing column

Q5. What does the abbreviation DBMS stand for?

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

Correct answer: 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 join
2. Inner join
3. Both I and II
4. None of the above

Correct answer: Inner join

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

1. True

WMIg3Q

b) 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 ask the 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

Correct answer: First, we will run MS Access and select New option from the file. Next it will ask the name of database.

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

Correct answer: Not Null

Q10. In SQL, which command is used to modify the rows of tables.

1. UPDATE
2. INSERT
3. BROWSE
4. APPEND

Correct answer: UPDATE