Write SQL*Plus commands to do the following:

a) Connect to the database ‘OracleDB’ with the user name ‘SalesTracking’ and password ‘sales’;
b) Make sure that the Autocommit is off;
c) Display the name of the current user;
d) List the names of all tables in this schema;
e) Display the structure of the table Branch;
f) List the names of all sequences in this schema.

a) CONNECT SalesTracking/sales@OracleDB
b) SET Autocommit OFF;
c) SHOW user;
d) SELECT * FROM USER_TABLES (or just TAB);
e) DESC Branch;
f) SELECT sequence_name FROM user_sequences;

Computer Science & Information Technology

You might also like to view...

Analyze the following code.

``` #include using namespace std; class B { public: B() { }; int k; }; int main() { B b; cout << b.k << endl; return 0; } ``` A. The program displays 1. B. The program displays unpredictable number. C. The program has a compile error because b.k cannot be accessed. D. The program displays 0. E. The program has a runtime error because b.k does not have a value.

View
Computer Science & Information Technology

When using the Find Duplicates Query Wizard, you select the fields that you think may include duplicate information, and the wizard creates the query to find records matching your criteria

Indicate whether the statement is true or false

View
Computer Science & Information Technology

To add a new guide to the slide, press ____________________, and then drag an existing guide.

Fill in the blank(s) with the appropriate word(s).

View
Computer Science & Information Technology

The ‘Create new' option in the Insert Object dialog box allows you to ____.

A. open an application and develop an original object in the destination file B. open an application and existing file to be inserted in the destination file C. switch between open applications to create and modify a new object D. none of the above

View
Computer Science & Information Technology