Cs403 solved quiz online 13-1-2012View more random threads:
- MGT503 Principles of Management mid term paper 2011 solve...
- MTH302 Business Mathematics mid term paper 2011
- ENG101 Online Quiz#01 Fall November 2011
- cs301 solved quiz on 18th of november 2011
- cs507 Quiz no 3 fall December 2011-2012
- MKT501 Marketing Management Quiz # 01 2011
- it430 solve mid term paper april 2011
- MKT501 Marketing Management Quiz NO.1 Fall Semester 2012
- MGT602 MCQ Help fall 2010
- mgt211 first quiz solved 2011 by ch.haseeb Ullah
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)