Database Test 6 Computer Subject
Database Test 6 Computer Subject
Question 31
Which is not true about modifying data?
Mass updates can lead to integrity problems and are not always fast or safe.
Not clear enough?
Question 32
Which of the following is not an SQL statement used on a single table?
SELECTION is a relational algebra operation, not a valid SQL statement.
Not clear enough?
Question 33
Which of the following is not an operation used on two or more tables?
SELECT with GROUP BY & HAVING is used on a single table, not necessarily multiple tables.
Not clear enough?
Question 34
SQL commands can be classified into three types. Which is NOT an SQL command type?
SQL has DDL (Data Definition), DML (Data Manipulation), and DCL (Data Control). DGL is not a valid category.
Not clear enough?
Question 35
In the given query which of the keyword has to be inserted?
INSERT INTO employee _____ (1501,Ahmad,21000);
The correct SQL syntax is INSERT INTO table_name VALUES (...).
Not clear enough?
Question 36
Three SQL DDL CREATE commands are _____?
CREATE is used for Schema, Table, and View definitions.
Not clear enough?
Question 37
Which keyword is NOT included in most data retrieval statements?
The keyword AS is optional and often omitted, while SELECT, FROM, and WHERE are core retrieval keywords.
Not clear enough?
Question 38
By default, the ORDER BY clause lists items in _____ order.
ORDER BY defaults to ascending order unless DESC is specified.
Not clear enough?
Question 39
Which is not an advantage of using a View?
Views can increase overhead rather than decrease it, since queries on views may require extra processing.
Not clear enough?
Question 40
The union operation automatically _____ unlike the SELECT clause.
UNION automatically removes duplicate rows, whereas SELECT does not unless DISTINCT is used.
Not clear enough?
You might like
The time required to deposit 4.5g of copper from CuSO4 solution by passing a current of 2.5 Amperes is (Cu = 64g; 1F = 96500C/mol)
Use the information below to answer question:
Trading account for the year ended 31st December 2009
| ₦        | ₦        | |||
|---|---|---|---|---|
| Opening Stock | 32,000 | Sales | 48,000 | |
| Purchases | 40,000 | Less Return | 2,000 | |
| Carriage inwards | 1,000 | |||
| 41,000 | ||||
| Less Return | 2,000 | 39,000 | ||
| Cost of goods available | ?? | |||
| Less closing stock | 9,000 | |||
| Cost of goods sold | ?? | |||
Calculate the Gross Profit / Loss.
A group of closely related organisms capable of interbreeding to produce fertile offspring are known as members of a