Question # 1 of 10
Which of the following
statements creates a database named IMDB.
Select correct option:
CREATE
DATABASE IMDB;
CREATE DB IMDB;
ADD DATABASE named IMDB;
CREATE IMDB DATABASE;
Question # 2 of
10
Select correct option:
SELECT FROM * Persons
SELECT *
FROM Persons
SELECT * WHERE Persons
SELECT WHERE * Persons
Question # 3 of
10
Which of the following is not
a part of an INSERT statement?
Select correct option:
INTO
VALUES
INSERT
MODIFY
Question # 4 of
10
In SQL, which command is used
to delete rows from table.
Select correct option:
DELETE
REMOVE
TRUNCATE
Both I and II
Question # 5 of
10
Which of the following is the
correct syntax for adding a new column into an existing table.
Select correct option:
ALTER TABLE table_name {
ALTER [COLUMN] column type [(size)] [DEFAULT default] }
ALTER
TABLE table_name { ADD [COLUMN] column type [(size)] [DEFAULT default] }
Both I and II.
None of the above.
Question # 6 of
10
GRANT belongs to which type
of SQL commands classification
Select correct option:
DML
DDL
DCL
DQL
Question # 7 of
10
What happens if the WHERE
clause is omitted from a DELETE statement?
Select correct option:
All
records from the table are deleted
No record from the table will
be deleted
First record of the table
will be deleted
The statement will not be
executed and will give a syntax error
Question # 8 of
10
What does the abbreviation
DBMS stand for?
Select correct option:
Database Manipulation
Software.
Data Borrowing and Movement
Software
Digital Base Mapping System.
Database
Management System.
Question # 9 of
10
Which of the following is
used to filter rows according to some condition(s)?
Select correct option:
SELECT
FROM
WHERE
UPDATE
Question # 10 of
10
REATE TABLE and CREATE index
belongs to which type of SQL commands
Select correct option:
DML
DDL
DCL
DQL
Which of the following is
used with INSERT command to insert values in a DB table?
Select correct option:
ONTO
INTO
UPTO
WITH
Which of the following is a
correct way of selecting all the columns from a table called PERSONS?
Select correct option:
SELECT FROM * Persons
SELECT
* FROM Persons
SELECT * WHERE Persons
SELECT WHERE * Persons
Question # 3 of 10 ( Start
time:09:53:51 PM) Total M - 1
The ________ operator allows
to use wild cards in the where clause of an SQL statement.
Select correct option:
IN
FROM
LIKE
None of the above.
Question # 4 of 10 ( Start
time:09:54:15 PM) Total M - 1
Which of the following
statements creates a database named IMDB.
Select correct option:
CREATE
DATABASE IMDB;
CREATE DB IMDB;
ADD DATABASE named IMDB;
CREATE IMDB DATABASE;
Question # 5 of 10 ( Start
time:09:54:31 PM) Total M - 1
Which of the following is not
true regarding clustering?
Select correct option:
It increases the efficiency
since related records are placed close to each other
Clustering
makes records, difficult to access
suitable to relatively static
situations.
It is a process, which means
to place records from different tables to place in adjacent physical locations
Question # 6 of 10 ( Start
time:09:54:55 PM) Total M - 1
Which of the following is
used to filter rows according to some condition(s)?
Select correct option:
SELECT
FROM
WHERE
UPDATE
Question # 7 of 10 ( Start
time:09:55:14 PM) Total M - 1
Which of the following is not
an aggregate function
Select correct option:
AVG
SUM
UPPER
MAX
CREATE TABLE and CREATE index
belongs to which type of SQL commands
Select correct option:
DML
DDL
DCL
DQL
Question # 9 of 10 ( Start
time:09:55:59 PM) Total M - 1
In SQL, which command is used
to modify the rows of tables.
Select correct option:
UPDATE
INSERT
BROWSE
APPEND
Identify the basic
part(s) of a SELECT statement?
SELECT
FROM
Both SELECT and FROM
DISTINCT
SELECT
FROM
Both SELECT and FROM
DISTINCT
Which of the following SQL statements used to control access to the data and to the database?
Select correct option:
GRANT
REVOKE
Both GRANT and REVOKE
SELECT
GRANT is a ______________ Command.
Select correct option:
DDL
DML
DCL
None of the above
Is the given SQL Statement prompt error? Select * from relation1;
Select correct option:
Logical Error
No Error
Parameter Error
Time out Error
Consider a table named “emp” having fields Empname, EmpID, Age, salary. Which of the following is true if the following SQL statement tries to execute? SELECT * FROM emp WHERE Empname=’ALI’;
Select correct option:
The statement has a syntax error
The statement only displays the EmpID of those employees whose name is ALI
The statement displays the entire fields from emp in which the Empname is ALI
The statement must have an ORDERBY clause
Consider the two relations, Supplier (S_no, S_name, Contact_No, Address) and Supply (S_no, Item_no). Which of the following statements give(s) a list of supplier names supplying the item with Item_no ‘555’?
Select correct option:
SELECT S_name FROM Supplier WHERE Item_no=’555’
SELECT S_name FROM Supplier, Supply WHERE Supplier.S_no=Supply.S_no AND Item_no=’555’
SELECT S_name FROM Supplier WHERE S_no EXISTS (SELECT S_no FROM Supply WHERE Item_no=’555’)
SELECT S_name FROM Supplier WHERE S_name EXISTS (SELECT S_name FROM Supply WHERE Item_no='555')
Which of the following is the correct syntax for adding a new column into an existing table.
Select correct option:
ALTER TABLE table_name { ALTER [COLUMN] column type [(size)] [DEFAULT default] }
ALTER TABLE table_name { ADD [COLUMN] column type [(size)] [DEFAULT default] }
Both I and II.
None of the above.
DML does not used to :
Select correct option:
add new rows to tables
retrieve rows from table
modify the rows of tables
alter a table definition
Objective of an order by clause is to display or arrange output of a select statement in a particular order.
Select correct option:
True
False
Which of the following is not DML command?
Select correct option:
Select
Update
Delete
Truncate
Which of the following is incorrect about alter table statement?
Select correct option:
Cannot be used to modify type or size of an existing column
Can be used to delete a column
Can not be used to create a new table
Can be used to add column in the existing tablet.
In “One to Many” cardinality one instance of a
relation is mapped with
Select correct option:
many instances of second entity type
One instance of second entity type
Primary key of 2 relations
none of above
A second Normal Form (2 NF) relation should
Select correct option:
be in 1 NF
not have a composite key
not have attributes dependent on key attribute
not have attributes dependent on one another
Normalization of database is essential to
(i) avoid accidental deletion of required data when some data is deleted
(ii) eliminate inconsistencies when a data item is modified in the database
(iii) allows storage of data in a computer’s disk
(iv) use a database management system
Select correct option:
i and iii
i and ii
ii and iii
ii and iv
A relation which is in a higher normal form
Select correct option:
implies that it also qualifies to be in lower normal form
does not necessarily satisfy the conditions of lower normal form
is included in the lower normal form
is independent of lower normal forms
“Unary relationship” is one which involves
Select correct option:
Single entity
Two entities
Many entities
No entity
An attribute y may be functionally dependent on
(i) a composite attribute x,y
(ii) a single attribute x (iii) no attribute
Select correct option:
i and ii
i and iii
ii and iii
iii
in “One to One Relationship” One instance of first entity type is mapped with two instances of second entity type
Select correct option:
true
false
Select correct option:
many instances of second entity type
One instance of second entity type
Primary key of 2 relations
none of above
A second Normal Form (2 NF) relation should
Select correct option:
be in 1 NF
not have a composite key
not have attributes dependent on key attribute
not have attributes dependent on one another
Normalization of database is essential to
(i) avoid accidental deletion of required data when some data is deleted
(ii) eliminate inconsistencies when a data item is modified in the database
(iii) allows storage of data in a computer’s disk
(iv) use a database management system
Select correct option:
i and iii
i and ii
ii and iii
ii and iv
A relation which is in a higher normal form
Select correct option:
implies that it also qualifies to be in lower normal form
does not necessarily satisfy the conditions of lower normal form
is included in the lower normal form
is independent of lower normal forms
“Unary relationship” is one which involves
Select correct option:
Single entity
Two entities
Many entities
No entity
An attribute y may be functionally dependent on
(i) a composite attribute x,y
(ii) a single attribute x (iii) no attribute
Select correct option:
i and ii
i and iii
ii and iii
iii
in “One to One Relationship” One instance of first entity type is mapped with two instances of second entity type
Select correct option:
true
false
DML perform functions such as
Select correct option:
Insertion
Deletion
Creation of database
All of above
Select correct option:
Insertion
Deletion
Creation of database
All of above
“Select” and “project” are the examples of
Select correct option:
Unary operations
Binary operations
Ternary operations
All of above
Select correct option:
Unary operations
Binary operations
Ternary operations
All of above
UPDATE command belongs to which type of Classification
DML
DDL
DCL
DQL
The _________ function helps reduce the need to use multiple OR
conditions.
Like
IN
AND
Between
Like
IN
AND
Between
Which of the flowing
clauses allows to sort the records in result set?
Where
Order by
From
Having
Where
Order by
From
Having
In SQL queries, while creating tables or relations in database,
key columns may be specified by
Null
Not Null
Data Type
None of the above
Null
Not Null
Data Type
None of the above
Identify the language which is used to specify database schema.
DCL
DML
DDL
Non of the above
DCL
DML
DDL
Non of the above
Data Definition Language (DDL) statements are used to define the
database structure or schema. Some examples:
CREATE - to create objects in the database
ALTER - alters the structure of the database
DROP - delete objects from the database
TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed
COMMENT - add comments to the data dictionary
RENAME - rename an object
CREATE - to create objects in the database
ALTER - alters the structure of the database
DROP - delete objects from the database
TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed
COMMENT - add comments to the data dictionary
RENAME - rename an object
_______ Operators are the ones that require two operands on both
sides of the operator.
Double
Tow Sided
Binary
None of the given options
Double
Tow Sided
Binary
None of the given options
What happened if the Where clause is omitted from a Delete
Statement?
All record from the table are deleted
No record from the tables will be deleted
First record of the tables will be deleted
The statement will not be executed and will give a syntax error
All record from the table are deleted
No record from the tables will be deleted
First record of the tables will be deleted
The statement will not be executed and will give a syntax error
Which of the following is a String function in SQL
Count
LEN
SQRT
SIN
Count
LEN
SQRT
SIN
Revoke is a __________ Statement
Data Definition
Control Access
Data Manipulation
Data Description
Data Definition
Control Access
Data Manipulation
Data Description
Truncate command response time is ____ as compared to
Delete command.
Select correct option:
Poor
Same
Better
worst
Select correct option:
Poor
Same
Better
worst
Which of the following syntax of the functions in SQL is used to
add column values?
Select correct option:
COUNT(*)
COUNT(expression)
MAX(expression)
SUM(expression)
Select correct option:
COUNT(*)
COUNT(expression)
MAX(expression)
SUM(expression)
SQL is used for:
Select correct option:
Creating, managing and deleting tables and manage the relationships among the stored date.
Generating queries, organizing, managing and retrieving data stored in a database.
Maintaining data integrity and coordinate data sharing.
All of the above
Select correct option:
Creating, managing and deleting tables and manage the relationships among the stored date.
Generating queries, organizing, managing and retrieving data stored in a database.
Maintaining data integrity and coordinate data sharing.
All of the above
Which of the following is used to filter rows according to some
condition(s)?
Select correct option:
SELECT
FROM
WHERE
UPDATE
Select correct option:
SELECT
FROM
WHERE
UPDATE
Which language is used to permit or prohibit access to a
table?
Select correct option:
DCL
DDL
DML
All of the above.
Select correct option:
DCL
DDL
DML
All of the above.
Data Manipulation Language (DML) is the set of commands used to
maintain and query a database including updating, inserting, modifying and
retrieving data.
Select correct option:
True
FALSE
Select correct option:
True
FALSE
Which of the following is NOT a DDL command?
Select correct option:
Create DB
Create table
Delete
Drop
Select correct option:
Create DB
Create table
Delete
Drop
Which of the following function falls in the category of
Aggregate functions.
Select correct option:
SUM
MIN
MAX
All of the above
Select correct option:
SUM
MIN
MAX
All of the above
Value of a function in SQL is always determined by the input
parameters
TRUE
FALSE
TRUE
FALSE
Post a Comment
Don't Forget To Join My FB Group VU Vicky
THANK YOU :)