The Following Section consists of Computer MCQ on Database Programming. Select the correct option to test your Computer skills on Database Programming.
Quiz-summary
0 of 20 questions completed
Questions:
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
Information
Computer Questions on Database Programming
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
Results
0 of 20 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
| Average score |
|
| Your score |
|
Categories
- Computer 0%
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- Answered
- Review
-
Question 1 of 20
1. Question
1 pointsYou can add a row using SQL in a database with which of the following?
Correct
Incorrect
-
Question 2 of 20
2. Question
1 pointsThe command to remove rows from a table ‘CUSTOMER’ is:
Correct
Incorrect
-
Question 3 of 20
3. Question
1 pointsThe SQL WHERE clause:
Correct
Incorrect
-
Question 4 of 20
4. Question
1 pointsWhich of the following is the original purpose of SQL?
Correct
Incorrect
-
Question 5 of 20
5. Question
1 pointsThe wildcard in a WHERE clause is useful when?
Correct
Incorrect
-
Question 6 of 20
6. Question
1 pointsA view is which of the following?
Correct
Incorrect
-
Question 7 of 20
7. Question
1 pointsThe command to eliminate a table from a database is:
Correct
Incorrect
-
Question 8 of 20
8. Question
1 pointsON UPDATE CASCADE ensures which of the following?
Correct
Incorrect
-
Question 9 of 20
9. Question
1 pointsSQL data definition commands make up a(n) ________ .
Correct
Incorrect
-
Question 10 of 20
10. Question
1 pointsWhich of the following is valid SQL for an Index?
Correct
Incorrect
-
Question 11 of 20
11. Question
1 pointsThe SQL command to create a table is:
Correct
Incorrect
-
Question 12 of 20
12. Question
1 pointsA ________ is a stored program that is attached to a table or a view.
Correct
Incorrect
-
Question 13 of 20
13. Question
1 pointsThe DROP TABLE statement:
Correct
Incorrect
-
Question 14 of 20
14. Question
1 pointsSQL views can be used to hide:
Correct
Incorrect
-
Question 15 of 20
15. Question
1 pointsThe SQL statement to create a view is:
Correct
Incorrect
-
Question 16 of 20
16. Question
1 pointsTo update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
Correct
Incorrect
-
Question 17 of 20
17. Question
1 pointsWhich of the following is NOT a type of SQL constraint?
Correct
Incorrect
-
Question 18 of 20
18. Question
1 pointsA ________ is a program that performs some common action on database data and that is stored in the database.
Correct
Incorrect
-
Question 19 of 20
19. Question
1 pointsFor what purposes are views used?
Correct
Incorrect
-
Question 20 of 20
20. Question
1 pointsWhat is an SQL virtual table that is constructed from other tables?
Correct
Incorrect
Quiz-summary
0 of 20 questions completed
Questions:
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
Information
Computer Questions on Database Programming 2
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
Results
0 of 20 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
| Average score |
|
| Your score |
|
Categories
- Computer 0%
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- Answered
- Review
-
Question 1 of 20
1. Question
1 pointsWith which type of SQL Server recovery model are all database changes logged except those that cause large log entries?
Correct
Incorrect
-
Question 2 of 20
2. Question
1 pointsUsing SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures?
Correct
Incorrect
-
Question 3 of 20
3. Question
1 pointsWhat mode of authentication does SQL Server NOT provide?
Correct
Incorrect
-
Question 4 of 20
4. Question
1 pointsThe strictest transaction isolation level provided by SQL Server is called:
Correct
Incorrect
-
Question 5 of 20
5. Question
1 pointsSQL Server program code that is executed instead of an SQL command that needs to be processed is called a(n):
Correct
Incorrect
-
Question 6 of 20
6. Question
1 pointsWhich type of SQL Server cursor concurrency places an update lock on a row when the row is read?
Correct
Incorrect
-
Question 7 of 20
7. Question
1 pointsWhich of the three possible types of triggers does SQL Server support?
Correct
Incorrect
-
Question 8 of 20
8. Question
1 pointsWhich of the following is a way to create and modify tables using SQL Server?
Correct
Incorrect
-
Question 9 of 20
9. Question
1 pointsWith which type of SQL Server recovery model, is no logging done?
Correct
Incorrect
-
Question 10 of 20
10. Question
1 pointsSQL Server 2000 stored procedures can:
Correct
Incorrect
-
Question 11 of 20
11. Question
1 pointsWith this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.
Correct
Incorrect
-
Question 12 of 20
12. Question
1 pointsAn SQL Server 2000 language that adds programming elements like parameters, variables, IF, WHILE loops, and so forth, to the basic capabilities of SQL is called:
Correct
Incorrect
-
Question 13 of 20
13. Question
1 pointsWith this type of index, the data are stored in the bottom level of the index and in the same order as that index.
Correct
Incorrect
-
Question 14 of 20
14. Question
1 pointsIn SQL Server 2000, which of the following makes a copy of the changes that have been made to the database since the last complete backup?
Correct
Incorrect
-
Question 15 of 20
15. Question
1 pointsWith this type of index, the bottom level of an index does not contain data, but rather it contains pointers to data.
Correct
Incorrect
-
Question 16 of 20
16. Question
1 pointsWith which type of SQL Server recovery model are all database changes logged?
Correct
Incorrect
-
Question 17 of 20
17. Question
1 pointsSQL Server automatically creates an index on:
Correct
Incorrect
-
Question 18 of 20
18. Question
1 pointsWhich of the following is not a factor in determining the concurrency control behavior of SQL Server?
Correct
Incorrect
-
Question 19 of 20
19. Question
1 pointsSQL Server program code that is executed after an SQL command has been processed is called a(n):
Correct
Incorrect
-
Question 20 of 20
20. Question
1 pointsWhich of the following refers to the SQL Server transaction isolation level which places and holds locks on all rows that are read?
Correct
Incorrect
Quiz-summary
0 of 20 questions completed
Questions:
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
Information
Computer Questions on Database Programming 3
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
Results
0 of 20 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
| Average score |
|
| Your score |
|
Categories
- Computer 0%
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- Answered
- Review
-
Question 1 of 20
1. Question
1 pointsWhat type of join is needed when you wish to include rows that do not have matching values?
Correct
Incorrect
-
Question 2 of 20
2. Question
1 pointsWhat type of join is needed when you wish to return rows that do have matching values?
Correct
Incorrect
-
Question 3 of 20
3. Question
1 pointsWhich of the following is true concerning a procedure?
Correct
Incorrect
-
Question 4 of 20
4. Question
1 pointsA CASE SQL statement is which of the following?
Correct
Incorrect
-
Question 5 of 20
5. Question
1 pointsWhich of the following statements is true concerning routines and triggers?
Correct
Incorrect
-
Question 6 of 20
6. Question
1 pointsWhich of the following is one of the basic approaches for joining tables?
Correct
Incorrect
-
Question 7 of 20
7. Question
1 pointsWhich of the following is true concerning systems information in an RDBMS?
Correct
Incorrect
-
Question 8 of 20
8. Question
1 pointsThe following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID
Correct
Incorrect
-
Question 9 of 20
9. Question
1 pointsEmbedded SQL is which of the following?
Correct
Incorrect
-
Question 10 of 20
10. Question
1 pointsA UNION query is which of the following?
Correct
Incorrect
-
Question 11 of 20
11. Question
1 pointsWhich of the following statements is true concerning subqueries?
Correct
Incorrect
-
Question 12 of 20
12. Question
1 pointsWhich of the following is a correlated subquery?
Correct
Incorrect
-
Question 13 of 20
13. Question
1 pointsHow many tables may be included with a join?
Correct
Incorrect
-
Question 14 of 20
14. Question
1 pointsThe following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ;
Correct
Incorrect
-
Question 15 of 20
15. Question
1 pointsWhich of the following is true concerning triggers?
Correct
Incorrect
-
Question 16 of 20
16. Question
1 pointsA BI reporting system does not ________ .
Correct
Incorrect
-
Question 17 of 20
17. Question
1 pointsWhich of the following are not done by Business Intelligence (BI) systems?
Correct
Incorrect
-
Question 18 of 20
18. Question
1 pointsBusiness Intelligence (BI) systems do not obtain their data by which of the following means?
Correct
Incorrect
-
Question 19 of 20
19. Question
1 pointsThe “curse of dimensionality” relates to which problem of using operational data for BI reporting?
Correct
Incorrect
-
Question 20 of 20
20. Question
1 pointsA report generated by a reporting system is delivered to the appropriate users via a user-accessed Web site. This system uses which of the following report modes?
Correct
Incorrect
Quiz-summary
0 of 20 questions completed
Questions:
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
Information
Computer Questions on Database Programming 4
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
Results
0 of 20 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
| Average score |
|
| Your score |
|
Categories
- Computer 0%
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- Answered
- Review
-
Question 1 of 20
1. Question
1 pointsRFM analysis uses customers’ purchasing patterns to ________ .
Correct
Incorrect
-
Question 2 of 20
2. Question
1 pointsThe “F” in RFM analysis stands for ________ .
Correct
Incorrect
-
Question 3 of 20
3. Question
1 pointsWe have Market Basket data for 1,000 rental transactions at a Video Store. There are for videos for rent — Video A, Video B, Video C and Video D. The probability that both Video C and Video D are rented at the same time is known as ________ .
Correct
Incorrect
-
Question 4 of 20
4. Question
1 pointsBusiness Intelligence (BI) reporting systems cannot do which of the following operations?
Correct
Incorrect
-
Question 5 of 20
5. Question
1 pointsWhich of the following is not a component of a data warehouse?
Correct
Incorrect
-
Question 6 of 20
6. Question
1 pointsBusiness Intelligence (BI) reporting analyses can be performed using ________ .
Correct
Incorrect
-
Question 7 of 20
7. Question
1 pointsWe have been given access to the company’s operational data, and have been asked to produce a report. We discover that some of the data we need are in an SQL server database while other needed data are in a separate Oracle database. This is an example of ________ .
Correct
Incorrect
-
Question 8 of 20
8. Question
1 pointsThe reports generated by a reporting system are usually not delivered in which of the following media?
Correct
Incorrect
-
Question 9 of 20
9. Question
1 pointsData mining applications are used accomplish which of the following tasks?
Correct
Incorrect
-
Question 10 of 20
10. Question
1 pointsWhich of the following is an unsupervised data mining technique?
Correct
Incorrect
-
Question 11 of 20
11. Question
1 pointsIn OLAP, we are interested in ________ .
Correct
Incorrect
-
Question 12 of 20
12. Question
1 pointsWhich of the following is not a reason that operational data are difficult to read?
Correct
Incorrect
-
Question 13 of 20
13. Question
1 pointsWe have Market Basket data for 1,000 rental transactions at a Video Store. There are four videos for rent — Video A, Video B, Video C and Video D. The probability that Video D will be rented given that Video C has been rented is known as ________ .
Correct
Incorrect
-
Question 14 of 20
14. Question
1 pointsOne popular classification technique in Business Intelligence (BI) reporting is ________ .
Correct
Incorrect
-
Question 15 of 20
15. Question
1 pointsWe have done an RFM analysis on our customer data. Mary Jones has a score of “1 1 5”. This series means that Mary ________ .
Correct
Incorrect
-
Question 16 of 20
16. Question
1 pointsWhich of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values?
Correct
Incorrect
-
Question 17 of 20
17. Question
1 pointsIn a 1:N relationship, the foreign key is placed in:
Correct
Incorrect
-
Question 18 of 20
18. Question
1 pointsWhich of the following column properties specifies whether or not cells in a column must contain a data value?
Correct
Incorrect
-
Question 19 of 20
19. Question
1 pointsA primary key should be defined as:
Correct
Incorrect
-
Question 20 of 20
20. Question
1 pointsWhich of the following column properties would be used to specify that cells in a column must contain a monetary value?
Correct
Incorrect