DBMS AND SQL

1. Normalization is helps in removing anomalies present

Insert

Delete

Update

All the above

2. In sql '<>' this operator can used for

Greater

Lesser

Greater lesser

NON OF THE ABOVE

3. Which command is more power full command and many times we can use sql querys

Alter

Create

Select

Update

4. Advantages of views

Security

Query simplicity

Structural simplicity

All the above

5. SQL has the following limitations: choose correct answers

No provision for declaring variables

No unconditional branching/jump statement

No block structure

All the above

6. Tables supported by oracle database are

Index organized tables

Partitioned tables

Materialized Views

Clustered tables

All the above

7. How many bits of raw data represent a single hexadecimal character?

1

2

3

4

8. Choose the DDL statements

Create,alter,insert,delete,rename

Insert,update,delete,truncate,drop

Create,alter,drop,rename,truncate

Create,alter,rename,truncate,grant

9. 3NF removes ....

Dependency among key attributes

Transitive dependency.

Partial dependency.

Functional dependency.

10. The maximum length of NVARCHAR2 in sql data is

2000

4000

3000

1000

11. LOCK TABLE is belongs to which statement

DDL

DML

DCL

NON OF THE ABOVE

12. In sql statements following one sequence which is correct

Oreder by, group by, having

Groupby, orderby ,having

Group by having,order by

Having groupby,orderby

13. I have created one database i loged in that db , from my db can loged into another db

True

False

14. Select 10 from emp; is it exected or not ..

Yes

No

15. which is following Record based logical model

Hierarchical data model

Network data model

Relational data model

All the above

16. The maximum length of varchar2 in pl/sql data is

3000

38000

32000

40000

17. bcnf valid for....

Partial Dependendencies

Multivalue attributes

Functional Dependendencies

Candidate key

18. Alias can be used any where in THE SELECT list for operational purpose

True

False

19. SET TRANSACTION is belongs to which statement

DDL

DML

DCL

NON OF THE ABOVE

20. Functional dependency works in

Ddl

Dml

Tcl

Dcl

Non of the above

DBMS and SQL

1. Normalization is helps in removing anomalies present

2.

What first name or nickname would you like us to use?

2. In sql '<>' this operator can used for

3. Which command is more power full command and many times we can use sql querys

4. Advantages of views

5. SQL has the following limitations: choose correct answers

6. Tables supported by oracle database are

7. How many bits of raw data represent a single hexadecimal character?

8. Choose the DDL statements

9. 3NF removes ....

10. The maximum length of NVARCHAR2 in sql data is

11. LOCK TABLE is belongs to which statement

12. In sql statements following one sequence which is correct

13. I have created one database i loged in that db , from my db can loged into another db

14. Select 10 from emp; is it exected or not ..

15. which is following Record based logical model

16. The maximum length of varchar2 in pl/sql data is

17. bcnf valid for....

18. Alias can be used any where in THE SELECT list for operational purpose

19. SET TRANSACTION is belongs to which statement

20. Functional dependency works in