DBMS Tutorial Point
In this article, you will get DBMS GATE Questions 2019 with answers. 1. Which one of the following statements is NOT correct about the B+ tree data structure used for creating an index of a relational database table? a. Each leaf node has a pointer to the next leaf nodeb. Non-leaf nodes have pointers to data recordsc. … Read more
It Includes the latest DBMS MCQ Questions and Answer.SQL Online test questions and answers. 1.Evaluate the SQL statement: SELECT ROUND (TRUNC (MOD (1600, 10),-1), 2) FROM dual; What will be displayed? a) 0 b) 1 c) C.0.00 d) D.an error statement Ans A 2.Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about … Read more
1. Aggregate functions are functions that take a ___________ as input and return a single value. a) Collection of values b) Single value c) Aggregate value d) Both Collection of values & Single value Answer: a 2. SELECT __________FROM instructor WHERE dept name= ’Comp. Sci.’; Which of the following should be used to find the … Read more
This article includes the latest and most important DBMS MCQ questions which are very important regarding interviews. 1. Consider a Payment table with attributes PAY_ID (Primary Key), PAY_DT, PAY_AMT, BANK_ACCT, INIT_NAME, and PAY_MODE. Except for PAY_ID, no columns are unique. The table has three indexes as follows: IDX1 – PAY_ID IDX2 – BANK_ACCT, PAY_AMT IDX3 … Read more
1. What operator tests the column for the absence of data? A. EXISTS operator B. NOT operator C. IS NULL operator D. None of these Answer: C 2. In SQL, which command(s) is (are) used to change a table’s storage characteristic? A. ALTER TABLE B. MODIFY TABLE C. CHANGE TABLE D. All of the above … Read more