Which of the following is the full form of RDBMS?
What is an RDBMS?
Does RDBMS have ACID properties?
What is a relation in RDBMS?
Which of the following systems use RDMS?
Dynamic hashing allows us to?
Which of the following constraints RDBS doesn’t check before creating the tables?
Which of the following is the correct option for the given query? SELECT DISTINCT name FROM RDBMS WHERE ID IS NOT NULL;
Which of the following is the correct output for the given query? (SELECT databaseid FROM RDBMS WHERE SECTION = 'c') EXCEPT (SELECT databaseid FROM RDBMS WHERE id < 10);
Which of the following commands do we use to delete a relation (RDBMS) from a database?
If RDBMS1, RDBMS2, RDBMS3 are attributes in a relation and S is another relation, which of the following is an incorrect specification of an integrity constraint?
Which of the following is the time of temporal data that record when a fact was recorded in a database?
________ deletes a data item from a database.
What is the result of the following query? SELECT studentdatabasename FROM RDBMS WHERE marks > SOME (SELECT marks FROM student WHERE SECTION = 'c');
________ is a predicate that we expect the database to always satisfy
Which of the following is a good database management practice?
What is an Instance of a Database?
Which of the following information does the database system catalog store?
If the database modifications occur while the transaction is still active, the transaction is said to use the __________ modification technique
If a transaction does not modify the database until it has committed it is said to use a _______ modification technique
The dependency rules specified by the database designer are known as _______
During the _______ phase, the local variables that hold the write operations are copied to the database
What is the format of entering date into a database while inserting data into it?
What does the following query do? UPDATE student SET marks = marks*1.10;
Which of the following cannot be used to modify the data in a database?
Observe the given SQL query and choose the correct option. SELECT database_name, RDBMS (DISTINCT bankuser_name) FROM depositor, account WHERE depositor.account_number = account.account_number GROUP BY branch_id
for each tuple tr in r do begin FOR each tuple ts IN s do BEGIN test pair (tr , ts ) TO see IF they satisfy the JOIN condition _ IF they do, ADD tr • ts TO the RESULT; END END What type of join is this?
Choose the correct option regarding the query SELECT branch_name, COUNT (DISTINCT customer_name) FROM depositor, account WHERE depositor.account_number = account.account_number GROUP BY branch_id HAVING avg(balance) = 10000;