导读-抢沙发 - iiDBA - Powered by Discuz!

来自: PostgreSQL专区

iidba

5 天前

新窗

PostgreSQL内部分享：pg10新特性

链接: https://pan.baidu.com/s/15R1f821PfOO2RRkqV5l_9Q 提取码: **** 本内容被作者隐藏 ****

10 0 0 iidba @ 5 天前

来自: 茶水间

iidba

6 天前

新窗图片

当一个DBA问另一个DBA"在银行干过吗"。。。

职业没有高低，只是熟悉的哥们，搭配上这么一套操作流程和行头，画面感极强，毫无违和感。平时说话，就是一副没有灵魂的样子。。。我只是一部没 ...

76 0 0 iidba @ 6 天前

来自: iiDBA VIP技术支持

甲骨论

6 天前

新窗

Examine this statement: SELECT1 AS id,‘ John’ AS first_name, NULL AS com...

Examine this statement: SELECT1 AS id,‘ John’ AS first_name, NULL AS commission FROM dual INTERSECT SELECT 1,’John’ null FROM dual ORDER ...

2 0 0 甲骨论 @ 6 天前

来自: iiDBA VIP技术支持

甲骨论

6 天前

新窗

Which three actions can you perform by using the ALTER TABLE command?

Which three actions can you perform by using the ALTER TABLE command? A) Drop pseudo columns from a table. B) Restrict all DML statements o ...

2 0 0 甲骨论 @ 6 天前

来自: iiDBA VIP技术支持

甲骨论

6 天前

新窗

Which two actions can you perform with object privileges?

Which two actions can you perform with object privileges? A) Create roles. B) Delete rows from tables in any schema except sys. C) Set def ...

1 0 0 甲骨论 @ 6 天前

来自: iiDBA VIP技术支持

甲骨论

6 天前

新窗

n Oracle database server session has an uncommitted transaction in progress w...

An Oracle database server session has an uncommitted transaction in progress which updated 5000 rows in a table. In which three situations d ...

3 0 0 甲骨论 @ 6 天前

来自: iiDBA VIP技术支持

甲骨论

6 天前

新窗

Which three statements are true?

View the exhibit and the examine the description of the tables. You e x ecu t e this SQL s t a t e m e n t : I N SERT INTO s al e s VALUE ...

1 0 0 甲骨论 @ 6 天前

来自: iiDBA VIP技术支持

甲骨论

6 天前

新窗

he STORES table has a column START_DATE of data type DATE, containing the dat...

The STORES table has a column START_DATE of data type DATE, containing the datethe row was inserted. You only want to display details of row ...

1 0 0 甲骨论 @ 6 天前

来自: iiDBA VIP技术支持

甲骨论

6 天前

新窗

Which two statements are true regarding a SAVEPOINT?

Which two statements are true regarding a SAVEPOINT? A) Rolling back to a SAVEPOINT can undo a CREATE INDEX statement. B) Only one SAVEPOINT ...

1 0 0 甲骨论 @ 6 天前

来自: iiDBA VIP技术支持

甲骨论

6 天前

新窗

The BOOK ID value 101 does not exist in the table. Examine the SQL statement....

Examine the command to create the BOOKS table. SQL> create table books(book id CHAR(6) PRIMARY KEY, title VARCHAR2(100) NOT NULL, publisher_ ...

1 0 0 甲骨论 @ 6 天前

来自: iiDBA VIP技术支持

甲骨论

6 天前

新窗

Which statement is true regarding the outcome of the above query?

Evaluate the following SQL statement SQL>SELECT promo_id, prom _category FROM promotionsWHERE promo_category=’Internet’ ORDER BY promo_id ...

1 0 0 甲骨论 @ 6 天前

来自: iiDBA VIP技术支持

甲骨论

6 天前

新窗

For which substitution variables will you be prompted?

You execute these commands: SQL>DEFINE hiredate = ’01-APR -2011’; SQL>SELECT employee_id, first_name, salary FROM employees WHERE hire da ...

1 0 0 甲骨论 @ 6 天前

来自: iiDBA VIP技术支持

甲骨论

6 天前

新窗

Which two statements are true? (Choose two.)

Which two statements are true? (Choose two.) A) The USER SYNONYMS view can provide information about private synonyms. B) The user SYSTEM ow ...

