Cs403 solved quiz online 13-1-2012View more random threads:
- MGT402 (solved) mcq's for midterm fall 2010
- cs605 software engineering 2 online solved quiz spring 2012
- CS301 Data Structures Quiz No.1 Solved Fall Semester 2012
- MGT411 Financial Accounting II solved mcqs Fall 2010
- mcm311reportingandsubediting solved quiz fall 2010
- MGT402- Cost andManagement Accounting final mcq's
- mgt211 latest quiz solved by Shoaib Akhtar Jhelum express...
- cs614 dataware house solved quiz for 2012
- Solved quiz of mcm301 quiz held on 27/01/2011
- mcm301 latest quiz fall 2010 29/12/2010
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’ ORDERBY Age;
The statement has a syntax error
Which of the following function falls in the category of Aggregate functions.
SUM
MIN
MAX
All of the above
REVOKE is a ______________ statement.
Data Definition
Control Access
Data manipulation
Data description
Correct statement for creating table in Microsoft SQL server is.
Which of the following statements creates a database named IMDB.
CREATE DATABASE IMDB
In SQL, which command is used to delete rows from table.
DELETE
REMOVE
TRUNCATE
Both I and II
Truncate is an alternative of Delete command.
False
The ________ condition allows to retrieve values within a specific range.
from
Which of the following SQL statements used to control access to the data and to the database
GRANT
REVOKE
Both GRANT and REVOKE
SELECT
Which of the following is used to retrieve and insert information from database?
DML
DDL
DCL
Both DML and DDL
Value of a function in SQL is always determined by the input parameters
True
False
Which of the following is used with INSERT command to insert values in a DB table?
Onto
INTO
UPTO
WITH
Is the given SQL Statement prompt error? Select * from relation1;
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’ ORDERBY Age;
DCL
In SQL, which command is used to modify the rows of tables.
UPDATE
INSERT
BROWSE
APPEND
The ________ operator allows to use wild cards in the where clause of an SQL statement.
LIKE
Truncate command response time is ______ as compared to Delete command.
Worst
Which of the following is not DML command?
Select
Update
Identify the language which is used to specify database schema.
Non of the above
Which of the following prevents duplicate values to be displayed as a result of an SQL statement?
DISTINCT
DELETE
UPDATE
ALTER
SQL stands for ______________. I - Structured Query Language II – Standard Query Language lll- Status Query Language
ONLY I
ONLY II
BOTH I AND II
ONLY III
Which language is used to permit or prohibit access to a table?
DCL
SQL is used for:
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
Sponsored Links
03009520262
Rabeel Website
There are currently 1 users browsing this thread. (0 members and 1 guests)