English
Hindi
Bengali

Question

Download Solution PDF

The names of the tables that an user can have access to or that he or she has created, can be displayed with the following SQL query:

This question was previously asked in
HTET PGT Official Computer Science Paper - 2017
Download PDF Attempt in App
View all HTET Papers >

  1. SELECT table_name

    FROM User_tables;

  2. SELECT Data_dictionary

    SHOW my_tables;

  3. SELECT my+tables

    FROM Data_dictionary;

  4. SELECT User_tables

    FROM this_login;

Answer (Detailed Solution Below)

Option 1 :

SELECT table_name

FROM User_tables;
Free Tests
View all Free tests >
Free
HTET PGT Official Computer Science Paper - 2019
60 Qs. 60 Marks 60 Mins
Start Now

Detailed Solution

Download Solution PDF

Query Syntax for listing the tables in SQL

  • Show all tables owned by the current user

SELECT  table_name FROM  user_tables;

  • Show all tables in the current database

SELECT  table_name FROM  dba_tables;

  • Show all tables that are accessible by the current user

SELECT  table_name FROM  all_tables;

Therefore, Correct answer is Option 1

Download Solution PDF
Latest HTET Updates

Last updated on Jun 6, 2025

-> The HTET TGT Applciation Portal will reopen on 1st June 2025 and close on 5th June 2025.

-> HTET Exam Date is out. HTET TGT Exam will be conducted on 26th and 27th July 2025

-> Candidates with a bachelor's degree and B.Ed. or equivalent qualification can apply for this recruitment.

-> The validity duration of certificates pertaining to passing Haryana TET has been extended for a lifetime.

-> Enhance your exam preparation with the HTET Previous Year Papers.

Exams Tests Super Practice

More SQL Questions

Q1.Which of the following command can be used to modify data in an SQL Table? A. INSERT B. DELETE C. UPDATE D. SELECT Choose the correct answer from the options given below:
Q2.Which of the following syntax is correct for CREATE DATABASE statement?
Q3.What is the correct syntax to drop a table?
Q4. The statement in SQL that deletes the table structure and the relationship is ______ .
Q5.In SQL, grant is a __________ command
Q6.“CREATE TABLE T” in SQL is an example of : 
Q7.Choose the correct meaning of SQL statement: Select * from r4r_emp; 
Q8.Which of the following statement contains an error?
Q9.If SQL command DELETE FROM EMPLOYEE; is executed on relation EMPLOYEE having 'n' tuple in it, ______ will be deleted from relation EMPLOYEE.
Q10.In SQL ______ is an aggregate function.

More Query Language Questions

Q1.An instance of relational schema R (A, B, C) has distinct values of A including NULL values. Which one of the following is true ?
Q2.Consider the following statements : I - The primary key of a relation cannot contain null values. II - Unique Key can have null values. Which among the following is true ? 
Q3.Which of the following command can be used to modify data in an SQL Table? A. INSERT B. DELETE C. UPDATE D. SELECT Choose the correct answer from the options given below:
Q4.Which of the following syntax is correct for CREATE DATABASE statement?
Q5.What is the correct syntax to drop a table?
Q6.What is uniquely used to identify a tuple in a relationship? 
Q7. The statement in SQL that deletes the table structure and the relationship is ______ .
Q8.In SQL, grant is a __________ command
Q9.“CREATE TABLE T” in SQL is an example of : 
Q10.Choose the correct meaning of SQL statement: Select * from r4r_emp; 
Suggested Test Series
View All >
HTET TGT Level 2 - 2024 Mock Test
183 Total Tests with 3 Free Tests
Start Free Test
Pedagogy for All Teaching Exams (Paper 1 & 2) - Let's Crack TET!
345 Total Tests with   3 Free Tests
Start Free Test

DSSSB TGT Important Links

Answer KeyAdmit CardResultCut OffEligibility CriteriaSalary and Job Profile

More DBMS Questions

Q1.If a hash table is implemented as a search tree, the expected time required to enter n names and make m searches is proportional to : 
Q2.In an ER Diagram, a double ellipse is used to represent : 
Q3.An instance of relational schema R (A, B, C) has distinct values of A including NULL values. Which one of the following is true ?
Q4.Consider the following statements : I - The primary key of a relation cannot contain null values. II - Unique Key can have null values. Which among the following is true ? 
Q5.Consider a relation R with attributes {A, B, C} and functional dependency set S = {A → B, A → C }. Then relation R can be decomposed into two relations : 
Q6.Consider the relations : R1{Roll_no, Name, Grades} and R2 {Roll_no, Subject_ID, Grades} Which of the following operations cannot be performed using the above relations ? 
Q7.The degree of a relation in database is
Q8.Which of the following table contains the primary information in the data warehouse?
Q9.An alternate key in database table is also called
Q10.Which of the following/s is/are FALSE statement? A. An all key relation is always in BCNF since it has no FDs. B. A relation that is not in 4NF due to nontrivial MVD must be decomposed to convert it into a set of relations in 4NF. C. The decomposition removes the redundancy by the MVD. D. 3NF is stronger than BCNF. Choose the correct answer from the options given below:
Testbook Edu Solutions Pvt. Ltd.
1st & 2nd Floor, Zion Building,
Plot No. 273, Sector 10, Kharghar,
Navi Mumbai - 410210
support@testbook.com
Toll Free:1800 833 0800
Office Hours: 10 AM to 7 PM (all 7 days)
Company
About usCareers We are hiringTeach Online on TestbookPartnersMediaSitemap
Products
Test SeriesTestbook PassOnline CoursesOnline VideosPracticeBlogRefer & EarnBooks
Copyright © 2014-2022 Testbook Edu Solutions Pvt. Ltd.: All rights reserved
User PolicyTermsPrivacy
Hot Links： teen patti star teen patti master online teen patti boss