Database Structure and Core Vocabulary: 10 practice questions

Question 1 of 10

What is a table in the PostgreSQL relational model?

1. AA collection of server instances grouped into one column
2. BA client process that accepts connections from database servers
3. CA named collection of rows with named, typed columns
4. DAn ordered display whose row positions identify stored records

Question 2 of 10

What does a row represent within a table?

1. AOne occurrence described by the table's named columns
2. BOne data type shared by unrelated database clusters
3. COne client program that manages the database files
4. DOne server instance containing a collection of databases

Question 3 of 10

What is a PostgreSQL database cluster?

1. AThe collection of databases managed by one server instance
2. BThe set of clients connected through one named column
3. CThe fixed display order of rows inside one result table
4. DThe data type assigned to each database in a table

Question 4 of 10

Which responsibility belongs to the PostgreSQL server process?

1. AServe only as a graphical theme for a client application
2. BManage database files, accept connections, and perform database actions
3. CAct as each named row and choose its fixed display position
4. DTurn every database into a data type for one column

Question 5 of 10

Which program can play the client role in PostgreSQL?

1. AA terminal, graphical tool, web server, or maintenance application
2. BA column type that manages every server-side database file
3. CA cluster that contains client programs instead of databases
4. DA row whose physical position accepts incoming network connections

Question 6 of 10

Which hierarchy uses PostgreSQL terms correctly?

1. AData type, network host, display order, server and table
2. BColumn, client, server file, cluster, data type and database
3. CServer instance, cluster, database, table, row and column
4. DRow, operating system, client theme, statement and cluster

Question 7 of 10

What should be assumed about the order of rows stored in a table?

1. ANo row order is guaranteed unless query output is explicitly sorted
2. BColumn order automatically sorts rows for every later query
3. CA client's screen order becomes the table's guaranteed storage order
4. DThe insertion position permanently identifies each stored row

Question 8 of 10

A reporting client runs on one host, PostgreSQL runs on another, and the report must read a file stored only beside the client. Which concern follows from the architecture?

1. AThe client must manage PostgreSQL's database files instead of requesting work
2. BEach file line gains a guaranteed table position before a connection exists
3. CThe server may not see the client-side file or may require another path
4. DThe file automatically becomes a database cluster shared by both hosts

Question 9 of 10

A designer needs many customer occurrences with the same attributes and a declared kind of value for each attribute. Which structure fits both requirements?

1. AA database cluster with one client process per attribute
2. BA graphical client with databases used as column data types
3. CA customer table with rows and named, typed columns
4. DA server file whose line order permanently identifies customers

Question 10 of 10

An architecture diagram must show one PostgreSQL instance managing several project databases and accepting requests from terminal and web applications. Which labeling is accurate?

1. AEach database is a data type, and the terminal is a named column
2. BOne server manages the cluster; the terminal and web applications are clients
3. CThe web application manages database files, and the server is a row
4. DEach client is a cluster, and the databases are server processes