18 : DBMS - Important Terms

Home >> Computer Awareness
1234567891011121314151617181920
1).
Structured Query Language (SQL) is used in the following? 
2).
What is the full form of BLOB?
3).
There is a situation in which resources are held by two or more connections that are each needed by the other connections. What is the name given to such a situation?
4).
What is the name given to the library of related functions that are not loaded into memory until they are called by the application program?
5).
Which of the following statements in SQL are considered as Data manipulation language?
6).
What is the name given to the computing infrastructure close to the sources of data?
7).
Who among the followings proposed the R-tree for the first time?
8).
What is the full form of IEC?
9).
Which of the following is the attribute which can be used to uniquely identify a row of data in a given table?
10).
The CAP Theorem concludes that it is not possible for a distributed computer system to provide three guarantees at the same time. Which of the following are among these three guarantees?
11).
Which of the followings is true regarding the process of Sharding?
12).
Which of the followings is the term used to describe the process of forecasting in data?
13).
Which among the followings is the term given to the three rules to find logically implied functional dependencies?
14).
Which of the followings are found in abundance in a relational database?
15).
What is the full form of RAID?
16).
Which of the followings is used to represent a Weak entity set?
17).
Which of the following form is based on the concept of functional dependency?
18).
Which of the following is the most commonly used operation in relational algebra for projecting a collection of records from a relation?
19).
What is the name given to the special type of stored procedure that automatically executes when an event occurs in the database server?
20).
What is the name given to the situation where the lock waits only for a specified amount of time for another lock to be released?
1. Structured Query Language (SQL) is used in the following?
[A] Create Databases
[B] Create & Modify Databases
[C] Create, Modify & Query Databases
[D] None of the above
2. What is the full form of BLOB?
[A] Binary Long Object
[B] Binary Large Object
[C] Basic Leverage Object
[D] None of the Above
3. There is a situation in which resources are held by two or more connections that are each needed by the other connections. What is the name given to such a situation?
[A] Deadlock
[B] Debugging
[C] Instance
[D] Remote Procedure Call
4. What is the name given to the library of related functions that are not loaded into memory until they are called by the application program?
[A] DML
[B] DLL
[C] DCL
[D] All of the Above
5. Which of the following statements in SQL are considered as Data manipulation language?
[A] Update
[B] Insert
[C] Delete
[D] All of the Above
6. What is the name given to the computing infrastructure close to the sources of data?
[A] Edge Computing
[B] Embedded Computing
[C] Encrypted Computing
[D] None of the Above
7. Who among the followings proposed the R-tree for the first time?
[A] Antonin Guttman
[B] Van Neumann
[C] Steve Jobs
[D] Michael Raschell
8. What is the full form of IEC?
[A] International Electrotechnical Commission
[B] International Electrical Council
[C] Internet Embedded Commission
[D] None of the Above
9. Which of the following is the attribute which can be used to uniquely identify a row of data in a given table?
[A] Secondary Key
[B] Personal Key
[C] Primary Key
[D] Foreign Key
10. The CAP Theorem concludes that it is not possible for a distributed computer system to provide three guarantees at the same time. Which of the following are among these three guarantees?
[A] Consistency
[B] Availability
[C] Partition Tolerance
[D] All of the Above
Advertisement

Kindly help us to keep GKToday updated and error free. Use this form to report error or outdated information in questions. We shall rectify asap...