Question

Question 32

1. Which view would you use to see only the tables you have created

   		ALL_TABLES
   		USER_TABLES
   		USER_TABS
   		ALL_OBJECTS

2 points

Question 33

1. Which script will you execute to create new user DAVE and give him the ability to connect to the database and the ability to create tables, sequences, and procedures?

   		CREATE USER dave IDENTIFIED BY dave18; GRANT create table, create sequence, create procedure TO dave;
   		CREATE USER dave IDENTIFIED BY dave18; GRANT create session, create table, create sequence, create procedure TO dave;
   		CREATE OR REPLACE USER dave IDENTIFIED BY dave18; GRANT create session, table, sequence, procedure;
   		CREATE dave IDENTIFIED BY dave18; GRANT create connect, table, sequence, procedure TO dave;

2 points

Question 34

1. To add a column to table INV use which command

   		MODIFY TABLE INV ADD column datatype
   		ALTER TABLE INV ADD column datatype
   		MODIFY TABLE INV INSERT column datatype
   		ALTER TABLE INV INSERT column datatype

2 points

Question 35

1. Any select statement can be stored in the database as a view.

   True

   False

2 points

Question 36

1. The following code creates a table named student_table with four columns: id, lname, fname, lunch_num

   CREATE TABLE student_table (

   id NUMBER(6),

   lname VARCHAR(20),

   fname VARCHAR(20),

   lunch_num NUMBER(4));

   The lunch_num column in the above table has been marked as UNUSED. Which of the following is the best statement you can use if you wish to

   remove the UNUSED column from the student_table?

   		DROP column
   		ALTER TABLE DELETE UNUSED COLUMNS
   		ALTER TABLE DROP UNUSED COLUMNS
   		ALTER TABLE DELETE ALL COLUMNS

2 points

Question 37

1. A Top-N Analysis is capable of ranking a top or bottom set of results.

   True

   False

Answer 1

Answer: Hey! kindly find your solution below. Let me know if any issue. Thanks.

32- To view the tables of current user we will use this- user_tables

33- CREATE USER dave IDENTIFIED BY dave18;
GRANT create session, create table, create sequence, create procedure TO dave;

34- ALTER TABLE INV ADD column datatype. To add a column in existing table we will use this statement.

35- True statement. We can store any select statement as a view.

36- ALTER TABLE DROP UNUSED COLUMNS. To drop an unused column from a table we will use this statement.

37. It's a true statement.