Enter your search terms
Submit search form
Web
examineonline.googlepages.com
Online Exam
>>
DataBase
>>
SQL
>>
Test 1
Menu
Programming
COMPTIA
GMAT
English
IQ
DataBase
OS
MCSE
CISCO
Finance
Management
Health
Soft Skills
Web Building
Multimedia
Test 1
1 . SQL stands for
A.
Standard Query Language
B.
Storage Queuing Language
C.
Structured Query Language
D.
Storage Query Language
2 . SQL is a language for
A.
developing system programs
B.
relational database management system
C.
business applications only
D.
both A. and B.
3 . SQL commands are classified into how many broad categories
A.
Two
B.
Three
C.
Four
D.
Five
4 . DDL stands for
A.
Data Definition Language
B.
Data Division Language
C.
Data Dividing Language
D.
Digital Defining Language
5 . Which of the following is TRUE about Primary Key?
A.
Same value of Primary Key can appear in more than one row in the table
B.
A Primary key defined column can be of type LONG
C.
A column that is defined as Primary Key cannot contain NULL value.
D.
Both A. and B.
6 . Which of the following commands denote DML commands
A.
INSERT
B.
CREATE
C.
ALTER
D.
Both A. and B.
7 . A SYNONYM can be
A.
Private
B.
Public
C.
Represents a table with different name
D.
All the Above
8 . Which of the command below undo the current transaction?
A.
COMMIT
B.
ROLLBACK
C.
ALTER
D.
SAVEPOINT
9 . The SQL*PLUS Command used to delete a existing table is
A.
DELETE TABLE
B.
DROP TABLE
C.
DEL TABLE
D.
REMOVE TABLE
10 . DML stands for
A.
Data Manipulation Language
B.
Discrete Manipulation Language
C.
Data Modifying Language
D.
Digital Manipulation Language
11 . The default headsep character when SQLPLUS is activated first is
A.
The horizontal bar (-)
B.
The vertical bar (|)
C.
The hash symbol (#)
D.
The exclamation mark (!)
12 . Which of the following order of execution Oracle uses a SQL query containing the clause having, where, group by and group function is used?
A.
where, group by, group function, having
B.
group by, having, where, group function
C.
having, group by, where, group function
D.
group function, having, group by, where
13 . DUAL table has
A.
One row and two columns
B.
Indefinite rows and two columns
C.
One row and row column
D.
Indefinite rows and indefinite columns
14 . SysDate function contain
A.
Only Current Date
B.
Only Current Time
C.
Both Current Date and Current Time
D.
Only Hours of Time
15 . The order of sorting can be changed by SQL command
A.
order from
B.
order to
C.
order in
D.
order by
16 . NULL Value is equal to
A.
zero
B.
blank value
C.
"0"
D.
None of the Above
17 . If the base table of a view is deleted and we give SQL Select command on view table name
A.
Gives the columns referred in select statement of view
B.
Reports a error
C.
Select only particular columns of view table
D.
Outputs the whole view table
18 . Which of the following denote Transaction Control commands in SQL
A.
ROLLBACK
B.
SAVEPOINT
C.
COMMIT
D.
All the Above
19 . In the SQL Command in matching a character pattern the symbol % denote
A.
Any Single Character
B.
Any Sequence of zero or more characters
C.
NULL character
D.
Value equal to zero
20 . The SQL command used to avoid the selection of duplicate rows is
A.
UNIQUE
B.
DISTINCT
C.
EXCLUSIVE
D.
DISCRETE
21 . The ROWID data type value represents
A.
row.block.file
B.
block.row.file
C.
file.row.block
D.
block.file.row
22 . Which of the following about DELETE FROM command in SQL is FALSE?
A.
DELETE FROM command can be used in Deletion of single column value.
B.
DELETE FROM command is used to delete many rows from a table.
C.
DELETE FROM command is used to delete one or more rows from a table.
D.
All the Above
23 . Which of the following SQL command represent character data type?
A.
CHAR
B.
VARCHAR
C.
VARCHAR2
D.
All the Above
24 . To remove or take off all the granted privileges the SQL command used is
A.
REMOVE PRIVILEGE ALL ON
B.
REVOKE ALL ON
C.
REMOVE ALL IN
D.
REVOKE ALL IN
25 . In order to fetch data from database which of the following SQL command is used?
A.
RETRIEVE
B.
SELECT
C.
RECOVER
D.
FETCH
26 . Suppose the employee tables defined has the following values namely: EMPNOEMPNAMESALARY 100SRI1000 200NULL2000 300PRI1500 What is the result returned by the following SQL Query? select count(empname) from employee;
A.
3
B.
1
C.
2
D.
0
27 . Using SQL it is possible to create
A.
Column Constraint
B.
Table Constraint
C.
Both A. and B.
D.
None of the Above
28 . What is the output of the following SQL statement? select TRANSLATE('MASTER AUTHOR', 'MAOU', 'Maou')
A.
MaSTER auTHoR
B.
master author
C.
MASTER AUTHOR
D.
mAster AUthOr
29 . SHARE UPDATE lock permit users to
A.
to query data
B.
to lock data
C.
both A. and B.
D.
None of the Above
30 . The structure of a table can be seen by using the SQL command
A.
structure tablename;
B.
struct tablename
C.
describe tablename;
D.
explain tablename
Test Name :
Test 1
Category :
SQL
Number of Question :
30
Pass Score :
80
Test Result
Your Score :
Passing Score :
80
Result :
Copyright by
VanTuMinh
© 2007
