Cs403 solved quiz online 13-1-2012View more random threads:
- cs507 information system solved quiz and mcq's
- fin623 mcq's and quiz solved 4/1/2011 download
- mgt613 Quiz May spring 2011
- HRM627 Human Resource Development solved quiz fall 2010
- CS301 Data Structures Quiz No.1 Solved Fall Semester 2012
- mth603 solved mcq's for midterm fall 2010 december 1
- cs507 quiz #2 16 November 2011
- MGT602 MCQ Help fall 2010
- MTH302 Business Mathematics mid term paper 2011
- CS506 WEB DESIGN AND DEVELOPMENT all solved quiz fall 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)