____ table store information about database or about the system.
SQL
System
Nested
None of these
Correct Answer :
B. System
Related Questions
Relations produced from an E-R model will always be
First normal form.
Second normal form.
Third normal form.
Fourth normal form.
In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
Oval; An oval with an underlined attribute
Circle; A circle with bolded attribute inside it
Diamond; A bolded attribute
Square; An attribute within the square
In E-R Diagram total participation is represented by
Double lines
Single line
Dashed lines
Triangle
Which two files are used during operation of the DBMS?
Query languages and utilities
DML and query language
Data dictionary and transaction log
Data dictionary and query language
_____is a full form of SQL.
Standard query language
Sequential query language
Structured query language
Server side query language
_____ database is used to provide statistical information or summaries of values based on various criteria.
Statistical
Mathematical
Normalized
Un normalized
Which of the syntax is correct for insert statement?
i) insert into values
ii) insert into (column list) values
ii) insert into
i-only
ii-only
Both of them
None of them
The transactions like adding an employee, enrolling a student in a course are examples of _______
Logical
Physical
None
Theoretical
An advantage of the database management approach is
data redundancy increases
data is dependent on programs
data is integrated and can be accessed by multiple programs
none of the above
What are the desirable properties of a decomposition
Partition constraint.
Dependency preservation.
Redundancy.
Security.
The collection of information stored in a database at a particular moment is called as ......
schema
instance of the database
data domain
independence
DBMS helps achieve
Centralized control of data
Data independence
Both A and B
Neither A nor B
The data in the database at a particular moment of time is called the _______
Snapshot
Dynaset
Stateless
Stateful
A relation is in attribute of other composite key. if an attribute of a composite key is dependent on an
2NF
3NF
BCNF
1NF
______contains information that defines valid values that are stored in a column or data type.
Default
Index
Rule
View
………………… approach reduces time and effort required for design and lesser risk in database management.
Single global database
Multiple databases
Top-down approach
None of the above
If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
left outer join
right outer join
full outer join
inner join
The keyword to eliminate duplicate rows from the query result in SQL is
DISTINCT
NO DUPLICATE
UNIQUE
None of the above
Relationships among relationships can be represented in an-E-R model using
Aggregation
Association
Weak entity sets
Weak relationship sets
A transaction is in state after the final statement has been executed.
partially committed
active
committed
none of the above
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 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.
The size of a data item is called its _______, which can be a field of some record or may be a larger unit such as a record.
Similarity
Granularity
Dimensionality
Arity
Which of the following is not comparison operator?
<>
<
=<
>=
The _______ is a set of programs to use and / or modify this data.
DBMS
System
Program
Software
operator is used to compare a value to a list of literals values that have been specified.
Like
COMPARE
BETWEEN
IN
Which is the best file organization when data is frequently added or deleted from a file?
Sequential
Direct
Index sequential
None of the above
A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer systems.
None
Multi
Single
Concurrent
In an ER model,_____ is described in the database by storing its data.
Entity
Attribute
Relationship
Notation
Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
Create table Employee(EMPNO int, EMPNAME char(10));
Create table Employee(EMPNO integer, EMPNAME String(10));
Create table Emplo(EMPNO number, EMPNAME string);
Create table Emp(EMPNO int, EMPNAME char(10));