Enter your search terms
Submit search form
Web
examineonline.googlepages.com
Online Exam
>>
DataBase
>>
SQL
>>
Test 2
Menu
Programming
COMPTIA
GMAT
English
IQ
DataBase
OS
MCSE
CISCO
Finance
Management
Health
Soft Skills
Web Building
Multimedia
Test 2
1 . What is the ouput of the SQL query on EMP table having a row namely EMPNO EMPNAME 1000master writes select INITCAP(empname) from emp;
A.
Master Writes
B.
MASTER WRITES
C.
master writes
D.
Master writes
2 . The SQL query gives output as: select power(2,3) from dual;
A.
8
B.
9
C.
6
D.
10
3 . The function TO_DATE in SQL
A.
Converts date into character string
B.
Converts character string into date
C.
Converts number into date
D.
Converts character string or number into date
4 . I the result of the combination of two tables to get duplicates also to be displayed we use command
A.
UNION
B.
UNION ALL
C.
UNION SHOW ALL
D.
ALL UNION
5 . Which of the following statement is FALSE?
A.
UNION produces result of combination of two tables
B.
To show duplicates we can use UNION ALL operator
C.
Queries that use UNION in the WHERE clause need not have the same number and type of column as in the select
D.
INTERESCT returns rows from both tables which are identical
6 . Which of the flowing denote group value functions in SQL
A.
SUM
B.
AVG
C.
COUNT
D.
All the Above
7 . The SQL command for filling the table with data (that is rows) is
A.
INSERT
B.
ADD
C.
FIL
D.
UPDATE
8 . The function that is used to cut off numbers to a specified number of decimal places is
A.
CUTOFF
B.
ROUND
C.
TRUNC
D.
TRUNCATE
9 . Which of the following data types are used in SQL?
A.
LONG
B.
DATE
C.
ROWID
D.
All the Above
10 . The table dropped can be
A.
Retrieved by using commit
B.
Cannot be retrieved
C.
Retrieved by altering the table
D.
Retrieved by rollback
11 . Which of the following is TRUE?
A.
The foreign key and the referenced key can be in the same table
B.
Combination of columns cannot be defined as foreign key
C.
A referential integrity is defined in child table.
D.
None of the Above
12 . Which of the following joins is possible in SQL
A.
EQUI-JOIN
B.
NON EQUI-JOIN
C.
Both A. and B.
D.
None of the Above
13 . Joining a Table to itself is called
A.
Equi-Join
B.
Self Join
C.
Outer Join
D.
Inner Join
14 . SAVEPOINT is
A.
Saves the data in database
B.
Identifies a point in a transaction to which we can later rollback
C.
Saves the profiles in database
D.
None of the Above
15 . A SQL command that is used to reduce the access time is
A.
MINIMIZE
B.
REDUCETIME
C.
INDEX
D.
MINTIME
16 . The SQLPLUS command btitle is used for
A.
Setting the title at the top of the page of a report
B.
Setting the title at the top and bottom of the page of a report
C.
Setting the title at the bottom of the page of a report
D.
Setting the title in the center of the report.
17 . The SQLPLUS command for calculating the total for each section of the report is
A.
calculate sum
B.
compute sum
C.
calculate add
D.
compute add
18 . Which of the following SQL statement retrieve all the columns from the table emp?
A.
select all from emp;
B.
select entire from emp;
C.
select * from emp;
D.
select # from emp;
19 . In a database row is also called as
A.
Query
B.
Query
C.
Relation
D.
Record
20 . In SQL the operator that will be used to output a record if any of the condition listed holds true is
A.
AND
B.
MINUS
C.
OR
D.
NOR
21 . The number of records in a table emp is given by the SQL statement
A.
select total(*) from emp;
B.
select count(*) from emp;
C.
select sum(*) from emp;
D.
select total from emp;
22 . Which of the following denote single value function used in SQL
A.
AVG ( )
B.
SQRT ( )
C.
COUNT ( )
D.
All the Above
23 . Which of the following denote group clause in SQL
A.
having
B.
group by
C.
Where
D.
Both A. and B.
24 . The SQL function that is used to remove unwanted characters in a string is
A.
RPAD
B.
LPAD
C.
LTRIM
D.
All the Above
25 . The SQL function SIGN (-50) gives value as
A.
-50
B.
50
C.
-1
D.
1
26 . The order by clause is added in a SQL statement
A.
Before the having clause
B.
After the having clause
C.
Before the group by clause
D.
Before the where clause
27 . A table T1 having 100 rows is joined with a table T2 with 50 rows without specifying the joined column in the where clause then result will have
A.
100 rows
B.
50 rows
C.
150 rows
D.
5000 rows
28 . In SQLPLUS the usual symbol for representing variable is
A.
#
B.
$
C.
&
D.
*
29 . Unique numbers can be assigned to columns in a database using
A.
Clusters
B.
Synonym
C.
Views
D.
Sequences
30 . An alias name for a base table is
A.
View
B.
Index
C.
Synonym
D.
Sequence
Test Name :
Test 2
Category :
SQL
Number of Question :
30
Pass Score :
80
Test Result
Your Score :
Passing Score :
80
Result :
Copyright by
VanTuMinh
© 2007
