For using a specific database …………… command is used.
database name use
Both A & B
None of them
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of DBMS MCQ
comments powered by Disqus.
_____clause is an additional filter that is applied to the result.
A top-to-bottom relationship among the items in a database is established by a
____specifies a search condition for a group or an aggregate.
Cascading rollback is avoided in all protocol except
The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in…
Which is the best file organization when data is frequently added or deleted from a file?
Shadow paging has
The data in the database at a particular moment of time is called the _______
Relational Algebra does not have
_____is a full form of SQL.
A ______ module is typically designed so that it will run on a user workstation or personal computer.
If an entity can belong to only one lower level entity then the constraint is
A relation is in attribute of other composite key. if an attribute of a composite key is dependent on…
SQL server stores index information in the _____system table
It is an abstraction through which relationships are treated as higher level entities
Data independence means
The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
The normal form that is not necessarily dependency preserving is
The fact that all employees of a particular organization should not have salaries more than $10000 is…
Change Staff table by removing default of Assistant for position column
What is data integrity?
HSAM stands for ……….
Union operator is a :
Which of the following aggregate functions does not ignore nulls in its results?.
According to the levels of abstraction, the schema at the intermediate level is called
The data models defined by ANSI/SPARC architecture are
The default level of consistency in SQL is
Which of the following ensures the atomicity of the transaction?
What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are…
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter