Online Test DDL, DML and DCL commands

Which describes the default behavior when you create a table?
The table is accessible to all users.
Tables are created in the public schema.
Tables are created in your schema.
Tables are created in the DBA schema.
The DBA issues this SQL command: CREATE USER Scott IDENTIFIED by tiger; what privileges do the user Scott has at this point?
no privileges
only the SELECT privilege
only the CONNECT privilege
all the privileges of a default user
Examine these statements: CREATE ROLE registrar; GRANT UPDATE ON student_grades TO registrar; GRANT registrar to user1, user2, user3; What does this set of SQL statements do?
The set of statements contains an error and does not work.
It creates a role called REGISTRAR, adds the MODIFY privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.
It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.
It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and creates three users with the role.
Examine the statement: Create synonym EMP for hr.employees; What happens when you issue the statement?
An error is generated.
You will have two identical tables in the HR schema with different names.
You create a table called employees in the HR schema based on your EMP table.
You create an alternative name for the employees table in the HR schema in your own schema
You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP_VU?
CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20);
CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;
CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;
CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20);]
Which is a valid CREATE TABLE statement?
CREATE TABLE EMP9$# AS (emp_id number(2));
CREATE TABLE EMP*123 AS (emp_id number(2));
CREATE TABLE PACKAGE AS (pack_id number(2));
CREATE TABLE 1EMP_TEST AS (emp_id number(2));
Evaluate the set of SQL statements: CREATE TABLE dept ( dept_id NUMBER (2), dname VARCHAR2 (14), Loc VARCHAR2 (13)); ROLLBACK; DESCRIBE DEPT; What is true about the set?
The DESCRIBE DEPT statement displays the structure of the DEPT table
The ROLLBACK statement frees the storage space occupied by the DEPT table.
The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist
The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.
When should you create a role?
to simplify the process of creating new users using the CREATE USER xxx IDENTIFIED by yyyy statement
To grant a group of related privileges to a user.
When the number of people using the database is very high
To simplify profile maintenance for a user who is constantly traveling.
You are granted the CREATE VIEW privilege. What does this allow you to do?
create a table view
create a view in any scheme
create a view in your schema
create a sequence view in any schema
Description:

Check your knowledge of SQL DDL,DML,DCL Commands
Disclaimer: Content, such as images used in the questions (if any), have been picked up from various places for the sole purpose of Instruction. Also check out these courses on WizIQ: Hadoop and Big Data Certified Online Training Course Comprehensive Introduction to SQL

Discussion

Bs Muthyalu

i want write a test on ddl dml dcl command

410 days 9 hours 59 minutes ago

Archana

this is my first online exm thx.....

2170 days 23 hours 50 minutes ago

Namrata

seriously this one is useful for the students who wants to become professional in this subject....i really appreciate the this test.......................
thanks !!!!!!!!!!

3053 days 3 hours 59 minutes ago

raja

beautiful qus - no one face it for the first time

3156 days 10 hours 14 minutes ago

kc lim

^^ thx a lot sharing this for practice!

3242 days 4 hours 12 minutes ago

amulu

good one

3387 days 17 hours 41 minutes ago

sanjay kumarjena

this is a good site for oracle professionals.

3412 days 18 hours 16 minutes ago

anju joshi

got to kno abou my subject knowledge......

3508 days 42 minutes ago

PcAlgDbt

This test has an error in results. In test review all the answers are correct but total score is 8/9.
At the same time at "My tests" page my score for this test is 4/9. :)

3589 days 16 hours 50 minutes ago

Your Facebook Friends on WizIQ

More Tests By Author

ASP Server Controls
10 Questions | 667 Attempts

ASP.NET, Namespaces ASP.NET
10 Questions | 2028 Attempts

An ASP.NET Application
10 Questions | 437 Attempts

Explore Similar Courses