ipl-logo

Oof

.pdf
School
U.E.T Taxila**We aren't endorsed by this school
Course
CIS 339
Subject
Information Systems
Date
Dec 18, 2024
Pages
7
Uploaded by DeanNarwhalPerson1307
1.How to know, which version of binaries are used for taking database backup?oUsing pg_dumpall with -v optionoUsing pg_dump with –version optionoUsing pg_restore with -j optionoUsing pg_restore with -v option2.pg_dumpall generates aocompressed dumpotarred dumpoplain dumpobinary dump3.I’ve lost a file that corresponds to a table in my database, will the database startup?oThe database will startoThe database will start with warningsoThe database will not start but is recoverableoThe database will not start and is not recoverable4.Which of the following will cause autovacuum to skip vacuum of a table?oautovacuum_vacuum_threshold not reachedoautovacuum_vacuum_cost_delay too highoautovacuum_freeze_max_age is reachedoall of the above5.Which system catalogue contains the encoding of the database?opg_databaseopg_classopg_descriptionopg_settings6.To force the query planner to prefer sequential, full-table scans, which of the following options should be oEnable_indexscan and enable_bitmapscanoEnable_seqscan and enable_bitmapscanoEnable_hashjoin and enable_indexscanoEnable_idxscan7.Which parameter would increase the performance of vacuum and create index operations?omaintenance_work_memoshared_buffersowork_memovacuum_cost_delay8.Which of the following system views can be used to track the status of the archiver process?opg_stat_archiveropg_stat_walsopg_stat_wal_receiveropg_stat_wal_writer9.Which of the following configuration parameters can be used to specify the date and time for point-in-time recovery?orecovery_min_apply_delayorestore_commandorecovery_target_timeorecovery_target
Background image
10.You have configured a physical backup of your database cluster using pg_basebackup. Which of the following options can be used to include all the WAL files generated while pg_basebackup is running?o–logso-Xo-ko-T11.Which of the following commands can be used to view the total number of WAL files that have been successfully archived since the last statistics reset?oSELECT archived_count FROM pg_stat_archiver;oSELECT archived_count FROM pg_stat_database;oSELECT checkpoints_req- checkpoints_timed FROM pg_stat_bgwriter;oSELECT archived_count FROM pg_stat_bgwriter;12.edb-psql is a terminal-based front-end to EDB Postgres Advanced Server. You would like to display a custom welcome message whenever a user connects to an EDB Postgres Advanced Server database using edb-psql utility. Which of the following options can be used to achieve this?o$PGDATA/postgresql.confo$HOME/ .psqlrco$PGDATA/pg_ident.confoPGDATA/postgresql.conf13.While executing an edb-psql command, the server is not prompting for a password. Which option can be added in the following command to force the server to prompt for a password? Command: edb-psql -p 5432 -U tiger-d postgreso-Xo-Wo-wo-xoPassword cannot be forced.14.While of the following edb-psql meta commands are used to redirect output to a file?o\o \go\q \f \to\h \f \zo\o \f \q15.Which of the following can be used to turn off auto commit in edb-psql?oset AUTOCOMMIT offo\set AUTOCOMMIT offoset COMMIT offounset AUTOCOMMIT16.You can create multiple schemas in an EDB Postgres Advanced Server databases. After connecting to an EDB Postgres Advanced Server database using edb-psql, you would like to switch from one schema to another. Which of the following commands can be used to switch schemas?oset schemaoset pathoset search_pathoset schema_path
Background image
17.As and EDB Postgres Advanced Server DBA you have decided to configure activity logging on your database server. Identify the parameter to configure the physical location of the logs files.olog_destinationolog_locationolog_filenameolog_directory18.Which of the following parameters can be used to control whether Optimizer hints embedded into SQL commands are utilized or not?oedb_custom_plan_triesoenable_* parametersoenable_indexonlyscanoenable_hints19.In EDB Postgres Advanced Server a database cluster is comprised of: (Select all that apply)? templates?files?port?data directory20.In EDB Postgres Advanced Server, what are the valid values for wal_level parameter?ominimal, normal and archiveominimal, replica and logicalominimal, archive, default and hot_standbyoThis parameter is not available in EDB Postgres Advanced Server21.At what level is the work_mem parameter of postgresql.conf applied?oClusteroOperationoDatabaseoSession22.Which of the following statements can be used to view a list of all the parameters requiring a server restart?oSELECT name, setting FROM pg_settings;oSELECT name, setting FROM pg_setting;oSELECT name FROM pg_setting WHERE context = ‘postmaster’;oSELECT name FROM pg_settings WHERE context = ‘postmaster;23.The background writer process in EDB Postgres Advanced Server is causing high I/o Activity on your production server. In order to control frequent, I/O spikes, which parameter can be tuned for your database cluster?otemp_buffersocheckpoint_timeoutobgwriter_pagesoAll of the above24.Which of the following maintenance commands requires an exclusive lock on each table in a database?oVACUUM;oVACUUM FREEZE ANALYZE;oVACUUM FREEZE;oVACUUM FULL;
Background image
25.Which of the following VACUUM options can be used to prevent transaction ID wraparound failures in EDB Postgres Advanced Server?oANALYZEoFULLoFREEZEoVERBOSE26.Which system table stores the total number of rows and disk blocks of each table and index in EDB Postgres Advanced Server?opg_statisticsopg_stat_user_tablesopg_classopg_stat_all_tables27.Which of the following steps is necessary after modifying the host-based access control file of EDB Postgres Advanced Server?oSTOP ClusteroREBOOT Operating SystemoRELOAD ClusteroREMOVE old postmaster.pid28.EDB Postgres Advanced Server implements security at different levels. Choose the correct security levels. (Choose all that apply)➢Server and Application Level➢Tablespace Level➢Database Level➢Object Level29.Which Oracle compatible data type can be used to store character data in EDB Postgres Advanced Server?oSTRINGoSERIALoVARCHAR2obytea30.EDB Postgres Advanced Server supports synchronous streaming replication. Which EBD Postgres Advanced Server parameter is used to specify the names of synchronously replicated replica servers?osynchronous_commitostreaming_standbyoremote_write_namesosynchronous_standby_names31.You are using EDB Postgres Advanced Server 15 and want to implement Streaming Replication between your production server and a replica server. Which replica server configuration file contains the parameters used to initiate replication between the primary and the replica server?opostgresql.confopg_standby.conforecovery.confostandby.signal32.You would like to monitor a streaming replication setup and decided to view the last transaction log location received and synced to disk by streaming replication. Which of the following functions can be used to get this information?opg_last_wal_receive_lsnopg_last_wal_replay_lsnopg_last_xact_replay_timestamp
Background image
opg_last_wal_lsn33.Streaming Replication is setup for high availability between your primary and hot standby server. A user is connected to the hot standby server and executes following SQL statement:SELECT * FROM edbsupport FOR SHARE;When executed on your hot standby server, what would be the output of the statement above?oThe statement will execute successfully.oThe statement will execute successfully but no rows are displayed.oERROR: SELECT FOR SHARE is not available on hot standby.oERROR: cannot execute SELECT FOR SHARE in a read-only transaction.34.Which of the following functions can be used to pause recovery immediately?opg_wal_replay_pause()opg_go_wal_replay_paused()opg_wal_replay_paused()opg_wal_replay_resume()35.Fill in the blank: If SELinux is installed and enabled on your system, you must set SELinux to ________ mode before installing EDB Postgres Advanced Server.oenforceopermissiveoenforcingoenabled36.Which of the following statements are correct? (Choose all that apply)➢One database has more than one cluster➢One cluster can have more than one database➢One cluster has more than one database with one instance for each database➢One cluster is one instance37.The default page size in EDB Postgres Advanced Server can be changed during ______.oRuntimeoInstallationoCluster initializationoDatabase creationoIt cannot be changed38.Which of the following utility processes performs a WAL buffer flush from the cache at each commit?owal writerobgwriteroarchiveroautovacuum39.What is the default page size in EDB Postgres Advanced Server?o2KBo16KBo4KBo8KB40.Which process is responsible for writing dirty pages to the disk?opostmasteroedb-postgresobgwriteroarchiver
Background image
41.Which of the following options are cluster level privileges? (Select all that apply)➢CREATEUSER➢SUPERUSER➢CREATEDB➢CREATEROLE42.Which of the following options are true about database roles in EDB Postgres Advanced Server? (Select all that apply)➢Role is a collection of database objects.➢Role can be created using CREATE ROLE statement➢Role can be assigned to a user or a group using ALTER statement➢If privileges for a role are modified, all the users who are granted the role acquire modified privileges.43.Which of the following options are object level privileges? (Select all that apply)➢SELECT➢CREATEUSER➢INSERT➢CONNECT44.Which tablespace is used to store cluster-wide tables and shared system catalogs in EDB Postgres Advanced Server?opg_defaultodefault_tablespaceopg_globaloglobal_tablespace45.What is the name of the directory that pg_global tablespace corresponds to?oPGDATA/globaloPGDATA/global_tablespaceoPGDATA/pg_globaloPGDATA/pgglobal46.The EDB Postgres Enterprise Manager web client is one of the user interfaces for EDB Postgres Advanced Server. Which statement is correct about this web client?1)EDB Postgres Enterprise Manager (PEM) web client is not open source.2)The PEM graphical interface supports both EDB Postgres Advanced Server and PostgreSQL.3)PEM SQL Editor also includes SQL Profiler.o1,2o2, 3o1, 3o1, 2, 347.Which of the following pg_hba authentication types is available in EDB Postgres Advanced Server?otalkolocaloscram-sha-256orsa
Background image
48.Which of the following are valid DML statements in EDB Postgres Advanced Server?1)COMMIT…2)UPDATE…3)DELETE…4)CREATE…5)DROP…o1, 2, 3o2, 3, 5o2, 3o2, 449.Which of the following Oracle compatible data types is available in EDB Postgres Advanced Server?oSERIALoNVARCHAR2oSTRINGoNUMERIC
Background image