DBMS And SQL
- 1.
The maximum length of NVARCHAR2 in sql data is
- A.
2000
- B.
4000
- C.
3000
- D.
1000
Correct Answer
B. 4000 -
- 2.
The maximum length of varchar2 in pl/sql data is
- A.
3000
- B.
38000
- C.
32000
- D.
40000
Correct Answer
C. 32000 -
- 3.
Tables supported by oracle database are
- A.
Index organized tables
- B.
Partitioned tables
- C.
Materialized Views
- D.
Clustered tables
- E.
All the above
Correct Answer
E. All the above -
- 4.
Choose the DDL statements
- A.
Create,alter,insert,delete,rename
- B.
Insert,update,delete,truncate,drop
- C.
Create,alter,drop,rename,truncate
- D.
Create,alter,rename,truncate,grant
Correct Answer
C. Create,alter,drop,rename,truncate -
- 5.
How many bits of raw data represent a single hexadecimal character?
- A.
1
- B.
2
- C.
3
- D.
4
Correct Answer
D. 4 -
- 6.
Alias can be used any where in THE SELECT list for operational purpose
- A.
True
- B.
False
Correct Answer
B. False -
- 7.
which is following Record based logical model
- A.
Hierarchical data model
- B.
Network data model
- C.
Relational data model
- D.
Relational data model
- E.
All the above
Correct Answer
E. All the above -
- 8.
bcnf valid for....
- A.
Partial Dependendencies
- B.
Multivalue attributes
- C.
Functional Dependendencies
- D.
Candidate key
Correct Answer
C. Functional Dependendencies -
- 9.
Normalization is helps in removing anomalies present
- A.
Insert
- B.
Delete
- C.
Update
- D.
All the above
Correct Answer
D. All the above -
- 10.
3NF removes ....
- A.
Dependency among key attributes
- B.
Transitive dependency.
- C.
Partial dependency.
- D.
Functional dependency.
Correct Answer
B. Transitive dependency. -
- 11.
functional dependency works in
- A.
Ddl
- B.
Dml
- C.
Tcl
- D.
Dcl
- E.
Non of the above
Correct Answer
A. Ddl -
- 12.
LOCK TABLE is belongs to which statement
- A.
DDL
- B.
DML
- C.
DCL
- D.
NON OF THE ABOVE
Correct Answer
C. DCL -
- 13.
SET TRANSACTION is belongs to which statement
- A.
DDL
- B.
DML
- C.
DCL
- D.
NON OF THE ABOVE
Correct Answer
B. DML -
- 14.
in sql '<>' this operator can used for
- A.
Greater
- B.
Lesser
- C.
Greater lesser
- D.
NON OF THE ABOVE
Correct Answer
D. NON OF THE ABOVE -
- 15.
in sql statements following one sequence which is correct
- A.
Oreder by, group by, having
- B.
Groupby, orderby ,having
- C.
Group by having,order by
- D.
Having groupby,orderby
Correct Answer
C. Group by having,order by -
- 16.
Advantages of views
- A.
Security
- B.
Query simplicity
- C.
Structural simplicity
- D.
All the above
Correct Answer
D. All the above -
- 17.
SQL has the following limitations: choose correct answers
- A.
No provision for declaring variables
- B.
No unconditional branching/jump statement
- C.
No block structure
- D.
All the above
Correct Answer
D. All the above -
- 18.
select 10 from emp; is it exected or not ..
- A.
Yes
- B.
No
Correct Answer
A. Yes -
- 19.
i have created one database i loged in that db , from my db can loged into another db
- A.
True
- B.
False
Correct Answer
B. False -
- 20.
which command is more power full command and many times we can use sql querys
- A.
Alter
- B.
Create
- C.
Select
- D.
Update
Correct Answer
C. Select -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Jan 29, 2013Quiz Edited by
ProProfs Editorial Team -
Sep 24, 2011Quiz Created by
Mahipalreddy
Back to top