_____is a full form of SQL.
Standard query language
Sequential query language
Structured query language
Server side query language
Correct Answer :
C. Structured query language
Related Questions
Precedence graphs help to find a
Serializable schedule.
Recoverable schedule.
Deadlock free schedule.
Cascadeless schedule.
The set of all values that can be taken by the attribute is called as _______ of the attribute.
Tuple
Cardinality
Degree
Domain
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 collection of information stored in a database at a particular moment is called as ......
schema
instance of the database
data domain
independence
The values of the attribute describes a particular
Entity set
File
Entity instance
Organization
DROP is a statement in SQL.
Query
Embedded SQL
DDL
DCL
The ______ indexes are forced to store only record IDs in the data structure and require at least one additional I/O Operation to retrieve the actual record.
Clustered
Hashed
Un-clustered
Collision
An outstanding functionality of SQL is its support for automatic_____ to the target data.
programming
navigation
functioning
notification
_____ First proposed the process of normalization.
Edgar. W
Edward Stephen
Edgar F. Codd
Edward Codd
E-R Modeling is achieved by using ____ diagrams
DFD
Flowcharts
Gantt Charts
E-R
The normalization was first proposed by .
Code
Codd
Boyce Codd
Boyce
The metadata is created by the
DML compiler
DML pre-processor
DDL interpreter
Query interpreter
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
Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
distinct values
cannot have NULL
both (A) & (B)
same as primary key
Which is the best file organization when data is frequently added or deleted from a file?
Sequential
Direct
Index sequential
None of the above
______is a preferred method for enforcing data integrity
Constraints
Triggers
Stored procedure
Cursors
Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
It will result in a deadlock situation.
It will immediately be rejected.
It will immediately be granted.
It will be granted as soon as it is released by A .
Which of the following is true for network structure?
It is a physical representation of the data.
It allows many to many relationship.
It is conceptually simple.
It will be the dominant database of the future.
Union operator is a :
Unary Operator
Ternary Operator
Binary Operator
Not an operator
In E-R Diagram total participation is represented by
Double lines
Single line
Dashed lines
Triangle
In SQL the word natural can be used with
inner join
full outer join
right outer join
all of the above
DBMS is a collection of _____ that enables user to create and maintain a database.
Keys
Program
Translators
Language Activity
Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common because it is non volatile.
RAM
Flash
Hard Disk
Secondary
Which of the following is not a characteristic of a relational database model?
Table
Tree like structure
Complex logical relationship
Records
Which one is correct statement?
Logical data independence provides following without changing application programs:
(i) Changes in access methods.
(ii) Adding new entities in database
(iii) Splitting an existing record into two or more records
(iv) C
(i) and (ii)
(iv) only
(i) and (iv)
(ii) and (iii)
What are the desirable properties of a decomposition
Partition constraint.
Dependency preservation.
Redundancy.
Security.
Data independence means
data is defined separately and not included in programs.
programs are not dependent on the physical attributes of data
programs are not dependent on the logical attributes of data
both B and C
The transactions like adding an employee, enrolling a student in a course are examples of _______
Logical
Physical
None
Theoretical
____specifies a search condition for a group or an aggregate.
GROUP BY Clause
HAVING Clause
FROM Clause
WHERE Clause
The rule that a value of a foreign key must appear as a value of some specific table is called a
Referential constraint.
Index.
Integrity constraint.
Functional dependency.