1 0 0 甲骨论 @ 6 天前

来自: iiDBA VIP技术支持

甲骨论

6 天前

新窗

View the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS,...

View the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS, and TIMES tables. The PROD_ID column is the foreign key in the ...

1 0 0 甲骨论 @ 6 天前

来自: iiDBA VIP技术支持

甲骨论

6 天前

新窗

Which statement is true regarding the SESSION_PRIVS dictionary view?

Which statement is true regarding the SESSION_PRIVS dictionary view? A) It contains the object privileges granted to other users by the curr ...

1 0 0 甲骨论 @ 6 天前

来自: iiDBA VIP技术支持

甲骨论

6 天前

新窗

View the Exhibit and examine the structure of the ORDERS table. The columns ...

View the Exhibit and examine the structure of the ORDERS table. The columns ORDER_MODE and ORDER TOTAL have the default values'direct ...

1 0 0 甲骨论 @ 6 天前

来自: iiDBA VIP技术支持

甲骨论

6 天前

新窗

Viev the Exhibit and examine the structure of the PRODUCT INFORMATION and INV...

Viev the Exhibit and examine the structure of the PRODUCT INFORMATION and INVENTORIEStables. You have a requirement from the supplies depart ...

1 0 0 甲骨论 @ 6 天前

来自: iiDBA VIP技术支持

甲骨论

6 天前

新窗

Which statement is true about the INTERSECT operator used in compound queries?

Which statement is true about the INTERSECT operator used in compound queries? A) It processes NULLS in the selected columns. B) INTERSECT i ...

1 0 0 甲骨论 @ 6 天前

来自: iiDBA VIP技术支持

甲骨论

6 天前

新窗

You execute this query: SELECT TO CHAR (NEXT_DAY(LAST_DAY(SYSDATE),’MON’...

You execute this query: SELECT TO CHAR (NEXT_DAY(LAST_DAY(SYSDATE),’MON’ ),’ dd“Monday for” fmMonth rrr’) FROM DUAL; What is the resul ...

1 0 0 甲骨论 @ 6 天前

来自: iiDBA VIP技术支持

甲骨论

6 天前

新窗

You issued this command: DROP TABLE hr. employees; Which three statements ar...

You issued this command: DROP TABLE hr. employees; Which three statements are true? A) ALL constraints defined on HR, EMPLOYEES are dropped. ...

1 0 0 甲骨论 @ 6 天前

来自: iiDBA VIP技术支持

甲骨论

7 天前

新窗

Which is the default column or columns for sorting output from compound queri...

Which is the default column or columns for sorting output from compound queries using SET operators such as INTERSECT in a SQL statement? A) ...

1 0 0 甲骨论 @ 7 天前

来自: iiDBA VIP技术支持

甲骨论

7 天前

新窗

Which three statements are true about views in an Oracle database?

Which three statements are true about views in an Oracle database? A) The WITH CHECK clause prevents certain rows from being displayed when ...

1 0 0 甲骨论 @ 7 天前

来自: iiDBA VIP技术支持

甲骨论

7 天前

新窗

Which two statements are true about external tables?

Which two statements are true about external tables? A) Indexes can be created on them. B) You can populate them from existing data in the d ...

1 0 0 甲骨论 @ 7 天前

来自: iiDBA VIP技术支持

lee

2020-8-4

新窗图片 - 售价 10 金币

大数据DBA--Oracle模块测试题1

**** 本内容被作者隐藏 ****

6 0 0 lee @ 2020-8-4 22:11

来自: iiDBA VIP技术支持

lee

2020-8-3

新窗精 - 售价 10 金币

2020年-89道超经典面试题汇总

**** 本内容被作者隐藏 ****

