Quiz
DCL
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (20)
1Using SQL's ___________commands, you can restrict who has access to what data in a database.
- AA. Database
- BB. Data
- CC. Data control
- DD. All of the Mentioned
2When a transaction has completed, it is referred to as __________
- AA. Committed
- BB. Aborted
- CC. Rolled back
- DD. Failed
3What keyword pairs with Data Control Language (DCL) statements?
- AA. SELECT
- BB. INSERT
- CC. DELETE
- DD. GRANT
4DCL offers commands to complete tasks such as __________
- AA. change the structure of tables
- BB. Insert, Update Or Delete Records And Data Values
- CC. authorizing access and other control over database
- DD. None of the Mentioned
5The database language that enables access to or maintenance of database data
- AA. DCL
- BB. DML
- CC. DDL
- DD. All of the Mentioned
6What statement claims about DCL is TRUE?
- AA. The DCL commands in SQL allow us to control which users have access to the data stored in SQL tables.
- BB. There will be certain privileges that each user has; consequently, the data can be accessed by them.
- CC. The DCL commands in SQL allow us to grant privileges to a user on the SQL database and its table(s), or revoke privileges that have already been granted.
- DD. All of the above
7Commands that falls under DCL include:
- AA. GRANT
- BB. REVOKE
- CC. Both A and B
- DD. None of the above
8The distinction between the commands GRANT and REVOKE is _____________
- AA. The GRANT command can be used to grant a user access to databases and tables whereas The REVOKE command can be used to revoke all access privileges already assigned to the user.
- BB. The REVOKE command can be used to grant a user access to databases and tables whereas The GRANT command can be used to revoke all access privileges already assigned to the user.
- CC. A transaction can be rolled back to its last saved state.
- DD. None of the above
9Which of the following bottom-up strategies creates a high-level object by combining two or more low-level entities?
- AA. Generalization
- BB. Specialization
- CC. Aggregation
- DD. All of the above
10Which of the subsequent statements is used to call the SQL function?
- AA. Connection statement
- BB. Callable statements
- CC. Prepared Statements
- DD. All of the above
11Which of the following describes the process of removing redundancy and unwanted data?
- AA. Functional dependency
- BB. Database modeling
- CC. Normalization
- DD. Decomposition
12On which normal forms does the idea of functional dependency rest?
- AA. 1NF
- BB. 2NF
- CC. 3NF
- DD. 4NF
13Which of the following claims regarding the third normal form (3NF) is untrue?
- AA. It is used to remove data duplication.
- BB. It contains transitive partial dependency.
- CC. It is used to achieve data integrity.
- DD. All of the above
14A series of operations from one transaction to another transaction is known as a schedule, which is used to preserve the order of the operation in each of the individual transactions.
- ATrue
- BFalse
15The transaction becomes irreversible in the database if which of the following occurs.
- AA.Commit
- BB.Rollback
- CC.Flashback
- DD.View
16How many tables can be brought together using a join?
- AA. One
- BB. Two
- CC. Three
- DD. Many
17Pick the incorrect response to this question.
- AA.SELECT FROM table_name WHERE column_name;
- BB.SELECT column_name FROM table_name;
- CC.SELECT column_name FROM table_name WHERE condidtion;
- DD.SELECT column_name WHERE condition;
18Only separate values from the table are returned by the ___________ statement.
- AA.Different
- BB.Distinct
- CC.None
- DD.All
19The basic data type of SQL varchar(n) has ..... length Unicode characters, and char(n) has ...... length Unicode characters.
- AA.Fixed, Variable
- BB.Fixed, Fixed
- CC.Variable, Variable
- DD.Variable, Fixed
20Why the following statement is erroneous?
SELECT dept_name, dept_id, avg (salary)
FROM instructor
GROUP BY dept_name;- AA. Dept_name should not be used in group by clause
- BB. Group by clause is not valid in this query
- CC. Avg(salary) should not be selected
- DD. None
Information
- Description
- DCL Interview Questions
- Author
- Jerry Reeves Jr
- Language
- English
- Views
- 23
- Tags
- Rating
- No ratings yet Rate this quiz