"

Name : Uday Shah - HOD (IT)

Contact No : 7600044051

--------------------------------------------------------------------------------------------------------------------- 

1. A primary key is always-

Unique and not null

2. A foreign key can refer to a-

Only primary key of another table

3. The constraint, which can be defined only at column level, is-

Not null

4. A foreign key can be specified with the table name only when-

Both columns have same name

5. Which of the following is not a character data type?

CLOB

6. Entity Integrity rule refers to the-

Primary key

7. Referential Integrity rule refers to the-

Foreign key

8. Which of the following is not a constraint

Default

9. A single check constraint can refer to more than one column at-

Table level only

10. 'On delete cascade' is used to-

Delete parent records and corresponding child records

11. A unique index is created for which two constrains from the following-

Primary key

Unique Constraint

12. Which two of the following is true when you create a constraint?

Once created it can't be alerted

A constraint can be created after the table is created

13. Which of the following is true about a sequence?

It belongs to a specific  schema

14. The RENAME command can't be used to change the name of-

A column

15. The NUMBER data type can't be used for-

       Hexadecimal

16. Which of the following is not a part of SQL?

Data exhibition Language

17. Which of the following groups are only DML commands?

Update, insert, delete

18. The default format to enter a data is-

dd/mon/yy

19. When you want to match the data values using wildcards, the operators used is –

LIKE

20. An IN operator is equivalent to-

A combination of multiple  OR operators

21. The '%' wild card character represents-

One or more characters

22. To find the occurrence of a sub string in the given string the function used is-

SUBSTR

23. The CONCAT function is similar to-

'||' operator

24. A HAVING clause is used to restrict-

Groups

25. A WHERE clause is used to restrict-

Rows

26. A NULL value is equivalent to-

      Unknown value

27. The TRUNCATE command is used to-

Remove all  rows from a table

28. The ALTER TABLE command is not used to-

Disable a constraint

Enable  a constraint

29. The time format used for the hour, minute and second is-

hh:mm:ss

30. Which of   the following is not a valid join operation?

subjoin

31. To perform a self join you require-

an alias

32. In most cases a join operation between two tables involves –

primary key of one table and foreign key of another

33. Which of  the following commands does not display duplicate rows-

Union

34. Which statement does not end a transaction-

ROLLBACK

35. Identify the correct command to create a new user-

CREATE USER newuser IDENTIFIED BY newuser00

36. An Index is automatically created on-

a primary key

37. An index uses the-

rowid

38. The main purpose of creating a ROLE is-

To Create a role model of a user

39. The main purpose of creating a view is for –

data security

NOTE :: Please Give Your Comment and Like on Facebook