Java & sql combined

Software Foundation_Phase 3_ java May 2019
*IT overview*
1)True
2)Both a and b
3)notepad and sticky notes
4)Application layer
5)desktop application

*Oops concepts*
1)JDK
2).java (for java written code only)
3).class ( Java compiled code)
4)JVM
5)compilation

*Problem Solving*
1) FALSE
2) only i,ii,iii,iv
3) Structuring, Detecting and Defining the problem.
4) Structured Programming ( dividing into smaller units/modules )
5) Procedural Programming (occurence of Functional decomposition)

*Classes and objects*
Final
Constructor
Object class ( superclass of every class)
Abstract
Abstract class (relies upon its subclass)

*Operators and variables quiz*
Boolean
0x99fffL
keyword
"Helloworld"
1
TCS: *Hands on phase 4:*

*1. DDL hands-on*

Step 1: 
create table Department(dept_id number(10), dept_name varchar(20));

Step 2: 
alter table Department add Location varchar(20);

Step 3: 
drop table Department;

*2. DQL hands-on*

Step 1: 
just click on the mention links.

Step 2: 
open vi editor and type this

   Select DEPT_NAME
   from department
   where DEPT_ID  = 100;

*3. DML hands-on*

Step 1:  
Insert into Employee values(1, 'AAA', 20000,  100);

Insert into Employee values(2, 'BBB', 30000, 200);

Insert into Employee values(3, 'CCC', 30000, 300);

commit;

Step 2: 
update Department set DEPT_NAME = 'FINANCE' where DEPT_ID = 100;

commit;

*4. Constraints hands-on*

Step 1: 
alter table department add constraint pk_id PRIMARY KEY (dept_id);

Step 2: 
alter table employee add constraint fk_id FOREIGN KEY (dept_id) references department (dept_id);

*5. Joins hands-on*

Step 1:
Simply enter User name and password

Step 2:
Select SALARY
from Employee, department
where DEPT_NAME = 'IT'
and Employee.DEPT_ID = department.DEPT_ID;

Step 3:
Select DEPT_NAME
from department
where DEPT_ID = (select DEPT_ID from
(Select DEPT_ID, count(DEPT_ID)
from Employee
group by DEPT_ID
order by 2 desc) where rownum = 1);p
[22/05, 9:40 pm] Shivangi TCS: 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

env
LOGNAME
echo
PS1=“C>”
Yes

--------------------
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

* Group By
* Total
* Count
* Count(*)
* Having
Quiz—Conditional Operator
1.Compilation error
2.Compilation error
3.1,2&3
4.True
5.Non numeric

Quiz--- Java package
1.Java
2.import.pkg.*
3.default (no modifiers)
4.Array
5.Dot
*Array & Iteration Quiz*

b int, d array
int[ ] array=new int[10]
do while
heapspace
array store exception

Software Foundation Phase 5

PL/SQL Quiz
All
False -> function return
True -> DML
Return
Return Varchar2 -> return variable (longer question)

Cursors
exit when SQL%NOTFOUND
Cursor
None of the above
true - sql cursor
false - begin block

Exception Handling
true - raiseapplicationerror
calling environment
SQLCODE
0 - explicitly
At the end

SP and Functions
return varchar2
all of the above - named block
all of the above - trigger
false
an execution of a specific probably