DBMS

INTRO TO DBMS QUIZ
1.cardinity
2.many to many
3.eliminating
4.primary key value must be unique and primary key values must not change
5.each table column should contain a unique value and each record needs to be unique
-----------------
Sql type quiz ans
Defferable
Drop,rename,add,modify
All of these
Datatype constraint
Truncate
---------------
Database constraints quiz
Alter table drop constraint
Check(budget>=0)
Not null
All of these
Select constraint_name,constraint_type from user_constraints where table name=“
-------------------
Functions in SQL Quiz

* Group By
* Total
* Count
* Count(*)
* Having
----------------------
SQL Joins
*FALSE
*Super key
*Relational database system (most useful database model)
*Relational database system
Primary key(unique)
-----------------------
DB objects
1). Nextval
2)Sequences
3)Create fulltext index and system stored procedures
4)two
5)none of these
---------------------
Sql cursors
1)true
2)false(cursor declared at beginning)
3)cursor
4)exit when Sql %notfound
5)none of these
-------------------------
 Exception handling
1)true
2)0
3)sqlcode
4)calling environment
5)at the end
 Stored procedures
1)all the above
2)all the above
3)an execution of a specific procedure
4)false
5)return varchar2
---------------------
 Sql blocks
1)all of these
2)return varchar2(function header)
3)return(function body)
4)false(function can return more than one value)
5)true(function can be used)