Java Sql Mcq answers

ERD and Normalization


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


1.Defferable
2.Drop,rename,add,modify
3.All of these
4.Datatype constraint
5.Truncate

Database constraints 
1.Alter table drop constraint
2.Check(budget>=0)
3.Not null
4.All of these
5.Select constraint_name,constraint_type from user_constraints where table name=“

Functions in sql
1.env
2.LOGNAME
3.echo
4.PS1=“C>”
5.Yes

SQL Joins


1.FALSE
2.Super key
3.Relational database system (most useful database model)
4.Relational database system
5.Primary key(unique)

Database Objects


1). Nextval
2)Sequences
3)Create fulltext index and system stored procedures
4)two
5)none of these

 

©2018 by The real one. Proudly created with Wix.com