PrakashNotes

1 What does DBMS stand for?

Data Base Management System Data Bank Management System Data Buffer Management System Data Block Management System

2 Which of the following is NOT a type of database?

Hierarchical Network Distributed Connected

3 Which language is used to query databases?

HTML SQL CSS JavaScript

4 A primary key in a database is used to:

Delete data Access files Uniquely identify records Create indexes

5 The term 'CRUD' in DBMS refers to:

Create, Read, Update, Delete Copy, Replace, Undo, Delete Create, Replace, Update, Download Create, Read, Upgrade, Delete

6 In relational databases, tables are also known as:

Attributes Tuples Relations Records

7 What is a tuple in a relational database?

A column A row A table A query

8 Which of the following is an example of a DBMS software?

MS Word Excel Oracle PowerPoint

9 Which SQL statement is used to extract data from a database?

GET SELECT OPEN EXTRACT

10 In an ER diagram, what does a diamond shape represent?

Attribute Relationship Entity Primary Key

11 Normalization in DBMS is used to:

Remove redundancy Add redundancy Remove constraints Add tables

12 A foreign key is a key used to:

Uniquely identify records within a table Relate two tables Sort data Perform calculations

13 Which command is used to remove a table from a database?

DELETE REMOVE DROP CLEAR

14 What is the function of the ‘JOIN’ operation in SQL?

Connects rows in the same table Connects rows in different tables Connects databases Connects data types

15 In SQL, what does 'NULL' represent?

A zero value An empty string An unknown value A negative value

16 What is a view in SQL?

A table copy A stored procedure A virtual table A backup

17 Which type of database model uses parent-child relationships?

Hierarchical Network Relational Object-oriented

18 The command to add data into a database table is:

ADD INSERT PUT UPDATE

19 What does DML stand for?

Data Manipulation Language Database Manipulation Language Data Management Language Database Management Language

20 Which of the following statements is used to modify existing records in a database?

UPDATE MODIFY CHANGE ALTER

21 What does DBMS stand for?

Data Base Management System Data Bank Management System Data Buffer Management System Data Block Management System

22 Which of the following is NOT a type of database?

Hierarchical Network Distributed Connected

23 Which language is used to query databases?

HTML SQL CSS JavaScript

24 A primary key in a database is used to:

Delete data Access files Uniquely identify records Create indexes

25 The term 'CRUD' in DBMS refers to:

Create, Read, Update, Delete Copy, Replace, Undo, Delete Create, Replace, Update, Download Create, Read, Upgrade, Delete

26 In relational databases, tables are also known as:

Attributes Tuples Relations Records

27 What is a tuple in a relational database?

A column A row A table A query

28 Which of the following is an example of a DBMS software?

MS Word Excel Oracle PowerPoint

29 Which SQL statement is used to extract data from a database?

GET SELECT OPEN EXTRACT

30 In an ER diagram, what does a diamond shape represent?

Attribute Relationship Entity Primary Key

31 Normalization in DBMS is used to:

Remove redundancy Add redundancy Remove constraints Add tables

32 A foreign key is a key used to:

Uniquely identify records within a table Relate two tables Sort data Perform calculations

33 Which command is used to remove a table from a database?

DELETE REMOVE DROP CLEAR

34 What is the function of the ‘JOIN’ operation in SQL?

Connects rows in the same table Connects rows in different tables Connects databases Connects data types

35 In SQL, what does 'NULL' represent?

A zero value An empty string An unknown value A negative value

36 What is a view in SQL?

A table copy A stored procedure A virtual table A backup

37 Which type of database model uses parent-child relationships?

Hierarchical Network Relational Object-oriented

38 The command to add data into a database table is:

ADD INSERT PUT UPDATE

39 What does DML stand for?

Data Manipulation Language Database Manipulation Language Data Management Language Database Management Language

40 Which of the following statements is used to modify existing records in a database?

UPDATE MODIFY CHANGE ALTER

41 What does DBMS stand for?

Data Base Management System Data Bank Management System Data Buffer Management System Data Block Management System

42 Which of the following is NOT a type of database?

Hierarchical Network Distributed Connected

43 Which language is used to query databases?

HTML SQL CSS JavaScript

44 A primary key in a database is used to:

Delete data Access files Uniquely identify records Create indexes

45 The term 'CRUD' in DBMS refers to:

Create, Read, Update, Delete Copy, Replace, Undo, Delete Create, Replace, Update, Download Create, Read, Upgrade, Delete

46 In relational databases, tables are also known as:

Attributes Tuples Relations Records

47 What is a tuple in a relational database?

A column A row A table A query

48 Which of the following is an example of a DBMS software?

MS Word Excel Oracle PowerPoint

49 Which SQL statement is used to extract data from a database?

GET SELECT OPEN EXTRACT

50 In an ER diagram, what does a diamond shape represent?

Attribute Relationship Entity Primary Key

51 Normalization in DBMS is used to:

