Test4 - a Yes b No 6.Which is not part of the Data...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
SUBJECT: DBS TIME : 10 min. MARKS : 10 TEST-4 OBJECTIVE TYPE QUESTIONS TEST Underline the correct answer for each question 1.Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint a Yes b No 2.A column defined as PRIMARY KEY can have NULL's a TRUE b FALSE 3.A Transaction ends a Only when it is Committed b Only when it is Rolledback c When it is Committed or Rolledback d None of the above 4.Which of the following is not correct about a View ? a To protect some of the columns of a table from other users b Ocuupies data storage space c To hide complexity of a query d To hide complexity of a calculations 5.Is it possible to modify a Datatype of a column when column contains data ?
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: a Yes b No 6.Which is not part of the Data Definiton Language ? a CREATE b ALTER c ALTER SESSION 7. The Data Manipulation Language statements are a INSERT b UPDATE c SELECT d All of the above 8.EMPNO ENAME SAL A822 RAMASWAMY 3500 A812 NARAYAN 5000 A973 UMESH A500 BALAJI 5750 Using the above data Select count(sal) from Emp will retrieve a 1 b 0 c 3 d None of the above 9.Which of the following statements contains an error? a.. SELECT * FROM emp WHERE empid = 493945; b. SELECT empid FROM emp WHERE empid= 493945; c. SELECT empid FROM emp; d. SELECT empid WHERE empid = 56949 AND lastname = 'SMITH'; 10.Which of the following is not a group function? a. avg( ) b. sqrt ( ) c. sum ( ) d. max ( )...
View Full Document

This note was uploaded on 10/25/2010 for the course CMPN SEM4 taught by Professor Thakur during the Spring '07 term at University of Mumbai.

Page1 / 2

Test4 - a Yes b No 6.Which is not part of the Data...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online