7 0 0 lee @ 2020-8-3 21:26

来自: MySQL技术专区

lee

2020-7-31

新窗

深入MySQL--开源组件-DBLE详解3

schema.xml schema.xml是最主要的配置项，我们将users用户表按照取模的方式平均拆分到了MySQL A和MySQL B两个数据数据库实例上，详细请看配置文件 ...

33 0 0 lee @ 2020-7-31 22:24

来自: MySQL技术专区

lee

2020-7-31

新窗

深入MySQL--开源组件-DBLE详解2

配置DBLE DBLE的配置文件都在conf目录里面，这里介绍几个常用的文件：文件说明 server.xml ...

24 0 0 lee @ 2020-7-31 22:18

来自: Oracle技术专区

iidba

2020-7-31

新窗

oracle用户表空间是使用率临界值多少合适

解决方案1：不宜超过80%,除非你表空间内的表数据都是完全连续存储的。解决方案2：设成可自动拓展的，就不用管这些了 1、查询表空间使 ...

24 0 0 iidba @ 2020-7-31 15:29

来自: MySQL技术专区

lee

2020-7-29

新窗

深入MySQL--MySQL常见异常分析及处理方案2

1.Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' 【报错原因】主键没有设置自动增长【解决方法】将主键设为自 ...

42 0 0 lee @ 2020-7-29 21:11

来自: iiDBA VIP技术支持

甲骨论

2020-7-28

新窗

which three statements are true regarding single row subqueries?

which three statements are true regarding single row subqueries? A. THEY CAN BE USED in the where clause. B. A SQL STATEMENT MAY HAVE MULTIP ...

2 0 0 甲骨论 @ 2020-7-28 22:57

来自: iiDBA VIP技术支持

甲骨论

2020-7-28

新窗

Which two statements are true about truncate and delete?

Which two statements are true about truncate and delete? A. the result of a delete can be undone by issuing a rollback B. delete can use a w ...

2 0 0 甲骨论 @ 2020-7-28 22:56

来自: iiDBA VIP技术支持

甲骨论

2020-7-28

新窗

Which three statements are true about Structured Query Language (SQL)?

