The clause in SQL that specifies that the query result should be sorted in ascending or descending order based on the values of one or more columns is
View
Order by
Group by
Having
Correct Answer :
B. Order by
The clause in SQL that specifies that the query result should be sorted in ascending or descending order based on the values of one or more columns is ORDER BY. (ORDER BY clause is used to arrange the result of the SELECT statement)
Related Questions
Which of the following constitutes a basic set of operations for manipulating relational data?
Predicate calculus
Relational calculus
Relational algebra
SQL
_____ command can be used to modify a column in a table
alter
update
set
create
The transactions like adding an employee, enrolling a student in a course are examples of _______
Logical
Physical
None
Theoretical
Which of the following is a reason to model data?
Understand each user's perspective of data
Understand the data itself irrespective of the physical representation
Understand the use of data across application areas
All of the above
Which of the following concurrency control schemes is not based on the serializability property?
Two - phase locking
Graph-based locking
Time-stamp based locking
None of these .
The default level of consistency in SQL is
repeatable read
read committed
read uncommitted
serializable
In 2NF
No functional dependencies (FDs) exist.
No multivalued dependencies (MVDs) exist.
No partial FDs exist.
No partial MVDs exist.
The drawback of shadow paging technique are
Commit overhead
Data fragmentation
Garbage collection
All of these
Which of the following is not a property of transactions?
Atomicity
Concurrency
Isolation
Durability
For correct behaviour during recovery, undo and redo operation must be
Commutative
Associative
idempotent
distributive
Checkpoints are a part of
Recovery measures.
Security measures.
Concurrency measures.
uthorization measures.
In SQL the statement select * from R, S is equivalent to
Select * from R natural join S.
Select * from R cross join S.
Select * from R union join S.
Select * from R inner join S.
The statement that is executed automatically by the system as a side effect of the modification of the database is
backup
assertion
recovery
trigger
____ table store information about database or about the system.
SQL
System
Nested
None of these
Which of the following addressing modes permits relocation without any change over in the code?
Indirect addressing
Indexed addressing
PC relative addressing
Base register addressing
The middleware databases in which the business rules act are applicable to _______ tier architectures
Single
Three
Two
None
DROP is a statement in SQL.
Query
Embedded SQL
DDL
DCL
The full form of GUI is _________
Government Union Internet
Graphical Unit Interface
Graphical User Interface
Graphical University Interface
In b-tree the number of keys in each node is than the number of its children.
one less
same
one more
half
Given the following relation S(SNO,SNAME,CITY) write a query to update the value of CITY to KANPUR for the supplier S1.
UPDATE S CITY = KANPUR WHERE SNO=S1
UPDATE S SET CITY = KANPUR FOR SNO=S1
UPDATE S SET CITY = KANPUR WHERE SNO=S1
UPDATE S RENAME CITY = KANPUR WHERE SNO=S1
The set of all values that can be taken by the attribute is called as _______ of the attribute.
Tuple
Cardinality
Degree
Domain
The data models defined by ANSI/SPARC architecture are
Conceptual, physical and internal
Conceptual, view and external
Logical, physical and internal
Logical, physical and view
Key to represent relationship between tables is called
primary key
secondary key
foreign key
none of the above
A ______ module is typically designed so that it will run on a user workstation or personal computer.
Software
Server
Program
Client
Which one is true statement :
With finer degree of granularity of locking a high degree of concurrency is possible.
Locking prevents non-serializable schedules.
Locking cannot take place at field level.
An exclusive lock on data item X is granted even if a shared lock is already held on X.
A list consists of last names, first names, addresses and pin codes. If all people in the list have the same last name and same pin code a useful key would be
the pin code
the last name
the compound key first name and last name
Tr from next page
In an E-R diagram double lines indicate
Total participation.
Multiple participation.
Cardinality N.
None of the above.
The metadata is created by the
DML compiler
DML pre-processor
DDL interpreter
Query interpreter
Which of the following is not a consequence of concurrent operations?
Lost update problem.
Update anomaly.
Unrepeatable read.
Dirty read.
The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify a given tuple.
Primary
Foreign
Candidate
Alternate