Remove redundancy Add redundancy Remove constraints Add tables

52 A foreign key is a key used to:

Uniquely identify records within a table Relate two tables Sort data Perform calculations

53 Which command is used to remove a table from a database?

DELETE REMOVE DROP CLEAR

54 What is the function of the ‘JOIN’ operation in SQL?

Connects rows in the same table Connects rows in different tables Connects databases Connects data types

55 In SQL, what does 'NULL' represent?

A zero value An empty string An unknown value A negative value

56 What is a view in SQL?

A table copy A stored procedure A virtual table A backup

57 Which type of database model uses parent-child relationships?

Hierarchical Network Relational Object-oriented

58 The command to add data into a database table is:

ADD INSERT PUT UPDATE

59 What does DML stand for?

Data Manipulation Language Database Manipulation Language Data Management Language Database Management Language

60 Which of the following statements is used to modify existing records in a database?

UPDATE MODIFY CHANGE ALTER

61 What does DBMS stand for?

Data Base Management System Data Bank Management System Data Buffer Management System Data Block Management System

62 Which of the following is NOT a type of database?

Hierarchical Network Distributed Connected

63 Which language is used to query databases?

HTML SQL CSS JavaScript

64 A primary key in a database is used to:

Delete data Access files Uniquely identify records Create indexes

65 The term 'CRUD' in DBMS refers to:

Create, Read, Update, Delete Copy, Replace, Undo, Delete Create, Replace, Update, Download Create, Read, Upgrade, Delete

66 In relational databases, tables are also known as:

Attributes Tuples Relations Records

67 What is a tuple in a relational database?

A column A row A table A query

68 Which of the following is an example of a DBMS software?

MS Word Excel Oracle PowerPoint

69 Which SQL statement is used to extract data from a database?

GET SELECT OPEN EXTRACT

70 In an ER diagram, what does a diamond shape represent?

Attribute Relationship Entity Primary Key

71 Normalization in DBMS is used to:

Remove redundancy Add redundancy Remove constraints Add tables

72 A foreign key is a key used to:

Uniquely identify records within a table Relate two tables Sort data Perform calculations

73 Which command is used to remove a table from a database?

DELETE REMOVE DROP CLEAR

74 What is the function of the ‘JOIN’ operation in SQL?

Connects rows in the same table Connects rows in different tables Connects databases Connects data types

75 In SQL, what does 'NULL' represent?

A zero value An empty string An unknown value A negative value

76 What is a view in SQL?

A table copy A stored procedure A virtual table A backup

77 Which type of database model uses parent-child relationships?

Hierarchical Network Relational Object-oriented

78 The command to add data into a database table is:

ADD INSERT PUT UPDATE

79 What does DML stand for?

Data Manipulation Language Database Manipulation Language Data Management Language Database Management Language

80 Which of the following statements is used to modify existing records in a database?

UPDATE MODIFY CHANGE ALTER

81 What does DBMS stand for?

Data Base Management System Data Bank Management System Data Buffer Management System Data Block Management System

82 Which of the following is NOT a type of database?

Hierarchical Network Distributed Connected

83 Which language is used to query databases?

HTML SQL CSS JavaScript

84 A primary key in a database is used to:

Delete data Access files Uniquely identify records Create indexes

85 The term 'CRUD' in DBMS refers to:

Create, Read, Update, Delete Copy, Replace, Undo, Delete Create, Replace, Update, Download Create, Read, Upgrade, Delete

86 In relational databases, tables are also known as:

Attributes Tuples Relations Records

87 What is a tuple in a relational database?

A column A row A table A query

88 Which of the following is an example of a DBMS software?

MS Word Excel Oracle PowerPoint

89 Which SQL statement is used to extract data from a database?

GET SELECT OPEN EXTRACT

90 In an ER diagram, what does a diamond shape represent?

Attribute Relationship Entity Primary Key

91 Normalization in DBMS is used to:

Remove redundancy Add redundancy Remove constraints Add tables

92 A foreign key is a key used to:

Uniquely identify records within a table Relate two tables Sort data Perform calculations

93 Which command is used to remove a table from a database?

DELETE REMOVE DROP CLEAR

94 What is the function of the ‘JOIN’ operation in SQL?

Connects rows in the same table Connects rows in different tables Connects databases Connects data types

95 In SQL, what does 'NULL' represent?

A zero value An empty string An unknown value A negative value

96 What is a view in SQL?

A table copy A stored procedure A virtual table A backup

97 Which type of database model uses parent-child relationships?

Hierarchical Network Relational Object-oriented

98 The command to add data into a database table is:

ADD INSERT PUT UPDATE

99 What does DML stand for?

Data Manipulation Language Database Manipulation Language Data Management Language Database Management Language

100 Which of the following statements is used to modify existing records in a database?

UPDATE MODIFY CHANGE ALTER

Menu

Unit 1: Database Management System (DBMS) (12 Hours)

Quiz Complete!