SQL, Databases

Question: When a table is dropped using a simple DROP statement, SQL performs some more operations simultaneously, select all the valid operations?
A
Removes all rows from the table

B
Drops all the table's indexes

C
Removes all dependent views

D
Removes all dependent procedures

Note: Not available
1. Report
Question: Which of the following statement is correct regarding table creation?
A
Tables once created cannot be modified to add columns

B
Constraints can only be given while table creation

C
One can easily create a table from a given table

D
When a table is created from another table, all the constraints are copied as well

E
The width of the columns cannot be modified

F
Columns cannot be removed from a table

Note: Not available
1. Report
Question: A production house has two sales outlets. Both outlets are maintaining their data separately in schemas A and B respectively. The Management wants to see the sale of both outlets in one report. Both outlets are using tables called Sales which have identical structure. Which method you will adopt to create the report?
A
Select * from A.Sales join B.Sales

B
Select * from A.Sales union all B.Sales

C
Select * from A.Sales, B.Sales

D
None of the above

Note: Not available
1. Report
Question: What are the programs that execute automatically whenever DML operations are performed on tables called?
A
Triggers

B
Procedures

C
Functions

D
None of the above

Note: Not available
1. Report
Question: Which of the following is not a type of constraint?
A
Primary key

B
Unique

C
Check

D
Distinct

E
Default

Note: Not available
1. Report
Question: Consider the query: SELECT name FROM Student WHERE name LIKE '_a%'; Which names will be displayed?
A
Names starting with "a"

B
Names containing "a" as the second letter

C
Names starting with "a" or "A"

D
Names containing "a" as any letter except the first

Note: Not available
1. Report
Question: A production house needs a report about the sale where total sale of the day is more than $20,000. Which query should be used?
A
select * from orders where sum(amount) > 20000

B
select orderdate, sum(amount) from orders where sum(amount) > 20000 order by OrderDate

C
select orderdate, sum(amount) from orders group by orderdate having sum(amount) > 20000

D
select orderdate, sum(amount) from orders group by OrderDate where sum(amount) > 20000

Note: Not available
1. Report
Question: Which character function should be used to return a specified portion of a character string?
A
CONCAT

B
LENGTH

C
SUBSTR

D
INITCAP

Note: Not available
1. Report
Question: What will happen if you query the emp table as shown below: select empno, DISTINCT ename, Salary from emp;
A
EMPNO, unique value of ENAME and then SALARY are displayed

B
EMPNO, unique value ENAME and unique value of SALARY are displayed

C
DISTINCT is not a valid keyword in SQL

D
No values will be displayed because the statement will return an error

Note: Not available
1. Report
Question: What is a rollback of transactions normally used for?
A
Recover from the transaction failure

B
Update the transaction

C
Retrieve old records

D
None of the above

Note: Not available
1. Report

First Prev 2 3 4 5 6 Next Last

Question: When a table is dropped using a simple DROP statement, SQL performs some more operations simultaneously, select all the valid operations?

Question: Which of the following statement is correct regarding table creation?

Question: What are the programs that execute automatically whenever DML operations are performed on tables called?

Question: Which of the following is not a type of constraint?

Question: Consider the query: SELECT name FROM Student WHERE name LIKE '_a%'; Which names will be displayed?

Question: A production house needs a report about the sale where total sale of the day is more than $20,000. Which query should be used?

Question: Which character function should be used to return a specified portion of a character string?

Question: What will happen if you query the emp table as shown below: select empno, DISTINCT ename, Salary from emp;

Question: What is a rollback of transactions normally used for?