Which three statements are true about Structured Query Language (SQL)? A. It guarantees atomicity, consistency, isolation, and durability (A ...

2 0 0 甲骨论 @ 2020-7-28 22:55

来自: iiDBA VIP技术支持

甲骨论

2020-7-28

新窗

Examine the description of the PRODUCTS table: Name Nul...

Examine the description of the PRODUCTS table: Name Null? Type PROD_ID NOT NUL ...

1 0 0 甲骨论 @ 2020-7-28 22:53

来自: iiDBA VIP技术支持

甲骨论

2020-7-28

新窗

Which two statements are true?

Examine the description of the BOOKS table: Name Null? ...

1 0 0 甲骨论 @ 2020-7-28 22:50

来自: iiDBA VIP技术支持

甲骨论

2020-7-28

新窗

Which three are true about the MERGE statement？

Which three are true about the MERGE statement？ A. It can merge rows only from tables. B. It can use views to produce source rows. C. It ca ...

1 0 0 甲骨论 @ 2020-7-28 22:45

来自: iiDBA VIP技术支持

甲骨论

2020-7-28

新窗

Which three statements are true about built-in data types?

Which three statements are true about built-in data types? A. A VARCHAR2 blank-pads column values only if the data stored is non-numeric and ...

1 0 0 甲骨论 @ 2020-7-28 22:44

来自: iiDBA VIP技术支持

甲骨论

2020-7-28

新窗

Which three statements are true about inner and outer joins?

Which three statements are true about inner and outer joins? A. A full outer join returns matched and unmatched rows. B. A full outer join m ...

1 0 0 甲骨论 @ 2020-7-28 22:43

来自: iiDBA VIP技术支持

甲骨论

2020-7-28

新窗

W hich two are true about multiple table INSERT statements?

W hich two are true about multiple table INSERT statements? A. They always use subqueries. B. They can transform a row from a source table i ...

1 0 0 甲骨论 @ 2020-7-28 22:42

来自: iiDBA VIP技术支持

甲骨论

2020-7-28

新窗

View the Exhibit and examine the structure of the PRODUCTS table. Which two ...

Question： View the Exhibit and examine the structure of the PRODUCTS table. Which two tasks require subqueries? A. Display the total number ...

2 0 0 甲骨论 @ 2020-7-28 22:41

来自: iiDBA VIP技术支持

甲骨论

2020-7-28

新窗

Examine these statements executed in a single Oracle session: CREATE TABLE p...

Examine these statements executed in a single Oracle session: CREATE TABLE product (pcode NUMBER(2),pname VARCHAR2(20)); INSERT INTO product ...

1 0 0 甲骨论 @ 2020-7-28 22:40

来自: iiDBA VIP技术支持

甲骨论

2020-7-28

新窗

Which three actions can you perform on an existing table containing date?

Which three actions can you perform on an existing table containing date? A. Add a new column as the table's first column. B. Define a defau ...

1 0 0 甲骨论 @ 2020-7-28 22:39

来自: iiDBA VIP技术支持

甲骨论

2020-7-28

新窗

View the Exhibits and examine the structure of the COSTS and PROMOTIONS table...

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables. You want to display PROD IDS whose promotion cost is less th ...

1 0 0 甲骨论 @ 2020-7-28 22:39

来自: iiDBA VIP技术支持

甲骨论

2020-7-28

新窗

Examine the description or the BOOKS_TRANSACTIONS table: Name ...

Examine the description or the BOOKS_TRANSACTIONS table: Name Null? Type CUST_ID ...

1 0 0 甲骨论 @ 2020-7-28 22:36

来自: iiDBA VIP技术支持

甲骨论

2020-7-28

新窗

Which statement is true about TRUNCATE and DELETE?

Which statement is true about TRUNCATE and DELETE? A. For large tables TRUNCATE is faster than DELETE. B. For tables with multiple indexes a ...

1 0 0 甲骨论 @ 2020-7-28 22:31

来自: iiDBA VIP技术支持

甲骨论

2020-7-28

新窗

Which four statements are true about constraints on Oracle tables?

Which four statements are true about constraints on Oracle tables? A. A Column can have only one CHECK Constraint. B. A NOT NULL Constraint ...

2 0 0 甲骨论 @ 2020-7-28 22:30

来自: iiDBA VIP技术支持

甲骨论

2020-7-24

新窗

Which three privileges can be restricted to a subset of columns in a table?

Which three privileges can be restricted to a subset of columns in a table? A. ALTER B. REFERENCES C. UPDATE D. SELECT E. INDEX F. INSERT G. ...

1 0 0 甲骨论 @ 2020-7-24 21:52

来自: iiDBA VIP技术支持

甲骨论

2020-7-24

新窗

Which three statements are true regarding single row subqueries?

Which three statements are true regarding single row subqueries? A. They must be placed on the left side of the comparison operator or condi ...

1 0 0 甲骨论 @ 2020-7-24 21:51

来自: iiDBA VIP技术支持

甲骨论

2020-7-24

新窗

Which two statements are true about the ORDER BY clause?

Which two statements are true about the ORDER BY clause? A. Numeric values are displayed in descending order if they have decimal positions. ...

1 0 0 甲骨论 @ 2020-7-24 21:50

来自: iiDBA VIP技术支持

甲骨论

2020-7-24

新窗

Which statement is true about aggregate functions?

Which statement is true about aggregate functions? A) The AVG function implicitly converts NULLS to zero. B) The MAX and MIN functions can b ...

1 0 0 甲骨论 @ 2020-7-24 21:50

来自: iiDBA VIP技术支持

甲骨论

2020-7-24

新窗

Which three are true about system and object privileges

Which three are true about system and object privileges A. WITH GRANT OPTION can be used when granting an object privilege to both users and ...

1 0 0 甲骨论 @ 2020-7-24 21:48

图文精华

最新回复