Enter your search terms
Submit search form
Web
examineonline.googlepages.com
Online Exam
>>
DataBase
>>
SQL
>>
Test 3
Menu
Programming
COMPTIA
GMAT
English
IQ
DataBase
OS
MCSE
CISCO
Finance
Management
Health
Soft Skills
Web Building
Multimedia
Test 3
1 . SQL is a
A.
Non- procedural language
B.
Procedural language
C.
Database Language
D.
Both A. and C.
2 . A query within a query where the inner query is evaluated for each row in the outer query is called
A.
Join
B.
View
C.
Correlated subquery
D.
None of the above
3 . The process by which changes to tables in a database are automatically moved to another database by the SQL Server processes is called
A.
Normalization
B.
Replication
C.
Integrity Check
D.
Synonym
4 . The database programming language which is used for retrieving data and updating data on a database is called
A.
Structured database Language
B.
Structured programming Language
C.
Structured Query Analyzer
D.
Structured Query Language
5 . Which of the following is not allowed while creating a table using CRRATE TABLE in SQL?
A.
Table name can be an oracle reserved word
B.
Table names must begin with a letter
C.
Table names can contain in it numbers also
D.
None of the Above
6 . Which of the following is FALSE about a ALTER TABLE command of SQL?
A.
ALTER TABLE command is used to create a table
B.
ALTER TABLE command is used to change the column elements in a table
C.
ALTER TABLE command is used to delete a table
D.
Both A. and C.
7 . The ORDER BY in SQL is used to order rows
A.
in ascending order
B.
descending order
C.
both A. and B.
D.
None of the Above
8 . Consider an emp table having columns empno, empname, salary Which of the following queries sort emp table by empname and then by salary in descending order
A.
select empno, empname, salary from emp order by empname, salary desc;
B.
select empno from emp sort by empname, sal in desc;
C.
select empno, empname, salary from emp sort in empname, salary desc;
D.
select # from emp sort by empname and salary in desc;
9 . The tables can be combined together in SQL using the concept of
A.
Normalization
B.
Indexing
C.
Sequence
D.
Join
10 . If the comparison operator used in a join is '=' then it is called a
A.
Non-EQUI JOIN
B.
EQUI JOIN
C.
SELF JOIN
D.
OUTER JOIN
11 . The concept of joining table can be achieved by which of the following
A.
UNION
B.
Subqueries
C.
MINUS
D.
All the Above
12 . Which of the following arithmetic functions are used in SQL
A.
ROUND
B.
TRUNC
C.
ABS
D.
All the Above
13 . Views are created using SQL command
A.
BUILD VIEW
B.
CONSTRUCT VIEW
C.
CREATE VIEW
D.
MAKE VIEW
14 . Consider the emp table having columns empno, ename Which of eth following SQL query fetches empno that occur more than twice in the emp table
A.
select count(*) from emp group by empno having count(*) >2;
B.
select empno, count(*) from emp having count(*) >2;
C.
select empno, count(*) from emp where count(*) >2;
D.
select empno, count(*) from emp group by empno having count(*) >2;
15 . In order to remove the index created the SQL command used is
A.
DELETE INDEX
B.
DROP INDEX
C.
ELIMINATE INDEX
D.
REMOVE INDEX
16 . If the value is null in order to place a value in it the function used is
A.
Substitute( )
B.
Place value ( )
C.
NVL ( )
D.
Place( )
17 . Data types gets converted automatically depending upon the usage. Which of the following is not possible in automatic conversion of data?
A.
Number gets converted into character string
B.
DATE gets converted into character string
C.
Number gets converted into date
D.
None of the Above
18 . What does the following SQL statement return? Assume the value of SysDate is 05-05-5555 Select SysDate / 5 from dual;
A.
01-01-1111
B.
Error
C.
01
D.
1111
19 . In order to convert single byte characters to multi byte characters the function used is
A.
CONVERT_MULTI_BYTE
B.
CHANGE_TO_MULTI_BYTE
C.
TO_MULTI_BYTE
D.
None of the Above
20 . The transformation functions used are
A.
CONVERT
B.
TRANSLATE
C.
DECODE
D.
Both B. and C.
21 . Which of the following is true with locking?
A.
No data can be updated while it is being read
B.
No data can be read while it is being updated
C.
While SQL statement gets executed automatically DBA locks data called implicit locking
D.
All the Above
22 . While creating tables the concept that is used to reduce redundancy in data is called
A.
Views
B.
Aliases
C.
Sequence
D.
Normalization
23 . SQL support which of the following data model
A.
Hierarchical Database Model
B.
Relational Database Model
C.
Network Database Model
D.
File Management Model
24 . Which of the following normalization forms are available?
A.
Third Normal Form
B.
Boyce Code Normal Form
C.
Fourth normal Form
D.
Both A. and B.
25 . The operator used to denote outer join in SQL is
A.
*
B.
->
C.
(+)
D.
#
26 . Which of the following SQL statement create a sequence SE with starting value as 30 and in increments of 20?
A.
GENERATE SEQUENCE SE START WITH 30 ADD BY 20;
B.
CREATE SEQUENCE SE START WITH 30 ADD BY 20;
C.
CREATE SEQUENCE SE START WITH 30 INCREMENT BY 20;
D.
GENERATE SEQUENCE SE INITIATE WITH 30 INCREMENT BY 20;
27 . Consider the emp table having empname as empname smith rita Which of the following SQl statement display all empname as capitalized?
A.
select inticap(empname) from emp;
B.
select capital(empname) from emp;
C.
select upper(empname) from emp;
D.
None of the Above
28 . Which of the flowing denote pattern matching operator in SQL?
A.
UNION
B.
MINUS
C.
LIKE
D.
SET
29 . Which of the following is TRUE about subqueries in SQL?
A.
Sub queries must be enclosed in parenthesis
B.
BETWEEN cannot be used with a sub query
C.
Both A. and B.
D.
None of the Above
30 . Which of the following is TRUE about Views in SQL?
A.
Views are windows of existing table
B.
Creation of view is done by using CREATE VIEW statement
C.
Views do not contain data but table from which it is created contain data
D.
All the Above
Test Name :
Test 3
Category :
SQL
Number of Question :
30
Pass Score :
80
Test Result
Your Score :
Passing Score :
80
Result :
Copyright by
VanTuMinh
© 2007
