An advantage of the database management approach is
(a) data is dependent on programs
(b) data redundancy increases
(c) data is integrated and can be accessed by multiple programs
(d) none of the above
1 Answers
Talk Doctor Online in Bissoy App
A result set is extracted from the database using the cursor object (that has been already created) by giving the following statement.
(a) One record (b) tuple
2 Answers 1 views
(i) Which command is used to view the list of tables in a database?
(i) SHOW TABLES: (ii) Equi- join: The join in which columns from two tables are compared for equality Duplicate columns are shown Natural Join The join in which only one of the identical columns...
2 Answers 1 views
(i) A table, ITEM has been created in a database with the following fields: ITEMCODE, ITEMNAME, QTY, PRICE
(i) ALTER TABLE Item ADD (Discount INT); (ii ) DDL: DROP TABLE, ALTER TABLE DML: INSERT INTO, UPDATE. ..SET
2 Answers 1 views
Aryan, a database administrator, has grouped records of a table with the help of group by clause.
Having clause is used to further filter those groups of records which will be generated through group by clause. For example: Select max(marks) from student group by classes having classes in (10,12); Above...
2 Answers 6 views
What do you understand by terms ‘primary key’ and ‘secondary key’ in a database?
A primary key is a field that identifies each record in a database table admitting that the primary key must contain its UNIQUE values. A secondary key shows the secondary value...
2 Answers 1 views
A _________ of the database is a group of fields (a) Table (b) Forms (c) Query
Correct answer is (a) Table
2 Answers 1 views
____ are the fundamental building blocks of the database. (a) Tables (b) Forms (c) Queries (d) Reports
Correct answer is (a) Tables
2 Answers 1 views
Choose the level of database abstraction that describes what data is stored in the database and what relationships exist among them,
Correct answer is (b) Logical
2 Answers 1 views
The most adopted and popular approach to write programs is .....
Structured programming
2 Answers 1 views
Statement 1 – Government of India adopted ‘Trickle Down Approach’ to alleviate poverty to
a) Both the statements are true
2 Answers 1 views