01-14-2012, 02:40 AM
Cs403 solved quiz online 13-1-2012
[FONT="]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;[/FONT]
The statement has a syntax error
[FONT="]Which of the following function falls in the category of Aggregate functions.[/FONT]
SUM
MIN
MAX
All of the above
[FONT="]REVOKE is a ______________ statement.[/FONT]
Data Definition
Control Access
Data manipulation
Data description
[FONT="]Correct statement for creating table in Microsoft SQL server is.[/FONT]
[FONT="]Which of the following statements creates a database named IMDB.[/FONT]
CREATE DATABASE IMDB
[FONT="]In SQL, which command is used to delete rows from table.[/FONT]
DELETE
REMOVE
TRUNCATE
Both I and II
[FONT="]Truncate is an alternative of Delete command.[/FONT]
[FONT="]False[/FONT]
[FONT="]The ________ condition allows to retrieve values within a specific range.[/FONT]
[FONT="]from[/FONT]
[FONT="]Which of the following SQL statements used to control access to the data and to the database[/FONT]
[FONT="]GRANT[/FONT]
[FONT="]REVOKE [/FONT]
[FONT="]Both GRANT and REVOKE[/FONT]
[FONT="]SELECT[/FONT]
[FONT="]Which of the following is used to retrieve and insert information from database?[/FONT]
[FONT="]DML[/FONT]
[FONT="]DDL[/FONT]
[FONT="]DCL[/FONT]
[FONT="]Both DML and DDL[/FONT]
[FONT="]Value of a function in SQL is always determined by the input parameters[/FONT]
[FONT="]True[/FONT]
[FONT="]False[/FONT]
[FONT="]Which of the following is used with INSERT command to insert values in a DB table?[/FONT]
[FONT="]Onto[/FONT]
[FONT="]INTO[/FONT]
[FONT="]UPTO[/FONT]
[FONT="]WITH[/FONT]
[FONT="]Is the given SQL Statement prompt error? Select * from relation1;[/FONT]
[FONT="] [/FONT]
[FONT="] [/FONT]
[FONT="]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;[/FONT]
[FONT="]DCL[/FONT]
[FONT="]In SQL, which command is used to modify the rows of tables.[/FONT]
[FONT="]UPDATE[/FONT]
[FONT="]INSERT[/FONT]
[FONT="]BROWSE[/FONT]
[FONT="]APPEND[/FONT]
[FONT="]The ________ operator allows to use wild cards in the where clause of an SQL statement.[/FONT]
LIKE
[FONT="]Truncate command response time is ______ as compared to Delete command.[/FONT]
Worst
[FONT="]Which of the following is not DML command?[/FONT]
Select
Update
[FONT="]Identify the language which is used to specify database schema.[/FONT]
Non of the above
[FONT="]Which of the following prevents duplicate values to be displayed as a result of an SQL statement?[/FONT]
[FONT="]DISTINCT[/FONT]
[FONT="]DELETE[/FONT]
[FONT="]UPDATE[/FONT]
[FONT="]ALTER[/FONT]
[FONT="]SQL stands for ______________. I - Structured Query Language II – Standard Query Language lll- Status Query Language[/FONT]
[FONT="]ONLY I[/FONT]
[FONT="]ONLY II[/FONT]
[FONT="]BOTH I AND II[/FONT]
[FONT="]ONLY III[/FONT]
[FONT="]Which language is used to permit or prohibit access to a table?[/FONT]
[FONT="]DCL[/FONT]
[FONT="]SQL is used for:[/FONT]
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
[FONT="]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;[/FONT]
The statement has a syntax error
[FONT="]Which of the following function falls in the category of Aggregate functions.[/FONT]
SUM
MIN
MAX
All of the above
[FONT="]REVOKE is a ______________ statement.[/FONT]
Data Definition
Control Access
Data manipulation
Data description
[FONT="]Correct statement for creating table in Microsoft SQL server is.[/FONT]
[FONT="]Which of the following statements creates a database named IMDB.[/FONT]
CREATE DATABASE IMDB
[FONT="]In SQL, which command is used to delete rows from table.[/FONT]
DELETE
REMOVE
TRUNCATE
Both I and II
[FONT="]Truncate is an alternative of Delete command.[/FONT]
[FONT="]False[/FONT]
[FONT="]The ________ condition allows to retrieve values within a specific range.[/FONT]
[FONT="]from[/FONT]
[FONT="]Which of the following SQL statements used to control access to the data and to the database[/FONT]
[FONT="]GRANT[/FONT]
[FONT="]REVOKE [/FONT]
[FONT="]Both GRANT and REVOKE[/FONT]
[FONT="]SELECT[/FONT]
[FONT="]Which of the following is used to retrieve and insert information from database?[/FONT]
[FONT="]DML[/FONT]
[FONT="]DDL[/FONT]
[FONT="]DCL[/FONT]
[FONT="]Both DML and DDL[/FONT]
[FONT="]Value of a function in SQL is always determined by the input parameters[/FONT]
[FONT="]True[/FONT]
[FONT="]False[/FONT]
[FONT="]Which of the following is used with INSERT command to insert values in a DB table?[/FONT]
[FONT="]Onto[/FONT]
[FONT="]INTO[/FONT]
[FONT="]UPTO[/FONT]
[FONT="]WITH[/FONT]
[FONT="]Is the given SQL Statement prompt error? Select * from relation1;[/FONT]
[FONT="] [/FONT]
[FONT="] [/FONT]
[FONT="]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;[/FONT]
[FONT="]DCL[/FONT]
[FONT="]In SQL, which command is used to modify the rows of tables.[/FONT]
[FONT="]UPDATE[/FONT]
[FONT="]INSERT[/FONT]
[FONT="]BROWSE[/FONT]
[FONT="]APPEND[/FONT]
[FONT="]The ________ operator allows to use wild cards in the where clause of an SQL statement.[/FONT]
LIKE
[FONT="]Truncate command response time is ______ as compared to Delete command.[/FONT]
Worst
[FONT="]Which of the following is not DML command?[/FONT]
Select
Update
[FONT="]Identify the language which is used to specify database schema.[/FONT]
Non of the above
[FONT="]Which of the following prevents duplicate values to be displayed as a result of an SQL statement?[/FONT]
[FONT="]DISTINCT[/FONT]
[FONT="]DELETE[/FONT]
[FONT="]UPDATE[/FONT]
[FONT="]ALTER[/FONT]
[FONT="]SQL stands for ______________. I - Structured Query Language II – Standard Query Language lll- Status Query Language[/FONT]
[FONT="]ONLY I[/FONT]
[FONT="]ONLY II[/FONT]
[FONT="]BOTH I AND II[/FONT]
[FONT="]ONLY III[/FONT]
[FONT="]Which language is used to permit or prohibit access to a table?[/FONT]
[FONT="]DCL[/FONT]
[FONT="]SQL is used for:[/FONT]
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
