php hit counter

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Online Virtual university Cs403 solved quiz online 13-1-2012
VU Help • House Banner VU Help Virtual University Students - Assignments, Solved Papers, GDB & Exam Help Student Help Forum • Collaborative • Free Support
#1
Cs403 solved quiz online 13-1-2012
[FONT=&quot]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=&quot]Which of the following function falls in the category of Aggregate functions.[/FONT]
SUM
MIN
MAX
All of the above
[FONT=&quot]REVOKE is a ______________ statement.[/FONT]
Data Definition
Control Access
Data manipulation
Data description
[FONT=&quot]Correct statement for creating table in Microsoft SQL server is.[/FONT]
[FONT=&quot]Which of the following statements creates a database named IMDB.[/FONT]
CREATE DATABASE IMDB
[FONT=&quot]In SQL, which command is used to delete rows from table.[/FONT]
DELETE
REMOVE
TRUNCATE
Both I and II
[FONT=&quot]Truncate is an alternative of Delete command.[/FONT]
[FONT=&quot]False[/FONT]
[FONT=&quot]The ________ condition allows to retrieve values within a specific range.[/FONT]
[FONT=&quot]from[/FONT]
[FONT=&quot]Which of the following SQL statements used to control access to the data and to the database[/FONT]
[FONT=&quot]GRANT[/FONT]
[FONT=&quot]REVOKE [/FONT]
[FONT=&quot]Both GRANT and REVOKE[/FONT]
[FONT=&quot]SELECT[/FONT]
[FONT=&quot]Which of the following is used to retrieve and insert information from database?[/FONT]
[FONT=&quot]DML[/FONT]
[FONT=&quot]DDL[/FONT]
[FONT=&quot]DCL[/FONT]
[FONT=&quot]Both DML and DDL[/FONT]
[FONT=&quot]Value of a function in SQL is always determined by the input parameters[/FONT]
[FONT=&quot]True[/FONT]
[FONT=&quot]False[/FONT]
[FONT=&quot]Which of the following is used with INSERT command to insert values in a DB table?[/FONT]
[FONT=&quot]Onto[/FONT]
[FONT=&quot]INTO[/FONT]
[FONT=&quot]UPTO[/FONT]
[FONT=&quot]WITH[/FONT]
[FONT=&quot]Is the given SQL Statement prompt error? Select * from relation1;[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]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=&quot]DCL[/FONT]
[FONT=&quot]In SQL, which command is used to modify the rows of tables.[/FONT]
[FONT=&quot]UPDATE[/FONT]
[FONT=&quot]INSERT[/FONT]
[FONT=&quot]BROWSE[/FONT]
[FONT=&quot]APPEND[/FONT]
[FONT=&quot]The ________ operator allows to use wild cards in the where clause of an SQL statement.[/FONT]
LIKE

[FONT=&quot]Truncate command response time is ______ as compared to Delete command.[/FONT]
Worst
[FONT=&quot]Which of the following is not DML command?[/FONT]
Select
Update

[FONT=&quot]Identify the language which is used to specify database schema.[/FONT]
Non of the above
[FONT=&quot]Which of the following prevents duplicate values to be displayed as a result of an SQL statement?[/FONT]
[FONT=&quot]DISTINCT[/FONT]
[FONT=&quot]DELETE[/FONT]
[FONT=&quot]UPDATE[/FONT]
[FONT=&quot]ALTER[/FONT]
[FONT=&quot]SQL stands for ______________. I - Structured Query Language II – Standard Query Language lll- Status Query Language[/FONT]
[FONT=&quot]ONLY I[/FONT]
[FONT=&quot]ONLY II[/FONT]
[FONT=&quot]BOTH I AND II[/FONT]
[FONT=&quot]ONLY III[/FONT]
[FONT=&quot]Which language is used to permit or prohibit access to a table?[/FONT]
[FONT=&quot]DCL[/FONT]
[FONT=&quot]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


Attached Files
.docx   Cs403 solved quiz online 13.docx (Size: 12.9 KB / Downloads: 550)
[SIZE="3"]03009520262[/SIZE]
Rabeel Website
Reply


Messages In This Thread
Online Virtual university Cs403 solved quiz online 13-1-2012 - by rabeel - 01-14-2012, 02:40 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  cs201 quiz no 1 on 14 november 2011 Xpert 4 2,365 02-11-2020, 07:15 PM
Last Post: CatherineKelsche
  CS506 Web Design and Development Online Quiz No. 04 Solution Spring 2014 education-2014 0 3,417 08-05-2014, 03:15 PM
Last Post: education-2014
  CS402 Theory of Automata Quiz No.3 Discussions and Solutions Spring 2014 vuassignments 1 6,533 07-23-2014, 01:34 PM
Last Post: vuassignments
  CS504 Software Engineering -I Quiz No. 04 Solution 2014 Due Date 25th July 2014 Entboy 0 2,868 07-22-2014, 03:11 PM
Last Post: Entboy
  CS601 Data Communication Solved Quiz No. 3 Solutions Spring Fall 2014 vuassignments 0 3,505 07-21-2014, 01:41 PM
Last Post: vuassignments
  MGT501 -Human Resource Management Online Solved MCQS Quiz No.3 Spring 2014 vuassignments 0 3,631 07-18-2014, 03:26 PM
Last Post: vuassignments
  CS101 Introduction to Computing Quiz No 3 Solution Spring Fall July 2014 education-2014 0 2,807 07-18-2014, 02:40 PM
Last Post: education-2014
  CS301 Data Structures Quiz No.1 Solved Fall Semester 2012 Vuhelper 2 5,892 05-20-2013, 11:23 PM
Last Post: Vuhelper
  CS402 Theory of Automata Solve Quiz Final Term Paper February 2013 Vuhelper 0 4,068 02-02-2013, 04:34 PM
Last Post: Vuhelper
  CS401 Computer Architecture and Assembly Language Solve Quiz No.3 Fall 2013 Vuhelper 0 4,339 01-11-2013, 04:05 PM
Last Post: Vuhelper

Forum Jump:


Users browsing this thread: 4 Guest(s)
VU Help • House Banner VU Help Virtual University Students - Assignments, Solved Papers, GDB & Exam Help Student Help Forum • Collaborative • Free Support