23-02-2015, 04:57 AM
The automatic control system of anti drunk-driving
|
jntu comprehensive viva questions for dbms with answers
|
The automatic control system of anti drunk-driving
10-04-2017, 04:05 PM
1) Define database.
A previously arranged collection of figures known as the database is called a database.
2) What is DBMS?
Database management systems (DBMS) are applications specially designed to allow user interaction with other applications.
3) What are the different types of interactions served by DBMS?
The various types of interactions served by DBMS are:
• Definition of data
• Upgrade
• Recovery
• Administration
4) Segregate the development of database technology.
The development of the database technology is divided into:
• Data structure or model
• Navigational model
• SQL / Relational model
5) Who proposed the relational model?
Edgar F. Codd proposed the relational model in 1970.
6) What are the characteristics of the database language?
The database language can also incorporate features such as:
DBMS-specific configuration and storage engine management
Restriction of constraints Application Programming Interface (IEEE 802.11)
7) What of the languages of the database?
Special languages, they have:
• Data definition language
• Data manipulation language
• Query language
8) Define database model.
The data model that fundamentally is how the data can be stored, manipulated and organized and the database structure is logically called the database model.
9) What is SQL?
The Structured Query Language (SQL), which is the standard ANSI language, updates the database and commands to access.
10) Collect the various database relationships.
The various database relationships are:
• One-to-one: A table that has relation drawn with another table that has the same type of columns.
• One-to-many: two tables that have a primary and foreign key relationship.
• Many-to-many: crossover table that has many tables related to many tables.
11) Define standardization.
Data organized without inconsistent dependency and redundancy within a database are called normalization.
12) Get the benefits of normalizing the database.
The advantages of normalizing the database are:
• No duplicate entries
• Saves storage space
• Offers the interpretations of the query.
13) Defines denormalization.
Increasing the performance of the database, adding redundant data which in turn helps to get rid of complex data is called denormalization.
14) Define DDL and DML.
The management of properties and attributes of the database is called DDL (Data Definition Language).
Data manipulation in a database such as insertion, update, and deletion is defined as Data Manipulation Language. (DML)
15) Retrieve some DDL commands.
They are:
CREATE:
Create is used in the CREATE TABLE statement. The syntax is:
CREATE TABLE [column name] ([column definitions]) [table parameters]
ALTER:
It helps in modifying an existing object in the database. Its syntax is:
ALTER objecttype name of the parameters object.
RELEASE:
Destroys an existing database, index, table, or view. Its syntax is:
DROP object_name object_name.
16) Defines the Union Union and Union operator.
The complete recordings of two tables are Union All operator.
A record other than two tables is Union.
17) Set the cursor.
A database object that helps in manipulating data row by row representing a result set is called a cursor.
18) Retrieve cursor types.
They are:
• Dynamic: reflects changes while you are moving.
• Static: does not reflect changes while scrolling and works on snapshot recording.
• Set of keys: you see the modification of the data without reflecting new date.
19) Collect cursor types.
They are cursor types:
• Implicit Cursor: It is automatically declared as soon as the SQL execution is performed without the user's awareness.
• Explicit Cursor: Defined by PL / SQL that handles the query in more than one row.
20) Define sub-query.
A query contained in a query is called the Subquery.
21) Why is the group used?
Group clause uses aggregate values that are obtained when collecting similar data.
22) Compare non-clustered and grouped index
Both have a tree structure B, the nonclustered index has data indicators that allow a table of many nonclustered indexes while the grouped index is different for each table.
23) Definition of aggregate functions.
Functions that act against a collection of values and return to single value are called aggregate functions
A previously arranged collection of figures known as the database is called a database.
2) What is DBMS?
Database management systems (DBMS) are applications specially designed to allow user interaction with other applications.
3) What are the different types of interactions served by DBMS?
The various types of interactions served by DBMS are:
• Definition of data
• Upgrade
• Recovery
• Administration
4) Segregate the development of database technology.
The development of the database technology is divided into:
• Data structure or model
• Navigational model
• SQL / Relational model
5) Who proposed the relational model?
Edgar F. Codd proposed the relational model in 1970.
6) What are the characteristics of the database language?
The database language can also incorporate features such as:
DBMS-specific configuration and storage engine management
Restriction of constraints Application Programming Interface (IEEE 802.11)
7) What of the languages of the database?
Special languages, they have:
• Data definition language
• Data manipulation language
• Query language
8) Define database model.
The data model that fundamentally is how the data can be stored, manipulated and organized and the database structure is logically called the database model.
9) What is SQL?
The Structured Query Language (SQL), which is the standard ANSI language, updates the database and commands to access.
10) Collect the various database relationships.
The various database relationships are:
• One-to-one: A table that has relation drawn with another table that has the same type of columns.
• One-to-many: two tables that have a primary and foreign key relationship.
• Many-to-many: crossover table that has many tables related to many tables.
11) Define standardization.
Data organized without inconsistent dependency and redundancy within a database are called normalization.
12) Get the benefits of normalizing the database.
The advantages of normalizing the database are:
• No duplicate entries
• Saves storage space
• Offers the interpretations of the query.
13) Defines denormalization.
Increasing the performance of the database, adding redundant data which in turn helps to get rid of complex data is called denormalization.
14) Define DDL and DML.
The management of properties and attributes of the database is called DDL (Data Definition Language).
Data manipulation in a database such as insertion, update, and deletion is defined as Data Manipulation Language. (DML)
15) Retrieve some DDL commands.
They are:
CREATE:
Create is used in the CREATE TABLE statement. The syntax is:
CREATE TABLE [column name] ([column definitions]) [table parameters]
ALTER:
It helps in modifying an existing object in the database. Its syntax is:
ALTER objecttype name of the parameters object.
RELEASE:
Destroys an existing database, index, table, or view. Its syntax is:
DROP object_name object_name.
16) Defines the Union Union and Union operator.
The complete recordings of two tables are Union All operator.
A record other than two tables is Union.
17) Set the cursor.
A database object that helps in manipulating data row by row representing a result set is called a cursor.
18) Retrieve cursor types.
They are:
• Dynamic: reflects changes while you are moving.
• Static: does not reflect changes while scrolling and works on snapshot recording.
• Set of keys: you see the modification of the data without reflecting new date.
19) Collect cursor types.
They are cursor types:
• Implicit Cursor: It is automatically declared as soon as the SQL execution is performed without the user's awareness.
• Explicit Cursor: Defined by PL / SQL that handles the query in more than one row.
20) Define sub-query.
A query contained in a query is called the Subquery.
21) Why is the group used?
Group clause uses aggregate values that are obtained when collecting similar data.
22) Compare non-clustered and grouped index
Both have a tree structure B, the nonclustered index has data indicators that allow a table of many nonclustered indexes while the grouped index is different for each table.
23) Definition of aggregate functions.
Functions that act against a collection of values and return to single value are called aggregate functions
10-04-2017, 04:07 PM
1) Define database.
A previously arranged collection of figures known as the database is called a database.
2) What is DBMS?
Database management systems (DBMS) are applications specially designed to allow user interaction with other applications.
3) What are the different types of interactions served by DBMS?
The various types of interactions served by DBMS are:
• Definition of data
• Upgrade
• Recovery
• Administration
4) Segregate the development of database technology.
The development of the database technology is divided into:
• Data structure or model
• Navigational model
• SQL / Relational model
5) Who proposed the relational model?
Edgar F. Codd proposed the relational model in 1970.
6) What are the characteristics of the database language?
The database language can also incorporate features such as:
DBMS-specific configuration and storage engine management
Restriction of constraints Application Programming Interface (IEEE 802.11)
7) What of the languages of the database?
Special languages, they have:
• Data definition language
• Data manipulation language
• Query language
8) Define database model.
The data model that fundamentally is how the data can be stored, manipulated and organized and the database structure is logically called the database model.
9) What is SQL?
The Structured Query Language (SQL), which is the standard ANSI language, updates the database and commands to access.
10) Collect the various database relationships.
The various database relationships are:
• One-to-one: A table that has relation drawn with another table that has the same type of columns.
• One-to-many: two tables that have a primary and foreign key relationship.
• Many-to-many: crossover table that has many tables related to many tables.
11) Define standardization.
Data organized without inconsistent dependency and redundancy within a database are called normalization.
12) Get the benefits of normalizing the database.
The advantages of normalizing the database are:
• No duplicate entries
• Saves storage space
• Offers the interpretations of the query.
13) Defines denormalization.
Increasing the performance of the database, adding redundant data which in turn helps to get rid of complex data is called denormalization.
14) Define DDL and DML.
The management of properties and attributes of the database is called DDL (Data Definition Language).
Data manipulation in a database such as insertion, update, and deletion is defined as Data Manipulation Language. (DML)
15) Retrieve some DDL commands.
They are:
CREATE:
Create is used in the CREATE TABLE statement. The syntax is:
CREATE TABLE [column name] ([column definitions]) [table parameters]
ALTER:
It helps in modifying an existing object in the database. Its syntax is:
ALTER objecttype name of the parameters object.
RELEASE:
Destroys an existing database, index, table, or view. Its syntax is:
DROP object_name object_name.
16) Defines the Union Union and Union operator.
The complete recordings of two tables are Union All operator.
A record other than two tables is Union.
17) Set the cursor.
A database object that helps in manipulating data row by row representing a result set is called a cursor.
18) Retrieve cursor types.
They are:
• Dynamic: reflects changes while you are moving.
• Static: does not reflect changes while scrolling and works on snapshot recording.
• Set of keys: you see the modification of the data without reflecting new date.
19) Collect cursor types.
They are cursor types:
• Implicit Cursor: It is automatically declared as soon as the SQL execution is performed without the user's awareness.
• Explicit Cursor: Defined by PL / SQL that handles the query in more than one row.
20) Define sub-query.
A query contained in a query is called the Subquery.
21) Why is the group used?
Group clause uses aggregate values that are obtained when collecting similar data.
22) Compare non-clustered and grouped index
Both have a tree structure B, the nonclustered index has data indicators that allow a table of many nonclustered indexes while the grouped index is different for each table.
23) Definition of aggregate functions.
Functions that act against a collection of values and return to single value are called aggregate functions
A previously arranged collection of figures known as the database is called a database.
2) What is DBMS?
Database management systems (DBMS) are applications specially designed to allow user interaction with other applications.
3) What are the different types of interactions served by DBMS?
The various types of interactions served by DBMS are:
• Definition of data
• Upgrade
• Recovery
• Administration
4) Segregate the development of database technology.
The development of the database technology is divided into:
• Data structure or model
• Navigational model
• SQL / Relational model
5) Who proposed the relational model?
Edgar F. Codd proposed the relational model in 1970.
6) What are the characteristics of the database language?
The database language can also incorporate features such as:
DBMS-specific configuration and storage engine management
Restriction of constraints Application Programming Interface (IEEE 802.11)
7) What of the languages of the database?
Special languages, they have:
• Data definition language
• Data manipulation language
• Query language
8) Define database model.
The data model that fundamentally is how the data can be stored, manipulated and organized and the database structure is logically called the database model.
9) What is SQL?
The Structured Query Language (SQL), which is the standard ANSI language, updates the database and commands to access.
10) Collect the various database relationships.
The various database relationships are:
• One-to-one: A table that has relation drawn with another table that has the same type of columns.
• One-to-many: two tables that have a primary and foreign key relationship.
• Many-to-many: crossover table that has many tables related to many tables.
11) Define standardization.
Data organized without inconsistent dependency and redundancy within a database are called normalization.
12) Get the benefits of normalizing the database.
The advantages of normalizing the database are:
• No duplicate entries
• Saves storage space
• Offers the interpretations of the query.
13) Defines denormalization.
Increasing the performance of the database, adding redundant data which in turn helps to get rid of complex data is called denormalization.
14) Define DDL and DML.
The management of properties and attributes of the database is called DDL (Data Definition Language).
Data manipulation in a database such as insertion, update, and deletion is defined as Data Manipulation Language. (DML)
15) Retrieve some DDL commands.
They are:
CREATE:
Create is used in the CREATE TABLE statement. The syntax is:
CREATE TABLE [column name] ([column definitions]) [table parameters]
ALTER:
It helps in modifying an existing object in the database. Its syntax is:
ALTER objecttype name of the parameters object.
RELEASE:
Destroys an existing database, index, table, or view. Its syntax is:
DROP object_name object_name.
16) Defines the Union Union and Union operator.
The complete recordings of two tables are Union All operator.
A record other than two tables is Union.
17) Set the cursor.
A database object that helps in manipulating data row by row representing a result set is called a cursor.
18) Retrieve cursor types.
They are:
• Dynamic: reflects changes while you are moving.
• Static: does not reflect changes while scrolling and works on snapshot recording.
• Set of keys: you see the modification of the data without reflecting new date.
19) Collect cursor types.
They are cursor types:
• Implicit Cursor: It is automatically declared as soon as the SQL execution is performed without the user's awareness.
• Explicit Cursor: Defined by PL / SQL that handles the query in more than one row.
20) Define sub-query.
A query contained in a query is called the Subquery.
21) Why is the group used?
Group clause uses aggregate values that are obtained when collecting similar data.
22) Compare non-clustered and grouped index
Both have a tree structure B, the nonclustered index has data indicators that allow a table of many nonclustered indexes while the grouped index is different for each table.
23) Definition of aggregate functions.
Functions that act against a collection of values and return to single value are called aggregate functions
10-04-2017, 04:08 PM
1) Define database.
A previously arranged collection of figures known as the database is called a database.
2) What is DBMS?
Database management systems (DBMS) are applications specially designed to allow user interaction with other applications.
3) What are the different types of interactions served by DBMS?
The various types of interactions served by DBMS are:
• Definition of data
• Upgrade
• Recovery
• Administration
4) Segregate the development of database technology.
The development of the database technology is divided into:
• Data structure or model
• Navigational model
• SQL / Relational model
5) Who proposed the relational model?
Edgar F. Codd proposed the relational model in 1970.
6) What are the characteristics of the database language?
The database language can also incorporate features such as:
DBMS-specific configuration and storage engine management
Restriction of constraints Application Programming Interface (IEEE 802.11)
7) What of the languages of the database?
Special languages, they have:
• Data definition language
• Data manipulation language
• Query language
8) Define database model.
The data model that fundamentally is how the data can be stored, manipulated and organized and the database structure is logically called the database model.
9) What is SQL?
The Structured Query Language (SQL), which is the standard ANSI language, updates the database and commands to access.
10) Collect the various database relationships.
The various database relationships are:
• One-to-one: A table that has relation drawn with another table that has the same type of columns.
• One-to-many: two tables that have a primary and foreign key relationship.
• Many-to-many: crossover table that has many tables related to many tables.
11) Define standardization.
Data organized without inconsistent dependency and redundancy within a database are called normalization.
12) Get the benefits of normalizing the database.
The advantages of normalizing the database are:
• No duplicate entries
• Saves storage space
• Offers the interpretations of the query.
13) Defines denormalization.
Increasing the performance of the database, adding redundant data which in turn helps to get rid of complex data is called denormalization.
14) Define DDL and DML.
The management of properties and attributes of the database is called DDL (Data Definition Language).
Data manipulation in a database such as insertion, update, and deletion is defined as Data Manipulation Language. (DML)
15) Retrieve some DDL commands.
They are:
CREATE:
Create is used in the CREATE TABLE statement. The syntax is:
CREATE TABLE [column name] ([column definitions]) [table parameters]
ALTER:
It helps in modifying an existing object in the database. Its syntax is:
ALTER objecttype name of the parameters object.
RELEASE:
Destroys an existing database, index, table, or view. Its syntax is:
DROP object_name object_name.
16) Defines the Union Union and Union operator.
The complete recordings of two tables are Union All operator.
A record other than two tables is Union.
17) Set the cursor.
A database object that helps in manipulating data row by row representing a result set is called a cursor.
18) Retrieve cursor types.
They are:
• Dynamic: reflects changes while you are moving.
• Static: does not reflect changes while scrolling and works on snapshot recording.
• Set of keys: you see the modification of the data without reflecting new date.
19) Collect cursor types.
They are cursor types:
• Implicit Cursor: It is automatically declared as soon as the SQL execution is performed without the user's awareness.
• Explicit Cursor: Defined by PL / SQL that handles the query in more than one row.
20) Define sub-query.
A query contained in a query is called the Subquery.
21) Why is the group used?
Group clause uses aggregate values that are obtained when collecting similar data.
22) Compare non-clustered and grouped index
Both have a tree structure B, the nonclustered index has data indicators that allow a table of many nonclustered indexes while the grouped index is different for each table.
23) Definition of aggregate functions.
Functions that act against a collection of values and return to single value are called aggregate functions
A previously arranged collection of figures known as the database is called a database.
2) What is DBMS?
Database management systems (DBMS) are applications specially designed to allow user interaction with other applications.
3) What are the different types of interactions served by DBMS?
The various types of interactions served by DBMS are:
• Definition of data
• Upgrade
• Recovery
• Administration
4) Segregate the development of database technology.
The development of the database technology is divided into:
• Data structure or model
• Navigational model
• SQL / Relational model
5) Who proposed the relational model?
Edgar F. Codd proposed the relational model in 1970.
6) What are the characteristics of the database language?
The database language can also incorporate features such as:
DBMS-specific configuration and storage engine management
Restriction of constraints Application Programming Interface (IEEE 802.11)
7) What of the languages of the database?
Special languages, they have:
• Data definition language
• Data manipulation language
• Query language
8) Define database model.
The data model that fundamentally is how the data can be stored, manipulated and organized and the database structure is logically called the database model.
9) What is SQL?
The Structured Query Language (SQL), which is the standard ANSI language, updates the database and commands to access.
10) Collect the various database relationships.
The various database relationships are:
• One-to-one: A table that has relation drawn with another table that has the same type of columns.
• One-to-many: two tables that have a primary and foreign key relationship.
• Many-to-many: crossover table that has many tables related to many tables.
11) Define standardization.
Data organized without inconsistent dependency and redundancy within a database are called normalization.
12) Get the benefits of normalizing the database.
The advantages of normalizing the database are:
• No duplicate entries
• Saves storage space
• Offers the interpretations of the query.
13) Defines denormalization.
Increasing the performance of the database, adding redundant data which in turn helps to get rid of complex data is called denormalization.
14) Define DDL and DML.
The management of properties and attributes of the database is called DDL (Data Definition Language).
Data manipulation in a database such as insertion, update, and deletion is defined as Data Manipulation Language. (DML)
15) Retrieve some DDL commands.
They are:
CREATE:
Create is used in the CREATE TABLE statement. The syntax is:
CREATE TABLE [column name] ([column definitions]) [table parameters]
ALTER:
It helps in modifying an existing object in the database. Its syntax is:
ALTER objecttype name of the parameters object.
RELEASE:
Destroys an existing database, index, table, or view. Its syntax is:
DROP object_name object_name.
16) Defines the Union Union and Union operator.
The complete recordings of two tables are Union All operator.
A record other than two tables is Union.
17) Set the cursor.
A database object that helps in manipulating data row by row representing a result set is called a cursor.
18) Retrieve cursor types.
They are:
• Dynamic: reflects changes while you are moving.
• Static: does not reflect changes while scrolling and works on snapshot recording.
• Set of keys: you see the modification of the data without reflecting new date.
19) Collect cursor types.
They are cursor types:
• Implicit Cursor: It is automatically declared as soon as the SQL execution is performed without the user's awareness.
• Explicit Cursor: Defined by PL / SQL that handles the query in more than one row.
20) Define sub-query.
A query contained in a query is called the Subquery.
21) Why is the group used?
Group clause uses aggregate values that are obtained when collecting similar data.
22) Compare non-clustered and grouped index
Both have a tree structure B, the nonclustered index has data indicators that allow a table of many nonclustered indexes while the grouped index is different for each table.
23) Definition of aggregate functions.
Functions that act against a collection of values and return to single value are called aggregate functions
|
« Next Oldest | Next Newest »
|
Important Note..!
If you are not satisfied with above reply ,..PleaseASK HERE
So that we will collect data for you and will made reply to the request....OR try below "QUICK REPLY" box to add a reply to this page| Tagged Pages: dbms comprehesivve viva questions, dbms comprehesive viva questions, |
