Related Questions
What is the correct answer?
4
Which two files are used during operation of the DBMS?
A. Query languages and utilities
B. DML and query language
C. Data dictionary and transaction log
D. Data dictionary and query language
What is the correct answer?
4
The _____ category includes storage media that can be operated on directly by the computers central processing unit.
What is the correct answer?
4
The values of the attribute describes a particular
What is the correct answer?
4
A transaction is in state after the final statement has been executed.
What is the correct answer?
4
In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
A. Oval; An oval with an underlined attribute
B. Circle; A circle with bolded attribute inside it
C. Diamond; A bolded attribute
D. Square; An attribute within the square
What is the correct answer?
4
Immediate database modification technique uses
D. Neither undo nor redo.
What is the correct answer?
4
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
What is the correct answer?
4
Union operator is a :
What is the correct answer?
4
In an E-R diagram double lines indicate
B. Multiple participation.
What is the correct answer?
4
An outstanding functionality of SQL is its support for automatic_____ to the target data.
What is the correct answer?
4
The middleware databases in which the business rules act are applicable to _______ tier architectures
What is the correct answer?
4
Tree structures are used to store data in
What is the correct answer?
4
The fact that information in the data warehouse changes far less often and may be regarded as non-real-time with periodic updating; This implies that data warehouses are _______
What is the correct answer?
4
A data type or format is specified for each _________
What is the correct answer?
4
The relational model is based on the concept that data is organized and stored in two-dimensional tables called ______
What is the correct answer?
4
SQL server stores index information in the _____system table
What is the correct answer?
4
In SQL the statement select * from R, S is equivalent to
A. Select * from R natural join S.
B. Select * from R cross join S.
C. Select * from R union join S.
D. Select * from R inner join S.
What is the correct answer?
4
In SQL, testing whether a subquery is empty is done using
What is the correct answer?
4
A logical schema
A. is the entire database
B. Describes how data is actually stored on disk.
C. is a standard way of organizing information into accessible parts.
What is the correct answer?
4
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.
What is the correct answer?
4
Which of the following concurrency control schemes is not based on the serializability property?
C. Time-stamp based locking
What is the correct answer?
4
The _______ is a set of programs to use and / or modify this data.
What is the correct answer?
4
The full form of GUI is _________
A. Government Union Internet
B. Graphical Unit Interface
C. Graphical User Interface
D. Graphical University Interface
What is the correct answer?
4
Which one is true statement :
A. With finer degree of granularity of locking a high degree of concurrency is possible.
B. Locking prevents non-serializable schedules.
C. Locking cannot take place at field level.
D. An exclusive lock on data item X is granted even if a shared lock is already held on X.
What is the correct answer?
4
The drawback of shadow paging technique are
What is the correct answer?
4
If both the functional dependencies : X�Y and Y�X hold for two attributes X and Y then the relationship between X and Y is
What is the correct answer?
4
____specifies a search condition for a group or an aggregate.
What is the correct answer?
4
………………… approach reduces time and effort required for design and lesser risk in database management.
A. Single global database
What is the correct answer?
4
Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common because it is non volatile.
What is the correct answer?
4
Which of the syntax is correct for insert statement?
i) insert into values
ii) insert into (column list) values