DATABASE DEVELOPMENT AND IMPLEMENTATION FOR BSC. INFORMATION TECHNOLOGY STUDENTS
BROUGHT TO YOU BY; Obibinii Ba Media
SPONSORED BY; Let Us Build Africa Now-LUBAN
You can start the quiz by clicking on the quiz icon below after going through these questions.
1. Which of the following is NOT a type of SQL constraint?
A. PRIMARY
B. FOREIGN KEY
C. ALTERNATE KEY
D. UNIQUE
2. A _______ is a program that performs some common action on database data and that is stored in the database.
A. trigger
B. stored procedure
C. pseudofile
D. None of the above is correct
3. For what purposes are views used?
A. To hide columns only
B. To hide rows only
C. To hide complicated SQL statements only
D. All of the above are uses for SQL views
4. What is an SQL virtual table that is constructed from other tables?
A. Just another table
B. A view
C. A relation
D. Query results
5. When using the SQL INSERT statement:
A. rows can be modified according to criteria only.
B. rows cannot be copied in mass from one table to another only.
C. rows can be inserted into a table only one at a time only.
D. rows can either be inserted into a table one at at a time or in groups.
7. What is not an advantage of stored procedures?
A. Greater security
B. SQL can be optimized
C. Code sharing
D. Increased network traffic
8. A reason for using an SQL view to hide columns is:
A. to simplify a result only.
B. to prevent the display of sensitive data only.
C. to accomplish both of the above.
D. None of the above are reasons for using an SQL view.
9. Which of the following is an SQL trigger supported by Oracle?
A. BEFORE
B. INSTEAD OF
C. AFTER
D. All of the above
10. The SQL ALTER statement can be used to:
A. change the table structure.
B. change the table data.
C. add rows to the table.
D. delete rows from the table
11. The default extension for an Oracle SQL*Plus file is:
A. txt.
B. pls.
C. ora.
D. sql.
12. To obtain the structure of an Oracle table, the command to use is:
A. STRUCTURE [TableName].
B. DESCRIBE [TableName].
C. DESCRIBE STRUCTURE [TableName].
D. DESC TABLE [TableName].
13. ODBC minimum SQL grammar contains which of the following?
A. INSERT, UPDATE, DELETE only
B. Stored Procedures only
C. Literals for date, time and timestamp only
D. CREATE VIEW, DROP VIEW only
14. When using ODBC, which of the
following processes ODBC requests
and submits specific SQL statements
to a given type of data source?
A. Data source
B. Driver
C. Driver manager
D. DBMS
15. The DBMS acts as an interface between what two components of an enterprise-class database system?
A. Database application and the database
B. Data and the database
C. The user and the database application
D. Database application and SQL
16. 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
17. 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
18. The following are components of a database except.
A. user data
B. metadata
C. reports
D. indexes
19. The following are functions of a DBMS except
A. creating and processing forms
B. creating databases
C. processing data
D. administrating databases
20. Which of the following is not a restriction for a table to be a relation?
A. The cells of the table must contain a single value.
B. All of the entries in any column must be of the same kind.
C. The columns must be ordered.
D. No two rows in a table may be identical.
21. A CASE SQL statement is which of the following?
A. A way to establish a data definition in SQL.
B. A way to establish an IF-THEN-ELSE in SQL.
C. A way to establish a loop in SQL.
D. All of the above.
22. Which of the following is valid SQL for an Index?
A. ADD INDEX ID;
B. CREATE INDEX ID;
C. CHANGE INDEX ID;
D. REMOVE INDEX ID;
23. Embedded SQL is which of the following?
A. Hard-coded SQL statements in a procedure.
B. Hard-coded SQL statements in a program language such as Java.
C. The process of making an application capable of generating specific SQL code on the fly.
D. Hard-coded SQL statements in a trigger.
24. Records retrieved from the database are often referred to as what?
A. The result set
B. sql_user_e
C. TableCreator
D. Beta-Role
25. Is “GROUP BY” clause is similar to “ORDER BY” clause?
a) Yes
b) No
c) Depends
d) None of the mentioned
26. What is the meaning of “ORDER BY” clause in Mysql?
a) Sorting your result set using column data
b) Aggregation of fields
c) Sorting your result set using row data
d) None of the mentioned
27. What is the meaning of the “WHERE” clause in Mysql?
a) Filtering out unwanted rows from result set
b) Filtering out unwanted columns from result set
c) Filtering out unwanted rows and columns from result set
d) None of the mentioned
28. What will be the output of the following MySQL command?
SELECT *
FROM employee
WHERE title=’HEAD TELLER’;
a) All columns and rows belong to table employee
b) All columns but only those rows which contain ‘HEAD TELLER’ as a “title”
c) All columns don’t belong to table employee
d) None of the mentioned
29. Is there any error in the following MySQL statement?
SELECT e.emp_id, e.fname,e.lname,d.name
FROM employee e INNER JOIN department d
ON e.dept_id=e.dept_id;
a) NO
b) YES
c) DEPEND
d) None of the mentioned
30. What will be the output of the following MySQL statement “false AND Null”?
a) Falseb) Null
c) Depend
d) None of the mentioned
31. What will be the output of the following MySQL statement “true AND Null”?
a) True
b) Null
c) Depend
d) None of the mentioned
32. What will be the output of the following MySQL statement “Null AND Null”?
a) True
b) Null
c) False
d) None of the mentioned
33. What will be the output of the following MySQL statement “true OR Null”?
a) Trueb) Null
c) False
d) None of the mentioned
35. What will be the output of the following MySQL statement “Null OR Null”?
a) True
b) Null
c) False
d) None of the mentioned
36. What will be the output of the following MySQL statement “NOT (Null)”?
a) True
b) Null
c) False
d) None of the mentioned
37. The datatype for single precision floating point number is ____________
a) FLOAT
b) DOUBLE
c) INT
d) BIGINT
38. Which datatype means a variable length non binary string?
a) VARCHARb) BINARY
c) VARBINARY
d) BLOB
39. Which statement is used to access an existing Database?
a) Use
b) use database.name
c) USE databasename;
d) None of the mentioned
40. The “Mysql command line tool” formats are bounded by ______________
a) +-|
b) +-*
c) +-/
d) +-}
Please try this
Answer
CREATE DATABASE Team;
USE Team;
CREATE TABLE Player (
Ply_id INT (10) PRIMARY KEY,
Ply_FName VARCHAR (40) NOT NULL,
Ply_LName VARCHAR (40) NOT NULL,
Ply_pos CHAR (10));
ALTER TABLE Player
DROP COLUMN Ply_pos;
ALTER TABLE Player
ADD COLUMN Ply_hobby VARCHAR (10);
ALTER TABLE Player
DROP PRIMARY KEY;
ALTER TABLE Player
ADD PRIMARY KEY (Ply_FName);
ALTER TABLE Player
MODIFY COLUMN Ply_hobby VARCHAR (25) NOT NULL;
Please kindly scroll down and click on the follow button below to follow Obibinii Ba Media for more updates