Skip to main content

Xplore-Mysql Solutions

Xplore-Mysql Solutions


1.When does the for loop terminate?
When index reaches the upper bound or is terminated early using Exit statement
2.Select an appropriate option for a 'Function' in Plsql
Function can return result value.
3.Which sql statement returns numeric value?
Select sysdat-hire-date From Emp;
4.The______contains a set of tables and views that oracle use as a reference to the database.
Data dictionary
5.What are defined as exceptions in Pl/Sql?
Run time errors
6.From the below table,what would be the primary key to get unique record from the table?
EmpId and ProjectId together
7.A column with reference to a record in a table should not have multiple values.Which normal form,talks about the above statement?
First
8.Delete * from Student.What will be the output?
Delete all rows from Student table
9.The formal classifications describing the level of database normalization in a model are called normal forms
True
10.We can use transaction control statements in database Triggers
False
11.Select the suitable option from below to create an index on 'job' column in emp table?
Create index emp_id on emp(job);
12.Which of the statements helps in terminating the Pl/Sql loop?
Exit When
13.Database triggers can be fixed when the table is truncated?
False
14.Types of Sql Statements
DDL
DML
TCL
15.In the below table
EmpId|EmpName|ProjId....
By referring the above table,Select a suitable query which gets all the employees whose project is same as project of 'd'?
Select * from Emp where ProjId=(Select ProjId from Emp where EmpName='d')
16.We can enable or disable a database trigger
True
17.Which of the below statement is used to remove access or privileges on database object to users?
Revoke
18.A stored function will not allow any parameter to be passed?
False
19.DCL commands are used to enforce the database security in a multiple user environment
True
20.DCL commands are
Create
Alter
Drop
21.Select the suitable Plsql statement
Bringing programming language features to Sql
22.Which is the correct syntax for handling exception handlers?
When ex_name Then statement
23.Which of the below constraints will make sure to allow,only the values of a column(in a master)to the respective column of a child table?
Foreign key
24.Which of the following is true with respect to referential integrity?
Every foreign key value must match primary key value associated table ,that is parent table
25.What is the grant statement to grant select,insert,delete privileges on table Emp to user:Test user?
Grant select,insert,delete on Emp to Test user.
26.Table 1: Emp
Empid1|EmpName|ProjId
Table 2: Proj
ProjId |ProjName..
By referring to the above table structure,select the query which would fetch Empid,EmpName,ProjId,ProjName for each company?
Select A.EmpId,A.EmpName,A.ProjId,B.ProjName from Emp A,Proj B where A.projId-B.ProjId
27.Select the suitable option for subquery
Inner query executes first
28.Which prefixes are available to oracle triggers?
Both:new and :old
29.What type of join in below statement?
Select Column names from table1 T1,table2 T2 where condition;
Self join
30.Evaluate the set of sql statements:
Create Table dept(dept_id number(2), dname varchar(14),Loc varchar2(13));
Rollback;
Describe Dept.What is true about the set?
The Describe Dept statement displays the structure of Dept table
31.How many types of indices are present in sql server?
2
32.Which is the invalid command in sql?
Fetch
33.The upward to lower flow in a loop is?
Reverse
34.To increase the size of column in sql use:
Alter table table_name Modify column_name datatype(new_size)
35.Sql Query used to search details based on first character in a column?
Select * from table_name where name like'(char)%";
36.What is the purpose of type and rowtype?
Type provides datatype of variable.
Rowtype provides record type that represents a entire row of a table or view or columns selected in the cursor
37.How many ways by which the procedure can be called?
Using execute command
Calling the name of the procedure from other plsql block
38.Cursors should be declared in begin block in Pl/Sql
False
39.What is the clause we need to add in function body return variable
Return varchar2
40.SQL command to drop the column in specific table?
Alter table tablename drop column columnname;


 

Comments

Popular posts from this blog

Get Ethical Hacking Project #1

Thanks for your interest in our course This is a paid course, 150 rs for Indian people, 5$ for international people Instructions to get course: Indian people can get the course by paying using this UPI id   tamilhacks@ybl  (KARTHIKEYAN T) send 150 Rs to this upi id with subject bug bounty and after payment take a screenshot and send that to email id tamilhackstech@gmail.com - you will get the course within 24 hours. (there will be no tax, when paying using upi id)     The above mentioned method is most preferable. if you don't have a upi id app, install  phonepe  or  google pay   app and register there and pay easily  or  pay here using the alternate method to get this course, this link cost 18% gst for the course . (nearly 30-100 Rs for tax and other charges here )   After payment you will receive a payment confirmation mail along with a downlink for the course, you can download the course file using that . the course is in zip format, so after downloading the file extra

Learn c++ in Tamil | Complete guide and tutorial | Beginner to Advance all concepts explained.

hi guys welcome , all the coding used in video are available here : /* hi guys welcome to learn c++ in tamil what is C++ how what software your own program schools,clg,institute.... start 1.interest 2.patience 3.fun 4.practise computer program - app - programming source code - hardware - fb running , executing machine language :  101010 assembly lang : mov h1; high lang : c , c++....java , js , python  eg :  a+b .....1001010  compiler :  human to machine              machine to human  rules :  a+b;  usage:  games, manufacturing , embedded , finance , graphics , etc...  Guide: 1.problem 2.solution - alternative 3.program  - C++ 4.compile  - turboc , ide , codeblocks , cmd 5.result   - library file - linker : #include<iostream.h>    input , output std::cout<<"welcome";   standard character out << " "; primary section : 1.statements   ;  end 2.functions   main() 3.syntax  , syntax error pra

Get Bug Bounty Course

Thanks for your interest in our course Limited Offer This is a paid course, Rs 10000 ,Rs 1000  for Indian people, 75$ 15$ for international people , 50$ 10$ for Srilankan people Instructions to get course: Indian people can get the course by paying using this UPI id  tamilhacks@ybl  send 1000 Rs to this upi id with subject bug bounty and after payment take a screenshot and send that to email id tamilhackstech@gmail.com - you will get the course within 24 hours. (there will be no tax, when paying using upi id)    The above mentioned method is most preferable. if you don't have a upi id app, install phonepe or google pay   app and register there and pay easily  or  pay here using the alternate method to get this course, this link cost 18% gst for the course . (nearly 30-100Rs for tax and other charges here ) After payment you will receive a payment confirmation mail along with a downlink for the course, you can download the course file using that. As for international peopl