For using a specific database …………… command is used.
use database
database name use
Both A & B
None of them
- _____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…