COMPUTER AWARENESS - DATE BASE MCQS SET 75
1. Which of the following products implemented the CODASYL DBTG model?
A.IDMS B.DB2 C.dBase-II D.R:base
2.An Enterprise Resource Planning application is an example of a(n) ________ .
A. single-user database application B. multiuser database application
C .e-commerce database application D. data mining database application
3. A DBMS that combines a DBMS and an application generator is ________ .
A. Microsoft's SQL Server B. Microsoft's Access C.IBM's DB2
D.Oracle Corporation's Oracle
4. You have run an SQL statement that asked the DBMS to display data in a table named USER_TABLES. The results include columns of data labeled "TableName," "NumberOfColumns" and "PrimaryKey." You are looking at ________ .
A.user data. B.metadata C.A report D.indexes
5. Which of the following is not considered to be a basic element of an enterprise-class database system?
A.Users B.Database applications C.DBMS D.COBOL programs
6. The DBMS that is most difficult to use is ________ .
A.Microsoft's SQL Server B.Microsoft's Access C.IBM's DB2 D.Oracle Corporation's Oracle
7. The SQL command to create a table is:
A.MAKE TABLE. B.ALTER TABLE. C.DEFINE TABLE. D.CREATE TABLE.
8. A ________ is a stored program that is attached to a table or a view.
A.pseudofile B.embedded SELECT statement C.trigger
D.None of the above is correct.
9. The DROP TABLE statement:
A.deletes the table structure only.
B.deletes the table structure along with the table data.
C.works whether or not referential integrity constraints would be violated.
D.is not an SQL statement.
10. SQL views can be used to hide:
A.columns and rows only. B.complicated SQL syntax only.
C.both of the above can be hidden by an SQL view. D.None of the above is correct.
A.IDMS B.DB2 C.dBase-II D.R:base
2.An Enterprise Resource Planning application is an example of a(n) ________ .
A. single-user database application B. multiuser database application
C .e-commerce database application D. data mining database application
3. A DBMS that combines a DBMS and an application generator is ________ .
A. Microsoft's SQL Server B. Microsoft's Access C.IBM's DB2
D.Oracle Corporation's Oracle
4. You have run an SQL statement that asked the DBMS to display data in a table named USER_TABLES. The results include columns of data labeled "TableName," "NumberOfColumns" and "PrimaryKey." You are looking at ________ .
A.user data. B.metadata C.A report D.indexes
5. Which of the following is not considered to be a basic element of an enterprise-class database system?
A.Users B.Database applications C.DBMS D.COBOL programs
6. The DBMS that is most difficult to use is ________ .
A.Microsoft's SQL Server B.Microsoft's Access C.IBM's DB2 D.Oracle Corporation's Oracle
7. The SQL command to create a table is:
A.MAKE TABLE. B.ALTER TABLE. C.DEFINE TABLE. D.CREATE TABLE.
8. A ________ is a stored program that is attached to a table or a view.
A.pseudofile B.embedded SELECT statement C.trigger
D.None of the above is correct.
9. The DROP TABLE statement:
A.deletes the table structure only.
B.deletes the table structure along with the table data.
C.works whether or not referential integrity constraints would be violated.
D.is not an SQL statement.
10. SQL views can be used to hide:
A.columns and rows only. B.complicated SQL syntax only.
C.both of the above can be hidden by an SQL view. D.None of the above is correct.
ANSWER:
1.A2.B
3.B
4.B
5.D
6.D
7.D
8.C
9.B
10.C
Magme Guru is India's Biggest learning free App for Aspirants who are competing for all government exams with more than 2350+ Subjects and 523+ Exams.
No comments:
Post a Comment