MENU
What does the following command do? Select two correct descriptions regarding this SQL statement. SELECT * FROM information_schema.tables;
Suggested Answer: A
Get Premium PGCES-02 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
33 comments · newest first
AN
Antonio
11 months ago
I thought it was just about the 'tables' table, not the whole schema!
DA
Davida
11 months ago
I think it also lists tables in 'information_schema' schema.
CE
Cecilia
12 months ago
Wait, isn't it just pulling from 'information_schema'?
SH
Sharen
12 months ago
Totally agree, it's about the connected database!
FR
Francisca
12 months ago
It shows tables in the current database.
LA
Lavonne
1 year ago
I feel like option B is misleading; it talks about the 'information_schema' database, but I think we're actually querying a schema.
KE
Kendra
1 year ago
I'm a bit confused about option C and D; they both mention the 'tables' table, but I can't recall which one is accurate.
EA
Earlean
1 year ago
I remember practicing a question about the information_schema, and I think option E makes sense since it mentions the schema specifically.
BO
Boris
1 year ago
I think option A is correct because it seems to refer to the currently connected database, but I'm not entirely sure.
WI
Winifred
1 year ago
High availability is key for any cloud-based system. Downtime can be a major issue, so I'll go with that option.
NO
Noble
1 year ago
I'm feeling a bit lost on this one. I don't have much experience with enterprise software trials, so I'm not sure which option is correct. I'll try to eliminate the ones that seem least likely, but I may have to guess on this one.
JA
James
1 year ago
This looks straightforward enough. I just need to make sure I'm referencing the right worksheet and column.
AR
Aracelis
1 year ago
Okay, let's see. The key seems to be separating the agnostic and non-agnostic logic, and then applying the right patterns to centralize and orchestrate the services. I'm leaning towards option C, but I'll need to double-check the details.
BR
Brittni
1 year ago
Ah, the classic information_schema query! I always get that mixed up with the system tables. At least it's not asking about the data dictionary, that would really make my head spin.
LO
Lorenza
1 year ago
At least it's not asking about the data dictionary, that would really make my head spin.
BI
Billy
1 year ago
Ah, the classic information_schema query! I always get that mixed up with the system tables.
AM
Amie
1 year ago
B) Requests a list of defined tables in the 'information_schema' database.
EL
Ellsworth
1 year ago
A) Requests a list of defined tables in the currently connected database.
LO
Lorrine
1 year ago
E) Requests a list of defined tables in the 'information_schema' schema.
NA
Nana
1 year ago
Ah, the classic information_schema query! I always get that mixed up with the system tables.
RO
Roosevelt
1 year ago
B) Requests a list of defined tables in the 'information_schema' database.
TR
Tracey
1 year ago
A) Requests a list of defined tables in the currently connected database.
TI
Titus
1 year ago
B is definitely wrong. The information_schema database is part of the current database, not a separate one. A and E are the right choices here.
MO
Mohammad
1 year ago
I'm pretty sure C and D are the right answers. The information_schema database stores table definitions, and this query is accessing the 'tables' table within that schema.
KE
Kenneth
1 year ago
I'm not sure about option C and D. I think they are incorrect because the command is not requesting the contents of a specific table, but rather a list of tables.
ME
Melinda
2 years ago
A and E are both correct. The statement requests a list of tables defined in the information_schema database, which contains metadata about the database itself.
ME
Melda
1 year ago
E) Requests a list of defined tables in the 'information_schema' schema.
HA
Harris
1 year ago
B) Requests a list of defined tables in the 'information_schema' database.
RO
Roxane
1 year ago
E) Requests a list of defined tables in the 'information_schema' schema.
RO
Roxane
1 year ago
A) Requests a list of defined tables in the currently connected database.
MA
Mariko
1 year ago
A) Requests a list of defined tables in the currently connected database.
DA
Dannette
2 years ago
I agree with Devora. The command is requesting a list of defined tables in the currently connected database and in the 'information_schema' database.
DE
Devora
2 years ago
I think the correct descriptions are A and B.